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