File from local drive on network as data source

[snowtech1]

Hello All,

We have an excel file in a drive on our local network updated daily by a webserver. It has limitations(as per the that team) to post it to a local drive.

All import sets and transform maps are setup and currently excel file loaded manually everyday.

Want to set a data source, so that the import can be scheduled. Have tried various methods(ftp,sftp) with credentials,path,domain name(used to setup the webserver to post the file).

But the result has been warnings/exceptions on the logs.

Am not wee versed in network/storage, conscious that servicenow is remote to the local network.

How to do we set external files as data sources? What are possible options for our scenario?

Any help would be useful.

tony.barratt

b-rad

Jamsta1912

[Chuck Tomasi]

You might find this helpful>

Scheduled File Import via Mid Server - ServiceNow Guru

[northfdl54937]

Chuch, Can you update this link???

[Jamsta1912]

Hello Snowtech,

I used SFTP for something very similar. But I had to rely on a guy from our Network team to set up the server and folder, and to provide the credentials. So my part was to set up the data source record in ServiceNow (using the credentials provided) and transform maps, and then create a scheduled import. On the data source record:

File Retrieval Method: SFTP

File Path: <path & name of file including extension>

Server: <ip address>

+ Username and Password.

Jamie.

[tantony]

Hi Jamie, Can you clarify more about the Server field? Did you use the username and password in the Server field '<ip address> + username:password' or filled the server field with '<ip address>' and provided the username and password in the username and password fields servicenow provides in the data source form?