How to automate export list to csv and upload to ftp server on regularly

[jonnyyan]

Hi Team,

we have a requirement that automate export the customer list as csv and upload the file to ftp server on regularly.

i'm a refresh man on servicenow development, could you give me some suggestion and process how to achieve this?

it's prefer to provider some example on this.

many many thanks

[Ankur Bawiskar · Accepted solution]

Hi Jonny,

ServiceNow provides a functionality to export table extract using schedule to a MID Server via Export Set application

Things required:

1) MID Server - MID Server Installation - ServiceNow Wiki

2) Export Set - Export sets

3) MID Server Script Include which will be mostly java code which picks file from mid sever location and uploads it to ftp location

4) FTP Username, password, directory

5) Somewhat java skills

https://www.servicenowguru.com/integration/exporting-report-ftp/

Send an Attachment from Service Now and store it on FTP server via MID server | Gyan'o'Mania

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

[jonnyyan]

Hi Ankur,

many many thanks for you reply, i will try it on your guide.

Thanks

Jonny

[Ankur Bawiskar]

Hi Jonny,

Yes you can proceed in that direction.

Could you also mark the answer as helpful and hit like. Thanks in advance.

Regards

Ankur

[Himmat Singh Bh]

Hi Ankur,

Does anyone know what should be the value of TRANSPORTMETHOD in the properties?

jspr.addParameter("transportMethod",type);

Thanks in advance.