Imports Haridwar data
Usage
import_data_haridwar(
analytics_path = shiny_file("haridwar/data/analytics.xlsx"),
operation_mySQL_conf = shiny_file("haridwar/.my.cnf"),
operation_meta_path = shiny_file("haridwar/data/operation_parameters.csv"),
excludedSheets = c("Parameters", "Location", "Sites", "#Summary", "Site_and_Parameter",
"Observations", "dP", "ORP", "Flow", "Current_Voltage", "As_total_Arsenator"),
skip = 69,
debug = TRUE
)Arguments
- analytics_path
Define path of analytics EXCEL spreadsheet to be imported (default: kwb.pilot:::shiny_file("haridwar/data/analytics.xlsx"))
- operation_mySQL_conf
column name pattern for identifying raw data (default: kwb.pilot:::shiny_file("haridwar/.my.cnf"))
- operation_meta_path
path to table with meta data for operational parameters (default: kwb.pilot:::shiny_file("haridwar/data/operation_parameters.csv"))
- excludedSheets
all sheets, which are not listed here will be imported as lab data sheets (default: c("Parameters", "Location", "Sites", "#Summary", "Site_and_Parameter", "Observations", "dP", "ORP", "Flow", "Current_Voltage", "As_total_Arsenator"))
- skip
number of rows to skip for each lab data sheet (default: 69), i.e. for all sheets which are not explictly excluded with parameter "excludedSheets"
- debug
if TRUE print debug messages (default: TRUE)