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'.

[Richard Hine]

I ran into this issue with the UNC path not being picked up, the fix was relatively simple. I had to just put an additional backslash in to escape the previous one...

In the example above ('\\hostname\C\Users\XXX\Desktop\MidServer_User_Import.xls')

I would have set \\\\hostname\\C\\Users\\XXX\\Desktop\\MidServer_User_Import.xls

Hope this helps...