[Kmymoney] Re: QIF IMPORT PROBLEMS

[timothy]

Hi

Sure thing. It was just that previous problems had almost immediate 
responses (and solutions) and I had not heard anything for two days.
So I thought I would have to look for a different direction. 
I will be patient.

Regards
Timothy

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


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