[Vtigercrm-developers] Convert a field to uitype 15

[Prasad]

Hi David,

Picklist value is supported with language translation.

You can provide a picklist value LBL_PICKLIST_VALUE_TESTING.
Then a translation in module language file
(modules/MODULENAME/language/en_us.lang.php

$mod_strings = Array (
'LBL_PICKLIST_VALUE_TESTING' => 'Picklist Value Testing',
//...
);

You should see the translated value in the picklist :)

Regards,
Prasad
vtiger Team

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
>>> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20090221/3b6b8cd1/attachment-0003.html