Automating a .csv file import/transform as a scheduled task

[jared_wentzel]

Hi All!

I am looking to schedule a task to load a .csv file and run the transform using a certain field map about every 15 minutes. I can already do this manually but I know its a completely different ball game when it comes to scheduling all of it. So my questions are... And I do appologize for all these questions I have been asking, I try to search for the answer before asking and find like 10 different wiki pages I need to read through before even grasping the concept and of course everything I have been working on was needed yesterday (We are implementing in a month and I am the lead admin who just finished the basic admin training a month ago, and I dont even know javascript..) I am learning a lot from all of the help I have received here as well as the wiki articles you all have recomended and I hope these questions will help other newbies who search these forums

• Where do I go in ServiceNow to schedule tasks?
• Where should I place the .csv file so the servicenow scheduler can grab it and do the "Load Data" Procedure?
• How to I automate the load data procedure?
• How to do I tell it what transform map to use?

[Pascal Lepine2]

Try this one found on ServiceNow Share: Remote File Importer.   You will be able to import file from your MID Server and you can schedule it when you want!

[jared_wentzel]

Thanks! I'm looking into an option that will untilize an inbound email action. Have our internal process fire an email with the .cvs file attached then have servicenow run a script that attaches the file to the datasource that I have setup. after the schduled load runs have it delete the attached .cvs file from the datasource by adding this javascript to the onAfter tansform... It's seems plausible, but so far I can't even delete the attachment. Is anyone else doing something like this?

[Jacob_Andersen]

You really have two good options:

Set up a public FTP site and use the schedule data source feature in ServiceNow to load the CSV and have it transformed into a target table.

Use something like the Crossfuze File Importer (link provided by another comment on here on snguru.com) to simply have a remote CSV file sent to the SN instance via the mid server on a scheduled basis to ultimately be transformed by the system transform maps.

[jared_wentzel]

I know I was just exploring all my options so I can present them to the team. Thank you everyone for all your input!

Oh and I finally got it to work via email attacment

[aurora_campero]

Hi Jared,

I would like to ask you how did you manages the case when the load fails or when data are not correct?