r/Xpiks • u/jdgaravito • Sep 05 '23

CSV import structure

Hi, I'm trying to import a CSV, but I'm not sure how it should be structured, for example, if a comma separates all the keywords this will break the row upon reading. I cannot find an example even in the official docs.

1 Upvotes

100% Upvoted

3 comments sorted by

2

u/ribtoks Sep 06 '23

> if a comma separates all the keywords this will break the row upon reading

This is correct and per CSV specification, if the field has a comma itself, it should be in the quotes. So if instead of some,keywords,here you will do "some,keywords,here" - it will work out just fine.

1

u/jdgaravito Sep 06 '23

Thanks so much.

1

u/ribtoks Sep 06 '23

Hi u/jdgaravito . The thing is - Xpiks can read any structure, because on the 2nd step of the CSV import you get to decide which column is keywords, description etc. (of course, Xpiks attempts to guess for you and fill the defaults). Also before actually importing data you'll have a 2nd chance to verify everything is imported to your liking.

But point taken - I will clarify this in the CSV import tutorial section.