Additional configuration options can be given by uploading a JSON file on the
Data Configuration dialog. Currently, the Process Cases Options is the only option that can be specified. If additional configuration options are not specified, all dictionary variables are included while breaking out the case data into the relational tables.
Processing cases through the command line can be slow if you have a large dictionary with a lot of data. The solution is to use the Process Cases Options to specify only the variables in the dictionary that are needed. For example, the dictionary variables used in a report. Only these specified dictionary variables will then be broken out into a relational database when process cases command tool is run.
The include options allow the dictionary variables and records to be targeted for inclusion. The entire dictionary can also be included by not specifying an include option or by specifying an empty array for the include option (see example 1). The include option is processed first.
The exclude option allows the dictionary variables and records to be targeted for exclusion. This can be convenient if a record or the entire dictionary was included, but not all dictionary variables are needed. The exclude option is always processed after the include option.
This specification includes the entire dictionary but excludes one record:
{
"processCasesOptions":{
"include": [],
"exclude": ["HOUSING_REC"]
}
}
This specification includes two records and excludes three variables that contain PII:
{
"processCasesOptions": {
"include": ["PERSON_REC", "HOUSING_REC"],
"exclude": ["HH_LAST_NAME", "HH_FIRST_NAME", "HH_ADDRESS"]
}
}