Export a report on an ftp server

[pierre_lambercy]

I would like to schedule a report to be posted on an ftp server on daily basis.

Did someone manage to do that?

Currently, the work-around I have is to schedule the distribution of the report via email and then run a script in outlook to detach it automatically on a folder.

[shetzel]

I'm also interested in this, anyone know how it can be accomplished? - Thanks.

[Jacob_Andersen]

I am working on a new version of this data extract functionality and should be completed with it soon. I'll let you guys try it out when I am complete.

Thanks.

[#4]

Hi Jacob

I tried to access the demo site to see the script and the id and password listed above did not work. Is there another way to see the script that you wrote?

Thanks.

[devikas]

Hi Anthony,

I am not able to find the Data Extract Update set.

Could you please help me to get the update set.

Thanks in advance,

Devika Shukla

[Jacob_Andersen]

I have completed the update set to provide functionality for a SN administrator to publish a report to an FTP/FTPS/MidServer at regular intervals. As this is an update set and not a plugin, there are a couple of steps that must be taken before installing the update set:

////// Mid Server Setup /////
-Install the Mid Server plugin
-Download a mid server by going to Mid Server->Downloads
-Install the mid server on the platform of your choice in your environment
-Once installed, take download ftp4che.jar (ver 0.7.1) file (I found a copy here: http://tinyurl.com/kwd73x) and place it in your agent/lib directory.
-Start/restart the mid server.

//// Retrieve and install the update set ////
-Install the System Update Sets (remote update set support) plugin
-Find System Update Sets->Update Source
-Create a new source using https://demoja.service-now.com user:forum pass:forum
-Retrieve and commit the Scheduled Data Extract 2.0 update set.

//// Try it out ////
-There will be two new modules under the Reports application called Scheduled Data Extract and Data Extract History.
-Open Scheduled Data Extract and create a new record.
-The form should be self-explanatory. The mid server should be the mid server that you just installed.

------------
Brief process flow
------------
At regular intervals, specified in the scheduled data extract record, the assigned mid server will retrieve the desired report and save it in a local temp directory.
If the target was specified to be the mid server, it will move the file to the located specified in the data extract record.
If the target was specified to be an FTP server, it will FTP the CSV/XML file to the target FTP server using the FTP credentials specified in the data extract record.
If the target was specified to be an FTPS server, it will FTPS the CSV/XML file to the target FTPS server using the FTP credentials and method (Auth TLS, Implicit SSL, etc) specified in the data extract record.

Feel free to give it a try and let me know of any feedback that you have.