Skip to main content
May 3, 2024
Question

Line breaks missing from imported csv files

  • May 3, 2024
  • 1 reply
  • 0 views

For at least 4 years I have been using the "Import Data" -> "Invoices" tool to upload invoices at the end of every week.  These invoices describe services rendered by our trucking company and I have a script that takes information from our database and places the text on separate lines inside a cell which then becomes the service description on the invoice.  The result looks like this:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

238499 - Preloaded
Trailer: 348
Freight: Structural Steel. Trailer dropped at Customer Yard.
Picked Up: Truck 1001 - 2024-04-15 - Customer in Orangeville
Delivered: Truck 1001 - 2024-04-15 - Job Site in Orangeville
Weight: 50000
Reference: S-3208

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

A couple of weeks ago Quickbooks Online stopped respecting the linebreaks in the csv file and now the description is just a run-on mess:

- - - -

238499 - Preloaded Trailer: 348 Freight: Structural Steel. Trailer dropped at Customer Yard. Picked Up: Truck 1001 - 2024-04-15 - Customer in Orangeville Delivered: Truck 1001 - 2024-04-15 - Job Site in Orangeville Weight: 50000 Reference: S-3208

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

Is the Quickbooks technical team aware of this problem?  Will it be fixed soon?

1 reply

May 3, 2024

Hello Andrew Etsi,

 

Welcome to Community!  Having the ability to import your invoices in one batch is a great feature in QuickBooks Online.  However, there are times when it may not perform as designed.  For this reason, I suggest contacting our Customer Care team outside of Community, for further evaluation of the unexpected behavior. They will be able to review this in more depth and escalate it for further investigation, with our Development Team, if necessary.

 

Feel free to reach out again, if you have any other questions. We would be happy to assist!