Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

empty trailing rows in CSV may cause improper reading #731

Closed
BetsyEmmons opened this issue Jun 5, 2013 · 7 comments
Closed

empty trailing rows in CSV may cause improper reading #731

BetsyEmmons opened this issue Jun 5, 2013 · 7 comments

Comments

@BetsyEmmons
Copy link

MapStory isn't detecting latitude and longitude attributes within .csv file. Here's my spreadsheet:
screen shot 2013-06-05 at 11 00 51 am

Here's how I uploaded it:
screen shot 2013-06-05 at 11 01 10 am

This is the message I received:
screen shot 2013-06-05 at 11 01 17 am

Any help is appreciated! Thanks! Also, I was working on the development site.

@cholmes
Copy link
Member

cholmes commented Jun 5, 2013

Could you try renaming to 'latitude' and 'longitude' and see if it works any better?

@BetsyEmmons
Copy link
Author

Had that originally, changed it to lat and long. neither worked.

@ischneider
Copy link
Member

In this case, the 6223nd entry is being read incorrectly as it contains a semi-colon. @BetsyEmmons, I would check the other data as well before trying again.

Until this is fixed, the message should note that it's possible the data is not being read correctly.

Updated title to reflect the true nature of the issue.

@cholmes
Copy link
Member

cholmes commented Jun 5, 2013

Bumping this to a future milestone. Would be nice to auto detect such issues, but in the meantime hopefully people will google and find answers and we'll improve documentation and help generally.

@ischneider
Copy link
Member

Updated again - upon further investigation, this was actually caused by empty rows at the end.

@BetsyEmmons
Copy link
Author

thank you!

@ischneider
Copy link
Member

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants