Developer forum

Forum » Integration » Data Integration - Export to xslx

Data Integration - Export to xslx

Thomas Jensen
Reply

Hi

I set up a export to Excel file .xslx with the 3 identifiers and some of the content fields
and it worked fine

in the Excel file I removed all rows except titles and 1 product with it's 4 variants
changed a value and imported it with (Update only existing products = checked)
and everything seemed to work fine (the change came through)

then I made an export again with the same activitiy
and when I opened the xslx file, Excel said that there was an error asking if it should fix it, and after the fix it looked right, just like the first export

then tried to set up a new test activitiy, no matter what I do it fails
(Job failed Error saving file d: \ ...... The failed input row is: {the product that is last})

If I delete that product, it is just fails on the next one, still the last

 

So any idea what has gone wrong?

 

it's on jagtjakt.dw9.dynamicweb-cms.com ver 9.4.12

 

Regards
Thomas


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Thomas,
In your destination provider settings you have the wrong file name "Integration/EcomProd2.xlsx":


Could you fix it to: just "EcomProd2.xlsx" and try again?
Regards, Dmitrij

 

You must be logged in to post in the forum