simonw
Could not load self-hosted CSV file using Datasette Lite
I was trying out Datasette Lite to look at some election data in CSV format. I uploaded a CSV file to my website at https://andysylvester.com/files/electiondata/Marion_County_All_Contests_Export.csv, tested that I could download the file, then tried to upload the file by clicking on the "Load CSV" button, but got the error message "That CSV could not be loaded". I checked the permissions of the file, it was 755. I then tested loading a file hosted on Github from the Datasette documentation (https://github.com/fivethirtyeight/data/blob/master/historical-ncaa-forecasts/historical-538-ncaa-tournament-model-results.csv), and was able to load that file successfully. I then created a test repo in my Github account, uploaded the CSV file listed at the top of this issue, and was able to load the CSV file from Github (https://github.com/andysylvester/election_data/blob/main/Marion_County_All_Contests_Export.csv).
If someone is hosting a CSV file on their web hosting, does Datasette Lite expect a certain permission for the file?
The server must provide CORS headers for datasette-lite to work. To test files locally I usually use https-server and http-server --cors to test that the file is not the problem.
