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
en:help:v2:landmarks:local-import-export-xsv [2018/02/20 18:05] alpinequesten:help:v2:landmarks:local-import-export-xsv [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
Line 1: Line 1:
-<sub>[[en:help|Online Help]] > [[en:help:v2|AlpineQuest 2.x]] > [[en:help:v2: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 (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; 
-  * 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. 
- 
-{{ :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 }}