[Vtigercrm-developers] organization ident

Joe Bordes joe at tsolucio.com
Wed May 9 08:26:50 PDT 2007


Very good idea!!

Joe
TSolucio

Jens Hamisch escribió:
> 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 
>>     
>
>   




More information about the vtigercrm-developers mailing list