Developer forum

Forum » Integration » Excel Provider source file path not valid error

Excel Provider source file path not valid error

Thiago Tedesco
Reply

Hi, we are experiencing an issue when running an Integration Activity that uses the Excel Provider as the source provider.

When setting up the source provider, we are able to select the correct location from the file picker, in this example:

 

 

The local path for this on the host is:

G:\Domains\Sites\uat-ic.mydwsite1.com\Files\Files\Integration\ExcelImports\EcomGroups.xlsx

 

When running the activity however, we get an error saying the path is not a valid one.

 

The integration job fails with the following message:

'G:\Domains\Sites\uat-ic.mydwsite1.com\FilesFiles\Integration\ExcelImports\EcomGroups.xlsx' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

 

One of the "\" is being removed it seems, which is breaking the path.

 

We have reproduced this error in DW 9.13.9 and 9.13.11

 

Is anybody else encountering a similar issue when using the Excel Provider as a source?


Replies

 
Morten Snedker Dynamicweb Employee
Morten Snedker
Reply
This post has been marked as an answer

Hi Thiago,

Please try with most recent Excel Provider from NuGet and let me know if that resolves the problem. Alternatvily 9.13.12, which should conatain the same fix. If it still does not work, try creating the job from scratch - wrong settings may have been saved to the job xml. If it still does not play as it should, please send us a mail on care@dynamicweb.com, and then we will take a look at it.

BR
Snedker

Votes for this answer: 1
 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply

I just ran into the same issue and I can confirm that upgrading the NuGet package (to dynamicweb.dataintegration.providers.excelprovider.4.0.14 in my case) solved the issue.

 

You must be logged in to post in the forum