CSV export: harmonize fileds for waypoints and trackpoints

Georg D shared this idea 8 years ago
Gathering feedback

In CSV export, one file contains waypoints and/or trackpoints. For the fields that both types have, the field order differs, and each point type has fields that the other point type does not have - resulting in 2 or 3 column definitions within one CSV file:


"name","lat","lon","alt","acc","time","desc","attachments","custom_coords"

and

"pos","lat","lon","alt","time","speed","bearing","acc","heartRate","cadence","temperature","custom_coords"


---

As many programs (like e.g. Excel) cannot "really" work with more than one column definition within one CSV file (they expect only one single table in one CSV file), it would be perfect to have just one column definition and to leave fields empty that are not used for the single point at hand (as already done with "attachments" or "temperature"). Example:


"name","lat","lon","alt","acc","time","custom_coords","desc","attachments","speed","bearing","heartRate","cadence","temperature"

"myWpt","36.392019","30.470093","444.33","5.00","2015-11-14T09:12:39Z","","<font color=""black"">table etc</font>","","","","","",""

"Trackpoint 1","36.392019","30.470093","333.44","5.00","2015-11-14T09:12:39Z","","","","4.00","30.00","","",""

---


If that is not possible/desired by Locus team, please create two separate CSV files, so one for wapoints and one for trackpoints. Then, one CSV file contains only one table definition and all programs are happy with it. It would make post processing easier to put the fields that both way- and trackpoints use 1) to the front and 2) have them in identical order, as many tools can gently handle "unexpected" ends of line, so the definitions would be like e.g.


"name","lat","lon","alt","acc","time","custom_coords","desc","attachments"

and

"pos","lat","lon","alt","acc","time","custom_coords","speed","bearing","heartRate","cadence","temperature"

---


BTW, I only use CSV as workaround as accuracy fields are missing in export as GPX, KML etc. and afterwards convert the CSV into GPX using an XSLT script.

Leave a Comment
 
Attach a file