This is fantastic, I had no idea that existed!
Another option from within the UI is to use the Custom List 2.0 app, which shows ALL milestones regardless of your current project scope or the projects they are visible in. I learned that by accident, but it has been a great help in finding milestones with limited project visibility.
------------------------------
Terry Ginzburg
------------------------------
Original Message:
Sent: Aug 29, 2024 06:20 PM
From: Kristy Corkan
Subject: Exporting all Milestones in Rally to Excel
@Neil Goodwin you could use the .csv endpoint to export all milestones in CSV format. The CSV endpoint is the same as the JSON endpoint only with .csv appended to it.
If you are logged into Rally in the workspace that you are interested in pulling this information, paste the following URL into another tab:
https://rally1.rallydev.com/slm/webservice/v2.0/milestone.csv?fetch=FormattedID,Name,TargetDate,Projects
There are a few caveats:
1. In order for this to work properly, you will need to explicitly add the attributes that you want to export into the fetch list. In the example above, I've added FormattedID,Name,TargetDate,Projects into the fetch list. If you'd like more attributes like TargetProject, Description, CreationDate, etc, add those into the list.
2. Collections on the milestones will not export in detail, but adding a collection will result in the number of items in that collection.
3. The CSV endpoint will export ALL the items if you do not have a page size on it, so it may take some time for the list to download.
Hopefully this helps!
Kristy
------------------------------
Kristy Corkan
Rally Product
Original Message:
Sent: Aug 29, 2024 12:48 PM
From: Neil Goodwin
Subject: Exporting all Milestones in Rally to Excel
Hi all,
I am curious if anyone has a way to export all Milestones in Rally to CSV regardless of which project(s) they are shared with. This is not possible OOTB in Rally as when viewing Milestones you can only see the ones shared with current project you are focused on. The show items from child projects does not work with Milestones.
I have a custom app that does show all Milestones in Rally regardless of projects, but an export button was never coded into it. I am not a developer, not able to add it. Maybe I can trade this code with someone who can add the export button to it? You get the app and I get it modified, win/win maybe :)