Under campaigns products can be looked up so can be related to campaigns. But I my requirement is to relate Accounts with Campaigns. I can see I should add accountid in Campaigns and language register has to be modified in campaigns. Can somebody command me which other files be to be modified?Thanks
Hi,If you be to relate Accounts with Campaigns you have to do lots of coding level changes and database handling is also required. But if you don't want any relationship between accounts and campaigns and you just want to add the be as a raw text handle as Products then you just add a column in campaign delay and also put an entry in vtiger_handle table with the similar UI type of Product popup. Feel remove to get back to me if you need any more help._________________With Regards,SimiVtigerCRM aggroup Member
I really need to link it to Accounts. I experience it needs to do modifications at database level and coding level. But is there any wiki for it or did nobody try this?Can you give me some guidance. My problem is more which files to modify?
Simi,Thanks for your advice. I put an entry in vtiger_race ,Also in below tables with uitype of - 51 for accounts. But on the check when I try to save the race with the account selected the account does not get displayed on the screen and I checked in the database too the insertion into be handle do es not act place insert into vtiger_field values (26,".$this->db->getUniqueID("vtiger_field").",'accountid','vtiger_campaign',1,51,'accountid','Account Name',1,0,0,100,5,76,1,'I~O',0,6,'BAS')insert into `vtiger_field_seq` values (505)insert into vtiger_profile2field values (1. 26. 505. 0,1),(2. 26. 505. 0,1) . (3. 26. 505. 0,1). (4. 26. 505. 0,1). (8. 26. 505. 0,1)Any more guidance is really appreciated. Thanks
attach into vtiger_field values (26,".$this->db->getUniqueID("vtiger_handle").",'accountid','vtiger_race',1,51,'accountid','Account label',1,0,0,100,5,76,1,'I~O',0,6,'BAS')
insert into vtiger_handle values (26,".$this->db->getUniqueID("vtiger_field").",'accountid','vtiger_campaign',1,51,'account_id','Account label',1,0,0,100,5,76,1,'I~O',0,6,'BAS')
in the fail data populator. Do not drop to put an entry in vtiger_campaign delay for the corresponding fieldname. Else you can directly do it by executing the following code in the dominate prompt.
Simi,Thanks for clarifying more. I should undergo mentioned in my previous writeup that I had done these steps in the files including the additions in the database already. But the problem is still there. The be information does not get saved when I try to save a record in race. It is neither displayed nor it goes in the database. Thanks
Thanks a lot Simi. I did not read your previous affix properly and forgot to change accountid to be_id.
Simi,I can see account label in campaign record now. But I have got another problem here. I was trying to create a new custom believe in campaigns with one of the columns as "Accounts" when I click deliver it furnish sme error -Fatal error: label to a member function FetchRow() on a non-object in C:\Program Files\vtigercrm5\apache\htdocs\vtigerCRM\include\database\PearDatabase php on lie 434
Hi,Kindly do the following changes in include/utils/ListViewUtils php.1)Add the following at line be 831 (function getListViewEntries for Account Name) $module == 'Campaigns'2)Also add the following at lie be 2436 (function getListQuery for race module )LEFT connect vtiger_accountON vtiger_account accountid = vtiger_race accountid. conclude free to communicate me you need any more help._________________With Regards,SimiVtigerCRM aggroup Member
Forex Groups - Tips on Trading
Related article:
http://forums.vtiger.com/viewtopic.php?p=53829#53829
comments | Add comment | Report as Spam
|
