[Kmymoney] Re: QIF IMPORT PROBLEMS

[Cristian Oneț]

On Fri, May 20, 2011 at 11:43 AM, timothy <timboyle at afrihost.co.za> wrote:
> 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?

Hi,

Please be a bit patient until someone who knows about QIF has some
suggestions for your problem. It definitely does not worth it to use
that complicated import procedure. I know Allan (CSV importer plugin
author) has worked with investment import and surely he has some
suggestions but maybe he haven't had time to answer yet.

Regards,
Cristian

>>
>>
>>
>> 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
>