Handling of Errors

If any errors occur during the import process, an error report will be generated. Use this report to identify and resolve the issues before attempting to re-import the data. Correct the errors by updating the necessary details and re-import the error report, rather than the original sheets, to avoid creating duplicate records.

Error Messages	Explanation
Value is missing under column {columnName}	The error appears when the mandatory field value is missing. For example, The Site field under Site module is a mandatory field and the value cannot be empty.
The value under the column {columnName} could not be parsed as a number because it contains non-numeric characters	The entered value in the column must be of numeric value only. For example, the field Area in Site module must be of numeric value such as ‘20086’
The value in the lookup field {columnName} does not exist in the {moduleName} module. Please provide a valid lookup value	The value in the lookup field Site must have the same value in the Site module. For example, the field value must be with a valid entry
Date format mismatch under column {columnName}	The error appears when there is a mismatch in the date format. The date format must be corrected to DD/MM/YYYY or MM/DD/YYYY based on the error
Exception under column {columnName} because of {errorMessage}	The error appears when there is an error in the field because of the string value or numeric value. For example, if the field supports string value, it must not contain any numeric value. Else, the error appears
Record not updated because of the error message	When there is any kind of an error in the field like, an ‘ID’ is not found for a record, the error message appears

Disclaimer: The errors mentioned above are general errors that can occur in any module of the application. In addition to these, there are various other errors specific to individual modules that may occur.