Exporting timeline iterations from RTC/Jazz to Outlook via CSV

README.md

Exporting timeline iterations from RTC/Jazz

0. locate timelines via RPT API (Script 1)
1. store result to file, convert to csv with powershell (Script 2)
2. Import CSV with LibreOffice Calc because Excel and Outlook are too stupid to parse the timestamps properly
3. save as CSV again, will use display values Outlook understands
4. in outlook
   1. File → Open & Export → Import/Export
   2. Import from another program or file → Comma Separated Values
   3. Browse for your CSV file and choose destination folder
   4. Map Custom Fields..., drag&drop fields from left to corresponding fields on the right.
   5. Import
5. Profit!

Script 1

# locate project by itemId
https://rtc.example.com/rtc5a/rpt/repository/foundation?fields=projectArea/projectArea/(name|itemId)
# show timelines
https://rtc.example.com/rtc5a/rpt/repository/foundation?fields=developmentLine/developmentLine[projectArea/itemId=_fJa5TuB7EeWm-bMUxjFWHQ]/*
# top level
https://rtc.example.com/rtc5a/rpt/repository/foundation?fields=developmentLine/developmentLine[itemId=_4DriACQUEeazc4KJdkzQug]/*
# second level
https://rtc.example.com/rtc5a/rpt/repository/foundation?fields=iteration/iteration[itemId=_4DriASQUEeazc4KJdkzQug]/*
#  All neted second level iterations
https://rtc.example.com/rtc5a/rpt/repository/foundation?fields=iteration/iteration[itemId=_4DriASQUEeazc4KJdkzQug]/children/children/(name|startDate|endDate)

Script 2

[xml]$iterations = get-content .\foundation.xml
$iterations.foundation.iteration.children | % { $_.children } | select | Convertto-csv