dbpf_manual_obs_subplot_xlsx: Import subplot data and manual observations from XLS file...

View source: R/dbpf_manual_obs_subplot_xlsx.R

dbpf_manual_obs_subplot_xlsxR Documentation

Import subplot data and manual observations from XLS file into DB

Description

Tests and optionally inserts manual observations into DB.

Usage

dbpf_manual_obs_subplot_xlsx(con, file_xlsx, mode = "test", dbformat = FALSE)

Arguments

con

Database connection object, as returned by dbpf_con()

file_xlsx

file name of the xlsx workbook to be imported [character]

mode

Should data be inserted into DB? Defaults to 'test' so that only testing information is returned. To insert: 'insert'

dbformat

Defaults to FALSE for reading complete sub-plot xls file. When set to TRUE, it reads only a data sheet named DB_format_manual_observation and ingests the data found there.

Details

Data is checked for existence (or duplication) of sensor and location and feedback is returned.

Author(s)

Stephan Gruber <stephan.gruber@carleton.ca>

Examples

## Not run: 
con  <- dbpf_con()
data <- dbpf_manual_obs_subplot_xlsx(con, file_xlsx)
dbDisconnect(con)

## End(Not run)

geocryology/PermafrostDB documentation built on April 17, 2025, 11:54 a.m.