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

[Thomas Baumgart]

Hi,

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="" />
  </PAYEE>

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.

-- 

Regards

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>