Import

by **JFM** » Sun Jan 26, 2020 3:09 pm

Trying to use the file/import/transaction/generic function. See attached. What am I doing wrong?

by **Mark** » Mon Jan 27, 2020 9:41 am

Hi JFM,

Can you attach the .CSV file you're importing, and also tell me the format string you're using?

by **JFM** » Mon Jan 27, 2020 10:20 am

The format string I used is

SYMB,MM/DD/YY,TRAN.ANUM,BNUM,CNUM

Attached is the .csv file.

Thanks for the help

by **JFM** » Tue Jan 28, 2020 9:03 am

Found the problem - looking closely at the header string, I had a "." and not a ","! Duuuuugh! Thanks. It works fine now.

by **Mark** » Tue Jan 28, 2020 9:23 am

Hi JFM,

Great, glad you solved it.