The following steps establish a procedure for reviewing problems that may arise when loading a csv for import.
The steps are oriented from the most possible and least intrusive, to the most complicated and time-consuming to test.
1 - Open the csv for a first inspection and make sure:
- No line breaks in fields
- That there are no problematic characters
- That the permitted separators are being used
- No blank lines
2 - Make a copy of the CSV and leave a few lines in it (3 or 4). Take a preview of the match you make of the columns.
3 - We check if documents have been created, and if so:
3 - We check if documents have been created, and if so:
- If a certain number of records have been created but not all of them, since the process is linear, we have to check the last one created because the next one is the one that has given some problem, and we locate it in the csv to see what it can be.
Other related articles
In bulk uploads, how should Mastertables type field data be uploaded?
Characters to avoid when generating a csv for importing
Comments
0 comments
Please sign in to leave a comment.