Re: KMyMoney2-Transaction Matching

[allan anderson]

>
> Message: 2
> Date: Mon, 21 Jul 2008 07:44:32 +0200
> From: Thomas Baumgart <thb@...>
> Subject: Re: [Kmymoney2-user] Transaction Matching
> To: kmymoney2-user@...
> Message-ID: <200807210744.32784.thb@...>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On Monday 21 July 2008 06:55:56 Brendan Coupe wrote:
> > I just compiled the latest CVS and transaction matching no longer
> > works. "Match" is in the right click menu but it's always grayed
> > out.
> >
> > It works in 0.9 and in the CVS version for Ubuntu provided by Clay
> > Weber (071208cvs).
>
> Ah, matching has been changed a bit. Select both transactions (your
> manually entered and the imported) then 'Match' becomes available.
>
> You will have to 'Accept' the match later (you can do it for all
> transactions at once - no need to deselect unmatched transactions either,
> they will be silently skipped from this operation) if you're confident
> with the figures. If something went wrong during matching, you can also
> 'Unmatch' to retrieve the original transactions. This was not possible
> with prior versions.
>
> Also, payee matching now allows to add a list of strings for matching to a
> single payee. One bank sends out 'Thomas Baumgart' and another one
> 'Baumgart, Thomas' for my own records, so I needed that for myself ;)

Hi Thomas

I get monthly bank interest transactions which have added to the payee, the
current date period, consequently I keep having to delete the growing list of
near duplicate payees.  Might there be the possibility of (*) for wild card
treatment of payee string suffixes, please?

Mind you, if this payee matching is part of import v. manual matching, I've
nothing to match the import against - unless, I schedule the interest
payments?  Or am I on the wrong track altogether?

Allan

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[Brendan Coupe]

I just downloaded several transactions for my credit card. All but one
matched as expected.

The one that did not match is:

TMC*TIME WARNER COM

It also added all three identical entries to the "Match on name listed
below" when I deleted three identcal payees int he payees list.
Normally it only adds unique names to the list.

I suspect the "*" in the OFX file is the problem.

By the way, simply dropping the "TMC*" fixed the problem. I found that
"match on payee" only requires a partial match, not the entire name. I
was wondering if that was true for the list of names and now I know it
is.

So I think the answer to Allan's question below is just use the payee
name without the date or any other part of the name that varies.

Brendan

On Tue, Jul 22, 2008 at 4:41 PM, allan <aganderson@...> wrote:

>
>>
>> Message: 2
>> Date: Mon, 21 Jul 2008 07:44:32 +0200
>> From: Thomas Baumgart <thb@...>
>> Subject: Re: [Kmymoney2-user] Transaction Matching
>> To: kmymoney2-user@...
>> Message-ID: <200807210744.32784.thb@...>
>> Content-Type: text/plain; charset="iso-8859-1"
>>
>> On Monday 21 July 2008 06:55:56 Brendan Coupe wrote:
>> > I just compiled the latest CVS and transaction matching no longer
>> > works. "Match" is in the right click menu but it's always grayed
>> > out.
>> >
>> > It works in 0.9 and in the CVS version for Ubuntu provided by Clay
>> > Weber (071208cvs).
>>
>> Ah, matching has been changed a bit. Select both transactions (your
>> manually entered and the imported) then 'Match' becomes available.
>>
>> You will have to 'Accept' the match later (you can do it for all
>> transactions at once - no need to deselect unmatched transactions either,
>> they will be silently skipped from this operation) if you're confident
>> with the figures. If something went wrong during matching, you can also
>> 'Unmatch' to retrieve the original transactions. This was not possible
>> with prior versions.
>>
>> Also, payee matching now allows to add a list of strings for matching to a
>> single payee. One bank sends out 'Thomas Baumgart' and another one
>> 'Baumgart, Thomas' for my own records, so I needed that for myself ;)
>
> Hi Thomas
>
> I get monthly bank interest transactions which have added to the payee, the
> current date period, consequently I keep having to delete the growing list of
> near duplicate payees.  Might there be the possibility of (*) for wild card
> treatment of payee string suffixes, please?
>
> Mind you, if this payee matching is part of import v. manual matching, I've
> nothing to match the import against - unless, I schedule the interest
> payments?  Or am I on the wrong track altogether?
>
> Allan
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> KMyMoney2-user mailing list
> KMyMoney2-user@...
> https://lists.sourceforge.net/lists/listinfo/kmymoney2-user
>

--
Brendan

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[Thomas Baumgart]

On Wednesday 23 July 2008 04:36:53 Brendan Coupe wrote:

> I just downloaded several transactions for my credit card. All but one
> matched as expected.
>
> The one that did not match is:
>
> TMC*TIME WARNER COM
>
> It also added all three identical entries to the "Match on name listed
> below" when I deleted three identcal payees int he payees list.
> Normally it only adds unique names to the list.
>
> I suspect the "*" in the OFX file is the problem.
>
> By the way, simply dropping the "TMC*" fixed the problem. I found that
> "match on payee" only requires a partial match, not the entire name. I
> was wondering if that was true for the list of names and now I know it
> is.

Well, it's more to it than just that. The list is actually a list of regular
expressions. So you can do all kinds of tricks with it. I have no idea if we
will need it or not, but we have it. For the regular wildcard '*' one would
need to use the sequence '.*' in RE (regular expression). That is 'any
character' (the dot) '0 or more times' (the asterisk) at that location.

'.+' would say 'any character' '1 or more times' so there must be at least one
character before it matches.

> So I think the answer to Allan's question below is just use the payee
> name without the date or any other part of the name that varies.

Yes, that is the most simple solution. "TMC*TIME WARNER COM" could be entered
as "TMC\*TIME WARNER COM" to be a string. I have changed KMyMoney to escape
those characters before the string is entered into the list. Of course, this
will have no effect on strings already in the list but will work for new
entries created during deletion of payees.

In case you want to read some more internals about regular expressions that we
support you can find it here: http://doc.trolltech.com/3.3/qregexp.html#1

> Brendan
>
> On Tue, Jul 22, 2008 at 4:41 PM, allan <aganderson@...> wrote:
> >> Message: 2
> >> Date: Mon, 21 Jul 2008 07:44:32 +0200
> >> From: Thomas Baumgart <thb@...>
> >> Subject: Re: [Kmymoney2-user] Transaction Matching
> >> To: kmymoney2-user@...
> >> Message-ID: <200807210744.32784.thb@...>
> >> Content-Type: text/plain; charset="iso-8859-1"
> >>
> >> On Monday 21 July 2008 06:55:56 Brendan Coupe wrote:
> >> > I just compiled the latest CVS and transaction matching no longer
> >> > works. "Match" is in the right click menu but it's always grayed
> >> > out.
> >> >
> >> > It works in 0.9 and in the CVS version for Ubuntu provided by Clay
> >> > Weber (071208cvs).
> >>
> >> Ah, matching has been changed a bit. Select both transactions (your
> >> manually entered and the imported) then 'Match' becomes available.
> >>
> >> You will have to 'Accept' the match later (you can do it for all
> >> transactions at once - no need to deselect unmatched transactions
> >> either, they will be silently skipped from this operation) if you're
> >> confident with the figures. If something went wrong during matching, you
> >> can also 'Unmatch' to retrieve the original transactions. This was not
> >> possible with prior versions.
> >>
> >> Also, payee matching now allows to add a list of strings for matching to
> >> a single payee. One bank sends out 'Thomas Baumgart' and another one
> >> 'Baumgart, Thomas' for my own records, so I needed that for myself ;)
> >
> > Hi Thomas
> >
> > I get monthly bank interest transactions which have added to the payee,
> > the current date period, consequently I keep having to delete the growing
> > list of near duplicate payees.  Might there be the possibility of (*) for
> > wild card treatment of payee string suffixes, please?
> >
> > Mind you, if this payee matching is part of import v. manual matching,
> > I've nothing to match the import against - unless, I schedule the
> > interest payments?  Or am I on the wrong track altogether?
> >
> > Allan
> >
> > -------------------------------------------------------------------------
> > This SF.Net email is sponsored by the Moblin Your Move Developer's
> > challenge Build the coolest Linux based applications with Moblin SDK &
> > win great prizes Grand prize is a trip for two to an Open Source event
> > anywhere in the world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > _______________________________________________
> > KMyMoney2-user mailing list
> > KMyMoney2-user@...
> > https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

--

Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
Computers let you make more mistakes faster than any other
invention in human history, with the possible exception
of handguns and tequila. --Mitch Radcliffe
-------------------------------------------------------------


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[Brendan Coupe]

Knowing that they are simply regular expressions makes sense and helps
me figure out some of the payees that have similar names. I have two
that have a "*" in them which I've already handled. My payee list is
looking better every day and my file is almost 10% smaller.

On Wed, Jul 23, 2008 at 12:23 AM, Thomas Baumgart <thb@...> wrote:

> On Wednesday 23 July 2008 04:36:53 Brendan Coupe wrote:
>> I just downloaded several transactions for my credit card. All but one
>> matched as expected.
>>
>> The one that did not match is:
>>
>> TMC*TIME WARNER COM
>>
>> It also added all three identical entries to the "Match on name listed
>> below" when I deleted three identcal payees int he payees list.
>> Normally it only adds unique names to the list.
>>
>> I suspect the "*" in the OFX file is the problem.
>>
>> By the way, simply dropping the "TMC*" fixed the problem. I found that
>> "match on payee" only requires a partial match, not the entire name. I
>> was wondering if that was true for the list of names and now I know it
>> is.
>
> Well, it's more to it than just that. The list is actually a list of regular
> expressions. So you can do all kinds of tricks with it. I have no idea if we
> will need it or not, but we have it. For the regular wildcard '*' one would
> need to use the sequence '.*' in RE (regular expression). That is 'any
> character' (the dot) '0 or more times' (the asterisk) at that location.
>
> '.+' would say 'any character' '1 or more times' so there must be at least one
> character before it matches.
>
>> So I think the answer to Allan's question below is just use the payee
>> name without the date or any other part of the name that varies.
>
> Yes, that is the most simple solution. "TMC*TIME WARNER COM" could be entered
> as "TMC\*TIME WARNER COM" to be a string. I have changed KMyMoney to escape
> those characters before the string is entered into the list. Of course, this
> will have no effect on strings already in the list but will work for new
> entries created during deletion of payees.
>
> In case you want to read some more internals about regular expressions that we
> support you can find it here: http://doc.trolltech.com/3.3/qregexp.html#1
>
>> Brendan
>>
>> On Tue, Jul 22, 2008 at 4:41 PM, allan <aganderson@...> wrote:
>> >> Message: 2
>> >> Date: Mon, 21 Jul 2008 07:44:32 +0200
>> >> From: Thomas Baumgart <thb@...>
>> >> Subject: Re: [Kmymoney2-user] Transaction Matching
>> >> To: kmymoney2-user@...
>> >> Message-ID: <200807210744.32784.thb@...>
>> >> Content-Type: text/plain; charset="iso-8859-1"
>> >>
>> >> On Monday 21 July 2008 06:55:56 Brendan Coupe wrote:
>> >> > I just compiled the latest CVS and transaction matching no longer
>> >> > works. "Match" is in the right click menu but it's always grayed
>> >> > out.
>> >> >
>> >> > It works in 0.9 and in the CVS version for Ubuntu provided by Clay
>> >> > Weber (071208cvs).
>> >>
>> >> Ah, matching has been changed a bit. Select both transactions (your
>> >> manually entered and the imported) then 'Match' becomes available.
>> >>
>> >> You will have to 'Accept' the match later (you can do it for all
>> >> transactions at once - no need to deselect unmatched transactions
>> >> either, they will be silently skipped from this operation) if you're
>> >> confident with the figures. If something went wrong during matching, you
>> >> can also 'Unmatch' to retrieve the original transactions. This was not
>> >> possible with prior versions.
>> >>
>> >> Also, payee matching now allows to add a list of strings for matching to
>> >> a single payee. One bank sends out 'Thomas Baumgart' and another one
>> >> 'Baumgart, Thomas' for my own records, so I needed that for myself ;)
>> >
>> > Hi Thomas
>> >
>> > I get monthly bank interest transactions which have added to the payee,
>> > the current date period, consequently I keep having to delete the growing
>> > list of near duplicate payees.  Might there be the possibility of (*) for
>> > wild card treatment of payee string suffixes, please?
>> >
>> > Mind you, if this payee matching is part of import v. manual matching,
>> > I've nothing to match the import against - unless, I schedule the
>> > interest payments?  Or am I on the wrong track altogether?
>> >
>> > Allan
>> >
>> > -------------------------------------------------------------------------
>> > This SF.Net email is sponsored by the Moblin Your Move Developer's
>> > challenge Build the coolest Linux based applications with Moblin SDK &
>> > win great prizes Grand prize is a trip for two to an Open Source event
>> > anywhere in the world
>> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> > _______________________________________________
>> > KMyMoney2-user mailing list
>> > KMyMoney2-user@...
>> > https://lists.sourceforge.net/lists/listinfo/kmymoney2-user
>
> --
>
> Regards
>
> Thomas Baumgart
>
> GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
> -------------------------------------------------------------
> Computers let you make more mistakes faster than any other
> invention in human history, with the possible exception
> of handguns and tequila. --Mitch Radcliffe
> -------------------------------------------------------------
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> KMyMoney2-user mailing list
> KMyMoney2-user@...
> https://lists.sourceforge.net/lists/listinfo/kmymoney2-user
>
>

--
Brendan

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

[Brendan Coupe]

I grabbed the latest source for testing and here's what I found:

1) "*" is now escaped as expected when I delete a Payee and add the
deleted name to the matching list.

2) I turned off matching for TMC*TIME WARNER COM  for my test and I
got 3 or 4 identical entries with the name as shown in the payees list
even though I only had one missing transaction in my ledger. I suspect
the OFX file has 3 or 4 months worth of data which would have my last
3 or 4 monthly payments to TMC*TIME WARNER COM possibly explaining the
duplication. All but one have no transactions. This happens regardless
of the payee name.

3) When I delete all of the transactions for TMC*TIME WARNER COM I get
3 or 4 identical names in the matching list. This appears to only
happen when there is a "*" in the name (maybe other special
characters) but I have not tested enough to be sure. It did not happen
with my other test payee that had a "#" in the name.

4) While payee matching works regardless of which account the previous
transactions are in, the categories do not get matched if the previous
transactions were in a different account. It would be nice to be able
to enable category matching across accounts, maybe on an account by
account basis. This is not a big issue for me since I mostly use one
account.

2 & 3 are basically non issues once I get payee matching completely
setup since that will eliminate the duplicate payees.



On Wed, Jul 23, 2008 at 1:37 PM, Brendan Coupe <brendan@...> wrote:

> Knowing that they are simply regular expressions makes sense and helps
> me figure out some of the payees that have similar names. I have two
> that have a "*" in them which I've already handled. My payee list is
> looking better every day and my file is almost 10% smaller.
>
> On Wed, Jul 23, 2008 at 12:23 AM, Thomas Baumgart <thb@...> wrote:
>> On Wednesday 23 July 2008 04:36:53 Brendan Coupe wrote:
>>> I just downloaded several transactions for my credit card. All but one
>>> matched as expected.
>>>
>>> The one that did not match is:
>>>
>>> TMC*TIME WARNER COM
>>>
>>> It also added all three identical entries to the "Match on name listed
>>> below" when I deleted three identical payees int he payees list.
>>> Normally it only adds unique names to the list.
>>>
>>> I suspect the "*" in the OFX file is the problem.
>>>
>>> By the way, simply dropping the "TMC*" fixed the problem. I found that
>>> "match on payee" only requires a partial match, not the entire name. I
>>> was wondering if that was true for the list of names and now I know it
>>> is.
>>
>> Well, it's more to it than just that. The list is actually a list of regular
>> expressions. So you can do all kinds of tricks with it. I have no idea if we
>> will need it or not, but we have it. For the regular wildcard '*' one would
>> need to use the sequence '.*' in RE (regular expression). That is 'any
>> character' (the dot) '0 or more times' (the asterisk) at that location.
>>
>> '.+' would say 'any character' '1 or more times' so there must be at least one
>> character before it matches.
>>
>>> So I think the answer to Allan's question below is just use the payee
>>> name without the date or any other part of the name that varies.
>>
>> Yes, that is the most simple solution. "TMC*TIME WARNER COM" could be entered
>> as "TMC\*TIME WARNER COM" to be a string. I have changed KMyMoney to escape
>> those characters before the string is entered into the list. Of course, this
>> will have no effect on strings already in the list but will work for new
>> entries created during deletion of payees.
>>
>> In case you want to read some more internals about regular expressions that we
>> support you can find it here: http://doc.trolltech.com/3.3/qregexp.html#1
>>
>>> Brendan
>>>
>>> On Tue, Jul 22, 2008 at 4:41 PM, allan <aganderson@...> wrote:
>>> >> Message: 2
>>> >> Date: Mon, 21 Jul 2008 07:44:32 +0200
>>> >> From: Thomas Baumgart <thb@...>
>>> >> Subject: Re: [Kmymoney2-user] Transaction Matching
>>> >> To: kmymoney2-user@...
>>> >> Message-ID: <200807210744.32784.thb@...>
>>> >> Content-Type: text/plain; charset="iso-8859-1"
>>> >>
>>> >> On Monday 21 July 2008 06:55:56 Brendan Coupe wrote:
>>> >> > I just compiled the latest CVS and transaction matching no longer
>>> >> > works. "Match" is in the right click menu but it's always grayed
>>> >> > out.
>>> >> >
>>> >> > It works in 0.9 and in the CVS version for Ubuntu provided by Clay
>>> >> > Weber (071208cvs).
>>> >>
>>> >> Ah, matching has been changed a bit. Select both transactions (your
>>> >> manually entered and the imported) then 'Match' becomes available.
>>> >>
>>> >> You will have to 'Accept' the match later (you can do it for all
>>> >> transactions at once - no need to deselect unmatched transactions
>>> >> either, they will be silently skipped from this operation) if you're
>>> >> confident with the figures. If something went wrong during matching, you
>>> >> can also 'Unmatch' to retrieve the original transactions. This was not
>>> >> possible with prior versions.
>>> >>
>>> >> Also, payee matching now allows to add a list of strings for matching to
>>> >> a single payee. One bank sends out 'Thomas Baumgart' and another one
>>> >> 'Baumgart, Thomas' for my own records, so I needed that for myself ;)
>>> >
>>> > Hi Thomas
>>> >
>>> > I get monthly bank interest transactions which have added to the payee,
>>> > the current date period, consequently I keep having to delete the growing
>>> > list of near duplicate payees.  Might there be the possibility of (*) for
>>> > wild card treatment of payee string suffixes, please?
>>> >
>>> > Mind you, if this payee matching is part of import v. manual matching,
>>> > I've nothing to match the import against - unless, I schedule the
>>> > interest payments?  Or am I on the wrong track altogether?
>>> >
>>> > Allan
>>> >
>>> > -------------------------------------------------------------------------
>>> > This SF.Net email is sponsored by the Moblin Your Move Developer's
>>> > challenge Build the coolest Linux based applications with Moblin SDK &
>>> > win great prizes Grand prize is a trip for two to an Open Source event
>>> > anywhere in the world
>>> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
>>> > _______________________________________________
>>> > KMyMoney2-user mailing list
>>> > KMyMoney2-user@...
>>> > https://lists.sourceforge.net/lists/listinfo/kmymoney2-user
>>
>> --
>>
>> Regards
>>
>> Thomas Baumgart
>>
>> GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
>> -------------------------------------------------------------
>> Computers let you make more mistakes faster than any other
>> invention in human history, with the possible exception
>> of handguns and tequila. --Mitch Radcliffe
>> -------------------------------------------------------------
>>
>> -------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
>> Build the coolest Linux based applications with Moblin SDK & win great prizes
>> Grand prize is a trip for two to an Open Source event anywhere in the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> KMyMoney2-user mailing list
>> KMyMoney2-user@...
>> https://lists.sourceforge.net/lists/listinfo/kmymoney2-user
>>
>>
>
>
>
> --
> Brendan
>

--
Brendan

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
KMyMoney2-user mailing list
KMyMoney2-user@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-user