Agile Central: Excel - How to export the Blocker username?

book

Article ID: 101634

calendar_today

Updated On:

Products

CA OPS/MVS Event Management & Automation CA Agile Central On Premise (Rally) CA Agile Central SaaS (Rally)

Issue/Introduction



When selecting the Blocker field for export of a User Story we are getting this - see below.
How can we export the Blocker user ?

<Please see attached file for image>

User-added image

Environment

Release:
Component: ACSAAS

Resolution

To export the Blocker, use: Blocker.BlockedBy in your excel column.

When clicking the Columns Choose... button you will only see the Blocker field , but that will result in the data that's shown in the question earlier. You need to manually edit the Columns field to include: "Blocker.BlockedBy" - see below:

<Please see attached file for image>

User-added image

Additional Information

More on the Excel Add-in: https://help.rallydev.com/import-export-excel-addin

A list of additional tech docs on the Excel Add-in can be found at: 
https://support.ca.com/us/product-information/ca-agile-central.html?q=excel&type=ALL

Attachments

1558701090055000101634_sktwi1f5rjvs16kdf.png get_app
1558701087904000101634_sktwi1f5rjvs16kde.png get_app