QIF syntax question

[Otto Müller]

Dies ist eine mehrteilige Nachricht im MIME-Format.
--------------FECA54B74B8D917C76CE7EFF
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Paul Lussier schrieb:
> 
> I'm in the process of inputting several months of bank transactions
> (debit card purchases, ATM receipts, etc.) into GnuCash.
> 
> [...] I [...] opted to create a QIF file of all the transactions.

I did some similar work (migrating about 2 years accumulated data out of
some old self-made DOS-program), and I decided to convert to the
XML-format og GnuCash 1.6.

The idea was: Create synthetic
<gnc:transaction version="2.0.0"> ... </gnc:transaction>
records and add them to your existent GnuCash file (Backup before !!!!)

The following tasks came up:
1) Figure out the lines
     <act:id type="guid">db184ad5b6329b92fe3a4daed874984d</act:id>
   of the accounts you will be using in your data to import as
     <split:account
type="guid">db184ad5b6329b92fe3a4daed874984d</split:account>
2) For each of your synthetic transaction create an
     <trn:id type="guid">befe990821efe004488bc13444800b9c</trn:id>
   I assume the guid must be unique in your file and has no deeper
meaning in it
   (throw the dice?). I myself used an existing one and modified only
some
   characters by counting up.
3) What to do with the remaining fields was quite obvious to me.
4) You must update the line
     <gnc:count-data cd:type="transaction">2703</gnc:count-data>
   indicating the new number of transactions. There were no problems
with
   a number too high.

This conversion done I had my old data imported to GnuCash "in the
twinkling of an eye".

Otto
--------------FECA54B74B8D917C76CE7EFF
Content-Type: text/x-vcard; charset=us-ascii;
 name="otto.mueller.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Visitenkarte für Otto Müller
Content-Disposition: attachment;
 filename="otto.mueller.vcf"

begin:vcard 
n:Müller;Otto
tel;fax:0228/16-26840
tel;work:0228/16-27552
x-mozilla-html:FALSE
org:Deutscher Bundestag - Verwaltung;Referat ZI 1
adr:;;Rheinweg 6;Bonn;;53113;
version:2.1
email;internet:otto.mueller@bundestag.de
fn:Otto Müller
end:vcard

--------------FECA54B74B8D917C76CE7EFF--