Import a file as a table in Opal. The file formats supported are: RDS (.rds), SPSS (.sav), SPSS compressed (.zsav), SAS (.sas7bdat), SAS Transport (.xpt), Stata (.dta). The RDS format is a serialized single R object (expected to be of tibble class), that can be obtained using base::saveRDS(). The other file formats are the ones supported by the haven R package. This operation creates an importation task in Opal that can be followed (see tasks related functions).
opal.table_import(
opal,
file,
project,
table,
identifiers = NULL,
policy = "required",
id.name = "id",
type = "Participant",
wait = TRUE
)
Opal object.
Path in Opal to the file that will be read as a tibble.
Name of the project into which the data are to be imported.
Destination table name.
Name of the identifiers mapping to use when assigning entities to Opal.
Identifiers policy: 'required' (each identifiers must be mapped prior importation (default)), 'ignore' (ignore unknown identifiers) and 'generate' (generate a system identifier for each unknown identifier).
The name of the column representing the entity identifiers. Default is 'id'.
Entity type (what the data are about). Default is 'Participant'.
Wait for import task completion. Default is TRUE.
Other table functions:
opal.resource_view_create()
,
opal.resource_view_reconnect()
,
opal.table_create()
,
opal.table_delete()
,
opal.table_dictionary_get()
,
opal.table_dictionary_update()
,
opal.table_exists()
,
opal.table_export()
,
opal.table_get()
,
opal.table_perm_add()
,
opal.table_perm_delete()
,
opal.table_perm()
,
opal.table_save()
,
opal.table_truncate()
,
opal.table_view_create()
,
opal.table_view_update()
if (FALSE) {
o <- opal.login('administrator','password', url='https://opal-demo.obiba.org')
opal.table_import(o, '/home/administrator/mydataset.rds', 'test', 'mytable')
opal.logout(o)
}