[Vtigercrm-developers] Convert a field to uitype 15
prasad at vtiger.com
Sat Feb 21 07:44:59 PST 2009
Picklist value is supported with language translation.
You can provide a picklist value LBL_PICKLIST_VALUE_TESTING.
Then a translation in module language file
$mod_strings = Array (
'LBL_PICKLIST_VALUE_TESTING' => 'Picklist Value Testing',
You should see the translated value in the picklist :)
On 2/21/09, David V. <davidv.net at gmail.com> wrote:
> Hi All,
> By the way, is there any easy way to translate picklists in Vtiger ?
> David V.
> On Sat, Feb 21, 2009 at 1: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
>>> skype: eFronteras.Stephen
>>> Reach hundreds of potential candidates - http://jobs.vtiger.com
>> vtiger Team
>> Reach hundreds of potential candidates - http://jobs.vtiger.com
> Reach hundreds of potential candidates - http://jobs.vtiger.com
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the vtigercrm-developers