Advanced Roadmaps Integration

In this page

What is Advanced Roadmaps?

(supported since Better Excel Exporter 4.2.0)

Advanced Roadmaps is Atlassian's Project Portfolio Management (PPM) solution, an agile roadmapping and project planning app for Jira Software.

Advanced Roadmaps integration features

• You can export Due date values (system field) and Start date values (standard Date Picker custom field type) to Excel.
• You can export the Advanced Roadmaps-managed custom field types like Original story points, Parent Link, Team, Target start and Target end, to Excel.

(Need more features? Tell us in a support ticket!)

Advanced Roadmaps integration vs. the Advanced Roadmaps built-in Excel exports

You may want to ask: if Advanced Roadmaps has a built-in Excel export feature, why would you use another app for the same?

While the Advanced Roadmaps built-in Excel exports may be sufficient for basic use cases, the Better Excel Exporter integration is more powerful in, at least, these:

• It supports Excel automation.
  You can export, email and attach Excel files using Automation for Jira (visual automation rules), ScriptRunner (Groovy scripts), or the REST API (use your favorite language!).
• It is extremely customizable.
  Instead of accepting the pre-defined export types in Advanced Roadmaps, you can define your own types via Excel templates.
• It supports all the powerful Excel features.
  You can use Excel formulas and functions, custom calculations in Groovy (sorting, complex math, data integration, etc.), charts, pivot tables, pivot charts, Visual Basic macros, among others.
• It is integrated with all the popular Jira apps.
  You can freely combine Advanced Roadmaps data and other apps' data in the same Excel file.
• It comes with powerful templates optimized for Advanced Roadmaps.
  You can use those "as is", or customize them to your needs.
• It is well-documented with the customization guide, the Expression Reference Manual, the recipes, and such.

If at least one of these is important for you, give the app a try.

Tutorial video

The Better Excel Exporter app enables exporting the issues in an Advanced Roadmaps plan to customizable Excel spreadsheets for reporting purposes:

Advanced Roadmaps Excel export samples

Configuration

Configuring the Advanced Roadmaps custom fields

There is nothing to do. Better Excel Exporter will automatically recognize the Advanced Roadmaps-managed fields and export them accordingly.

Exporting issues in an Advanced Roadmaps program

Advanced Roadmaps offers several JQL functions to find issues in a program, in a plan, by parent, by child, etc. Use these JQL functions in the Issue Navigator to search for the issues to export, sort the issues, then export the result using Better Excel Exporter.

To search for the issues in an Advanced Roadmaps program, use this JQL:

issuekey IN issuesInProgram(12)

...where "12" is the program's ID. To learn its ID, open the program, and you will see the ID in the page URL (in the browser's address bar).

Exporting issues in an Advanced Roadmaps plan

To search for the issues in an Advanced Roadmaps plan, use this JQL:

issuekey IN issuesInPlan(34)

...where "34" is the plan's ID. To learn its ID, open the plan, and you will see the ID in the page URL (in the browser's address bar).

Exporting issues within the hierarchy, by team and by target dates

Similarly to the use cases discussed in the previous sections, you can use JQL to search for:

• the issues linked via the Parent Link custom field
• the parents of issues
• the children of issues
• the issues assigned to a team
• the issues that have target start- and target end dates

See the Advanced Roadmaps documentation for examples.

Learn more about Advanced Roadmaps

• Advanced Roadmaps product information (at its own vendor)
• Advanced Roadmaps documentation