[Vtigercrm-developers] Convert a field to uitype 15

[Stephen Mack]

Thanks for the response... could you give some insight into the database
fields?

roleid picklistvalueid picklistid sortid

I think I understand everything except the picklistid field.  Is there some
documentation on that value?

-- Stephen Mack
Gerente de Ventas y Marketing
Escuela Fronteras
www.eFronteras.com
skype: eFronteras.Stephen


On Mon, Feb 23, 2009 at 1:35 PM, Asha <asha at vtiger.com> wrote:
>
> 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
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20090223/a62e6a01/attachment-0003.html