Hi Stephen,<br><br>picklistid here refers to the id of this picklist (category) in vtiger_picklist table. This is the unique id by which a picklist is identified. Please refer to vtiger_picklist table for clarification<br>
<br><div><span class="gmail_quote">On 2/23/09, <b class="gmail_sendername">Stephen Mack</b> <<a href="mailto:stephen@efronteras.com">stephen@efronteras.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Thanks for the response... could you give some insight into the database fields?<br><br>roleid picklistvalueid picklistid sortid<br><br>I think I understand everything except the picklistid field. Is there some documentation on that value?<span class="q"><br>
<br>-- Stephen Mack<br>Gerente de Ventas y Marketing<br>Escuela Fronteras<br><a href="http://www.eFronteras.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.eFronteras.com</a><br>skype: eFronteras.Stephen<br>
<br><br></span><div><span class="e" id="q_11fa43880136336e_2">On Mon, Feb 23, 2009 at 1:35 PM, Asha <<a href="mailto:asha@vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">asha@vtiger.com</a>> wrote:<br>
><br>> Hi Stephen,<br>><br>> 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.<br>
><br>> On 2/23/09, Stephen Mack <<a href="mailto:stephen@efronteras.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">stephen@efronteras.com</a>> wrote:<br>>><br>>> Thank you so much Asha,<br>
>><br>>> 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.<br>
>><br>>> I did the following:<br>>> 1) I updated the value stored in vtiger_picklistvalues_seq<br>>> "356"<br>>> 2) I added the following record to vtiger_category<br>>> "1";"myvalue";"1";"356"<br>
>> 3) I added the following record to vtiger_category_seq<br>>> "1"<br>>><br>>> The field does not show up in the picklist editor yet. Is that related to the vtiger_role2picklist" database?<br>
>><br>>> -- Stephen Mack<br>>> Gerente de Ventas y Marketing<br>>> Escuela Fronteras<br>>> <a href="http://www.eFronteras.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.eFronteras.com</a><br>
>> skype: eFronteras.Stephen<br>
>><br>>><br>>> On Sat, Feb 21, 2009 at 2:50 AM, Asha <<a href="mailto:asha@vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">asha@vtiger.com</a>> wrote:<br>>>><br>
>>> Hi Stephen,<br>>>><br>>>> If I understood properly, you are trying to convert the picklist to a role based picklist.<br>
>>><br>>>> If that is the case, you are missing one important part.<br>>>><br>>>> 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.<br>
>>><br>>>> Let me explain the schema of the table vtiger_category that you created:-<br>>>><br>>>> categoryid -> unique id for each category value<br>>>> category -> The actual category value<br>
>>> presence -> whether the value is a editable or non-editable value (0 - non-editable, 1- editable)<br>>>> picklist_valueid -> It is the unique id for this picklist value across all the picklist values throughout all the existing picklist tables.<br>
>>><br>>>> Feel free to get back to me for any further clarification.<br>>>><br>>>> On 2/21/09, Stephen Mack <<a href="mailto:stephen@efronteras.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">stephen@efronteras.com</a>> wrote:<br>
>>>><br>>>>> I'm trying to convert field vtiger_vendor | category to a picklist field (uitype 15)<br>>>>><br>>>>> Here is how far I got.<br>>>>><br>>>>> 1. I edited vtiger_fields changing the field from uitype 1 -> uitype 15<br>
>>>> 2. I created the table vtiger_category using the following SQL<br>>>>><br>>>>> CREATE TABLE `vtiger_category` (<br>>>>> `categoryid` int(19) NOT NULL auto_increment,<br>
>>>> `category` varchar(200) collate latin1_german2_ci NOT NULL,<br>>>>> `presence` int(1) NOT NULL default '1',<br>>>>> `picklist_valueid` int(19) NOT NULL default '0',<br>
>>>> PRIMARY KEY (`categoryid`),<br>>>>> UNIQUE KEY `category_category_idx` (`category`)<br>>>>> ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=18 ;<br>
>>>><br>>>>> 3. I created the table vtiger_category_seq using the following SQL<br>>>>><br>>>>> CREATE TABLE `vtiger_category_seq` (<br>>>>> `id` int(11) NOT NULL<br>
>>>> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;<br>>>>><br>>>>> 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?<br>
>>>><br>>>>> Thanks in advance.<br>>>>><br>>>>> -- Stephen Mack<br>>>>> Gerente de Ventas y Marketing<br>>>>> Escuela Fronteras<br>>>>> <a href="http://www.eFronteras.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.eFronteras.com</a><br>
>>>> skype: eFronteras.Stephen<br>>>>><br>>>>> _______________________________________________<br>>>>> Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a><br>
>>><br>>>><br>>>><br>>>> --<br>>>> Regards,<br>>>> Asha<br>>>> vtiger Team<br>>>> _______________________________________________<br>>>> Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a><br>
>><br>>><br>>> _______________________________________________<br>>> Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a><br>
><br>><br>><br>
> --<br>> Regards,<br>> Asha<br>> vtiger Team<br>> _______________________________________________<br>> Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a><br>
<br>
</span></div><br>_______________________________________________<br>
Reach hundreds of potential candidates - <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a> <br></blockquote></div><br><br clear="all"><br>-- <br>
Regards,<br>Asha<br>vtiger Team