Data Source - File Path issue

[catchdini]

Im using an excel file in a midserver that is configured, to import into Users table. In Data Sources, I have chosen 'File retrieval method' as 'File' and in the 'FilePath', Im giving it as 'MIDServer_xxxxxx\C:\Users\XXX\Desktop\MidServer_User_Import.xls' where MIDServer_xxx is the midserver name. When I try to test load, Im seeing java.lang.SecurityException: invalid file name. Attached the screenshot of both. Please let me know how I should point to the file, which is in the mid server in 'File Path'.

[Pradeep Sharma]

Hi,

Try to give only the file path and check if it works

Also please go through the below wiki link section 2 for further info

Data Sources - ServiceNow Wiki

Thanks,

Pradeep Sharma

[catchdini]

I tried that link already but I couldn't find help out of it. I noticed that the file path that they have mentioned is /root/... which we normally use in Unix. Since my midserver is a Windows and Im pretty much sure that the file path is the problem. This is clearly visible in the error message I get, attached in the screenshot too, when I posted.

[Sanjeev Kumar1]

Hi,

If you want to use excel file from MID Server you need to use "Scheduled File Import" under File Import.

[catchdini]

Hi,

I don't see the option in my instance. From where did you update it? Can you plz share me the xml?
Thanks in advance.