Create Ecosite / Ecosite Note XLSX NASIS Import Files

Usage

create_ESD_ecosites_import(file, coiids, ecositeids)

create_ESD_notes_import(file, coiids, author, notes)

create_note_from_ESD_ecosites(file, template, ..., sheet = "ESDList")

Arguments

file: output file name (either .XLSX or .CSV)
coiids: vector of component IDs
ecositeids: vector of ecological site IDs
author: author of note
notes: note content
template: a sprintf()-style format string up to 8192 bytes in length
...: values to be passed into template. Only logical, integer, real and character vectors are supported.
sheet: Default XLSX sheet name "ESDList"

Value

writes XLSX or CSV file

Examples


library(soilDB)

create_ESD_ecosites_import("test_esd.xlsx", 2770865, "F018XI205CA")
#> Loading required namespace: openxlsx

if (soilDB::local_NASIS_defined()) {
  esdnotes <- create_note_from_ESD_ecosites("test_esd.xlsx", "Assigned %s %s")$note

  esdnotes

  create_ESD_notes_import("test_esd_note.xlsx",
                          coiids = 2770865,
                          author = "Andrew Brown",
                          notes = esdnotes)
  unlink('test_esd_note.xlsx')
}
unlink('test_esd.xlsx')