search

martin-ueding / geo-activity-playground

Data analysis and visualization based on GPS tracked outdoor activities.
https://martin-ueding.github.io/geo-activity-playground/
MIT License
35 stars 13 forks source link

Line breaks in "Activity Description" break CSV import #143

Closed martin-ueding closed 1 month ago

martin-ueding commented 2 months ago

I also get an import error with 0.26.2. the activities.csv from the zip file shows 94 columns.

In the cases, where the "Activity Description" contains a line break, there is a very strange break in the csv as well and the entry spans over two or more lines, not aligning with the "traditional csv structure".... image 2024-08-07_import-error.txt

Originally posted by @eifelkiwi in https://github.com/martin-ueding/geo-activity-playground/issues/112#issuecomment-2274138608

martin-ueding commented 2 months ago

That's nasty. Perhaps I'll need to write my own CSV parser to catch these issues. I'll think about a way to fix this.