Both sides previous revisionPrevious revisionNext revision | Previous revision |
en:help:v2:landmarks:local-import-export-xsv [2016/05/26 11:48] – alpinequest | en:help:v2:landmarks:local-import-export-xsv [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.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 ''**.CSV**'', ''**.TSV**'' and more generally [[https://en.wikipedia.org/wiki/Delimiter-separated_values|delimiter-separated values]] files and display them on the map: | |
* Click 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, click on the top left drawer menu {{:icon_03.png?nolink}} to list the main folders of your device. For example, click 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}}, click on it to display the import settings {{:icon_06.png?nolink}}: | |
* If needed, click on ''"**Folder**"'' to import the file in the current folder instead of the default import folder; | |
* If needed, click on ''"**Charset**"'' to select the file charset if it's different from the device charset; | |
* If needed, click on ''"**Landmark**"'' to select the type of landmark to create from the imported locations; | |
* If needed, click on ''"**Separator**"'' to select the column separator character; | |
* If needed, click 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, click 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, click 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 (which depends on the file size). When it's done, you can: | |
* Select ''"**Browse**"'' {{:icon_10.png?nolink}} to list the content of the imported file, for example to display only few items; | |
* Select ''"**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 to a CSV or TSV file: | |
* Long-press the landmark to export {{:icon_01.png?nolink}}; | |
* Select ''"**Export as...**"'' {{:icon_02.png?nolink}}; | |
* Choose ''"**CSV file**"'' {{:icon_03.png?nolink}} for comma-separated values, or ''"**TSV file**"'' {{:icon_04.png?nolink}} for tab-separated values. | |
| |
{{ :en:help:1.4:landmarks:format-xsv:export-1.jpg?nolink }} | |
| |
\\ | |
| |
In the export settings dialog: | |
* Select all columns you want to export, by checking or un-checking the corresponding check-boxes {{:icon_05.png?nolink}}; | |
* Click on the ''"**Ok**"'' button {{:icon_06.png?nolink}} to export the landmark; | |
* The exported file is created and saved in the same folder {{:icon_07.png?nolink}}. | |
| |
{{ :en:help:1.4:landmarks:format-xsv:export-2.jpg?nolink }} | |