Have created 4 reference fields with appropriate field types, populated them with values, and connected them to a collection that will hold main data. The main data collection in table form works correctly. I can enter rows manually and the references dropdowns work.
The prob is when I try import a CSV (Utf-8). The heading on the CSV matches the field names on the collection, and the CSV values exactly match the reference field values.
Funny thing is some of the values import, but with errors. In other fields the values are “untitled”. And in one field three of records are “untitled” and six have correct values but have errors => “the value does not match the field type Reference”
Thanks Roberto
Still haven’t got it working. Workaround is dropdowns in excel so when saving as CSV and importing, the values are all consistent. Eg all 12X12 rather than some 12X12 and others 12 x 12
Can you share the CSV file here? I would want to check it out.
If you are unable to for any reason, you can reach out to our customer care team to see if they can help. I would recommend choosing to reach out to the content manager team as it more directly pertains to them instead of Editor X.
I was able to import the collection. Again, I think the issue might be with the usage of a reference field. I made a video below showing how I imported this.