The format of the .csv file exported by Homebase->Export View is incorrect.
The correct format for csv is:
field1,field2,field3
Not
field1, filed2, field3
The space is critical and is therefore a bug. Anyone who knows the basics of csv format know why this doesn't work.
space and double quote are both delimiters
The problem arises when you try to dump Client Street and Apt Address
This field contains a comma that is escaped with double quotes "101 Main St, Apt 1"
The problem is that the csv written as such with space comma double quote will read in as
Col1 Col2
"101 Main St Apt 1"
The solution is to use notepad to search and replace
Search: space comma double quote
Replace: comma double quote
This is not an Excel issue. I tried Libreoffice as well and neither can read the current .csv format that PS21 is writing.
INTUIT PLEASE FIX THIS BUG.
This discussion has been locked. No new contributions can be made. You may start a new discussion here
@lefty Thank you for making us aware of this issue.
I will report this issue to our engineering team.
@lefty This issue has been resolved in today's program update.
You have clicked a link to a site outside of the Intuit Accountants Community. By clicking "Continue", you will leave the community and be taken to that site instead.