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]

Here you go

http://www.servicenowguru.com/integration/scheduled-file-import-mid-server/

[catchdini]

I already contacted Crossfuze but they are charging for this feature. I don't think I can go for that.

[catchdini · Accepted solution]

The right way to do is to give the path in the UNC format

[dap1]

Hello catchi dini,

I'm facing exactly the same issue when configuring an excel spreadsheet as a data source, would you mind explaining to me How to achieve this, please.

I ´ve Installed a MID Server and I ´ve tried the following combinations for the path but nothing works:

'MIDServer_xxxxxx\C:\Users\XXX\Desktop\MidServer_User_Import.xls'

'MIDServer_xxxxxx/C:/Users/XXX/Desktop/MidServer_User_Import.xls'

'//hostname/C$/Users/XXX/Desktop/MidServer_User_Import.xls'

'\\hostname\C\Users\XXX\Desktop\MidServer_User_Import.xls'

'//MIDServer_xxxxxx/hostname/C$/Users/XXX/Desktop/MidServer_User_Import.xls'

Thank you in advice.

[peterskvarenina]

Hi,

I have the same issue, can you please write the specific path to the file you used ? Nothing works for me.

Thank you