Importing errors in wix data - content manager

Ask the community
, ,
1

Hello,

I am getting unpredictable and weird outcomes like ‘same content getting imported multiple times’ or ‘existing content getting deleted’ when trying to import a csv file to content manager. The outcomes are random and different outcome happens after each attempt.

For example: in my csv file there are 10 rows of data, in which, each column is a mapped to a data field in my corvid database. When I import this file, sometimes I get 15 new rows and sometimes 17 new rows! Some rows are imported twice or thrice of more times.

Has anyone else also faced the same issue? What could be the reason?

Note: The file size is <50 KB and each row is less than 4-5 KB. There are only 20-30 rows which I am attempting to import and current total rows in existing database are less than 100.

2

If you are importing/exporting CSV files to and from Wix as shown here.
https://support.wix.com/en/article/about-importing-data-in-the-content-manager
https://support.wix.com/en/article/importing-data-to-a-database-collection
https://support.wix.com/en/article/exporting-data-from-a-database-collection

Then please note that it is not a code related issue and therefore you would be better suited going through Wix Support for more help with this issue.
https://support.wix.com/en/article/contacting-wix-support

If you have used code like in this tutorial here.
https://support.wix.com/en/article/corvid-tutorial-importing-and-exporting-collection-data-with-code

Then please add any code that you have used and the console log errors received, along with any screenshots that might help too.

3

Thanks, GOS for guiding me to this link - https://support.wix.com/en/article/corvid-tutorial-importing-and-exporting-collection-data-with-code

I tried using this link and while I am not having any issue of multiple copies of the same row but I am stuck with couple of other issues-

  2. one of my data field is of type ‘tags’. I am getting "This is a string. Convert this to tags’ message in Sandbox. Screenshot attached. How can I fix this?

  4. Some of my fields are of multiple reference types. Those are not getting imported while the field with single reference are imported successfully.

Can you please help me with these two?