TOTECS Forums

Unable to merge multiple product image CSV files together for Product Images data export

Author
Thread

Author Ryan
15th November 2017

I have multiple CSV files, each with a different product brand, the keyImageID is the products item code and any extra images have A,B,C,etc at the end, all CSV files work fine independently, but not together, which doesn't make sense since we don't have duplicate item codes, when i have them all together i am receiving the following error: Error whilst trying to obtain Product Image data from the Generic1 Adaptoradaptor's CSV File data source. An item with the same key has already been added. In an attempt to find the error I have merged all data into one big spreadsheet and i have also checked for double ups in each individual CSV and cannot find the duplicate? is there anyway of finding or being told which entry is the duplicate?


Comments

Author Rowan Drew

TOTECS Software Development Manager
Thanks for raising the issue Ryan. After investigating this issue is caused by a bug, and is not just isolated to the Product Images data export, but for any data exports using a CSV data source that matches multiple files.
Bug issue #ACC-374 has been raised and we'll look to patch through a fix as soon as possible. I'll let you know when we have fix ready to go.

  Comment has been marked as the answer

Author Rowan Drew

TOTECS Software Development Manager
This bug has now been fixed and a patch has been applied to the Connector Host Installer for version 1.11.3.
You will just need to uninstall the older version of the Connector Host Service, then download and install the newer version available at https://www.squizz.com/apps.html. Also make sure that the Connector Application is also on the latest version (1.11 at the time of writing) by agreeing to update the app once it opens.
Let me know if you any problems upgrading, and there's also documentation about it at https://www.squizz.com/docs/connector/Installation.html#section1000

  Comment has been marked as the answer