Welcome back! Ask questions, get answers, and join our large community of tax professionals.
cancel
Showing results for 
Search instead for 
Did you mean: 

Proseries 2021 Hombase View export to csv has bug

lefty
Level 4

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. 

 

0 Cheers

This discussion has been locked. No new contributions can be made. You may start a new discussion here

2 Comments 2
IntuitAngela_13
Employee
Employee

@lefty Thank you for making us aware of this issue. 

I will report this issue to our engineering team.

IntuitAngela_13
Employee
Employee

@lefty This issue has been resolved in today's program update.