[Kmymoney] Re: BUG REPORTING

Cristian Oneț onet.cristian at gmail.com
Mon May 23 12:23:22 CEST 2011 

On Mon, May 23, 2011 at 1:09 PM, timothy <timboyle at afrihost.co.za> wrote:
> Hi
> I registered with bugzilla and I submitted a bug report
> which seemed to be accepted OK. At least it was given a
> number as below. However I received the following email
> which is puzzling me. I presume the bug report was sent by
> bugzilla to the developers who have also strict security.
>
> My question is do I have to also register as a developer
> to get the bug attended to?
> (sic)
>
> Your mail to 'KMyMoney-devel' with the subject
>
>    [Bug 273950] New: QIF investment import containing
> L[parent:sub-account] flagged
>
> Is being held until the list moderator can review it for approval.
> The reason it is being held:
>
>    Post by non-member to a members-only list
>
> Regards
> Timothy

Let me explain why you received that mail. When you submit a bug in
bug.kde.org you use an email address to identify yourself. Each
product in the bug tracker has an email assigned to it, KMyMoney's is
kmymoney-devel at kde.org (the developer mailing list). Each time someone
submits a bug an email is sent to that address. Today we received your
report [1] but since the email you used to register at bug.kde.org is
not subscribed to the kmymoney-devel mailing list your message
(actually sent by the tracker) had to go trough moderation thus you
received the email.

As a conclusion you don't actually have to subscribe to the devel
mailing list, we can communicate trough the bug tracker (which also
goes trough the developer mailing list).

Regards,
Cristian

[1] http://mail.kde.org/pipermail/kmymoney-devel/2011-May/005307.html

>
> On Sat, 2011-05-21 at 11:30 +0100, aga wrote:
>> On Sat, 21 May 2011 11:48:45 +0200
>> timothy <timboyle at afrihost.co.za> wrote:
>>
>> > Hi Alan
>> >
>> > Here is the conclusion on testing your QIF file invAa.QIF.
>> > This file has BuyX and DivX transactions on a security with
>> > the monies/proceeds transferred in (Buy) and transferred to
>> > (Div) a cheque account at top level ie not a sub-account [chq].
>> >
>> > 1) The QIF file you sent works perfectly in both import and transfers.
>> >
>> > 2) I then edited the same QIF file to transfer to a cheque account
>> > with a parent account ie [Bank Accounts:chq], the transactions are
>> > imported OK, but no transfer takes place and the transaction in the
>> > ledger shows a yellow triangle/exclamation with the account field
>> > blank.
>> > 3) To check whether this was caused by my account hierarchy, I then
>> > manually edited both 1) and 2) in the ledger to a "Bank Accounts:chq"
>> > in the account field and both transfers worked perfectly and the
>> > yellow triangle disappeared.
>> >
>> > So it looks like kmm cannot handle [parent:sub-account] in the QIF
>> > import, but can do so as a manual transaction.
>> >
>> > I would be interested to know whether your csv plugin works with a
>> > [parent:sub a/c] transfer?
>> >
>> > Regards
>> > Timothy
>> >
>>
>> Hi Timothy
>> So far as the last para. is concerned, I've not built any special
>> capability for this in the plugin, but I don't think it's necessary.
>>
>> I set up an asset account with a checking sub-account.  I then did a csv
>> import  and when presented by KMM with the account selector wizard, I
>> chose the new sub-account and the import completed successfully.
>>
>> There appears to be a slight anomaly/bug though.  After the import,
>> which shows in Ledger view, the amount does not show in Accounts view,
>> either against the asset account, which I think is correct, or against
>> the checking account, which I think is an error.  This is very similar
>> to a bug I reported very recently.  (Having checked, I posted about it
>> - Institution View Behaviour - on Monday, but I'd better report it as a
>> bug now.
>>
>> So, now going back to your QIF import issue, into which account did you
>> choose to import?  When you say 'no transfer took place', that suggests
>> you didn't import into the chq account, as no transfer would then be
>> necessary.  Perhaps I'm not understanding what you are doing/trying?
>>
>> Allan
>> >
>> > On Fri, 2011-05-20 at 16:39 +0200, timothy wrote:
>> > > Hi Alan
>> > >
>> > > Sorry the delay, but I was out and about. Its great to have
>> > > something new to work on as I had run out of ideas.
>> > >
>> > > My account hierarchy is as follows; All the top-level dummy accounts
>> > > are 'asset'. The banking sub-accounts are then all "cheque" or
>> > > "saving". The investment sub-accounts are all "investment" with
>> > > "stock" or "mutual fund" actual investments. So there is actually
>> > > not a mix of cheque and investments in one account.
>> > >
>> > > I have am busy testing out your QIFs and getting interesting
>> > > results. I will report back as soon as I can see a pattern. One
>> > > thing I have noticed is that I am using only 'T' and in both your
>> > > files you have both U and T with the same amounts. The U is
>> > > supposedly for higher transaction amounts than the T. I do not
>> > > think this is my problem but I am making sure it is not.
>> > >
>> > > It is taking longer than I would expect because none of your
>> > > accounts or categories exist in my kmm file and I am trying to
>> > > standardise on the creation and/or allow kmm to do it automatically
>> > > and record the results.
>> > >
>> > > As far as the plugin goes I would welcome giving it a go. My
>> > > expertise is average, but enthusiasm is boundless. The CSV I will
>> > > send to you. I am pretty flexible on my side since I am using sed
>> > > and awk on all the downloaded files to cut the rubbish and
>> > > semi-standardise the format into a csv which is then input into a C
>> > > program for generating the QIFs. What I mean is if there is
>> > > something you would expect or anything you do not like I could fix
>> > > it from my side.
>> > >
>> > > Thanks for your interest and response.
>> > >
>> > > Regards
>> > > Timothy
>> > >
>> > >
>> > >
>> > > On Fri, 2011-05-20 at 12:15 +0100, aga wrote:
>> > > >
>> > > > Begin forwarded message:
>> > > >
>> > > > Date: Fri, 20 May 2011 11:50:50 +0100
>> > > > From: aga <agander93 at gmail.com>
>> > > > To: kmymoney at kde.org
>> > > > Subject: [Kmymoney] Re: QIF IMPORT PROBLEMS
>> > > >
>> > > >
>> > > > On Fri, 20 May 2011 09:18:49 +0200
>> > > > timothy <timboyle at afrihost.co.za> 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
>> > > >
>> > > > Hi Timothy
>> > > >
>> > > > As Cristian mentions in his reply, I've produced a plugin for
>> > > > KMM, to handle import directly into KMM, of CSV files, both
>> > > > investment and bank statements.  As it's fairly recent, it is not
>> > > > yet supplied as a part of KMM, but hopefully will be part of the
>> > > > next release.  However, for me, and a couple of others who've
>> > > > tried it, it works pretty well.  I'm not sure yet of when that
>> > > > release will be avaiable.  It is presently included in the SVN,
>> > > > development, version.
>> > > >
>> > > > So far as bank statements are concerned, I gather you are able to
>> > > > use OFX, which is good.
>> > > >
>> > > > For investments, using the csv plugin, and in fact using QIF, it
>> > > > is most certainly possible to have dividends/sells transfer
>> > > > automatically into a cheque type account, and I previously used
>> > > > QIF for this and now use CSV successfully.
>> > > >
>> > > > In your first posting, you mention problems associated with
>> > > > subaccounts and categories, which surprises me, and I wonder if
>> > > > your difficulty might be associated with the way in which you say
>> > > > you've set up your accounts.  I'm not clear if you have a mix of
>> > > > investment and checking sub-accounts below your dummy top-level?
>> > > > If so, what type is that top-level account?  I must confess I've
>> > > > no idea whether that is catered for in KMM.  You may though be
>> > > > able to mix-n-match below an Institution, which may give you what
>> > > > you require.
>> > > >
>> > > > I've just dug out and modified an old QIF file and confirmed that
>> > > > it imports correctly transactions containing dividends and
>> > > > transferred the proceeds correctly to a cheque account. Attached
>> > > > invAa.QIF.
>> > > >
>> > > > Similarly, an old large Quicken file which I've stripped, and
>> > > > which confirms that a payment can tranfer to a sub-account- see
>> > > > last transaction of everythingtrans.QIF
>> > > >
>> > > > If so far as your web investment imports are concerned, then the
>> > > > csv plugin may help.  This may be a bit of bother to set up
>> > > > initially, as its only in the development release, but much
>> > > > depends on your expertise and enthusiasm!  Let me know.
>> > > >
>> > > > Allan
>> > > > _________________________________________________________________________
>> > > >
>> > > > Hi Timothy
>> > > >
>> > > > It might be an idea, if you can, to let me have a sample
>> > > > investment csv file, to see if there might be any problems with
>> > > > its format, that I might need to look into.  CSV files are very
>> > > > variable, and I only have seen a few types.  If so, send it
>> > > > direct to me.  I'll treat it as private anyway.
>> > > >
>> > > > Allan
>> > > >
>> > > > Be sure to edit anything sensitive/incriminating!
>> > > > _______________________________________________ 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
>

More information about the KMyMoney mailing list