[GNC] Trouble downloading OFX from Canadian Tire Bank

[Vincent Dawans]

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>
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
> To update your subscription preferences or to unsubscribe:
> 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.
>