[Kmymoney-devel] Re: Fw: [Kmymoney] Re: QIF IMPORT PROBLEMS

[timothy]

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 <agander93 at gmail.com>
> To: kmymoney at kde.org
> Subject: [Kmymoney] Re: QIF IMPORT PROBLEMS
> 
> 
> On Fri, 20 May 2011 09:18:49 +0200
> timothy <timboyle at 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 KMyMoney at kde.org https://mail.kde.org/mailman/listinfo/kmymoney