IdeaExchange Data Scrub to .csv

Ok, what we do is we have a custom page set up on production, and a custom content on that page. We wrote a script using API, and add it to that custom content every time we need to get the updated report. The best thing about this is you can add any field in the report for your liking. Make it comma separated, run on the custom page.

Example :

<#assign ideaReport = restadmin("rest_call_url")>
<#list ideaReport.xyz as data>
${data.name}, ${data.author}, ${data.url}
</#list>

When you run the report, put come would be as:
Idea name, author name, url
Idea name 2, author name 2, url 2

You can copy paste it to note pad, save as. Csv, there you go.

I hope this helps.