Importing non-QIF files

Derek Atkins warlord at MIT.EDU
Mon Sep 1 22:40:58 CDT 2003


I would write a PERL script to convert your data to QIF and then use
the QIF importer.  There is no CSV or TAB-format importer at the
moment (although you are welcome to write one if you wish -- but the
hard part is the UI to map "columns" to data items).

-derek

Henri P Gavin <hpgavin at duke.edu> writes:

> Dear GnuCash users:
> 
> My bank provides on-line statements in a plain-text format. QIF format
> statements are not available from this institution. The checking
> account statement looks like:
> 
> 01/24/2003 Withdrawal MORTGAGE (EQTY ENHNC) -$148.16 $8,888.08
> 01/24/2003 Deposit EMPLOYER (MONTHLY ) $1,988.27 $9,336.24
> 01/24/2003 A-XYZ U [P]...Amt: 3988.27 EMPLOYER (MONTHLY )
> 01/25/2003 Withdrawal @ BOOKSHOP Trace #4714 -$7.12 $2,537.60
> 01/31/2003 Withdrawal (Item #2698) -$156.00 $7,869.53
> 
> Right now I am cutting-and-pasting into Gnucash.  What is the best
> automatic way to import this kind of plain-text accout statment?  I
> could write a converter to a GnuCash compatible format, if I could see
> what the format standard looks like.
> 
> Thank you
> 
> Henri Gavin
> 
> 
> _________________________________________________________________________
> Henri Gavin                                         Henri.Gavin at Duke.EDU
> Department of Civil and Environmental Engineering   tel: 919 - 660 - 5201
> Duke University, Box 90287                          fax: 919 - 660 - 5219
> Durham, NC 27708--0287                              www.duke.edu/~hpgavin/
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at lists.gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user

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