Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
en:help:v2:landmarks:local-import-export-xsv [2018/02/20 18:05] alpinequesten:help:v2:landmarks:local-import-export-xsv [2023/09/17 09:45] alpinequest
Line 1: Line 1:
-<sub>[[en:help|Online Help]] > [[en:help:v2|AlpineQuest 2.x]] > [[en:help:v2:landmarks|Landmarks]]</sub>+<sub>[[en:help:v2|Online Help]] > [[en:help:v2:placemarks|Placemarks]] > How to import and export placemarks in CSV/TSV files?</sub>
  
-====== How to import CSV/TSV files? ======+====== How to import and export placemarks in CSV/TSV files? ======
 \\ \\
-The application allows you to import landmarks (waypoints, routestracks, 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+The import and export CSV/TSV files support allows the application to import placemarks from and export placemarks to CSV files ([[https://en.wikipedia.org/wiki/Comma-separated_values|comma-separated values]], ''***.csv**''and more generally to [[https://en.wikipedia.org/wiki/Delimiter-separated_values|delimiter-separated values]] files (like tab-separated values, or TSV). 
-  * Tap on the ''"**Landmarks**"'' {{:icon_01.png?nolink}} menu icon and on ''"**Explore landmark**"'' {{:icon_02.png?nolink}}. The default landmark folder is listed;+ 
 +Because this format is not primarily designed to store geographic data, you'll need to manually specify what type of data is stored by each column, especially in which columns are stored the latitudes and longitudes of the geographic points. 
 +\\ 
 +\\ 
 +===== How to import CSV/TSV files? ===== 
 +\\ 
 +To import a CSV/TSV file
 +  * Tap on the ''"**Placemarks**"'' {{:icon_01.png?nolink}} menu icon and on ''"**Explore placemarks**"'' {{:icon_02.png?nolink}}. The default placemark 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/**"''.   * 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/**"''.
  
Line 14: Line 21:
   * If needed, tap on ''"**Folder**"'' to import the file in the current folder instead of the default import folder;   * 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 ''"**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 ''"**Placemark**"'' to select the type of placemark to create from the imported locations;
   * If needed, tap on ''"**Separator**"'' to select the column separator character;   * 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, tap on ''"**Location format**"'' to select the coordinates format of the file;
Line 36: Line 43:
 \\ \\
  
-====== How to export CSV/TSV files? ======+===== How to export CSV/TSV files? =====
 \\ \\
-To export a landmark in a ''***.csv**'' or ''***.tsv**'' file and use it in an external application: +To export a placemark in a ''**.csv**'' or ''**.tsv**'' file and use it in an external application: 
-  * Tap on a displayed landmark on the map (here for example a set of waypoints) {{:icon_01.png?nolink}} and on its icon  {{:icon_02.png?nolink}} right of the selected waypoint name;+  * Tap on a displayed placemark 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}};   * Choose ''"**Export as...**"'' {{:icon_03.png?nolink}};
  
-In the list of available export formats, choose ''"**CSV**"'' {{:icon_04.png?nolink}} for comma-separated values, or ''"**TSV**"'' for tabulation-separated values.+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 }} {{ :en:help:v2:landmarks:local-export-xsv-1.jpg?nolink }}
Line 50: Line 57:
 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. 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:+Among available fields (depending on what is recorded in the exported placemark), you'll find:
   * ''"**Longitude**"'' and ''"**Latitude**"'', the coordinates of the points in the WGS84 (GPS) datum;   * ''"**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;   * ''"**Coordinates**"'', the coordinates of the points in another datum you can select;
Line 59: Line 66:
   * ''"**Distance from the center**"'', the distances from the current map center of the points, in meter (m).   * ''"**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.+Once the placemark 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 ''"**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 ''"**Open**"'' {{:icon_08.png?nolink}} to open the file with a compatible application installed on your device;
Line 67: Line 74:
  
 {{ :en:help:v2:landmarks:local-export-xsv-2.jpg?nolink }} {{ :en:help:v2:landmarks:local-export-xsv-2.jpg?nolink }}
 +