Imports Haridwar data

Imports Haridwar data

import_data_haridwar(
  analytics_path = system.file(file.path("shiny", "haridwar/data/analytics.xlsx"),
    package = "aquanes.report"),
  operation_mySQL_conf = system.file("shiny/haridwar/.my.cnf", package =
    "aquanes.report"),
  operation_meta_path = system.file(file.path("shiny/haridwar/data",
    "operation_parameters.csv"), package = "aquanes.report"),
  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: system.file(file.path("shiny/haridwar/data", "analytics.xlsx"), package = "aquanes.report"))
operation_mySQL_conf	column name pattern for identifying raw data (default: system.file("shiny/haridwar/.my.cnf", package = "aquanes.report"))
operation_meta_path	path to table with meta data for operational parameters (default: system.file(file.path("shiny/haridwar/data", "operation_parameters.csv"), package = "aquanes.report"))
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)

Value

returns data frame with Haridwar raw data (operation & analytics)