Automatically export the table data as csv/excel file and attach it in RITM

[Harish27]

Hi ,

I am doing bulk upload of data into custom table. I am using data source and transform map to validate the data in the excel sheet and dump the data to a custom table.

Now I want to automatically export the data from custom table as csv/excel format and attach it in RITM.?

How can i achieve this?

Any help would be massively appreciated. Thank you!

[Ankur Bawiskar]

Hi Harish,

for that you would require mid server script include where you will have to code using java packages and javascript combination

Regards
Ankur

[Harish27]

Hi Ankur,

Will there be any performance issue if the table size is large (Ex.15k-20k) records?

Thanks&Regards,

Harish M

[Ankur Bawiskar]

Hi Harish,

it might take time depending on how much field data you want to push to that csv for those 15k-20k records

Regards
Ankur

[Harish27]

Hi Ankur,

Am able to generate the file but.. I need to save it as csv format again.

It should automatically write in csv and attach it as a file right.?

Upload Data is my resultant file after export.

Regards,

Harish M

[Ankur Bawiskar]

Hi Harish,

you can refer the above links it would help generating the csv file

Regards
Ankur