Process Sample Field Sheet Data
process_field_sheet_samples.Rd
process_field_sheet_examples()
takes sample field sheets and converts
them to database-ready formatting.
Arguments
- filepath
the filepath of the field sheet you want to prepare for upload. Column names and data types should match the following:
Bin text value
Bin FL Range (mm) Numeric value
Sample # Numeric value
Sample ID Text value
Date Date (ideally in format YYYY-MM-DD)
Time Time
FL (mm) Numeric value
Field Run ID Numeric value
Comments Text value
Value
A tibble object containing the data from all sheets in the @param filepath workbook
in required format for update_field_sheet_samples
. This contains
the following variables:
sample_id The unique identifier for the sample recorded.
datetime_collected The date and time (YYYY-MM-DD H:M:S) the sample was processed.
fork_length_mm The recorded fork length corresponding to the sample.
field_run_type_id The unique identifier for the field run type.
field_comment Any recorded comments from the field regarding the sample.
Details
See create_field_sheet
and get_field_sheet_event_plan
for
more information on creating field sheet workbooks.
See also
Other field sheet helpers:
create_field_sheet()
,
create_season_field_sheets()
,
get_field_sheet_event_plan()
,
update_field_sheet_samples()