[Vtigercrm-developers] Convert a field to uitype 15

Asha asha at vtiger.com
Mon Feb 23 08:35:49 PST 2009


Hi Stephen,

Yes, it won't be shown in Picklist editor, because values in picklist editor
are picked up based on the selected role. Since you do not have entries in
vtiger_role2picklist, it may not be showing up in the Picklist editor.

On 2/23/09, Stephen Mack <stephen at efronteras.com> wrote:
>
> Thank you so much Asha,
>
> I'm one step closer but I still am not all the why there.  I think I need
> to add entries to "vtiger_role2picklist" and I would like some insight into
> the fields.
>
> I did the following:
> 1) I updated the value stored in vtiger_picklistvalues_seq
>     "356"
> 2) I added the following record to vtiger_category
>     "1";"myvalue";"1";"356"
> 3) I added the following record to vtiger_category_seq
>     "1"
>
> The field does not show up in the picklist editor yet.  Is that related to
> the vtiger_role2picklist" database?
>
> -- Stephen Mack
> Gerente de Ventas y Marketing
> Escuela Fronteras
> www.eFronteras.com
> skype: eFronteras.Stephen
>
>
> On Sat, Feb 21, 2009 at 2:50 AM, Asha <asha at vtiger.com> wrote:
>
>> 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
>> _______________________________________________
>> Reach hundreds of potential candidates - http://jobs.vtiger.com
>>
>
>
> _______________________________________________
> 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/20090223/a7bcc6c4/attachment-0003.html 


More information about the vtigercrm-developers mailing list