Import multi-line field values

Post Reply
TransPost Support
TransPost team member
Posts: 42
Joined: Wed 11 Mar, 2015 9:31 pm

Import multi-line field values

Post by TransPost Support » Sat 21 Mar, 2015 4:26 pm

Can TransPost import text from multi-line cells in Excel, for example addresses or descriptions?

It depends on which version of AccountRight you are using. In all cases AccountRight will accept up to 255 characters for descriptions and, when printing invoices etc, wrap them in a reasonable manner on output, breaking at spaces etc.

CSV files may have their lines terminated by either CR+LF or just CR or LF. If output by Excel they are terminated by CR+LF. If there are Excel cells which are multi-line then those line breaks within the row are terminated by just a LF.

Thus if your Excel file looks like this:
Multi-line Excel cells.JPG
Multi-line Excel cells.JPG (34.73 KiB) Viewed 7995 times
If you save it as a CSV file it will be formatted with an LF at the line breaks in the description.

When TransPost reads a file formatted like this it initially accepts a multi-line field as a single string, complete with new-line breaks.

If you are using the old AccountRight (v19.x or earlier) then TransPost uses the MYOB ODBC driver which does not accept any line breaks in SQL so TransPost filters them out do the entire text becomes a single line. In the above example the desctions would become
  • Description of line item - with specifics on a second line
    A second line itemwith more detailsextending to a third line
If you are using AccountRight Live (Version 2014 onwards) then intermediate line breaks within a field, indicated by solo LF within lines terminated by CR+LF will be passed on by TransPost and the descriptions will appear in the resulting Invoice laid out just like they are in Excel.

Note that you must not open and save the csv file using a text editor such as Notepad as most text editors will turn the solo LF into CR+LF, effectively splitting the row of data at that point, which makes a complete mess of it.

Post Reply