Exporting your data: Difference between revisions
No edit summary |
No edit summary |
||
| Line 23: | Line 23: | ||
<br/> | <br/> | ||
<br/> | <br/> | ||
__TOC__ | |||
From different places of the Local Website you can [[Browsing records|browse your data]], and/or export your own in different [[Glossary#Extended_list:|formats:]] <br/> | From different places of the Local Website you can [[Browsing records|browse your data]], and/or export your own in different [[Glossary#Extended_list:|formats:]] <br/> | ||
| Line 97: | Line 99: | ||
==Available formats== | ==Available formats== | ||
<br/> | <br/> | ||
<center> | <center> | ||
<table border="1px solid black" width="75%" align="center" ;> | <table border="1px solid black" width="75%" align="center" ;> | ||
| Line 156: | Line 159: | ||
<br/> | <br/> | ||
<center> | |||
<table border="1px solid black" width="75%" align="center" ;> | |||
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; color: black; background-color: LightGray"> | |||
<th>Name</th> | |||
<th>Description</th> | |||
<th>Availability</th> | |||
<th>Example</th> | |||
</tr> | |||
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; color: black"> | |||
<td style="text-align: center">BASIC</td> | |||
<td style="text-align: center">Tab separated plain text(.txt)</td> | |||
<td style="text-align:left">Data stored as a text, with columns separated by spaces.<br/>It can be opened with Microsoft Notepad, WordPad and TextEdit.</td> | |||
</tr> | |||
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; color: black"> | |||
<td style="text-align: center">OLD_BASIC+</td> | |||
<td style="text-align: center">MS Excel file (.xlsx)</td> | |||
<td style="text-align:left">[[Glossary#Spreadsheet:|Spreadsheets]].<br/>It can be opened with Microsoft Excel.</td> | |||
</tr> | |||
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; color: black"> | |||
<td style="text-align: center"> | |||
[[File:2023-08-29 .xls icon.png|frameless|center]]</td> | |||
<td style="text-align: center">MS Excel file 97-2003(.xls)</td> | |||
<td style="text-align:left">[[Glossary#Spreadsheet:|Spreadsheets]].<br/>It can be opened with any version of Microsoft Excel.</td> | |||
</tr> | |||
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; color: black"> | |||
<td style="text-align: center"> | |||
[[File:2023-08-29 .kml icon.png|frameless|center]]</td> | |||
<td style="text-align: center">Google Earth (.KML)</td> | |||
<td style="text-align:left">Geo-referenced information that can be displayed in maps.<br/>It can be opened with GoogleEarth, but also with other GIS software.</td> | |||
</tr> | |||
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; color: black"> | |||
<td style="text-align: center"> | |||
[[File:2023-08-29 .xml icon.png|frameless|center]]</td> | |||
<td style="text-align: center">eXtensible Markup Language (.XML)</td> | |||
<td style="text-align:left">Data encrypted to be transferred between two computers through the web. It is used for the [[Glossary#API:|API]].</td> | |||
</tr> | |||
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; color: black"> | |||
<td style="text-align: center"> | |||
[[File:2023-08-29 .json icon.png|frameless|center]]</td> | |||
<td style="text-align: center">JavaScript Object Notation (.JSON)</td> | |||
<td style="text-align:left">Data encrypted to be transferred between two computers through the web. It is used for the [[Glossary#API:|API]].</td> | |||
</tr> | |||
</table> | |||
</center> | |||
<br/> | |||
<br/> | |||
===Create a new template=== | ===Create a new template=== | ||
Revision as of 14:05, 31 August 2023
|
|
From different places of the Local Website you can browse your data, and/or export your own in different formats:
| Name | Description | |
|---|---|---|
| Tab separated plain text(.txt) | Data stored as a text, with columns separated by spaces. It can be opened with Microsoft Notepad, WordPad and TextEdit. |
|
| MS Excel file (.xlsx) | Spreadsheets. It can be opened with Microsoft Excel. |
|
| MS Excel file 97-2003(.xls) | Spreadsheets. It can be opened with any version of Microsoft Excel. |
|
| Google Earth (.KML) | Geo-referenced information that can be displayed in maps. It can be opened with GoogleEarth, but also with other GIS software. |
|
| eXtensible Markup Language (.XML) | Data encrypted to be transferred between two computers through the web. It is used for the API. | |
| JavaScript Object Notation (.JSON) | Data encrypted to be transferred between two computers through the web. It is used for the API. |
We take the example below from Explore> All my observations, the past 30 days (see image Exporting your data). Select a template (for example, BASIC) and click on the format (for example, Excel). Place the mouse pointer on the format icons to see which extension corresponds to each icon. Once you click on the format, the file is automatically generated in the format you selected. Create your own templates using the wheel next to the template expandable list. See your exports in All my exports (see image Exporting your data, creating files).
The file shows in orange while being created and turns green when it is ready to be downloaded. To download, click on the file name. Place the mouse pointer on the "i" icon when the file is ready in order to see the characteristics for each format type. To delete any file click on the X on the top right corner of the file area (see image Exporting your data, files ready to export).
Available formats
| Name | Description | |
|---|---|---|
| Tab separated plain text(.txt) | Data stored as a text, with columns separated by spaces. It can be opened with Microsoft Notepad, WordPad and TextEdit. |
|
| MS Excel file (.xlsx) | Spreadsheets. It can be opened with Microsoft Excel. |
|
| MS Excel file 97-2003(.xls) | Spreadsheets. It can be opened with any version of Microsoft Excel. |
|
| Google Earth (.KML) | Geo-referenced information that can be displayed in maps. It can be opened with GoogleEarth, but also with other GIS software. |
|
| eXtensible Markup Language (.XML) | Data encrypted to be transferred between two computers through the web. It is used for the API. | |
| JavaScript Object Notation (.JSON) | Data encrypted to be transferred between two computers through the web. It is used for the API. |
Templates
| Name | Description | Availability | Example |
|---|---|---|---|
| BASIC | Tab separated plain text(.txt) | Data stored as a text, with columns separated by spaces. It can be opened with Microsoft Notepad, WordPad and TextEdit. |
|
| OLD_BASIC+ | MS Excel file (.xlsx) | Spreadsheets. It can be opened with Microsoft Excel. |
|
| MS Excel file 97-2003(.xls) | Spreadsheets. It can be opened with any version of Microsoft Excel. |
||
| Google Earth (.KML) | Geo-referenced information that can be displayed in maps. It can be opened with GoogleEarth, but also with other GIS software. |
||
| eXtensible Markup Language (.XML) | Data encrypted to be transferred between two computers through the web. It is used for the API. | ||
| JavaScript Object Notation (.JSON) | Data encrypted to be transferred between two computers through the web. It is used for the API. |
Create a new template
Note: images and examples are drawn from the French portal Faune-France. The design and position of some tools may vary slightly from portal to portal. To see a list of portals go to wiki section Local portals and partners. |