[GNC] Trouble downloading OFX from Canadian Tire Bank

[R. Victor Klassen]

Thanks.  I’ll take a look when I’m at the machine where it happened - early next week.

> On Dec 16, 2022, at 1:27 PM, Vincent Dawans <dawansv at gmail.com> wrote:
> 
> I recently helped somebody with an ofx file missing the <ACCTID> and <ACCTTYPE> tags. Both are required for gnuCash to remember how to match the ofx to an account in your books. It remembers the first time then uses  <ACCTID> and <ACCTTYPE> to redo the match on following imports. Although in that case I think the import process would simply abort, I don't think it crashed. If you don't see these tags, you can put whatever you want for both tags as long as it is unique to files for that account in your books
> 
> Here is the sanitized example ofx file that was used when we discussed that issue. The ACCTID and TYPE are part of the <BANKACCTFROM> group which could also be missing. In testing in that case it was discovered that the <BANKID> tag that is in the same group wasn't really needed (but it won't hurt if it's there of course). If your file does in fact have a correct BANKACCTFROM section and tags, then you might need to compare what other differences exist and experiment to see if they are the source of the problem.
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NON
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:NONE
> <OFX>
> <SIGNONMSGSRSV1>
> <SONRS>
> <STATUS>
> <CODE>0
> <SEVERITY>INFO
> </STATUS>
> <DTSERVER>20220925094411
> <LANGUAGE>ENG
> </SONRS>
> </SIGNONMSGSRSV1>
> <BANKMSGSRSV1>
> <STMTTRNRS>
> <TRNUID>1
> <STATUS>
> <CODE>0
> <SEVERITY>INFO
> </STATUS>
> <STMTRS>
> <CURDEF>AUD
> <BANKACCTFROM>
> <BANKID>123456789
> <ACCTID>123456789012
> <ACCTTYPE>CHECKING
> </BANKACCTFROM>
> <BANKTRANLIST>
> <STMTTRN>
> <TRNTYPE>DEBIT
> <DTPOSTED>20220922000000
> <TRNAMT>-999.96
> <FITID>808288
> <MEMO>Transfer to censored - Receipt censored
> </STMTTRN>
> <STMTTRN>
> <TRNTYPE>CREDIT
> <DTPOSTED>20220922000000
> <TRNAMT>999.99
> <FITID>788899
> <MEMO>censored - Internal Transfer - Receipt censored
> </STMTTRN>
> </BANKTRANLIST>
> </STMTRS>
> </STMTTRNRS>
> </BANKMSGSRSV1>
> </OFX>
> 
> On Fri, Dec 16, 2022 at 9:34 AM R. Victor Klassen <rvklassen at gmail.com <mailto:rvklassen at gmail.com>> wrote:
> I just downloaded the monthly credit card statement as “Microsoft money” format which gave me a file with suffix ofx and header content that appears to be OFX.  Importing it causes a prompt and consistent crash.  I tried trimming out all transactions but one and it still crashes.  I’m assuming there is something in the header causing the problem.  
> 
> I tried switching to Quicken and got a qfx file with the identical header which I find suspicious. Attempting to open it was as fruitful as before.  
> 
> I don’t know whether it’s Gnucash or the file.  If the file I could likely write a preprocessor to fix it.  Is there documentation somewhere as to what is expected in the file?
> 
> 
> Gnucash 4.12 build 4.12+ (2022-09-24) 
> MaxOS Ventura on a 2022 Mac mini with an M1 chip
> 
> 
> 
> 
> Sent from my iPhone
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.