[Vtigercrm-developers] Creating custom uitype 10 field in the Calendar Module.

[ardi zeneli]

Hi Matteo,

i tried executing the script and it worked, the uitype 10 field was created
in the Events but i still wasn't able to save records because the following
error appeared: {"success":false,"error":{"code":"Record you are trying to
access is not found","message":"Record you are trying to access is not
found"}}
I then tried to execute the query you sent me but an error appeared as
well: #1054 - Unknown column 'other_acc3' in 'where clause', even after i
manually added this field to the vtiger_field table.

Is there anything else i am missing?

Thanks

On Tue, Jul 21, 2015 at 1:30 PM, Matteo Baranzoni <info at greenbitweb.com>
wrote:

> this vtlibs script:
>
> // Turn on debugging level
>> $Vtiger_Utils_Log = true;
>> require_once('vtlib/Vtiger/Module.php');
>> require_once('vtlib/Vtiger/Block.php');
>> require_once('vtlib/Vtiger/Field.php');
>> $module = Vtiger_Module::getInstance('Events');
>> $block = Vtiger_Block::getInstance('LBL_RELATED_TO',$module);
>> $field = new Vtiger_Field();
>> $field->label = 'other accounts';
>> $field->name = 'other_acc3';
>> $field->column = 'other_acc3';
>> $field->columntype = 'VARCHAR(255)';
>> $field->uitype = 10;
>> $field->typeofdata = 'V~O';
>> $block->addField($field);
>> $block->save($module);
>> $field->setRelatedModules(Array('Accounts'));
>
>
> save on vtiger field bad tablename ( '0' value).
> you can fix with something like:
>
> UPDATE `vtiger_field` SET `tablename` = 'vtiger_activity' WHERE
> `vtiger_field`.`columnname` = other_acc3;
> ALTER TABLE `vtiger_activity` ADD `other_acc3` VARCHAR(255) NOT NULL;
>
>
> 2015-07-21 12:20 GMT+02:00 Simone Travaglini <simonetravaglini at gmail.com>:
>
>> or also to campaign and lead! suppose you are doing a campaign and want
>> track event and opportunity generated with relation to lead!
>>
>> 2015-07-21 9:55 GMT+02:00 Vincent Piton <vincent.piton at free.fr>:
>>
>>> +1
>>>
>>> It would be great to relate an event to a campaign and an account
>>>
>>>
>>>
>>> *De :* vtigercrm-developers-bounces at lists.vtigercrm.com [mailto:
>>> vtigercrm-developers-bounces at lists.vtigercrm.com] *De la part de*
>>> Simone Travaglini
>>> *Envoyé :* mardi 21 juillet 2015 09:50
>>> *À :* vtigercrm-developers at lists.vtigercrm.com
>>> *Objet :* Re: [Vtigercrm-developers] Creating custom uitype 10 field in
>>> the Calendar Module.
>>>
>>>
>>>
>>> Could be usefull, sometimes we need to do the same. +1
>>>
>>>
>>>
>>> 2015-07-20 12:53 GMT+02:00 ardi zeneli <zeneliiardi at gmail.com>:
>>>
>>> Hi Manu,
>>>
>>>
>>>
>>> I wanted this new custom uitype 10 field related to Organisations for
>>> the cases where the field in the "Related To" block is alredy related with
>>> another Opportunity or Campaign and i want to relate this Event with an
>>> Organization, which would not be possible since the field is alredy
>>> compiled.
>>>
>>>
>>>
>>> Thanks
>>>
>>>
>>>
>>> On Mon, Jul 20, 2015 at 12:35 PM, Manu urs <manu.k at vtiger.com> wrote:
>>>
>>> Hi
>>>
>>> You can relate a "Event" with  "Organizations" through the "Related
>>> to"  block  in  Event creation . Let us know your purpose of creating a new
>>> custom uitype 10 field ?
>>>
>>> Regrards,
>>>
>>> Manu Urs
>>>
>>>
>>>
>>> On Mon, Jul 20, 2015 at 2:40 PM, ardi zeneli <zeneliiardi at gmail.com>
>>> wrote:
>>>
>>> Hello,
>>>
>>>
>>>
>>> can anybody give me a hint on how to add a uitype 10 field on the
>>> Calendar module, especially in the Events. Everytime i try to add it by
>>> code to the root or by other extensions the uitype 10 field is added to the
>>> "To Do-s". I would like for this custom field to be related with the
>>> organizations module.
>>>
>>>
>>>
>>> Thanks
>>>
>>>
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Regards,
>>>
>>> Manu
>>>
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Simone Travaglini
>>> 328 5499846
>>> Linkedin: Simone Travaglini
>>>
>>>
>>> Rispetta l'ambiente: non stampare questa mail se non ti è veramente
>>> necessario!
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>
>>
>>
>> --
>> Simone Travaglini
>> 328 5499846
>> Linkedin: Simone Travaglini
>>
>>
>> Rispetta l'ambiente: non stampare questa mail se non ti è veramente
>> necessario!
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150721/1cc395cd/attachment-0001.html>