OFX file example

Derek Atkins warlord at MIT.EDU
Thu Aug 2 10:17:56 EDT 2012


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


More information about the gnucash-user mailing list