CSV Export via Report Grid - No Quotes Around Strings

[rode...@roderickforsythe.com]

Hello,

When exporting reports where data elements are free-form text fields with line feeds (\n) - the export to CSV is not readable. How can I create a CSV from a reports (or directly from a collection) where I can create a safe CSV?

Thanks!

[Shobhit Tripathi]

Hi,

For creating a CSV from collection you need to follow below steps:

1. First of all you have call all the value from collection which you need to save in csv file. Below is the link to do that:
    http://docs.runmyprocess.com/Developer_Guide/Collection/Collection_JS_Freemarker#list-objects_1
   
2. Now you have to convert above (which is in JSON format) records into CSV format, please find attached file (JSON to CSV.txt).

3. After that you have to use create_file function for creating a file. Refer this link:
    http://docs.runmyprocess.com/API_Reference/FM/File.html#create_file
   
4. Finally you should use update_file function in which you are giving the extension of your file (.csv) refer below link:
    http://docs.runmyprocess.com/API_Reference/FM/File.html#update_file
   
Please find attached screenshot where I mentioned each point.

If you still facing any problem, then feel free to ask.

Thanks & Regards,
Shobhit

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/c1e1e44a-87f0-41be-9890-7f5a7a81d4e4%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.