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><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;">
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?<span class="q"><br><br clear="all">-- 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 class="gmail_quote"><span class="q">On Sat, Feb 21, 2009 at 2:50 AM, Asha <span dir="ltr"><<a href="mailto:asha@vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">asha@vtiger.com</a>></span> wrote:<br>
</span><div><span class="e" id="q_11fa3c1b847e864d_4"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
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><div>
<div><div></div><div>
<span class="gmail_quote">On 2/21/09, <b class="gmail_sendername">Stephen Mack</b> <<a href="mailto:stephen@efronteras.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">stephen@efronteras.com</a>> wrote:</span></div>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div>
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 <b>vtiger_category</b> 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 <b>vtiger_category_seq</b> 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><span><br clear="all">-- 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>
</span><br></div></div>_______________________________________________<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></blockquote></div><font color="#888888"><br>
<br clear="all"><br>-- <br>
Regards,<br>Asha<br>vtiger Team
</font><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></blockquote></span></div></div><br>
<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