Learn what to do if you encounter single record with more lines than the specified upper limit of 100.
An error occurs while trying to import a general ledger.
There is an unbalanced quotation character ( " or ' ) on the line specified.
- Open your general ledger file and go to the line specified in the error message. In the example below, the line would be row 238.
- Search for a double or single quotation mark ( " or ' ). An odd (as opposed to even) number of either of these quotation marks will cause this error; either add a balancing " or ', or remove all " and ' characters.
- Note that properly formatted CSV files have " characters to escape values that have , (comma) in them, in which case you should not just delete all " characters from the file.
- If there are more than a few rows with unbalanced (odd number) quotation marks, notify your client of this issue and ask them for a better formatted file (e.g., in proper CSV format or tab delimited text file).
Encountered single record with more lines than the specified upper limit of 100 (row 238). Context: RT Lower hinge w/148" wheelbase (14),1334905,2019-12-10,2020-01-01,318.75,2019-12-10 08:52:48.65000