Questions? We have answers.

Error Code : MBER1102

  • Updated

Symptom

While trying to import a general ledger file, you encounter the following error:

A cell in column {columnName}, row {rowNumber} contains too many characters and cannot be read. Escape this cell then reimport the file again. If the issue persists, grant MindBridge access to your engagement.

 


What does this error mean?

MindBridge encountered a cell that contains too many characters and cannot be read. It is likely that there is an unbalanced quotation character ( " or ' ) on the line specified.


Resolution

Be consistent in the use of quotation mark types.

  1. Open your general ledger file and go to the row specified in the error message.
  2. Search for a double or single quotation mark ( " or ' ).
    An uneven number of either of these quotation marks will cause this error.
  3. Either add a balancing " or ', or remove all " and ' characters.
    Note: Properly formatted CSV files have double quotation ( " ) characters to escape values that have a comma ( , ) in them, in which case you should not just delete all double quotation ( " ) characters from the file.
  4. If there are more than a few rows with an unbalanced (uneven) number of quotation marks, notify your client of this issue and ask them for a better formatted file (for example, in proper CSV format or a tab delimited text file).


Anything else on your mind? Chat with us or submit a request for further assistance.


Related articles

Was this article helpful?