Using excel/csv file values to display in collection/report interface

[menos...@googlemail.com]

hi guys,

Im currently working on a application that allows people to view data. However i would like to know whether its possible to use data from a excel sheet or csv file and display them in a interface (collection/report widget. So in principle it should pull up specific cells or types of data and display it in the report interface.

Thanks in advance

[Pankaj Kumar]

Hi,

You can import the csv data using the free marker method "import_objects", it will import the data in a collection and you can use collection data to show it in report.

Also you can make query on collection data to show specific data of the as per your business logic.

 

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" 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/3f6551ad-6b37-4bd1-92b1-3887a5a2b7d6%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[menos...@googlemail.com]

Hi thank you, i would like to display only certain cells of data from the csv file. Are you able to tell me how i can do this? would appreciate it if you could give me an example.

Thanks

Menoss

[Bidisha Das]

Hi,

You can download the CSV file in RMP using File upload widget on web Interface.After that you can use import_objects("file_id","Collection_name", ",", "true") in process to import the file content into collection.

Please refer to : http://docs.runmyprocess.com/API_Reference/FM/Collections.html

You can then configure report widget on WI where you can display whichever columns you want to from CSV file.You just need to put the column name as in CSV in Property name in report.

Thanks & Regards

Bidisha