import SENATE's grab sample data from csv

import SENATE's grab sample data from csv

Usage

hsImpGsData(
  csv,
  mdb,
  sep = ",",
  dateFormat = underscoreToPercent("_d/_m/_Y"),
  blockBeginPtrn = "Messstelle",
  tblNamePtrn = "tblSenGrabSmp_@M",
  boolAsk = TRUE,
  dbg = FALSE
)

Arguments

csv

full path to csv file

mdb

full path to MS Access database (*.mdb)

sep

separator in csv file

dateFormat

date format in csv file (default: %d/%m/%Y)

blockBeginPtrn

pattern indicating the begin of a data block in the file (default: Messstelle)

tblNamePtrn

table name pattern. Default: "tblSenGrabSmp_@M" with the placeholder @M being replaced with the acronym of the monitoring point

boolAsk

logical passed to hsWriteBlockToTable

dbg

If TRUE, debug messages are shown