Summary
Learn about error code MBER1111 and how to resolve it.
Symptom
While MindBridge is validating your data, the following error message appears:
Invalid value in row {row} for {column}: "{value}". Correct or remove the value and try again.
What does this error mean?
When data is imported into MindBridge, the amount, debit and credit columns must contain only numeric data. If this error occurs, MindBridge has detected some form of non-numeric data in one of these columns. The error will point to the data in question. For example:
MBER1127 - Invalid value in row for : ''. Correct or remove the value and try again
- Args({row=277100, column=debit, value=BBY"})
Resolution
Within your data, navigate to the row number indicated in the error message and examine the value. For example, in the following error message the row number is 277100, in the debit column, with value BBY:
MBER1127 - Invalid value in row for : ''. Correct or remove the value and try again
- Args({row=277100, column=debit, value=BBY"})
Upon visual examination of the data, we can see that the value in column V has spilled over to column W in rows 277100 and 277101 and caused the data to be shifted over one column to the right:
If there are just a few isolated occurrences within the data then this can be changed manually. If you are unsure however, please reach out to the MindBridge support team for assistance.
Anything else on your mind? Chat with us or submit a request for further assistance.