search

CityOfPhiladelphia / community-health-explorer

Host, edit and visualize CSV-based data using Jekyll, Leaflet & Chartist
http://healthexplorer.phila.gov
23 stars 8 forks source link

Invalid characters in CSV data #78

Open timwis opened 6 years ago

timwis commented 6 years ago

It looks like there's some invalid characters in the CSV files. Likely things like "enhanced quotation marks" that MS Excel or MS Word add, or a windows thing. Jekyll build fails with invalid byte sequence in UTF-8. You can see the culprits here:

screen shot 2017-11-03 at 18 20 45

Can we convert these to regular " and such in prose.io? From there (since I'm out of town), @awm33 should be able to stage it (unless schema changes are significant). Just change year in _config.yml, run jekyll build, and deploy to somewhere like surge.sh for preview.

Kistine commented 6 years ago

@timwis and @awm33 - Prose doesn't seem to have an upload functionality so @AmoryH uploaded directly to GitHub. I've gone into the 2017 branch and edited the 4 files by searching for those specific quotation marks and replacing them with regular ones - I believe I got them all but the search and find function wasn't super easy to use. Hopefully that does the trick? Let me know.