[Kmymoney-devel] Bug Maybe? Payee address is saved completely in one column

Thomas Baumgart thb at net-bembel.de
Sun Aug 21 09:18:22 UTC 2011


on Sunday 21 August 2011 07:28:18 Eric A. Bonney wrote:

> I am working with KMM ver 4.5.96 and I noticed something tonight while
> working on my Android "port". It appears that the entire address is
> saved in the column addressStreet. It does not appear that the columns
> addressCity, addressZipcode, addressState are used at all.
> The payee address tab has a large text box to enter the address in, but
> this is not parsed out to the various columns. I have also attempted to
> update those columns myself and then looked at the payee in KMM when I
> do, the City and State are not brought into the payee screen.
> I am not sure if this is a bug or if this working as intended. I planned
> on putting the actual address components into the specific columns
> listed in the database. Is this the correct approach or are those
> columns going to disappear and have only one column for the entire address?

This is more of a question towards the DB backend implementors but I try to 
give some hints nevertheless. The frontend keeps them as seperate attributes 
(found in mymoneypayee.h)

  // Simple get operations
  QString name(void) const
  QString address(void) const
  QString city(void) const
  QString state(void) const
  QString postcode(void) const

as well does the XML backend

  <PAYEE email="" matchingenabled="0" reference="" id="P000003" 
name="Stadtgrund" >
   <ADDRESS street="" postcode="" city="" state="" telephone="" />

and also the SQL backend stores them in different columns from what I see (I 
am not a DB expert) in MyMoneyStorageSql::writePayee().

So now I am confused. All what I see does not match what you report. At least 
it's my impression. Maybe someone with more knowledge at this point can shed 
some light on Eric's findings.



Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
New processes are created by other processes, just like new humans.
New humans are created by other humans, of course, not by processes.
(Unix System Administrator Handbook)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 225 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20110821/972d0327/attachment.sig>

More information about the KMyMoney-devel mailing list