vtiger

[hairpriz]

Hello
I added customized fields in the contact module but i would like to save the datas into another table than contactscf. So i need to know where is the sql lines which record and display this datas.
Someone knows this informations or another way to achieve that purpose:?:
Thanks :wink:

[Asha]

Hi,

The queries to add Custom field information are in modules/Settings/AddCustomFieldToDB.php

Custom fields listing is done by modules/Settings/CustomFieldList.php

Values to a particular custom field of a module (say Contacts) is added through Save.php of that module and the tablename for the custom field values is picked from $tab_name array stored in the module.

Eg: $tab_name array of Contacts.php has the table name 'vtiger_contactscf'. So the custom field values will be inserted into this table through Save.php of modules/Contacts.

[hairpriz]

Hi Asha and thanks for your quick reply! :)
If i understand well, I just need to change vtiger_contactscf in contact.php into "my new table" if I have the same fields in this table? :)

[Asha]

Hi,

Yes. To save the data in some other table and not in vtiger_contactscf, changing the table name in $tab_name and $tab_name_index should help you.

[hairpriz]

When i do that i cannot see the contactdetails anymore :(

Here is the error
Code:
Fatal error: Call to a member function Move() on a non-object in C:\wamp\www\vtigercrm5\vtigerCRM\include\database\PearDatabase.php on line 441

and the sql errors
Code:
(mysql): select * from 0 where vtiger_parks=>contact_id=22
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0 where vtiger_parks=>contact_id=22' at line 1


         ADOConnection._Execute(select * from 0 where vtiger_parks=>contact_id=22, false) % line  861, file: adodb.inc.php
      ADOConnection.Execute(select * from 0 where vtiger_parks=>contact_id=22) % line  240, file: PearDatabase.php
   PearDatabase.query(select * from 0 where vtiger_parks=>contact_id=22) % line 1206, file: CRMEntity.php
CRMEntity.retrieve_entity_info(22, Contacts) % line   41, file: DetailView.php
include(C:\wamp\www\vtigercrm5\vtigerCRM\modules\Contacts\DetailView.php) % line  649, file: index.php
[/quote]

Do you see what's wrong?