<div dir="ltr">Hi,<div><br></div><div>Thanks to Matteo's advices i was able to add the new uitype 10 field in the events and to get it to work. The record can be saved and it appears in the Calendar. But there is still another problem. When i go to the related Organization of this event, in the related activities of this Organization, the event created by me doesn't appear. Any reason why this happens, or how to solve this problem. </div><div><br></div><div>Thanks,</div><div>Ardi</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jul 21, 2015 at 3:39 PM, ardi zeneli <span dir="ltr"><<a href="mailto:zeneliiardi@gmail.com" target="_blank">zeneliiardi@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Matteo,<div><br></div><div>i executed the query you send me and "other_acc3" was added as a column in the vtiger_activity table. But when i tried to execute the other query it gave me the same error as before: <span style="font-size:12.8000001907349px"> #1054 - Unknown column 'other_acc3' in 'where clause'.</span></div><div><span style="font-size:12.8000001907349px">Anything else i might do to make this work?</span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">Thanks</span></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jul 21, 2015 at 3:03 PM, Matteo Baranzoni <span dir="ltr"><<a href="mailto:info@greenbitweb.com" target="_blank">info@greenbitweb.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">you need to update <span style="font-size:12.8000001907349px">vtiger_activity table: </span><span style="font-size:12.8000001907349px">ALTER TABLE `vtiger_activity` ADD `other_acc3` VARCHAR(255) NOT NULL; </span><div style="font-size:12.8000001907349px"><br></div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2015-07-21 14:51 GMT+02:00 ardi zeneli <span dir="ltr"><<a href="mailto:zeneliiardi@gmail.com" target="_blank">zeneliiardi@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Matteo,<div><br></div><div>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"}}</div><div>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. </div><div><br></div><div>Is there anything else i am missing?</div><div><br></div><div>Thanks</div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jul 21, 2015 at 1:30 PM, Matteo Baranzoni <span dir="ltr"><<a href="mailto:info@greenbitweb.com" target="_blank">info@greenbitweb.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">this vtlibs script:<div><br></div><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">// Turn on debugging level<br>$Vtiger_Utils_Log = true;<br>require_once('vtlib/Vtiger/Module.php');<br>require_once('vtlib/Vtiger/Block.php');<br>require_once('vtlib/Vtiger/Field.php');<br>$module = Vtiger_Module::getInstance('Events');<br>$block = Vtiger_Block::getInstance('LBL_RELATED_TO',$module);<br>$field = new Vtiger_Field();<br>$field->label = 'other accounts';<br>$field->name = 'other_acc3';<br>$field->column = 'other_acc3';<br>$field->columntype = 'VARCHAR(255)';<br>$field->uitype = 10;<br>$field->typeofdata = 'V~O';<br>$block->addField($field);<br>$block->save($module);<br>$field->setRelatedModules(Array('Accounts')); </blockquote><div><br></div></blockquote>save on vtiger field bad tablename ( '0' value).<div>you can fix with something like: </div><div><br></div><div>UPDATE `vtiger_field` SET `tablename` = 'vtiger_activity' WHERE `vtiger_field`.`columnname` = other_acc3; <br></div><div>ALTER TABLE `vtiger_activity` ADD `other_acc3` VARCHAR(255) NOT NULL; <br></div><div><br></div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2015-07-21 12:20 GMT+02:00 Simone Travaglini <span dir="ltr"><<a href="mailto:simonetravaglini@gmail.com" target="_blank">simonetravaglini@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">or also to campaign and lead! suppose you are doing a campaign and want track event and opportunity generated with relation to lead!</div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2015-07-21 9:55 GMT+02:00 Vincent Piton <span dir="ltr"><<a href="mailto:vincent.piton@free.fr" target="_blank">vincent.piton@free.fr</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="FR" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#333132">+1<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#333132">It would be great to relate an event to a campaign and an account<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#333132"><u></u> <u></u></span></p><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">De :</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com" target="_blank">vtigercrm-developers-bounces@lists.vtigercrm.com</a> [mailto:<a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com" target="_blank">vtigercrm-developers-bounces@lists.vtigercrm.com</a>] <b>De la part de</b> Simone Travaglini<br><b>Envoyé :</b> mardi 21 juillet 2015 09:50<br><b>À :</b> <a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a><br><b>Objet :</b> Re: [Vtigercrm-developers] Creating custom uitype 10 field in the Calendar Module.<u></u><u></u></span></p><div><div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">Could be usefull, sometimes we need to do the same. +1<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">2015-07-20 12:53 GMT+02:00 ardi zeneli <<a href="mailto:zeneliiardi@gmail.com" target="_blank">zeneliiardi@gmail.com</a>>:<u></u><u></u></p><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm"><div><p class="MsoNormal">Hi Manu,<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">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.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Thanks<u></u><u></u></p></div></div><div><div><div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">On Mon, Jul 20, 2015 at 12:35 PM, Manu urs <<a href="mailto:manu.k@vtiger.com" target="_blank">manu.k@vtiger.com</a>> wrote:<u></u><u></u></p><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm"><div><div><div><p class="MsoNormal" style="margin-bottom:12.0pt">Hi <br><br>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 ?<u></u><u></u></p></div><div><p class="MsoNormal">Regrards,<u></u><u></u></p></div><div><p class="MsoNormal">Manu Urs<u></u><u></u></p></div></div></div><div><p class="MsoNormal"><u></u> <u></u></p><div><div><div><p class="MsoNormal">On Mon, Jul 20, 2015 at 2:40 PM, ardi zeneli <<a href="mailto:zeneliiardi@gmail.com" target="_blank">zeneliiardi@gmail.com</a>> wrote:<u></u><u></u></p></div></div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm"><div><div><div><p class="MsoNormal">Hello,<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">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.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Thanks<u></u><u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></p></div></div><p class="MsoNormal">_______________________________________________<br><a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><u></u><u></u></p></blockquote></div><p class="MsoNormal"><span style="color:#888888"><br><br clear="all"><br>-- <u></u><u></u></span></p><div><div><div><p class="MsoNormal"><span style="color:#888888">Regards,<u></u><u></u></span></p></div><p class="MsoNormal"><span style="color:#888888">Manu<u></u><u></u></span></p></div></div></div><p class="MsoNormal"><br>_______________________________________________<br><a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><u></u><u></u></p></blockquote></div><p class="MsoNormal"><u></u> <u></u></p></div></div></div><p class="MsoNormal"><br>_______________________________________________<br><a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><u></u><u></u></p></blockquote></div><p class="MsoNormal"><br><br clear="all"><u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><p class="MsoNormal">-- <u></u><u></u></p><div><p class="MsoNormal">Simone Travaglini<br>328 5499846<br>Linkedin: Simone Travaglini <br><br><br><span style="color:#33cc00">Rispetta l'ambiente: non stampare questa mail se non ti è veramente necessario!</span><u></u><u></u></p></div></div></div></div></div></div><br>_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div>Simone Travaglini<br>328 5499846<br>Linkedin: Simone Travaglini <br><br><br><span style="color:rgb(51,204,0)">Rispetta l'ambiente: non stampare questa mail se non ti è veramente necessario!</span><br></div>
</div>
</div></div><br>_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>