[Kmymoney] Re: QIF IMPORT PROBLEMS

[Ian Millington]

Not sure where you got that info from Timothy but it's not right - skrooge
does import and export KMM files. Be that as it may, it's academic as it
requires KDE 4. I should have read your question more carefully, sorry.

I note the suggestion that Christian has made and recommend you wait a while
and see  if the developer can come up with an answer for you.

Ian

On 20 May 2011 10:14, timothy <timboyle at afrihost.co.za> wrote:

> I have just had a look at skrooge. I runs on KDE 4.x which I am not using
> at the moment. I am still using kmymoney 1.0.5 because of the speed
> considerations. However when I upgrade to Natty I will have the latest
> KMM and KDE installed by default so will try again from there. BTW I see
> skrooge handles QIF and OFX import, but only QIF and CSV export.
>
>
> 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
>
>
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.kde.org/pipermail/kmymoney/attachments/20110520/79e9da15/attachment.htm