CSV file from MIDserver to ServiceNow instance

cnavr_work
Kilo Expert

Hi,

I need to pull the CSV file located on the MID server to the specific table in the ServiceNow.

Any suggestions?

Thanks

Ctirad

1 ACCEPTED SOLUTION

Hi,


finally I used an asset from ServiceNow Share which does exactly what I needed.


There were only some small changes required for running it on Istanbul version.


But after the changes it is working perfectly.



Ctirad


View solution in original post

19 REPLIES 19

vab_13
ServiceNow Employee
ServiceNow Employee

Out Of The Box, MID server is not supported when using the "Data Source Type - File".


There might be some 3rd party custom solutions around this


https://community.servicenow.com/thread/162732


http://www.servicenowguru.com/downloads/?did=17



Vab


Stefan Baldhof1
Kilo Guru

Hi Ctirad,



for a similar use case we implemented a "workaround" by loading the csv files into a mySQL Database located on the MID server. Then you can use the standard import mechanisms to retrieve and load these data into the desired tables in ServiceNow.



Regards,


Stefan


Hi Stefan,


thanks for hint, but the customer insists that data would be in CSV (does not want to install additional DB) and wants to send via MIDserver to the ServiceNow instance.


Thanks


Ctirad


Hi Ctirad,



Any update on this?


Can you mark my answer as correct and hit like if you were near to achieving your requirement or already achieved. This helps in removing this question from unanswered list and allows others to find similar question easily. Thanks in advance.



Regards


Ankur


Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hello Stefan,



Can you please provide the steps that you used to implement this?   Did you use JDBC type data source?   How did you convert the csv file? This sounds perfect solution to our current problem.



Thank You,


Chad Wilhelm