Scheduling Data Imports and automating the transformation of data using transform maps

[abrahams]

I am able to import data into ServiceNow however I am struggling a bit trying to determine how I can automate the transformation of data to populate our ServiceNow tables from the import. I have the tranform maps set up and they work great manually. I have one import table that updates four ServiceNow tables. As it is now I've been doing this import of data manually. I would think that this process could be automated. Would anyone know how I could go about automating the running of those maps after the automated import occurs? Is there a way to state automatically run a transformation map? This is not an LDAP import.

[jason_petty]

Under the System Import Sets Application there is a module called Scheduled Imports. Set up a scheduled import there and you specify the data source you set up for your import before and the transform map is linked to that data source. It will fire on the schedule you give it and use the transform map automatically when it runs.

[abrahams]

That is how I had it set up however it just seems to import the data into the import set table as pending with a mode of "Synchronous". It doesn't automatically run the transform maps. Would it matter what file retrieval method I use in the Data Source?

[jason_petty]

What type of data source are you using? File, JDBC? And what kind of file retrieval method are you using if it is file type?

[abrahams]

I was trying this with an attachment. I am guessing that would be my issue. I am currently working with our server group to see if I can get FTPS or SCP set up on the server I am pulling the spreadsheet from to see if that will help to use one of those for the retrieval method. The spreadsheet gets updated daily so I will need the current spreadsheet information anyway and not just the one attachment.