Insert rows in EBX5 Code List — EBXInsert • faoebx5

This function will insert data rows into a code list stored in EBX5.

EBXInsert(branch, instance, folder, folder2 = "", table, data, connection = NA)

Arguments

branch	dataset branch
instance	dataset instance
folder	folder where the table is
folder2	optional second level folder
table	ebx5 table name
data	a `data.frame` containing all columns to be be inserted
connection	the result of `GetEBXConnection`; optional

Value

boolean

Details

The data columns provided must follow the code-list which is being inserted. All fiels of a primary key (usually the Identifier), and all mandatory fields must be present. Using the SOAP-API the column names and tabe table name are not the label visible in EBX, but the name. Requires that the EBX5 connection was configured using SetupEBXConnection.

Author

Thomas Berger, thomas.berger@fao.org

Luis G. Silva e Silva, luis.silvaesilva@fao.org

Examples


if (FALSE) {
cl_insert <- data.frame(Identifier = c(999, 888), Name_En=c('Test1','Test2'))
EBXInsert(branch='Fishery',
          instance='Fishery',
          folder='Metadata',
          table='Test_table',
          data=cl_insert)
}