[Kmymoney] Re: QIF IMPORT PROBLEMS

[timothy]

On Fri, 2011-05-20 at 09:13 +0100, Ian Millington wrote:
> When I first tried to migrate from Quicken to Kmymoney my files were 
> reported as too old, and that I needed an older version of KMM. That was 
> the KDE3 version - I don't know whether that has got any better so when 
> I came to migrate I didn't try it.
> 
> What worked a treat for me (and I know it's not the ideal answer) was to 
> import the QIF files into skrooge (with over 12 years transactions on 
> multiple accounts only 2 adjustments were needed).I played around with 
> skrooge for a while but found it not so user-friendly. What I was able 
> to do, importantly, was  to export as a kmymoney file which Kmymoney was 
> then able to use.
> 
> So, my take on it was that skrooge currently has the edge on import and 
> export (at least so far as QIF is concerned) whereas KMM currently has 
> the edge on function. Rather than continue to struggle it might be best 
> to use the above way to get you up and running a lot quicker
> 
> HTH
> 
> Ian
> 
Thanks. That is definitely worth a try. It might mean that I would
download a PDF file, convert it to QIF, import to skrooge, export to QIF
again and then import to KMM. At the very least I might get some insight
into what sort of format is acceptable in kmymoney and what is different
in my files. Does skrooge handle OFX export?

Timothy

> 
> 
> 
> On 20/05/11 08:18, timothy 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
> >
> > _______________________________________________
> > KMyMoney mailing list
> > KMyMoney at kde.org
> > https://mail.kde.org/mailman/listinfo/kmymoney