Home → Problems →

QFX encoding

• Edit

Hugo Frappier

16 Jan, 2011 07:03 PM

I am currently trying to see if I can move my data from Quicken 2003 for Mac to MoneyDance. So far so good! ;-)

But now, when I import a QFX file from my bank, accents are not dealt properly. I tried UTF8 encoding, ISO-8859-1 encoding, MacRoman and nothing works.

What is the expected file encoding for QFX?

1. 1 Posted by Ben Spencer on 18 Jan, 2011 07:51 PM

   

   The expected encoding is UTF-8

   Can you provide a part of the file that includes a transaction with an accent that I can pass on to the developers.

   Ben Spencer
   Moneydance Support

   • Edit

2. 2 Posted by Hugo Frappier on 18 Jan, 2011 08:16 PM

   

   Here you go. My banks generate a ISO-8859-1 (Latin 1) encoded QFX file. The one attached has accents.

   I tried convertinf to UTF-8, but the accents are not handled properly when import in MoneyDance.

   Have fun

   • cibc-1.qfx 1.25 KB
   • Edit

3. 3 Posted by Ben Spencer on 21 Jan, 2011 05:26 PM

   

   Hi

   I am sorry it took so long to get back to you. The problem was right under my nose and I still couldn't see it.

   The QFX file you have provided defines the ENCODING and CHARSET in the header of the file.

   OFXHEADER:100
   DATA:OFXSGML
   VERSION:102
   SECURITY:NONE
   ENCODING:USASCII
   CHARSET:1252
   COMPRESSION:NONE
   OLDFILEUID:NONE
   NEWFILEUID:NONE

   If you remove the ENCODING:USASCII and CHARSET:1252 lines from the header Moneydance will default to UTF-8 will allows for the accented characters.

   Sincerely
   Ben Spencer
   Moneydance Support

   • Edit

4. 4 Posted by Hugo Frappier on 04 Feb, 2011 12:37 PM

   

   Excellent. I'll write a folder action to remove those lines. I'll also check if the file is indeed in 1252. if not, I will report a bug to my bank, they should fix the encoding or remove the lines. But it's a bank, so that change might never happen.

   Thanks.

   • Edit

5. Ben Spencer closed this discussion on 04 Feb, 2011 01:55 PM.