Export records: Difference between revisions

From Biolovision Help
Jump to navigation Jump to search
(Created page with "<br/> <center> <div class="toc" style="border-radius:5px;background-color:#ffffff;padding-left:8px;padding-right:8px;padding-bottom:8px;width:600px;"> 600px <div class="toc" style="border-radius:5px;padding-left:15px;text-align:left; font-size:12px;width:575px;"> '''Export data.''' </div> </div> </center> <br/> <br/> Export your data by going to Main menu > Consulting > Sightings > All my observations. All your ob...")
 
No edit summary
Line 27: Line 27:
</p>
</p>
</div>
</div>
</center>
<br/>
<br/>
_________________
<br/>
<center>
<div class="toc" style="border-radius:5px;background-color:#ffffff;padding-left:8px;padding-right:8px;padding-bottom:8px;width:600px;">
[[File:Export menu.png|600px]]
<div class="toc" style="border-radius:5px;padding-left:15px;text-align:left; font-size:12px;width:575px;">
'''Export data.'''
</div>
</div>
</center>
<br/>
<br/>
Export your data by going to Main menu > Consulting > Sightings > [[Media:Consulting menu.png|All my observations]]. All your observations, and go to Export section. <br/>
<br/>
<center>
<div class="toc" style="border-radius:5px;background-color:#ffffff;padding-left:8px;padding-right:8px; padding-bottom:8px;width:600px;">
[[File:Export options.png|600px]]
<div class="toc" style="border-radius:5px;padding-left:15px;text-align:left; font-size:12px;width:575px;">
'''Export section.'''
</div>
<p style="color:black;font-size:12px;padding-left:30px;text-align:left;column-count:2;">
<b>1.</b> [[Export data#Period|Select period]]. <br />
<b>2.</b> [[Export data#Format|Select format]]. <br/>
<b>3.</b> [[Export data#Start|Start exporting]]. <br />
</p>
</div>
</center>
<br/>
<br/>
<span id="Period"></span>
:::'''1. Select period'''<br/>
<br/>
Select the period of time to export your data. <br/>
<br/>
Check: <br/>
* a full year, <br/>
* a Full month, or <br/>
* only a day. <br/>
<br/>
Change options by changing period selection on the above section <b>'Choose a date and a taxonomic group'</b>. Year, month and day ready to export are those selected above. <br/>
<br/>
<span id="Format"></span>
:::'''2. Select format'''<br/>
<br/>
Select how to export data. <br/>
<br/>
Check one of the options: <br/>
<table style="width:70%; border:1; align=left;">
<tr style="padding: 25px; text-align: left; font-family: sans-serif; color: black; background-color: white">
<td>
[[File:Notas icon.png|frameless|center|100px]]
</td>
<td style="text-align:left">Export your data as a tab separated plain text(.txt). It can be opened with Microsoft Notepad, WordPad and TextEdit. </td>
</tr>
<tr style="padding: 25px; text-align: left; font-family: sans-serif; color: black; background-color: white">
<td>
[[File:Excel xls.png|frameless|center|100px]]
</td>
<td>Export your data as a MS Excel file (.xlsx). It can be opened with Microsoft Excel.</td>
</tr>
<tr style="padding: 25px; text-align: left; font-family: sans-serif; color: black; background-color: white">
<td>
[[File:Export xlsx.png|frameless|center|100px]]</td>
<td>Export your data as a MS Excel file 97-2003(.xls). It can be opened with any version of Microsoft Excel.</td>
</tr>
</table>
<br/>
<span id="Start"></span>
:::'''3. Start export''' <br/>
<br/>
When period and format are selected, click <b>'START'</b> and select where to store your data in your computer. Export will start immediately. Fields downloaded are stated underneath:<br/>
<br/>
<center>
<table class="wikitable sortable" style="border:1px solid black;" width="75%" align="center" ;>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<th>Field name</th>
<th>File description</th>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">ID ornitho 'Local portal'</td>
<td style="text-align:left">Entry number at the local portal. It is automatically assigned.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Universal observation ID</td>
<td style="text-align:left">Entry number at Biolovision products. It is automatically assigned.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Biolovision species ID</td>
<td style="text-align:left">Number associated to the species. It is automatically assigned by the system.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Species</td>
<td style="text-align:left">Species name in the language selected at 'Preferences'.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Latin name</td>
<td style="text-align:left">Latin name of the species.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Taxonomic group</td>
<td style="text-align:left">Taxonomic group of the obsevation.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Family</td>
<td style="text-align:left">Family the observation belongs to.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Systematic order</td>
<td style="text-align:left"></td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Date</td>
<td style="text-align:left">Date of observation.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Day</td>
<td style="text-align:left">Day number the observation took place.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Month</td>
<td style="text-align:left">Month the observation took place.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Year</td>
<td style="text-align:left">Year the observation took place.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Day of the year</td>
<td style="text-align:left">Day the observation took place, starting the count on 1st January.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Pentad</td>
<td style="text-align:left">Pentad (group of five days) of the year the observation took place.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Decade</td>
<td style="text-align:left">Decade (group of ten days) of the year the observation took place.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Week number</td>
<td style="text-align:left">Week number the observation took place, counting from the first week of January.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Timing</td>
<td style="text-align:left">Time of observation.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Site</td>
<td style="text-align:left">Site name and location where the observation took place.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Latitude (N)</td>
<td style="text-align:left">Latitude coordinates in N-S position format.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Longitud (S)</td>
<td style="text-align:left">Longitud coordinates in E-W position format.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Latitud (DMS)</td>
<td style="text-align:left">Latitud in DMS format (degrees, minutes and seconds).</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Longitud (DMS)</td>
<td style="text-align:left">Longitud in DMS format (degrees, minutes and seconds).</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">UTM Zone North</td>
<td style="text-align:left">Square the observation took place on a UTM grid.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">UTM X (m)</td>
<td style="text-align:left">Position on the X axe on a UTM grid.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">UTM Y (m)</td>
<td style="text-align:left">Position on the Y axe on a UTM grid.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Singing / hearing contact</td>
<td style="text-align:left">Indicates if the individual/s observed was singing or vocalising.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Altitude</td>
<td style="text-align:left">Altitude the observation took lace. It os determined automatically but can be modified when entering data.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Estimation</td>
<td style="text-align:left">Count precision. Indicates how precise is the number of individuals recorded on the observation.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Number</td>
<td style="text-align:left">Number of individuals recorded on the observation.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Details</td>
<td style="text-align:left">Number of individuals per age/sex class, if provided.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Atlas code</td>
<td style="text-align:left">Atlas code recorded for the observation.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Hidden</td>
<td style="text-align:left">Indicates if the observation is public or hidden to the public.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Verify</td>
<td style="text-align:left"></td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Comment</td>
<td style="text-align:left">Public comment left about the observation.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Private comment</td>
<td style="text-align:left">Private comment left about the observation.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Observer ID</td>
<td style="text-align:left">Number automatically assigned to the user on the local portal.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Universal observer ID</td>
<td style="text-align:left">Number automatically assigned to the user on Biolovision products.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">First name</td>
<td style="text-align:left">First name of observer.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Family name</td>
<td style="text-align:left">Family name of observer.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">E-mail</td>
<td style="text-align:left">Observer's e-mail.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Anonymous</td>
<td style="text-align:left">Indicates if the observer wanted to report the observation anonymously.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Insertion date</td>
<td style="text-align:left">Date the observation was recorded on the system.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Source</td>
<td style="text-align:left">Indicates how the data was submitted.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">Last modification date</td>
<td style="text-align:left">Last date the observation was edited once entered.</td>
</tr>
<tr style="padding: 25px; text-align: center; font-size: 16px; font-family: sans serif; ">
<td style="text-align: center">SEARCH_EXPORT_TEXT_HAS_OFFSPRING_INFO</td>
<td style="text-align:left">Indicates if the observation included offspring data.</td>
</tr>
</table>
</center>
</center>
<br/>
<br/>
<br/>
<br/>

Revision as of 16:14, 22 November 2024


Export menu.png

Export data.



Export your data by going to Main menu > Consulting > Sightings > All my observations. All your observations, and go to Export section.

Export options.png

Export section.

1. Select period.
2. Select format.
3. Start exporting.




_________________


Export menu.png

Export data.



Export your data by going to Main menu > Consulting > Sightings > All my observations. All your observations, and go to Export section.

Export options.png

Export section.

1. Select period.
2. Select format.
3. Start exporting.



1. Select period


Select the period of time to export your data.

Check:

  • a full year,
  • a Full month, or
  • only a day.


Change options by changing period selection on the above section 'Choose a date and a taxonomic group'. Year, month and day ready to export are those selected above.

2. Select format


Select how to export data.

Check one of the options:

Notas icon.png
Export your data as a tab separated plain text(.txt). It can be opened with Microsoft Notepad, WordPad and TextEdit.
Excel xls.png
Export your data as a MS Excel file (.xlsx). It can be opened with Microsoft Excel.
Export your data as a MS Excel file 97-2003(.xls). It can be opened with any version of Microsoft Excel.


3. Start export


When period and format are selected, click 'START' and select where to store your data in your computer. Export will start immediately. Fields downloaded are stated underneath:

Field name File description
ID ornitho 'Local portal' Entry number at the local portal. It is automatically assigned.
Universal observation ID Entry number at Biolovision products. It is automatically assigned.
Biolovision species ID Number associated to the species. It is automatically assigned by the system.
Species Species name in the language selected at 'Preferences'.
Latin name Latin name of the species.
Taxonomic group Taxonomic group of the obsevation.
Family Family the observation belongs to.
Systematic order
Date Date of observation.
Day Day number the observation took place.
Month Month the observation took place.
Year Year the observation took place.
Day of the year Day the observation took place, starting the count on 1st January.
Pentad Pentad (group of five days) of the year the observation took place.
Decade Decade (group of ten days) of the year the observation took place.
Week number Week number the observation took place, counting from the first week of January.
Timing Time of observation.
Site Site name and location where the observation took place.
Latitude (N) Latitude coordinates in N-S position format.
Longitud (S) Longitud coordinates in E-W position format.
Latitud (DMS) Latitud in DMS format (degrees, minutes and seconds).
Longitud (DMS) Longitud in DMS format (degrees, minutes and seconds).
UTM Zone North Square the observation took place on a UTM grid.
UTM X (m) Position on the X axe on a UTM grid.
UTM Y (m) Position on the Y axe on a UTM grid.
Singing / hearing contact Indicates if the individual/s observed was singing or vocalising.
Altitude Altitude the observation took lace. It os determined automatically but can be modified when entering data.
Estimation Count precision. Indicates how precise is the number of individuals recorded on the observation.
Number Number of individuals recorded on the observation.
Details Number of individuals per age/sex class, if provided.
Atlas code Atlas code recorded for the observation.
Hidden Indicates if the observation is public or hidden to the public.
Verify
Comment Public comment left about the observation.
Private comment Private comment left about the observation.
Observer ID Number automatically assigned to the user on the local portal.
Universal observer ID Number automatically assigned to the user on Biolovision products.
First name First name of observer.
Family name Family name of observer.
E-mail Observer's e-mail.
Anonymous Indicates if the observer wanted to report the observation anonymously.
Insertion date Date the observation was recorded on the system.
Source Indicates how the data was submitted.
Last modification date Last date the observation was edited once entered.
SEARCH_EXPORT_TEXT_HAS_OFFSPRING_INFO Indicates if the observation included offspring data.