Scheduled Export of a file in CSV format into a shared folder through MID Server

[Teja31]

Scheduled Export of a file in CSV format into a shared folder through MID Server

[Ankur Bawiskar]

Hi,

For this you would require to use ServiceNow Export Set Functionality and use MID Server. It does following:

- Configure table, conditions and columns to be included via Export Definition

- Configure export target; it says to which location it will be placed

- Configure Export Set; it links export definition and export target together; specify file type csv/xls/xlsx and file name convention, timestamp to be appended

- Configure Scheduled Export Set; link Export Set to it; select time to run; run as user

https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/administer/export_sets/concept/c_...

https://docs.servicenow.com/bundle/helsinki-platform-administration/page/administer/export-sets/conc...

https://docs.servicenow.com/bundle/helsinki-platform-administration/page/administer/export-sets/conc...

https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/administer/export_sets/concept/c_...

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Teja31]

Hi,

Thanks for your reply!!

I created Export set and I linked it to export target and export definition. And when I run Export data, It is creating an attachment in Mid Server Attachments table in servicenow, But we need to have that file to be loaded or updated in the shared drive.

Thanks,

Teja

[Ankur Bawiskar]

Hi,

This is not possible directly. what you can do is execute post export script and have mid server script include which will have java code to pick that file from folder location and upload.

you need to check any existing java code available for this.

Regards

Ankur

[Teja31]

Hi Bawiskar,

When you get a chance, Could you please help me in the below post!!

https://community.servicenow.com/community?id=community_question&sys_id=facc2c31db191f487b337a9e0f961959

Thanks,

Teja