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

[Christopher Lam]

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> wrote:

> > -----Original Message-----
> > From: Liz [mailto:edodd at billiau.net]
> > Sent: Sunday, 10 July 2016 9:25 AM
> > To: Chris Good <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
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.
>