Import from an excel file every day

dianemiro · ‎08-02-2017

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 · ‎08-02-2017

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

View solution in original post

Kalaiarasan Pus · ‎08-02-2017

Please consider an alternate design if feasible as you are going to end up wiping the table daily and reloading it again. This is an inefficient way to do and will end up causing performance issues if the numbers of records being imported is large.

I would instead look for opportunities to directly consume any oracle or other data source and only insert/update/delete a day's record.