[Vtigercrm-developers] organization ident

[Jens Hamisch]

Hi,


or opportunity 

c)  handle organization and orgunit as yet another CRMEntities


would be the best fit into the internal vtiger design for my
point of view.

The effort would be even more than just introducing an orgid
(code-changes and cleanups), but from the maintainability point
of view it would be a clear and straight forward solution.


Jens



On Wed, May 09, 2007 at 04:23:28PM +0200, Enrico Weigelt wrote:
> 
> Hi folks,
> 
> 
> I've found an big-fat problem with the organization modeling in 
> the DB:
> 
> The org is always referenced by its name !
> To be clear: its the *printable* name, which appears for example
> on the bill.
> 
> So now it's clear, why it cannot be changed in the settings ;-O
> 
> It appears the name is also abused as ident, which is the key
> problem. There's no additional ID here.
> 
> To fix this, we have two options: 
> 
> a) Add an numerical ID to the organization table and fix all the
>    schema to reference on that. This would probably be the most
>    clean model, but requires much care on schema updates.
>    
> b) Add an new text field (ie. "official_name") which now carries
>    the actual *name* (ie. for printing on the invoice) and leave
>    evrything else untouched. Nearly trivial to implement, but maybe
>    not very clean design.
> 
> 
> 
> Comments ?
> 
> cu
> -- 
> ---------------------------------------------------------------------
>  Enrico Weigelt    ==   metux IT service
> 
>   phone:     +49 36207 519931         www:       http://www.metux.de/
>   fax:       +49 36207 519932         email:     contact at metux.de
>   cellphone: +49 174 7066481
> ---------------------------------------------------------------------
>  -- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops --
> ---------------------------------------------------------------------
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com 

-- 

--------------------------------------------------------------------------------

         s t r a w b e r r y      e d v - s y s t e m e      g m b h

     SSSSSSSSS       Am Flosskanal 7            Jens Hamisch
   SSSSSSSSSSSSS     D-82515 Wolfratshausen     Geschaeftsfuehrer/CEO
  SSSSS-----SSSSS                               
 ---SSSSS---------   fon (+49 8171) 41805-0     
 -----SSSSSSS-----   fax (+49 8171) 41805-59    
 ---------SSSSS---   info at strawberry.com        jens.hamisch at strawberry.com
  SSSSS-----SSSSS                               mobil: (+49 172) 8104162
   SSSSSSSSSSSSS     Geschaeftsfuehrer/CEO      
     SSSSSSSSS       Jens Hamisch               
  
   a g   m u e n c h e n   H R B   9 3 2 8 7  -  D E   1 2 9  4 6 7  5 1 8