It's all about the answers!

Ask a question

How can I automate the export of Reports to a csv or text file for ingestion into Power BI


Aaron Garcia (827) | asked Jan 09 '19, 9:00 a.m.

We are currently using Rational Team Concert CCM v 6.0.4. I want to make a few reports or queries and automatically export that data on a weekly or monthly basis to a designated directory. The csv or text files could then be ingested into Microsoft Power BI.

I have seen these topics regarding this:

https://jazz.net/forum/questions/94776/assertionfailedexception-problem-with-getting-the-values-of-attributes

https://jazz.net/forum/questions/168663/how-to-programatically-run-a-query-and-get-results-in-csv-form

 Having said that, if there is a piece of code that can already do this, please paste it in here and explain to me how I execute this code or run it to make RTC do what I want. Please don't refer me to some blog that has 37 answers and a series or comments that confuse the issue.

Thanks!

Accepted answer


permanent link
Ralph Schoon (63.1k33645) | answered Jan 09 '19, 10:23 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

 The only available automation I am aware of is https://github.com/jazz-community/work-item-command-line this was also mentioned in one of the answers on the questions you mention above.

Aaron Garcia selected this answer as the correct answer

Your answer


Register or to post your answer.