Page 1 of 1

Import CSV data truncated

Posted: Sun Mar 26, 2023 8:12 pm
by hamish
When I import a set of waypoints in CSV format the number of points is truncated, yet if I import the same data as CSV to Google Earth Pro, export as a KMZ and then import the KMZ to Alpine Quest the missing data points are there.

In this instance I'm using an edited version of the Geolytix Retail Points data of supermarket and convenience store locations in UK (Open Data), the original CSV file can be downloaded here https://drive.google.com/file/d/1B8M7m8 ... x.ghost.io if the url is no longer valid an updated url can normally be accessed from this blog article https://geolytix.com/blog/supermarket-retail-points/

Importing as KML doesn't give me the same control in AQ over how the information is displayed as importing as CSV, and CSV is easier for me to quickly edit.

Re: Import CSV data truncated

Posted: Tue Mar 28, 2023 12:05 am
by Psyberia-Support
Thanks for this report.
I check the file and the problems comes from un-escaped quotes in text field.
I'll make sure the app handles this case in the next update.
Until it's available, you can regenerate the CSV file with the option "Quotes all text fields", and it will work fine.
Sorry about that.

Re: Import CSV data truncated

Posted: Sun Apr 02, 2023 9:23 pm
by hamish
thanks for your help , this file and others work now, Just to note that using the option "Quotes all text fields" is when you save CSV using OpenOffice Calc rather than MS Excel.