| Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision |
| en:help:v2:landmarks:local-import-export-xsv [2016/05/26 11:43] – [How to import CSV/TSV landmark files?] alpinequest | en:help:v2:landmarks:local-import-export-xsv [2023/09/17 09:45] – alpinequest |
|---|
| <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 landmark files? ====== | ====== How to import and export placemarks in 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: | 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). |
| * 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/**"''. | 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/**"''. |
| |
| {{ :en:help:v2:landmarks:local-import-xsv-1.jpg?nolink }} | {{ :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}}: | 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, click 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, click 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, click 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, click on ''"**Separator**"'' to select the column separator character; | * If needed, tap on ''"**Separator**"'' to select the column separator character; |
| * If needed, click 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; |
| * 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); | * 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); | * 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. | {{:icon_help.png?nolink}} Some of the columns may already be assigned since the application tries to detect them from the headers. |
| \\ | \\ |
| |
| 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. | 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 (which depends on the file size). When it's done, you can: | Wait some time for the file to be imported. 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; | * Choose ''"**Browse**"'' {{:icon_10.png?nolink}} to list the content of the imported file, for example if you want to display only few items; |
| * Select ''"**Display**"'' {{:icon_11.png?nolink}} to display the entire file content on the map. | * 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 }} | {{ :en:help:v2:landmarks:local-import-xsv-3.jpg?nolink }} |
| \\ | \\ |
| |
| ====== How to export CSV/TSV landmarks? ====== | ===== How to export CSV/TSV files? ===== |
| \\ | \\ |
| To export a landmark to a CSV or TSV file: | To export a placemark in a ''**.csv**'' or ''**.tsv**'' file and use it in an external application: |
| * Long-press the landmark to export {{:icon_01.png?nolink}}; | * 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); |
| * Select ''"**Export as...**"'' {{:icon_02.png?nolink}}; | * Choose ''"**Export as...**"'' {{:icon_03.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 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 dialog: | 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. |
| * 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; | Among available fields (depending on what is recorded in the exported placemark), you'll find: |
| * The exported file is created and saved in the same folder {{:icon_07.png?nolink}}. | * ''"**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 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 ''"**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 }} |
| |
| {{ :en:help:1.4:landmarks:format-xsv:export-2.jpg?nolink }} | |
