Anyone know if GnuCash can import ofx bank transactions from Australian ING Direct bank?

[Chris Good]

From: Christopher Lam [mailto:christopher.lck at gmail.com] 
Sent: Wednesday, 20 July 2016 11:42 PM
To: Chris Good <chris.good at ozemail.com.au>; gnucash-user at gnucash.org
Subject: Re: Anyone know if GnuCash can import ofx bank transactions from Australian ING Direct bank?

 

Haha I've reported exact same issue to ING bank last year. I'm not wasting my time waiting for them to fix this! C

 

On 10 July 2016 at 15:41, Chris Good <chris.good at ozemail.com.au <mailto:chris.good at ozemail.com.au> > wrote:

> -----Original Message-----
> From: Liz [mailto:edodd at billiau.net <mailto:edodd at billiau.net> ]
> Sent: Sunday, 10 July 2016 9:25 AM
> To: Chris Good <chris.good at ozemail.com.au <mailto:chris.good at ozemail.com.au> >
> Subject: Re: Anyone know if GnuCash can import ofx bank transactions from
> Australian ING Direct bank?
>
> >
> > I'll have a look and see if there is some GnuCash option for getting
> > log messages that may explain what's wrong with my data. It would be
> > very helpful if some-one could supply a sample .ofx file that works
> > with GnuCash.
> >
> > [1] http://www.ofx.org/downloads.html
> >
> > BTW (2) Does anyone know if it is possible to set MS Outlook so that
> > every line in an email I send to the GnuCash mailing lists, isn't
> > followed by a blank line in the replies?
> >
> > Regards, Chris Good
>
> sample, unedited, 4 transactions only, tested to see that it works
>
> Liz

Hi Liz,

Thanks very much for supplying the sample .ofx file. It enabled me to
quickly
identify the problem with my file which was that the xml entity BANKACCTFROM

and its content elements was missing. I.e. before <BANKTRANLIST> should be:
<BANKACCTFROM>
<BANKID>1234
<ACCTID>12345678
<ACCTTYPE>SAVINGS
</BANKACCTFROM>

Without the bank account identifying info, GnuCash doesn't find any
transactions to import.
After I manually added them to my file, the .ofx transactions imported fine.
I'll write a script to add the missing BANKACCTFROM info and also ensure the

FITID is unique for every transaction within an account.

I have emailed these problems to ING Direct Australia bank and they seem
very
helpful, so hopefully they will be fixed.
I've no idea if ING Direct Australia uses the same software as other ING
Direct banks around the world.

Just to document, I noticed the file Liz supplied also had after
</BANKTRANLIST>
<LEDGERBAL>
<BALAMT>1234.56
<DTASOF>20160701
</LEDGERBAL>
but this doesn't seem to be needed for importing into GnuCash.

Thanks again Liz and David,

Regards, Chris Good



 

Hi Christopher,

 

Thanks for letting me know you have already reported this to ING.

I haven’t given up on them fixing this yet, but I’m not waiting for them either. I know large companies can be slow to implement changes.

 

You may be interested in an app I have written to fix the problems with the ING Australian OFX file.

As well as fixing the 2 problems noted above, it enables you to limit the transactions output by date range to make it easier to avoid duplicates.

 

This works with Linux and Windows.

It may also work with Mac OS/X but I cannot test this.

 

Instructions for Linux:

https://github.com/goodvibes2/IngAusOfxFixLinux/blob/master/README.md

 

Instructions for Windows:

https://github.com/goodvibes2/IngAusOfxFixWin/blob/master/README.md

 

I have added it to the GnuCash Published Tools Wiki:

http://wiki.gnucash.org/wiki/Published_tools

 

(I know I could have done this much faster in awk or many other languages instead of java with a gui, but hey, I enjoy java!)

 

Regards,

Chris Good

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4817 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20160726/29954a40/attachment-0001.p7s>