AnsweredAssumed Answered

Can you make custom indexes on custom module with relationship fields for import duplicate checking?

Question asked by Mary Growney on Feb 24, 2016
Latest reply on Oct 26, 2016 by Mayer Elyashiv

We're having issues creating custom indexes on a custom module, PICRM_Agency_Policy, on two fields that are populated using a formula with the relate function from two other modules, Accounts and Contacts. These two fields are Account Name and Contact Name. We have tried to include these fields in the custom_import_index.php file in custom/Extension/modules/PICRM_Agency_Policy/Ext/Vardefs/ but it will not allow us to do duplicate checking on the Account Name and Contact Name fields on the module on import. Is there a way to do this? Currently we have coded it this way:

 

$dictionary['PICRM_Agency_Policy']['indices'][] = array(

'name' => 'idx_account_id_cstm',

'type' => 'index',

'fields' => array(

0 => 'account_name_c'

),

'source' => 'non-db'

);

 

$dictionary['PICRM_Agency_Policy']['indices'][] = array(

'name' => 'idx_contact_name_cstm',

'type' => 'index',

'fields' => array(

0 => 'contact_name_c'

),

'source' => 'non-db'

);

 

Here is the Sugar_Developer guide for creating custom indexing for duplicate checkin gon import that we followed: https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.6/Data_Framework/Vardefs/Examples/Specifying_Custom_Indexes_for_Import_Duplicate_Checking/

 

Thank you,

Mary

Outcomes