Skip to contents

process_field_sheet_examples() takes sample field sheets and converts them to database-ready formatting.

Usage

process_field_sheet_samples(filepath)

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.

Examples

filepath <- "data-raw/test.xlsx"
field_data_clean <- process_field_sheet_samples(filepath)
#> Error: `path` does not exist: 'data-raw/test.xlsx'