[Vtigercrm-developers] Convert a field to uitype 15

[Asha]

Hi Stephen,

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

On 2/23/09, Stephen Mack <stephen at efronteras.com> wrote:
>
> Thanks for the response... could you give some insight into the database
> fields?
>
> roleid picklistvalueid picklistid sortid
>
> I think I understand everything except the picklistid field.  Is there some
> documentation on that value?
>
> -- Stephen Mack
> Gerente de Ventas y Marketing
> Escuela Fronteras
> www.eFronteras.com
> skype: eFronteras.Stephen
>
>
> On Mon, Feb 23, 2009 at 1:35 PM, Asha <asha at vtiger.com> wrote:
> >
> > Hi Stephen,
> >
> > 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.
> >
> > On 2/23/09, Stephen Mack <stephen at efronteras.com> wrote:
> >>
> >> Thank you so much Asha,
> >>
> >> 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.
> >>
> >> I did the following:
> >> 1) I updated the value stored in vtiger_picklistvalues_seq
> >>     "356"
> >> 2) I added the following record to vtiger_category
> >>     "1";"myvalue";"1";"356"
> >> 3) I added the following record to vtiger_category_seq
> >>     "1"
> >>
> >> The field does not show up in the picklist editor yet.  Is that related
> to the vtiger_role2picklist" database?
> >>
> >> -- Stephen Mack
> >> Gerente de Ventas y Marketing
> >> Escuela Fronteras
> >> www.eFronteras.com
> >> skype: eFronteras.Stephen
> >>
> >>
> >> On Sat, Feb 21, 2009 at 2: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
> >
> >
> >
> > --
> > Regards,
> > Asha
> > vtiger Team
> > _______________________________________________
> > Reach hundreds of potential candidates - http://jobs.vtiger.com
>
>
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com
>



-- 
Regards,
Asha
vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20090223/f702da4c/attachment-0003.html