If you facing some issues while import a CSV file to zistemo (e.g. incorrect file structure) please follow these steps to corrects errors.
1. Check file encoding
Usually, files are encoded in UTF-8 which is the most common encoding. Please check if your file is encoded properly. Most text editor can detect the encoding or you could check it directly in you terminal (Mac OS) with
file -I filename
2. Check file header
On each sample file you can see a header line. You must not change the header line for importing CSV file! The header must be exact the same as on the sample file. Further, please make sure that there’re no extra spaces on the header.
3. Check for empty columns and rows
4. Check quotation marks
5. End of Line (EOL) Character
Usually, end of line character/new line character is \r\n. However, some operating systems and some programs using \r as eol-character. Please make sure your file eol-characters is \r\n.