Getting a File from a MID Server - sounds easy ?

[Frank1975]

Hi all,

i am at the end of my understanding why this should be so difficult to get a csv-File from the MID Server (Not an FTP)   and import it into a Import Set table in Service Now.

Here are my attempts so far:

I tried Remote File Import which i found on Share, even so its from 2014 i was hoping it would still do the trick, I got the file and the Data got imported into the Import Set table. So far so good.

But it did the import twice. So instead of ending up with 30000 records, i ended up with 60000 records (duplicates). Tried a couple of things (there is not that much you can change in the settings) - No success.

Next try - JDBC File Loader also from the Share Site -   say works on Helsinki (which the above one did not)   This almost caused my DEV Systems to blew up. Somehow it got stuck in a loop and imported the Data from the csv File 4 times and i ended up with 120000 records. OK my bad, lets shrink down the records of the csv File to 100 rows. I did that using Notepad ++ . First run, i got 360 records, second try , without changing anything but delete the old records, i ended up with 180 Records. Third attemp, only deleting the records in the Import Set table gave me 460 records.

Is it really so difficult to import a CSV File with 30000 records in Service Now ?
Any suggestions what i could use or what i am doing wrong here ?

Any help is really appreciated.

Thanks
Frank

[sergiu_panaite]

Maybe this thread helps a bit?

MID Server CSV Importer

[Frank1975]

HI Sergiu,,

unfortunately even if i copy the script and replace it, still getting weird results. It still imports the rows two or three times.

I ended up writing a inbound action script and send the csv file to the Instance by email and have it imported (email attach, copy to datasource table, run a scheduled import)

Thanks

Frank