How can I create a CSV file

[emon...@lanogalera.biz]

How can I create a csv file with the data from the web interface?

[Gunjan Rajgure]

Hello Sir,

You need to write javascript code to create csv file. There is code available in javascript. Just need to get data from Web Interface into array and using some javascript code you can create a csv file with that data.

Hope this will helps you. Please don't hesitate to contact us for more query.

Thanks & Regards,

Gunjan Rajgure

Fujitsu - RunMyProcess Support

On Thu, Aug 10, 2017 at 6:04 AM, <emon...@lanogalera.biz> wrote:

How can I create a csv file with the data from the web interface?

--
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+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://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/e1af327f-705f-4953-870b-b31c5b75a9bc%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Gunjan Rajgure]

Hello Sir,

Could you tried JavaScript code to create csv file? Please let us know if you are facing any issue.

 

Don't hesitate to contact us for further query.

Thanks & Regards,

Gunjan Rajgure

Fujitsu - RunMyProcess Support

[emon...@lanogalera.biz]

Helle Gunjan

I'm tried this javascript code, the data I want to wrtie in my csv was in array widget named TratoArray.

function JSON2CSV(objArray) {
var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
var str = '';
var line = '';
var head = array[0];
for (var index in array[0]) {
line += index + ',';
}
line = line.slice(0, -1);
str += line + '\r\n';
for (var i = 0; i < array.length; i++) {
var line = '';
for (var index in array[i]) {
line += array[i][index] + ',';
}

line = line.slice(0, -1);
str += line + '\r\n';
}
return str;
}
var array=RMPApplication.get("TratoArray");
alert(JSON2CSV(array));

Thanks

On Monday, August 14, 2017 at 12:18:31 AM UTC-6, gunjan.rajgure wrote:
> Hello Sir,
>
>
> Could you tried JavaScript code to create csv file? Please let us know if you are facing any issue.
>
>
>  
> Don't hesitate to contact us for further query.
>
>
>
>
> Thanks & Regards,
> Gunjan Rajgure
> Fujitsu - RunMyProcess Support
>
>
> On Sat, Aug 12, 2017 at 11:46 AM, Gunjan Rajgure <gunjan....@runmyprocess.com> wrote:
>
> Hello Sir,
>
>
> You need to write javascript code to create csv file. There is code available in javascript. Just need to get data from Web Interface into array and using some javascript code you can create a csv file with that data.
>
>
> Hope this will helps you. Please don't hesitate to contact us for more query.
>
>
>
>
> Thanks & Regards,
> Gunjan Rajgure
> Fujitsu - RunMyProcess Support
>
>
>
>
> On Thu, Aug 10, 2017 at 6:04 AM, <emon...@lanogalera.biz> wrote:
> How can I create a csv file with the data from the web interface?
>
>
>
> --
>
> 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.

[Gunjan Rajgure]

Hello Sir,

You can try out following code to generate csv data.

// Here is the Code.

var var1 = RMPApplication.get("var1");

var var2 = RMPApplication.get("var2");    // Get your web interface data.

var var3 = RMPApplication.get("var3");

var data = [[var1,var2,var3,...]];    // Put your Web Interface data in array

 

function download_csv_file() {

    var csv = 'var1,var2,var3\n';

    data.forEach(function(row) {

            csv += row.join(',');

            csv += "\n";

    });

 

    console.log(csv);   // You can check csv data on browser console.

    var csv_data = document.createElement('a');

    csv_data.href = 'data:text/csv;charset=utf-8,' + encodeURI(csv);

    csv_data.target = '_blank';

    csv_data.download = 'csv_file.csv';   // Name of the file which is download in csv format (you can define the name)

    csv_data.click();

}

download_csv_file();   // Call this function on button click of Web Interface.

Hope this will helps you. You can check your CSV data on browser console.

Please feel free to contact us for further query.

Thanks & Regards,

Gunjan Rajgure

Fujitsu - RunMyProcess Support

To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://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/1c7213c9-5dc1-4c82-91e3-a4b5d822bace%40runmyprocess.com.

[Dipen Raval]

Hi Sir,

Good Day.

Could you please confirm that issue has been clarified?

Please don't hesitate to contact us for any further query.

Thanks & Regards,

Dipen Raval

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CA%2B3gzEg-f0L%2BZqW%3DzKyGgzqZphDYW7hKMnk86c0RvOm0JmUPhw%40mail.gmail.com.

[Dipen Raval]

Hi Sir,

Awaiting for your response.

Thanks & Regards,
Dipen Raval
Fujitsu RunMyProcess Support

On Mon, Aug 21, 2017 at 6:18 PM, Dipen Raval <dra...@runmyprocess.com> wrote:

Hi Sir,

Good Day.

Could you please confirm that issue has been clarified?

Please don't hesitate to contact us for any further query.

Thanks & Regards,

Dipen Raval

Fujitsu RunMyProcess Support

[emon...@lanogalera.biz]

On Tuesday, August 22, 2017 at 3:26:50 PM UTC-6, draval wrote:
> Hi Sir,
>
> Awaiting for your response.
>
> Thanks & Regards,
> Dipen Raval
> Fujitsu RunMyProcess Support
>

> Sorry for the late!

I have tried but its doesn't work, its fail in the line
> var data = [[var1,var2,var3]];

> To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/1c7213c9-5dc1-4c82-91e3-a4b5d822bace%40runmyprocess.com.
>
>
>
> For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.
>
>
>
>
>
>
>
> --
>
> 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 https://groups.google.com/a/runmyprocess.com/group/supportforum/.
>

[Prachi Chandak]

Hi Sir,

I would suggest you to share your code as well as WI configurations of widget for which you want in there value in CSV file.

Please feel free to contact us for any other help.

Thanks & Regards,

Prachi Chandak

Fujitsu RunMyProcess Support

To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://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/ae1be2ed-af36-479f-905f-884b23617fbd%40runmyprocess.com.

[Gunjan Rajgure]

Hello Sir,

I think you have confusion between JS variables and the variables used in "RMPAppliction.get", please try out following code to generate csv data.

Get your Web Interface data into the JavaScript variables and add that data into the array named as "data". I used here var1, var2...... and value1, value2...... as example purpose.

// Here is the Code.

var var1 = RMPApplication.get("value1");

var var2 = RMPApplication.get("value2");    // Get your web interface data. 

var var3 = RMPApplication.get("value3");

var data = [[var1,var2,var3,...]];    // Put your Web Interface data in array

 

function download_csv_file() {

    var csv = 'var1,var2,var3\n';

    data.forEach(function(row) {

            csv += row.join(',');

            csv += "\n";

    });

 

    console.log(csv);   // You can check csv data on browser console.

    var csv_data = document.createElement('a');

    csv_data.href = 'data:text/csv;charset=utf-8,' + encodeURI(csv);

    csv_data.target = '_blank';

    csv_data.download = 'csv_file.csv';   // Name of the file which is download in csv format (you can define the name)

    csv_data.click();

}

download_csv_file();   // Call this function on button click of Web Interface.

Hope this will helps you. You can check your CSV data on browser console. Please confirm csv data on browser console by pressing F12.

Please feel free to contact us for any further query.

Thanks & Regards,

Gunjan Rajgure,

Fujitsu - RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CA%2BDBeVJ1M%2BPaJoefU%3DqEK81XnRmK3v_4EMU_23VAf09ti4ALGA%40mail.gmail.com.

[Abhilash Sambhare]

Hello Sir,

Have you implemented the solution provided in the earlier post.Please don't hesitate to contact us.

Thanks & Regards,

Abhilash Sambhare

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CA%2B3gzEiwX6sz%3DZteb-1aKkoe3QGxJXRq2_8EWzAgZFjbz__pSA%40mail.gmail.com.

[emon...@lanogalera.biz]

On Wednesday, August 9, 2017 at 6:34:16 PM UTC-6, emon...@lanogalera.biz wrote:
> How can I create a csv file with the data from the web interface?

Hi Gunjan Rajgure

Im tried this code on the console browser line by line but its fail on the last line (var data = [[var1,var2,var3]];) #N/A
var var1=RMPApplication.get("productor");
alert(var1);
var var2=RMPApplication.get("procedencia");
alert(var2);
var var3=RMPApplication.get("calidad");
alert(var3);
var data = [[var1,var2,var3]];

[Gunjan Rajgure]

Hello Sir,

That line means you are adding your Web Interface values into the array and using that array you need to perform iterations on array to create comma separate value. Can you please share screen shot of error you are getting, that will be helpful for better understanding. 

Please feel free to contact us for any further query.

Thanks & Regards,

Gunjan Rajgure

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+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://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/8eabd841-49c5-443f-9472-677089f507fb%40runmyprocess.com.

[Dipen Raval]

Hi Sir,

Awaiting for your response.

Thanks & Regards,
Dipen Raval
Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CA%2B3gzEj_R%2BOOvE--FD1HXcakY2R8NcLpdJt%2Bvu15kFiqZHktiQ%40mail.gmail.com.

[emon...@lanogalera.biz]

On Wednesday, August 9, 2017 at 6:34:16 PM UTC-6, emon...@lanogalera.biz wrote:

> How can I create a csv file with the data from the web interface?

I attach the screenshot

Cordially
Edgar Montoya

[Gunjan Rajgure]

Hello Edgar,

There is syntax error in array declaration, apology for that. You can use same code as

// Same code as above.

var var1 = RMPApplication.get("value1");

var var2 = RMPApplication.get("value2");    // Get your web interface data. 

var var3 = RMPApplication.get("value3");

var data = [

                   [var1,var2,var3,...]

                 ];    // Put your Web Interface data in array. Here is the change only.

 

function download_csv_file() {

    var csv = 'var1,var2,var3\n';

    data.forEach(function(row) {

            csv += row.join(',');

            csv += "\n";

    });

 

    console.log(csv);   // You can check csv data on browser console.

    var csv_data = document.createElement('a');

    csv_data.href = 'data:text/csv;charset=utf-8,' + encodeURI(csv);

    csv_data.target = '_blank';

    csv_data.download = 'csv_file.csv';   // Name of the file which is download in csv format (you can define the name)

    csv_data.click();

}

download_csv_file();   // Call this function on button click of Web Interface.

Just declare array as -

 Instead of var arr=[[a,b,c,d]]; use 

var arr=[

               [a,b,c,d]

             ];

Note: Don't forget to see output on browser console by pressing F12.

Please feel free to contact us for any further query.

Thanks & Regards,

Gunjan Rajgure

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+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://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/0353d182-14e3-4db0-85ec-b99638097410%40runmyprocess.com.

[Dipen Raval]

Hi Sir,

Good Day.

Could you please confirm that issue has been clarified?

Please don't hesitate to contact us for any further query.

Thanks & Regards,

Dipen Raval

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CA%2B3gzEj7di2siOBbB4jtWJAUPdinZ-%3D6CsgZ0FBsZE7HBj4tRA%40mail.gmail.com.

[Prachi Chandak]

Hello Edgar,

Have to able to create CSV  file or you are still facing any issues.

Please confirm if the issue has been clarified.

Thank you for contacting.

Thanks & Regards,

Prachi Chandak

Fujitsu RunMyProcess Support

On Thu, Sep 7, 2017 at 2:19 AM, Dipen Raval <dra...@runmyprocess.com> wrote:

Hi Sir,

Good Day.

Could you please confirm that issue has been clarified?

Please don't hesitate to contact us for any further query.

Thanks & Regards,

Dipen Raval

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CALU-SgpgpJmfFUsi-SCoACpBqrWzOiM36NfDgFLeiZr1%2BpJuXA%40mail.gmail.com.

[Dipen Raval]

Hi Edgar,

Awaiting for your response.

Thanks & Regards,
Dipen Raval
Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CA%2BDBeVLWCitsid2Pr35vLsKctwSKs1NzxC9tzT7mW8cWFVtFGQ%40mail.gmail.com.

[emon...@lanogalera.biz]

Sorry for the late

I create the csv with this code:

function JSON2CSV(objArray) {
var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
var str = '';
var line = '';
var head = array[0];
for (var index in array[0]) {
line += index + ',';
}
line = line.slice(0, -1);
str += line + '\r\n';
for (var i = 0; i < array.length; i++) {
var line = '';
for (var index in array[i]) {
line += array[i][index] + ',';
}

line = line.slice(0, -1);
str += line + '\r\n';
}
return str;
}

var prod=RMPApplication.get("productor");
var proc=RMPApplication.get("procedencia");
var vol=RMPApplication.get("volumen");
var pp=RMPApplication.get("precPunto");
var cal=RMPApplication.get("calidad");
var rc=RMPApplication.get("repCompra");
var com=RMPApplication.get("comision");
var cp=RMPApplication.get("condPago");
var tt= RMPApplication.get("tipTrato");
var array=[{"Productor":prod,"Procedencia":proc,"Calidad":cal,"CondPago":cp}];

alert (JSON2CSV(array));
But i how can I sent this code by email or ftp as a file?

On Monday, September 11, 2017 at 5:48:37 AM UTC-6, draval wrote:
> Hi Edgar,
>
> Awaiting for your response.
>
>

> 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 https://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/0353d182-14e3-4db0-85ec-b99638097410%40runmyprocess.com.
>
>
>
> For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.
>
>
>
>
>
>
>
>
>
> --
>
> 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 https://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/CA%2B3gzEj7di2siOBbB4jtWJAUPdinZ-%3D6CsgZ0FBsZE7HBj4tRA%40mail.gmail.com.
>
>
>
> For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.
>
>
>
>
>
>
>
> --
>
> 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 https://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/CALU-SgpgpJmfFUsi-SCoACpBqrWzOiM36NfDgFLeiZr1%2BpJuXA%40mail.gmail.com.
>
>
>
> For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.
>
>
>
>
>
>
>
> --
>
> 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.

[Ankita Shrinath]

Hi Edgar,

Good Day.

All our apology for delay in response.

To send the csv file that you have downloaded, please follow the below steps:-

1.Add ‘File upload’ widget to web interface. Give the variable name to the widget (eg. File_upload).

2.Now create a process that sends the csv file (uploaded using ‘File upload’ widget) via email.

3.When you select the activity, in the Functional tab select Type as ‘Email/Notification’. In the ‘Send an email/a notification’ tab, enter the required details, check ‘Notify via email’ checkbox. Select Provider as ‘Default mail server’. In the Attach file option, click on ‘Open an editing window’ and write the following script code:

<#assign file_list=[]>

<#list file as x>

<#assign file_list = file_list +[x.id]>

<#list>

${file_list}

Here “file” is ‘File upload’ widget’s variable name.And save the process.

4.Now in web interface add a button. Select ‘Action’ as Start process. Then click on choose process and select the process that you have created (to send email).

Hope this steps will help you to send file via email.

Please feel free to contact us for any further information.

Thanks & regards,

Ankita Shrinath

Fujitsu RunMyProcess Support

[Dipen Raval]

Hi Edgar,

Good Day.

Could you please confirm that issue has been clarified?

Please don't hesitate to contact us for any further query.

Thanks & Regards,

Dipen Raval

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+unsubscribe@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://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/CA%2BifTbmJ5O%2BCzxZzZs7TNsj7J%3DgiNnYE4A1ZxAENh6ud-VAE8A%40mail.gmail.com.

[emon...@lanogalera.biz]

On Wednesday, August 9, 2017 at 6:34:16 PM UTC-6, emon...@lanogalera.biz wrote:

> How can I create a csv file with the data from the web interface?

Thanks is clrarified, but I use jsontocsv in the process

Thank you again for the support