OFX file example

[Derek Atkins]

Richard,

Richard Thomas <richdthomas at gmail.com> writes:

> 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?

it sounds like you are weeding out duplicates ahead of time ;)

> Cheers,
>
> Richard.

-derek

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

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