...
Now we need to configure the UserIntegratorConfigFile.json file which contains the configuration of how imported data will be processed. This file has 10 different section for different purposes.
...
DataConsistencyCheckConfiguration
| Code Block |
|---|
"DataConsistencyCheckConfiguration" : {
} |
Currently there configurations section is empty.
DataConsistencyCheckConfiguration
| Code Block | ||
|---|---|---|
| ||
"DataConsistencyCheckConfiguration" : {
} |
...
ValueMappingConfiguration
| Code Block | ||
|---|---|---|
| ||
"ValueMappingConfiguration": {
"FieldNamesWithMapping": [
{
"FieldName": "Rank",
"MappingMode": "Complete",
"MappingFileName": "ValueMapping-Rank.json"
}
]
} |
...
Example for a ValueMappingRank.json array
| Code Block | ||
|---|---|---|
| ||
[
{
"SourceValue": "Capt.",
"TargetValue": "Captain"
},
{
"SourceValue": "Captain",
"TargetValue": "Captain"
},
{
"SourceValue": "1st Eng.",
"TargetValue": "First Engineer"
},
{
"SourceValue": "2nd Eng.",
"TargetValue": "Second Engineer"
}
] |
...
Sample Configuration:
| Code Block | ||
|---|---|---|
| ||
"DataSanitationConfiguration": {
"FieldsToSanitize": [
{
"FieldName": "DeptCode",
"ReduceToSingleWhiteSpace": "true",
"SanitizeValues": [
{
"Original": "XT",
"Replacement": "xt"
},
{
"Original": ",",
"Replacement": "+"
}
]
}
]
} |
...