...
Either format will export the file data as a .csv file.
...
Table
Exporting data in the “Table” format will result in each trait being presented as a separate column.
...
Traits or plots that received values of “NA”, “0”, or were left blank are included in the “Table” format.
| Note |
|---|
Caution. : Timestamp informationfrom data collection is not included in the “Table” format. |
...
Database
Exporting data in the “Database” format will result in data being presented as a continuous list. The data are presented in the order in which they were entered into Field Book (Fig. 4).
All data points in the “Database” format does include a timestamp.
Traits or plots that received values of “NA” or “0” are included in the “Database” format.
| Note |
|---|
Caution. Blank entries from data collection are not included in the “Database” format. |
...
Note on text entry and photos
In both the Table and Database formats, traits like “Notes” (including special characters) will be presented as they were collected.
If photos were taken for plots, the file name for the photo will be included in the .csv file.
Field Columns
The second customization that users can choose for local export involves is how much plot information to includeexport. Users can choose to export only the 5-digit observation unit database ID, or additional to add more identifying information for each plot (Fig. 5).
...
If the user selects “All imported columns” (Fig. 8), then each plot will be identified in the exported file by the full list of information available for for each plot [plot number, plot name, germplasm, replicate, column, block, and row] in addition to the 5-digit “ObservationUnitDBId”. (Fig. 9).
...
Selecting “Only active traits” will only export data for the traits that have been selected (check marked) under the “Traits” page (Fig. 11).
Even if other traits have had data collected in that instance of the field trial, if the box is not checked next to it under “Traits”, these traits will not be included in the exported file.
...
When the user selects “Bundle media data with export file” (Fig. 12), any traits with associated media data (such as the trait “Plot photo” with jpeg data) will be exported in into a folder containing the media data. The .csv file(s) containing the numeric and text-based data for each plot will also be exported.
...