Read the .zip archive of a TrialMaster export — read

Import the .zip archive of a TrialMaster trial export as a list of dataframes. The archive filename should be leaved untouched as it contains the project name and the date of extraction.
Generate a .rds cache file for future reads.
If 7zip is not installed or available, use read_all_xpt() instead.

Usage

read_trialmaster(
  archive,
  ...,
  use_cache = "write",
  clean_names_fun = NULL,
  split_mixed = FALSE,
  extend_lookup = TRUE,
  subdirectories = FALSE,
  pw = getOption("trialmaster_pw"),
  verbose = getOption("edc_read_verbose", 1),
  key_columns = "deprecated"
)

Arguments

archive: [character(1)]
the path to the archive
...: unused
use_cache: [mixed(1): "write"]
controls the .rds cache. If TRUE, read the cache if any or extract the archive and create a cache. If FALSE extract the archive without creating a cache file. Can also be "read" or "write".
clean_names_fun: [function]
a function to clean column names, e.g. tolower, janitor::clean_names(),...
split_mixed: [logical(1): FALSE]
whether to split mixed datasets. See split_mixed_datasets.
extend_lookup: [character(1): FALSE]
whether to enrich the lookup table. See extend_lookup.
subdirectories: [logical(1)]
whether to read subdirectories
pw: [character(1)]
The password if the archive is protected. To avoid writing passwords in plain text, it is probably better to use options(trialmaster_pw="xxx") instead though.
verbose: [numeric(1)]
one of c(0, 1, 2). The higher, the more information will be printed.
key_columns: deprecated

Value

a list containing one dataframe for each .xpt file in the folder, the extraction date (datetime_extraction), and a summary of all imported tables (.lookup).