search

GSS-Cogs / chart-builder

The Chart Builder is a proof-of-concept app to understand the feasibility of using a CSV file (or SPARQL query) to generate and customise a chart or data visualisation
https://chart-builder-no4vxskx7a-nw.a.run.app
2 stars 0 forks source link

Fix issue with CSV files created in Excel on Windows OS not loading correctly #147

Closed charlesons closed 2 years ago

charlesons commented 2 years ago

The issue was identified by a content creator for the VAWG site.

CSV files created in Excel on Windows OS were not loading correctly into Chart Builder. Once a file was selected as a data source the Category, Measure and Dimension fields were not populated with data columns to select from.

Whilst exploring the issue we found that saving an example of the problem files in a text editor on a linux based OS resolved the issue.

We subsequently narrowed the issue down to the line ending characters used in the problem files (Windows OS) being \r\n whereas unix based OS use \n.

The issue is documented here: https://github.com/mholt/PapaParse/issues/289

And the advice given by the developer is to clean up the \r characters from the file prior to parsing.

charlesons commented 2 years ago

Estimate includes debugging time and comms / support with end user.