[Vtigercrm-developers] Convert a field to uitype 15

Asha asha at vtiger.com
Fri Feb 20 21:50:15 PST 2009


Hi Stephen,

If I understood properly, you are trying to convert the picklist to a role
based picklist.

If that is the case, you are missing one important part.

You will have to add the entries for the values of the picklist for each
role to vtiger_role2picklist which will make the value available for each of
the existing roles.

Let me explain the schema of the table vtiger_category that you created:-

categoryid -> unique id for each category value
category -> The actual category value
presence -> whether the value is a editable or non-editable value (0 -
non-editable, 1- editable)
picklist_valueid -> It is the unique id for this picklist value across all
the picklist values throughout all the existing picklist tables.

Feel free to get back to me for any further clarification.

On 2/21/09, Stephen Mack <stephen at efronteras.com> wrote:
>
> I'm trying to convert field vtiger_vendor | category to a picklist field
> (uitype 15)
>
> Here is how far I got.
>
> 1. I edited vtiger_fields changing the field from uitype 1 -> uitype 15
> 2. I created the table *vtiger_category* using the following SQL
>
> CREATE TABLE `vtiger_category` (
>   `categoryid` int(19) NOT NULL auto_increment,
>   `category` varchar(200) collate latin1_german2_ci NOT NULL,
>   `presence` int(1) NOT NULL default '1',
>   `picklist_valueid` int(19) NOT NULL default '0',
>   PRIMARY KEY  (`categoryid`),
>   UNIQUE KEY `category_category_idx` (`category`)
> ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1
> COLLATE=latin1_german2_ci AUTO_INCREMENT=18 ;
>
> 3. I created the table *vtiger_category_seq* using the following SQL
>
> CREATE TABLE `vtiger_category_seq` (
>   `id` int(11) NOT NULL
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;
>
> The changes seem to be working correctly except I can't use the picklist
> editor to add the entries and I'm don't understand the schema fully to add
> them manually.  What is the step I'm missing to finish the conversion?
>
> Thanks in advance.
>
> -- Stephen Mack
> Gerente de Ventas y Marketing
> Escuela Fronteras
> www.eFronteras.com
> skype: eFronteras.Stephen
>
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com
>



-- 
Regards,
Asha
vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20090221/dd49b278/attachment-0003.html 


More information about the vtigercrm-developers mailing list