Found this issue while looking at How to download in Pdf or print a monthly statement with all transactions from all accounts?
Downloaded a CSV but cannot import successfully due to the CSV generated having line breaks within lines.
Steps to reproduce
- Generate Detailed Nominal Ledger Report as per Run a Detailed Nominal Ledger Report
- First open a text editor such as Notepad+ + (this is good as shows the line numbers so shows genuine lines rather than just wrapped lines)
- Ensure word wrap is off
- Open the CSV before doing anything else with it
- Examine the text
The summary data at the top of the CSV is not ideal from a data import perspective but can be worked around. Each line of the main nominal ledger should begin with the date, followed by comma separated values for each subsequent field.
‘Items for purchase’ and ‘Items for invoice’ lines are split between Supplier/Client and Description into 2 lines. This is apparent in a text editor and simply messes up in the import into Excel. I’ve tried changing in Notepad ++ from Windows (CR LF) to Unix (LF) but no effect.