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

Document ID : KB000101634
Last Modified Date : 15/06/2018
Show Technical Document Details
Question:
When selecting the Blocker field for export of a User Story we are getting this - see below.
How can we export the Blocker user ?

User-added image
Answer:
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:

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