Previous Top Next
13) Import, export (CSV, Excel)
For this document the 11 places that make up the ‘ElfStedentocht’ are used.
More info: https://en.wikipedia.org/wiki/Elfstedentocht

Warning: Although a route/trip can be created, it does not follow the original. For that you would have to use more shaping points.

These are the places that make up the ElfStedentocht:

Leeuwarden
Sneek
IJlst
Sloten
Stavoren
Hindeloopen
Workum
Bolsward
Harlingen
Franeker
Dokkum
Leeuwarden

Note: In this document only place names are used for the addresses, but you can use anything that GeoCode recognizes. See 11 Using GeoCode


Using the clipboard
From Excel to TripManager

·   Prepare a sheet in Excel with the address in column E. No column heading needed. Address is the minimal info needed. Other columns can be added if desired and available.


graphic


Tip: if you enter data in columns C,D (Lat,Lon) set the format In Excel to text and enter values in decimal form. For an example see From Tripmanager to Excel
·   Select all lines, Columns A-E, and copy to Clipboard (CTRL+C)
·   Create a new empty Trip in TripManager See 12 Using Trip Editor
·   In TripManager Right Click/Paste, or CTRL+V
graphic
graphic
·   Because columns A-D were empty in Excel default route point names are assigned, all points are Shape, and there are no Coordinates.
·   You can now look up the addresses to obtain the coordinates. See Looking up addresses
·   When done save the trip, or export to GPX/CSV.


Note: The example above copies all route points at once. Copying a selection as a block, and inserting after an existing point is also supported. Here RtePt 5 to 7 are copied and inserted after RtePt 11.
graphic



From Tripmanager to Excel


·   Create a new empty sheet in Excel and set at least column C and D as text.

graphic



·   Select all lines in TripManager (CTRL+A) and copy to clipboard (CTRL+C)

graphic



·   Paste in Excel.

graphic

·   Do with it whatever you like.


Using CSV files
First prepare a CSV file to import in TripManager.
·   The CSV should contain a heading line with the column names. These column names are recognized. Route point;Point type;Lat;Lon;Address
·   Tip: The column names are the same as in TripManager except ID, that can not be used.
·   The CSV should contain at least 1 column: Address.
·   Columns Lat/Lon are not mandatory, but if you supply them use the decimal separator as specified in your Windows regional settings! (usually a comma, or a point)


Sample using all columns created by exporting a trip file in TripManager
Route point;Point type;Lat;Lon;Address
RtePt 1;Via;53,200594;5,791855;Leeuwarden
RtePt 2;Shape;53,033548;5,661103;Sneek
RtePt 3;Shape;53,010137;5,623324;IJlst
RtePt 4;Shape;52,894991;5,645395;Sloten
RtePt 5;Shape;52,883269;5,360212;Stavoren
RtePt 6;Shape;52,942618;5,400482;Hindeloopen
RtePt 7;Shape;52,977849;5,446409;Workum
RtePt 8;Shape;53,062018;5,522896;Bolsward
RtePt 9;Shape;53,175210;5,414200;Harlingen
RtePt 10;Shape;53,188051;5,540965;Franeker
RtePt 11;Shape;53,324352;5,999231;Dokkum
RtePt 12;Via;53,200594;5,791855;Leeuwarden


Sample using 2 columns created by saving as CSV in Excel.
Route point;Address
Leeuwarden;Leeuwarden
Sneek;Sneek
IJlst;IJlst
Sloten;Sloten
Stavoren;Stavoren
Hindeloopen;Hindeloopen
Workum;Workum
Bolsward;Bolsward
Harlingen;Harlingen
Franeker;Franeker
Dokkum;Dokkum
Leeuwarden;Leeuwarden
graphic
Note: Here the route point names are the same as the addresses, but they can be different of course.

From CSV to TripManager
·   Create a new empty Trip in Tripmanager.
·   Click on the CSV button, Import.
graphic



·   Open the prepared CSV file. The result should look like this. You can now look for addresses.


graphic


Note: If the point type is not supplied it is set to Via.

From TripManager to CSV
·   Creating a CSV file is as simple as opening a trip in TripManager and clicking on CSV/Export.

graphic
Note: You can use the created CSV file for importing.


Looking up addresses

Select the lines to look up, or select all lines (CTRL+A) and click on the Search button.

When no coordinates are available TripManager will search for the coordinates from the address.
If coordinates are available TripManager will search for the place.

graphic
graphic
·   For every selected line the search dialog will be shown.
·   Select the matching line and accept the proposed coordinates with OK.
·   Cancel will not update the Coordinates, Retry allows you to change the search parameter and retry.
graphic
graphic

·   Note: While the trip has not been calculated, TM will only draw straight lines between the route points.