Generate data to Excel

[freal...@gmail.com]

Hi.
Is it possible to generate data for excel sheet ?

[Pankaj Kumar]

Hi,

Currently no default freekarker method available to extract the data from an excel file. You can use 3rd party tools aor API to convert the excel data in a csv file or JSON and by using CAPI, you can process that data in RMP.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

On Fri, Nov 20, 2015 at 3:57 PM, <freal...@gmail.com> wrote:

Hi.
Is it possible to generate data for excel sheet ?

--
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/9b64afa7-59b0-42b5-914c-ba8c7fa49c4a%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[freal...@gmail.com]

My goal is extract data to excel and not from excel. I have one order with data and I want extract this data to excel. In spite of generate a PDF file I want generate a Excel file, understand?
Can you explain me how I can do this?

[Pankaj Kumar]

Hi,

Generating excel file is not supported by RMP as of now. Alternatively you can try to write the data on Google Sheet. Please refer to previous post on support forum on this.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

On Fri, Nov 20, 2015 at 4:41 PM, <freal...@gmail.com> wrote:

My goal is extract data to excel and not from excel. I have one order with data and I want extract this data to excel. In spite of generate a PDF file I want generate a Excel file, understand?
Can you explain me how I can do this?

--
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/fa3a7573-ddfd-4a38-a51c-056cd34a2656%40runmyprocess.com.

[freal...@gmail.com]

Hi Pankaj.
So, it isn't possible generate. But you said that is possible convert to csv file right? How I can do this?

[Pankaj Kumar]

Hi,

You can use the method "create_file(name, content, charset, contentType)" to generate a csv file from process variable.Please refer to below link

• http://docs.runmyprocess.com/API_Reference/FM/File.html#create_file
  

To pass the content of the csv file, please use the below structure in a variable in input/output tab. here we are passing the value of variable "first_name" and "last_name" in csv.

content = 

firstName, lastName

${first_name},${last_name}

Also you can use "json_to_csv" freemarker method to create a csv file from JSON to csv. Please refer to below link to get more detail about the method.

• http://docs.runmyprocess.com/API_Reference/FM/Utilities.html#json_to_csv
  

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

On Fri, Nov 20, 2015 at 4:59 PM, <freal...@gmail.com> wrote:

Hi Pankaj.
So, it isn't possible generate. But you said that is possible convert to csv file right? How I can do this?

--
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/1e1e20eb-276b-4e3e-bd63-6d0737bee38b%40runmyprocess.com.

[freal...@gmail.com]

Hi Pankaj.
Can you send me screenshots with an example for I understand?

[Murali]

Hi,

Unfortunately, we are not allowed to provide the code that is specific to application requirement.

And it will be considered as personalized assistance through a dedicated consultant with support hours purchased on your account.

Please write to con...@runmyprocess.com to get in touch with our Sales team. 

Once you have the support hours, Kindly raise a case on RMP Support Portal  to streamline this requirement.

Feel free to ask for any queries on the same.

Regards,
Murali

[freal...@gmail.com]

Hi.
I already send email but nobody answers me. How I can pay to have support?