Import a file to Servicenow from MID Server

[Sathwik1]

I need to import a csv file from MID Server daily... Daily once the 3rd party will place a csv file in the MID Server...when ever they place I need to place that file in our MID Server...

Can anyone help me with this?  I referred previous community questions but I didn't get complete clarity...so please help me to understand clearly

[Ankur Bawiskar · Accepted solution]

@Sathwik 

Please find responses below

Question 1: Regarding First Script [Background Script ]

Should I run this in our instance is enough ? (or) should I login to Server in which MID Server is located and there I need to login to my developer instance and run?

- you should run this from your instance which is configured with the mid server

Question 2 : Regarding Business rule..

By this business rule..where my CSV file will get stored? It needs to attach to a import table in our instance

- you can attach it to the data source which you require to be transformed

- remember you need to trigger the transform as well once file gets attached to data source

Question 3 : This Process needs to run daily at certain time..

- create a schedule job which runs daily and uses the script shared above

Regards
Ankur

[Ankur Bawiskar]

@Sathwik 

Hope you are doing good.

Let me know if I have answered your question.

If so, please mark appropriate response as correct & helpful so that this thread can be closed and others can be benefited by this.

Regards
Ankur

[Sathwik1]

@Ankur Bawiskar 

Thanks for your support.....

I found some simple solution by using "Remote import file" by using this I can import files from MID Server to servicenow by scheduling some particular time...

[Ankur Bawiskar]

@Sathwik 

I believe it is some custom solution available to download.

The approach I shared will also work.

Let me know if I have answered your question..

If so, please mark my response as correct & helpful so that this thread can be closed and others can be benefited by this.

Regards
Ankur

[Sathwik1]

@Ankur Bawiskar 

Hi, I tried your method but I was not able to understand the procedure what you have said but it is quite interesting...I will try it again....Thank you so much @Ankur Bawiskar for your kind support everytime