[Kmymoney] Re: QIF IMPORT PROBLEMS

[Ian Millington]

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







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
>
>
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney

-- 
Created in Mozilla Thunderbird and Kubuntu Linux - all free software
www.mozillamessaging.com/en-US/thunderbird
www.kubuntu.org