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>
<span class="gmail_quote">On 2/21/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;">
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 class="sg"><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>_______________________________________________<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