Automatic import sets

[ant_niopires]

Hi all,

I have a question about import sets.

I want to make regular (once a week) data updates to a table created in my instance.

Is there a way to automate an import set to run at x hours, on y day, using the same data source, with the created transform map

and to the same target tabel? and that repeats itself after a few days?

This way i could only change my data in the data file and then the update in my instance would be done.

If this is not possible, is there a close solution to this? Maybe not everything in this process can be automated but perhaps

some of the steps on it might be automated.

Thank you for you attention,

António Pires

[ant_niopires]

Amazing!

Thanks for all the help everyone

[nayanawadhiya1]

Hey Antonio,

        Refer this for Scheduling Import Sets -

        Scheduling Data Imports - ServiceNow Wiki  

[Rakesh Mamidi]

In Data source, You should have "Import set table Name".when this table is set and in first   import run ,all excel sheet columns (as per data source data like sheet number and header row number) will be automatically created in import set table(as string fields)

This allows you to do mapping fields in transform map. In case you are not able to run import using data source - manually import excel sheet to our import set table so that if will create all fields.

You can refer table import_log for any error logs.