JIRA Align - Excel Add-In

[Devasena Sistu]

I'm looking for a Connector / Add-In from  JIRA Align to Excel.

[Peter Jessen]

Hi @Devasena Sistu ,

@Samit Mehta [321 Gang] is correct, in that Align has the ability to export and import specific items in XML format that is resolved in Excel.

• This functionality is limited to only those fields defined in the XML templates for each object that can be exported and imported.
• In addition, some objects, such as dependencies can only be exported ad not imported.

If you are looking for the type of robust Excel plug-in that Rally provided in the past (I haven't used Rally since 2015), then Align does not support that.

Your two additional options for connecting data from Align to an out side source are:

• The Jira Align REST API 2.0. which provided bi-directional data
• You would need to build the interface to the REST API 2.0.
• Here is the related Help article: 
  • https://help.jiraalign.com/hc/en-us/articles/360045371954-Getting-started-with-the-REST-API-2-0 
• The Enterprise insights business intelligence module (additional purchase) that provides the data lake for connection to tools such as Tableau. 
  • This data flow is one way - out of Align.

Regards,
Peter

[Samit Mehta [321 Gang]]

Please expand on what exactly would you want this connector to do?

Jira Align has a built-in ability to export and import work items (Themes, Epics, Features, Stories, etc) from/to Excel.  Is that what you were looking to do?