Hello,
We're looking for a way to scrub our IdeaExchanges (individually) and export the data in a .csv file. This would include information like current status, labels, comments, and the body of the idea which is not currently available in LSI.
Has or is anyone doing this today? If so, any suggestions on what it would take to make it happen?
adsk_cmgrs another option is to do a search then export the result in csv. A setting needs to be set in the backend, check this thread for more information.
I would love more information VarunGrazitti!
OlivierS, would that search export contain all of the items listed in my original post?
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.
