Import from an excel file every day

[dianemiro]

Hi,

I am new into importing files from ServiceNow. We have an excel file on a network drive that needs to be imported everyday to ServiceNow. Apparently, if we change the excel and remove something, the record from the ServiceNow was still there and existing. What is the proper import method so I can sync the excel file and SNOW list effectively?

[dravvyramlochun · Accepted solution]

Hello Diane,

When you are importing the data, are you mapping them using transform maps and import set?

If yes then you can set a coalesce on the tranform map and each and every time the import happens it will check the difference and map the updated fields accordingly.

Please check the documentation here:

http://wiki.servicenow.com/index.php?title=Importing_Data_Using_Import_Sets#Creating_a_Transform_Map

Some other community reference:

Data Import from Excel sheet to table

I want to import data to new table by excel file

[lSurya 24]

Hello Diane,

I would prefer to say, in order to import data on a regular basis, use LDAP.

http://wiki.servicenow.com/index.php?title=LDAP_Integration#gsc.tab=0

Getting Started with LDAP Integration - ServiceNow Wiki

[lSurya 24]

or refer to the below link where you might need to use mid server:

https://www.servicenowguru.com/integration/scheduled-file-import-mid-server/

[Ganesan M]

Hi Diane,

After having import set ready you can schedule it as per in the below link

Schedule a data import