Hi Alan Sorry the delay, but I was out and about. Its great to have something new to work on as I had run out of ideas.
My account hierarchy is as follows; All the top-level dummy accounts are 'asset'. The banking sub-accounts are then all "cheque" or "saving". The investment sub-accounts are all "investment" with "stock" or "mutual fund" actual investments. So there is actually not a mix of cheque and investments in one account. I have am busy testing out your QIFs and getting interesting results. I will report back as soon as I can see a pattern. One thing I have noticed is that I am using only 'T' and in both your files you have both U and T with the same amounts. The U is supposedly for higher transaction amounts than the T. I do not think this is my problem but I am making sure it is not. It is taking longer than I would expect because none of your accounts or categories exist in my kmm file and I am trying to standardise on the creation and/or allow kmm to do it automatically and record the results. As far as the plugin goes I would welcome giving it a go. My expertise is average, but enthusiasm is boundless. The CSV I will send to you. I am pretty flexible on my side since I am using sed and awk on all the downloaded files to cut the rubbish and semi-standardise the format into a csv which is then input into a C program for generating the QIFs. What I mean is if there is something you would expect or anything you do not like I could fix it from my side. Thanks for your interest and response. Regards Timothy On Fri, 2011-05-20 at 12:15 +0100, aga wrote: > > Begin forwarded message: > > Date: Fri, 20 May 2011 11:50:50 +0100 > From: aga <agande...@gmail.com> > To: kmymo...@kde.org > Subject: [Kmymoney] Re: QIF IMPORT PROBLEMS > > > On Fri, 20 May 2011 09:18:49 +0200 > timothy <timbo...@afrihost.co.za> wrote: > > > Hi > > > > I wondered if you could confirm that the problems I have been > > experiencing are due to the way KMM handles QIF or that there is > > something wrong with my files. > > > > I have tried importing old QIFs from when I migrated from MsMoney and > > I get similar results. At that time so many things were new and > > unknown that I can not remember these being specific problems. I do > > remember that I had to do considerable manual reconfiguring of > > accounts and categories. > > > > Be that as it may, I really want to know whether I should give up on > > the QIF import and start looking into OFX import of investment > > transactions. > > > > If anyone has examples of investment files (both QIF and OFX) that > > have successfully imported into KMM. I would very much like to use > > them in my further endeavours. My investments sites merely give web > > page output of transactions which I can download in various formats > > from PDF, XLS, CSV, HTML and even text. These I have been converting > > to QIF for import. My bank and credit card go directly with OFX into > > KMM. > > > > Ar first glance OFX investing appears not to cater for categories and > > sub-categories and does not appear to be able to transfer the > > proceeds of Sells or Dividends to another (cheque) account? > > > > Sample files that actually worked would be of tremendous help. > > > > PREVIOUS MESSAGE TO KMM MAILING LIST > > ------------------------------------ > > > > Hi > > > > I am running KMM 1.0.5 on KDE 3.5.10 on Ubuntu Maverick. > > > > I have been testing out QIF investment files imported into KMM and > > have run into a few problems. > > > > The QIF spec gives the L option as 1)category:subcategory or > > 2)[transfer to account] depending on the N option having an X or not > > i.e. NSellX or NDivX. > > > > However in my testing: > > 1) KMM fails to recognise the colon: and creates a new category called > > "category:subcategory" as if the whole string was a new category > > name. > > > > 2) the transfer account given as [parent-account:sub-account] is not > > recognised and although imported OK shows a yellow > > triangle /exclamation with the account field being blank in the > > ledger. If I reduce the string to just [sub-account], a new > > investment account is created with that name at top level even though > > the same-name account exists as a sub-account. > > > > Perhaps I should explain that I have organised my account structure > > with generic top level asset "dummy"accounts such as Banks Accounts; > > Money Markets; Retirement etc. Each one of these may contain several > > relevant investment or checking accounts with their corresponding > > investments. > > > > Any light on this matter would be appreciated. > > > > Timothy > > Hi Timothy > > As Cristian mentions in his reply, I've produced a plugin for KMM, to > handle import directly into KMM, of CSV files, both investment and bank > statements. As it's fairly recent, it is not yet supplied as a part of > KMM, but hopefully will be part of the next release. However, for me, > and a couple of others who've tried it, it works pretty well. I'm not > sure yet of when that release will be avaiable. It is presently > included in the SVN, development, version. > > So far as bank statements are concerned, I gather you are able to use > OFX, which is good. > > For investments, using the csv plugin, and in fact using QIF, it is > most certainly possible to have dividends/sells transfer automatically > into a cheque type account, and I previously used QIF for this and now > use CSV successfully. > > In your first posting, you mention problems associated with subaccounts > and categories, which surprises me, and I wonder if your difficulty > might be associated with the way in which you say you've set up your > accounts. I'm not clear if you have a mix of investment and checking > sub-accounts below your dummy top-level? If so, what type is that > top-level account? I must confess I've no idea whether that is catered > for in KMM. You may though be able to mix-n-match below an > Institution, which may give you what you require. > > I've just dug out and modified an old QIF file and confirmed that it > imports correctly transactions containing dividends and transferred the > proceeds correctly to a cheque account. Attached invAa.QIF. > > Similarly, an old large Quicken file which I've stripped, and which > confirms that a payment can tranfer to a sub-account- see last > transaction of everythingtrans.QIF > > If so far as your web investment imports are concerned, then the csv > plugin may help. This may be a bit of bother to set up initially, as > its only in the development release, but much depends on your expertise > and enthusiasm! Let me know. > > Allan > _________________________________________________________________________ > > Hi Timothy > > It might be an idea, if you can, to let me have a sample investment csv > file, to see if there might be any problems with its format, that I > might need to look into. CSV files are very variable, and I only have > seen a few types. If so, send it direct to me. I'll treat it as > private anyway. > > Allan > > Be sure to edit anything sensitive/incriminating! > _______________________________________________ KMyMoney mailing list > kmymo...@kde.org https://mail.kde.org/mailman/listinfo/kmymoney _______________________________________________ KMyMoney-devel mailing list KMyMoney-devel@kde.org https://mail.kde.org/mailman/listinfo/kmymoney-devel
