Scheduled file import from Mid server

[kmayur]

I need to do a scheduled import of an .xls file placed on shared drive on a mid server. Any pointers please?

There is an update set available at servicenowguru's site for this. Does that wok for Calgary and higher versions?

Thanks.

[mfasko]

I am looking to do the same thing you are, and I have scoured the interwebs for the actual Update Set that the Guru article links to.....it has been removed from the site.

If anyone has a copy of a working version of that Update Set (Calgary), please let me know!

Thanks in advance...

[Inactive]

Michael,

As you can see in the link below:

» Downloads

The download button links you to the contact form. Contact Crossfuze for more details on the Scheduled File Importer module.

[mfasko]

Derek, I guess I assumed that means I'd have to pay for it....which is also not an option at the moment. And if somebody out there in the community had a copy of the free version of the Update Set laying around, this was my attempt to find said person and said free version of said Update Set, freely.

[sach1]

This can be done using DATA source and Schedule Imports.

Data Source:

File retrieval method as: SFTP

File Path: (your file location)

Server: IP of the server (we also gave the port number serverip:22)

Give the Import set table lable and name.

Once the data source is created, you can job in schedule Import.

Regards,

Sachin