OFX file example

[Richard Thomas]

Hi Derek,

I use YYYYMMDDhhmmNNN, where the NNN is a number that is incremented for
each line of CSV that my script reads.

Cheers,

Richard.

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
>