OFX Import

[Kew, Martin Scott - kewms001]

Dave, Derek,

Thanks both of you. I just sent an email to my bank indicating that their OFX format could be invalid and that the existing format is not compatible with gnucash. It looks like it is now a case of wait and see, where I will use QIF in the meantime (luckily I can select a date range for the transaction download and thereby minimise the number of duplicate transactions, if I am careful).

I will post to this list again if and when I get a response from the bank.
 
Regards
Martin 
________________________________________
From: David Reiser [dbreiser at earthlink.net]
Sent: Thursday, 17 November 2011 4:26 PM
To: Kew, Martin Scott - kewms001
Cc: gnucash-user at gnucash.org
Subject: Re: OFX Import

My complaint with QIF is that you have to deal with duplicates manually. Several of the financial organizations I've dealt with over the years provide downloads for some fixed period of time -- generally the 30 days prior to the download request. If I want to download more often than  that, I have to deal with more duplicates than I think is reasonable.

But if your bank is serving up invalid ofx, then I don't see that you have much choice.

Dave
--
David Reiser
dbreiser at earthlink.net




On Nov 17, 2011, at 12:32 AM, Kew, Martin Scott - kewms001 wrote:

> Hi David,
>
> Thanks for the prompt reply. I just used a text editor to change the TRNTYPE to POS and then to OTHER (where I found the OTHER type in the OXF spec for banking). In both cases I got the same result i.e. an empty transaction matcher window. As a point of clarification, the example oxf file came from a download of a single day's transactions from my bank.
>
> Am I stuck, where I should just use QIF import instead, given that my bank supports (QIF, OXF, CSV) transaction download formats?
>
> Regards
> Martin
>
> ________________________________________
> From: David Reiser [dbreiser at earthlink.net]
> Sent: Thursday, 17 November 2011 3:43 PM
> To: Kew, Martin Scott - kewms001
> Cc: gnucash-user at gnucash.org
> Subject: Re: OFX Import
>
> On Nov 16, 2011, at 9:58 PM, Kew, Martin Scott - kewms001 wrote:
>
>> Hi,
>>
>>
>>
>> I am a new gnucash user (revision 2.4.8, Windows XP) where I am having a problem importing bank transactions using the OFX import feature. When I attempt to import I get an empty "generic transaction matcher" window. Attached is the .oxf file used, this file contains a single transaction.
>>
>>
>>
>> Regards
>>
>> Martin
>> <example.ofx>_______________________________________________
>
> The <TRNTYPE> in that example is invalid. There are only 17 allowed options for <TRNTYPE> and they are all caps, no spaces or symbols.
>
> My comment is based on 1.0.3, 2.0.3, and 2.1.1 versions of the ofx spec. This isn't the kind of thing they change much, if ever. My guess as to the correct <TRNTYPE> for the example transaction is POS. I think you'll have to use the memo to tell that you got cash back.
>
> I believe the reason you see the blank transaction matcher window is that the importer throws away invalid transactions, and you have no valid transactions left.
>
> Dave
> --
> David Reiser
> dbreiser at earthlink.net