Column mappings
The column mappings consistent of the following elements:
id Identifier for the column. If the CSV file has a header then the ID should be the header for that column. If it does not then the ID should be the index (starting at 1) for the column.
type Tells the connector how to process this column. Each file type has its own set of applicable types, and they are described below. One type that is common to all files is CSVIgnore. This type tells the connector that it should not process this column. It will ignore this column for processing on read operations. For write operations it will preserver this column as is for existing records, and write an empty value for new records.
For example:
{type = CSVAcctID; id = userid};
or without headers
{type = CSVGrpMbrGroupID; id = 1}
Boolean attributes require an additional two elements for defining the column. these elements define which values represent true and false for the boolean attribute.
val_true - value in the CSV column that represents true in a boolean config.
val_false - value in the CSV column that represents false in a boolean config.
For example:
{type = CSVAcctStatus; id = is_enabled; val_true = TRUE; val_false = FALSE};