OFX file example

[Richard Thomas]

Hi Derek,

I am sure that I won't import the same transaction with a different FITID
and here's how....

I regularly download the CSV file from my bank's online banking system (3
to 6 times a week) and give it a unique filename.

The CSV file always contains the last 25 transactions, so there is plenty
of overlap between each downloaded CSV file.

Here's the date ranges of the last three CSV files that I have download
from my bank:

13/JUL/2012 to 27/JUL/2012
16/JUL/2012 to 31/JUL/2012
23/JUL/2012 to 02/AUG/2012

I do a diff between the CSV file that I have just downloaded and the
previously download CSV file.

>From that, I extract just the new transactions that have appeared in the
latest CSV file since the previous CSV file.

The extracted files are fed into my OFX file creation code and that's what
I import into GnuCash.

How does that sound?

Cheers,

Richard.


On 2 August 2012 15:17, Derek Atkins <warlord at mit.edu> wrote:

> Hi,
>
> Richard Thomas <richdthomas at gmail.com> writes:
>
> > Hi Derek,
> >
> > I use YYYYMMDDhhmmNNN, where the NNN is a number that is incremented for
> > each line of CSV that my script reads.
>
> And you make sure to re-use the same NNN if you happen to have the same
> transaction in a second import?  Or are you always 100% sure that you'll
> never have a duplicate?
>
> > Cheers,
> >
> > Richard.
>
> -derek
>
> > On 1 August 2012 16:25, Derek Atkins <warlord at mit.edu> wrote:
> >
> >> Hi,
> >>
> >> Richard Thomas <richdthomas at gmail.com> writes:
> >>
> >> > Hi Derek,
> >> >
> >> > My choice of file format to import is down to the way I use Gnucash
> and
> >> my
> >> > online banking.
> >> >
> >> > I hand enter my transactions and then import from my online banking
> data.
> >> >
> >> > I have now written a script to convert my bank's CSV file format to
> OFX
> >> file
> >> > format.
> >> >
> >> > It's producing OFX files that Gnucash is understanding, which I'm
> really
> >> > pleased with.
> >>
> >> What is your source of FITID for the OFX?
> >>
> >> > Thanks,
> >> >
> >> > Richard.
> >>
> >> -derek
> >>
> >> > On 30 July 2012 23:00, Derek Atkins <warlord at mit.edu> wrote:
> >> >
> >> >     Hi,
> >> >
> >> >     Richard Thomas <richdthomas at gmail.com> writes:
> >> >
> >> >     > Hi
> >> >     >
> >> >     > Would anybody be able to point me in the direction of a really
> >> simple
> >> >     OFX
> >> >     > file example please.
> >> >     >
> >> >     > Below is an example of a QIF file, to show the type of
> transaction
> >> I
> >> >     want
> >> >     > to import as OFX:
> >> >     >
> >> >     > !Type:Bank
> >> >     > D19/07/2012
> >> >     > NTST PRICHARD ENTERPRISES
> >> >     > Cc
> >> >     > T-12.34
> >> >     > ^
> >> >
> >> >     There is no such thing as a "really simple OFX file".  OFX is a
> >> fairly
> >> >     complicated SGML protocol.  Why do you want to convert a nice,
> simple
> >> >     QIF transaction to the complicated OFX format?  The only benefits
> of
> >> >     OFX, IMHO, are the ability to do automated duplicate-import
> detection
> >> >     (using the account-unique OFX FITID) and the Bayesian account
> >> mapping.
> >> >     OTOH QIF lets you do mass assignment of transactions with the same
> >> Payee
> >> >     or Memo.
> >> >
> >> >     > Thanks in advance.
> >> >     >
> >> >     > Richard.
> >> >
> >> >     > Please remember to CC this list on all your replies.
> >> >     > You can do this by using Reply-To-List or Reply-All.
> >> >
> >> >     -derek
> >> >
> >> >     --
> >> >            Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >> >            Member, MIT Student Information Processing Board  (SIPB)
> >> >            URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
> >> >            warlord at MIT.EDU                        PGP key available
> >> >
> >>
> >> --
> >>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >>        Member, MIT Student Information Processing Board  (SIPB)
> >>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
> >>        warlord at MIT.EDU                        PGP key available
> >>
> > _______________________________________________
> > 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.
> >
> >
>
> --
>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>        Member, MIT Student Information Processing Board  (SIPB)
>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>        warlord at MIT.EDU                        PGP key available
>