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 · Accepted solution]

Hi Harish,

you can use script to create csv file and then attach to RITM

refer below links on how to create file from script and how to attach

you can enhance your script accordingly.

Generate csv file with the catalog variables and attaching to RITM record

Generate CSV file through script

Regards
Ankur

[Harish27]

Hi Ankur Sir,

Thank you very much.. Achieved my requirement. 🙂

[Ankur Bawiskar]

You are welcome

Happy learning

Regards
Ankur

[Harish27]

Just one more question.. I hope this is easy when we do it with export set and mid server.

The requirement was to send the data file from mid server to share point. Any idea on how we can achieve this one sir.

Thank you !