search

DoSomething / chompy

:card_index: The DoSomething.org third-party importer.
MIT License
1 stars 0 forks source link

CSVs made in Excel error out #27

Open sbsmith86 opened 6 years ago

sbsmith86 commented 6 years ago

When you create a csv in Excel, save it, and then try to upload the file in chompy we get a bunch of errors that basically say it is not a valid CSV.

@katiecrane mentioned she has seen this for and you have to clean up some of the extra sauce that excel puts in a csv file.

From katie:

To clean up those weird excel csvs, this has worked for me: perl -p -i -e "s/\r/\n/g" file.csv

ngjo commented 6 years ago

Pivotal card here: https://www.pivotaltracker.com/story/show/155369328