Differences

This shows you the differences between two versions of the page.

Link to this comparison view

en:help:landmarks:local-import-export-xsv [2018/10/11 14:54] (current)
alpinequest created
Line 1: Line 1:
 +<​sub>​[[en:​help|Online Help]] > [[en:​help:​landmarks|Landmarks]]</​sub>​
  
 +====== How to import CSV/TSV files? ======
 +\\
 +The application allows you to import landmarks (waypoints, routes, tracks, areas) from any ''​**.csv**'',​ ''​**.tsv**''​ and more generally [[https://​en.wikipedia.org/​wiki/​Delimiter-separated_values|delimiter-separated values]] files and display them on the map:
 +  * Tap on the ''"​**Landmarks**"''​ {{:​icon_01.png?​nolink}} menu icon and on ''"​**Explore landmark**"''​ {{:​icon_02.png?​nolink}}. The default landmark folder is listed;
 +  * Select the folder in which the file to import is located. If needed, tap on the top left menu {{:​icon_03.png?​nolink}} to list the main folders of your device. For example, tap on ''"​**My downloads**"''​ {{:​icon_04.png?​nolink}} to select the folder ''"​**/​storage/​emulated/​0/​Download/​**"''​.
 +
 +{{ :​en:​help:​v2:​landmarks:​local-import-xsv-1.jpg?​nolink }}
 +
 +\\
 +
 +Once the file to import is displayed {{:​icon_05.png?​nolink}},​ tap on it to display the import settings {{:​icon_06.png?​nolink}}:​
 +  * If needed, tap on ''"​**Folder**"''​ to import the file in the current folder instead of the default import folder;
 +  * If needed, tap on ''"​**Charset**"''​ to select the file charset if it's different from the device charset;
 +  * If needed, tap on ''"​**Landmark**"''​ to select the type of landmark to create from the imported locations;
 +  * If needed, tap on ''"​**Separator**"''​ to select the column separator character;
 +  * If needed, tap on ''"​**Location format**"''​ to select the coordinates format of the file;
 +  * If needed, un-check ''"​**Headers in first row**"''​ {{:​icon_07.png?​nolink}} if the first line of the file is not used to store headers (column labels);
 +  * For each column, tap on the assignment button {{:​icon_08.png?​nolink}} to select a corresponding type (you must select at least a ''"​**Coordinates**"''​ column or a ''"​**Latitude / Y**"''​ and a ''"​**Longitude / X**"''​ column);
 +
 +{{:​icon_help.png?​nolink}} Some of the columns may already be assigned since the application tries to detect them from the headers.
 +
 +{{ :​en:​help:​v2:​landmarks:​local-import-xsv-2.jpg?​nolink }}
 +
 +\\
 +
 +When you've assigned an import type to all the columns you want, tap on ''"​**Ok**"''​ {{:​icon_09.png?​nolink}} to start the import. In this example, the application will read the location longitudes from the first column, the latitudes from the second one, and the names from the third column.
 +
 +Wait some time for the file to be imported. When it's done, you can:
 +  * Choose ''"​**Browse**"''​ {{:​icon_10.png?​nolink}} to list the content of the imported file, for example if you want to display only few items;
 +  * Choose ''"​**Display**"''​ {{:​icon_11.png?​nolink}} to display the entire file content on the map.
 +
 +{{ :​en:​help:​v2:​landmarks:​local-import-xsv-3.jpg?​nolink }}
 +
 +\\
 +
 +====== How to export CSV/TSV files? ======
 +\\
 +To export a landmark in a ''​**.csv**''​ or ''​**.tsv**''​ file and use it in an external application:​
 +  * Tap on a displayed landmark on the map {{:​icon_01.png?​nolink}} and on its icon {{:​icon_02.png?​nolink}} (you can either tap the waypoint icon to only export the selected waypoint or tap the set icon to export all the waypoints of the set);
 +  * Choose ''"​**Export as...**"''​ {{:​icon_03.png?​nolink}};​
 +
 +In the list of available export formats, choose ''"​**CSV file**"''​ {{:​icon_04.png?​nolink}} for comma-separated values, or ''"​**TSV file**"''​ for tabulation-separated values.
 +
 +{{ :​en:​help:​v2:​landmarks:​local-export-xsv-1.jpg?​nolink }}
 +
 +\\
 +
 +In the export settings, select all the columns you want to export {{:​icon_05.png?​nolink}},​ and tap on ''"​**Ok**"''​ {{:​icon_06.png?​nolink}} to export the landmark.
 +
 +Among available fields (depending on what is recorded in the exported landmark), you'll find:
 +  * ''"​**Longitude**"''​ and ''"​**Latitude**"'',​ the coordinates of the points in the WGS84 (GPS) datum;
 +  * ''"​**Coordinates**"'',​ the coordinates of the points in another datum you can select;
 +  * ''"​**Elevation**"'',​ the elevations of the points, either in the WGS84 (GPS) datum or in the EGM96 (Geoid) reference;
 +  * ''"​**Time**"'',​ the dates and times recorded of the points in millisecond ([[https://​en.wikipedia.org/​wiki/​Unix_time|unix time format]]);
 +  * ''"​**Accuracy**"'',​ the accuracies of the points in meters, with a 68% confidence;
 +  * ''"​**Pressure**"'',​ the pressures recorded of the points, in hectopascal (hPa);
 +  * ''"​**Distance from the center**"'',​ the distances from the current map center of the points, in meter (m).
 +
 +Once the landmark has been exported, the full path of the exported file {{:​icon_06.png?​nolink}} is displayed.
 +  * Tap on ''"​**Share**"''​ {{:​icon_07.png?​nolink}} to share the file (send it as email, upload it on Dropbox, etc.), available actions {{:​icon_10.png?​nolink}} depend on the applications installed on your device;
 +  * Tap on ''"​**Open**"''​ {{:​icon_08.png?​nolink}} to open the file with a compatible application installed on your device;
 +  * Tap on ''"​**Ok**"''​ {{:​icon_09.png?​nolink}} to close the dialog.
 +
 +{{:​icon_help.png?​nolink}} Be careful when trying to access the exported file from a computer using an USB cable, Android takes time to update the file list of your device, and newly created ones may not be immediately visible.
 +
 +{{ :​en:​help:​v2:​landmarks:​local-export-xsv-2.jpg?​nolink }}

Choose language:

Online help