Validate
The CSV detail log file typically contains one line of detail data for each configuration data worksheet row that failed the validate operation. If multiple fields within a single configuration data worksheet row contain invalid values, a separate line is written to the CSV detail log file for each field. If no validation errors are encountered during the operation, no lines are written to the CSV detail log file.
Table 1 shows the detail data
logged for each DSU validate operation.
| Value | Description |
|---|---|
| Worksheet Name | The name of the configuration data worksheet used for the validate operation |
| Row Number | The row number in the configuration data worksheet that contains the data that was being validated |
| Field Name | The name of the field in the row of configuration data that contained an invalid value |
| Error Description | Description of the validation error |
| Rule Description | Description of the validation rule that detected the validation error |
| Invalid Value | The invalid value that caused the validation error |
The CSV detail log file for the validate operation has the following
naming convention: YYYYMMDD_HHmmss_SSS_valRulesFileName_Detail.csv where:
- YYYY
- is the year
- MM
- is the month
- DD
- is the day
- HH
- is the hour
- mm
- are minutes
- ss
- are seconds
- SSS
- are milliseconds
- valRulesFileName
- is the name, without the file extension, of the configuration data workbook specified in the valRulesFileName property