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.

[User150433]

I have applied the update set version 2.1.
I am exporting the entire user table in CSV format & getting Below error while executing the Scheduled Data Extract. I am putting the file in the MID server itself.

FTP Log:

Initializing SNDataRetriever
Running SNDataRetriever execute
Arriving to getReport function
Exception caught in SNDataRetriever->getReport: geamdev.service-now.com
Releasing Connection
The report was empty?

[Jacob_Andersen]

Amit,

Is your mid server going through a proxy to communicate with your SN instance? If so, can you email me at jacob.andersen@service-now.com and let's see if we can solve your problem.

[Jacob_Andersen]

Amit,

I am not sure what that problem is. Other customers are using this through a proxy and the debugging that I did for this on your system let me to believe that that might not be the issue. I am swamped right now, but encourage you to debug this if you are able to. I'd love to hear any feedback that you might have for this.

I would try pointing to a different FTP server, etc, to see if anything improves. Thanks.

[HunterSWolf]

Good Morning-

I was giving this a try in my Demo instance as it is close to what I would like to do but I am getting the below error in the Data Extract history.

Topic: JavascriptProbe
Queue: Input
Name: SNDataRetriever

[code]
<?xml version="1.0" encoding="utf-8"?>
Evaluation error: Caused by error in JavaScript probe 'SNDataRetriever' at line 1

==> 1: var req = new SNDataRetriever();req.getLog()

[/code]

[snowadmin]

Hi Anthony,

I am facing the same issue where my file is not getting transferred to FTP location from temp mid server location.

Please help me.

Regards,

Poonam Vashist