If you do not use EventMeasure or have historical data that pre-dates EventMeasure or you have made changes to data or corrected errors outside of the annotation files (.EMObs) and this changed data is now the “true” copy of the data (e.g. in excel) you will have to import generic files (e.g. Count, Length and Mass).
An example R workflow is provided, to create multiple YYYY-MM_Project.name_Method_Count.txt and YYYY-MM_Project.name_Method_Length.txt files from multiple Campaigns from an Access database:
The “Format” and “On import checks” described for the $Count.txt (Table 3), $Length.txt (Table 5) and $Mass.txt (Table 7) indicate the format and requirement of fields for the file to be successfully uploaded.
An example template for $Count.txt, $Length.txt and $Mass.txt are provided, the head of which are shown in Tables 4, 6 and 8 respectively.
For historical BRUV data - if a user wanted to import cumulative MaxN data - they could upload an additional $Points.txt file such as found in a EM datatable output.
Table 3. Format of the YYYY-MM_Project.name_Method_Count.txt file
| Name | Format | On Import checks |
|---|---|---|
| Sample | String | Cannot be blank |
| Family | String | Cannot be blank |
| Genus | String | Cannot be blank |
| Species | String | Cannot be blank |
| Count | Numeric | Is numeric |
| Others | As many other user defined column names as required | Can be blank |
Table 4. Head of 2015-01-Montes.transect-stereoBRUVs_Count.txt
| Sample | Family | Genus | Species | Count |
|---|---|---|---|---|
| NCB606 | Nemipteridae | Pentapodus | porosus | 2 |
| NCB606 | Labridae | Coris | caudimacula | 4 |
| NCB606 | Nemipteridae | Pentapodus | porosus | 2 |
| NCB607 | Nemipteridae | Pentapodus | porosus | 3 |
Table 5. Format of the YYYY-MM_Project.name_Method_Length.txt file
| Name | Format | On Import checks |
|---|---|---|
| Sample | String | Cannot be blank |
| Family | String | Can be blank |
| Genus | String | Cannot be blank |
| Species | String | Cannot be blank |
| Count | Numeric | Is numeric |
| Length | Numeric | Is numeric |
| Others | As many other user defined column names as required | Can be blank |
Table 6. Head of 2015-01-Montes.transect-stereoBRUVs_Length.txt
| Sample | Family | Genus | Species | Count | Length |
|---|---|---|---|---|---|
| NCB606 | Nemipteridae | Pentapodus | porosus | 1 | 150 |
| NCB607 | Nemipteridae | Pentapodus | porosus | 1 | 140 |
| NCB607 | Labridae | Coris | caudimacula | 1 | 190 |
| NCB608 | Labridae | Coris | caudimacula | 1 | 180 |
Table 7. Format of the YYYY-MM_Project.name_Method_Mass.txt file
| Name | Format | On Import checks |
|---|---|---|
| Sample | String | Cannot be blank |
| Family | String | Can be blank |
| Genus | String | Cannot be blank |
| Species | String | Cannot be blank |
| Mass | Numeric | Is numeric |
| Others | As many other user defined column names as required | Can be blank |
Table 8. Head of 2015-01-Montes.transect-stereoBRUVs_Mass.txt
| Sample | Family | Genus | Species | Mass |
|---|---|---|---|---|
| NCB606 | Nemipteridae | Pentapodus | porosus | 1.484175026 |
| NCB607 | Labridae | Coris | caudimacula | 0.2356908879 |
| NCB608 | Nemipteridae | Pentapodus | porosus | 0.941117226 |
| NCB609 | Nemipteridae | Pentapodus | porosus | 1.560714043 |