Major bugs importing CSV with commas or newlines in text columns #9
Open
Description
I ran into some major bugs when importing CSV files that contain commas or newlines in text columns - the existing parsing just did simple splitting on commas and newlines and did not take into account the totally valid possibility that such character might exist between quotes in text columns. I submitted a pull request for my branch, which does much more sophisticated parsing of the CSV, keeping track of the opening and closing quotes that are required around such text when present in a CSV. I also added a MysqlLogger implementation, since I needed a persistent import audit trail.
Metadata
Assignees
Labels
No labels