Developer forum

Forum » PIM » Excel Provider only works for first sheet in xls?

Excel Provider only works for first sheet in xls?

Stephen Anthony Jackson
Stephen Anthony Jackson
Reply

I created some import jobs for some additional product category fields the customer wants to provide via excel only. 

When creating excel source, the dialogue asks me which table.  "Sheet1" or "Sheet2".

For the first job, which uses "Sheet1"... data gets updated fine

For second job "Sheet2", the job runs, and it says 26 products updated, but no fields are updated.

Could this be a bug?


Replies

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

Hi Stephen,

What is the extension of your file? xls or xlsx?
I had some issues in the past with xls files.

Adrian

 
Stephen Anthony Jackson
Stephen Anthony Jackson
Reply

Hi Adrian. It turned out that the issue was caused by something else, which started failing at the same time I started using Sheet2. Problem is that the import job doesnt tell you this. It just says "Updated 29 Products" no errors.

 

 

You must be logged in to post in the forum