Re: [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  wrote:
> 
> I recently helped somebody with an ofx file missing the  and 
>  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  
>  and  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  group which could 
> also be missing. In testing in that case it was discovered that the  
> 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
> 
> 
> 
> 
> 0
> INFO
> 
> 20220925094411
> ENG
> 
> 
> 
> 
> 1
> 
> 0
> INFO
> 
> 
> AUD
> 
> 123456789
> 123456789012
> CHECKING
> 
> 
> 
> DEBIT
> 2022092200
> -999.96
> 808288
> Transfer to censored - Receipt censored
> 
> 
> CREDIT
> 2022092200
> 999.99
> 788899
> censored - Internal Transfer - Receipt censored
> 
> 
> 
> 
> 
> 
> 
> On Fri, Dec 16, 2022 at 9:34 AM R. Victor Klassen  > 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@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.

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Trouble downloading OFX from Canadian Tire Bank

[R. Victor Klassen]

I did succeed in building once - I’m not sure how hard it will be to reproduce 
that success.  

The latest stable build is late September (which is what I’m running).   I 
don’t recall how long until the next release.  I was able to pull in the file 
using csv.

> On Dec 16, 2022, at 2:34 PM, Glenn Serre  wrote:
> 
> Good morning,
> 
> You may be crashing due to a recently fixed bug:
> https://bugs.gnucash.org/show_bug.cgi?id=798629
> 
> Can you download (or build) a more recent gnucash? You would want a
> gnucash built after Oct 7 2022.
> 
> -- Glenn S.
> 
> On Fri, Dec 16, 2022 at 9:34 AM R. Victor Klassen  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@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.

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Trouble downloading OFX from Canadian Tire Bank

[Glenn Serre]

Good morning,

You may be crashing due to a recently fixed bug:
https://bugs.gnucash.org/show_bug.cgi?id=798629

Can you download (or build) a more recent gnucash? You would want a
gnucash built after Oct 7 2022.

-- Glenn S.

On Fri, Dec 16, 2022 at 9:34 AM R. Victor Klassen  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@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.
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Trouble downloading OFX from Canadian Tire Bank

[Vincent Dawans]

I recently helped somebody with an ofx file missing the 
and  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
 and  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  group which could
also be missing. In testing in that case it was discovered that the
 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









0

INFO



20220925094411

ENG









1



0

INFO





AUD



123456789

123456789012

CHECKING







DEBIT

2022092200

-999.96

808288

Transfer to censored - Receipt censored





CREDIT

2022092200

999.99

788899

censored - Internal Transfer - Receipt censored













On Fri, Dec 16, 2022 at 9:34 AM R. Victor Klassen 
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@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.
>
___
gnucash-user mailing list
gnucash-user@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.