Adding custom Indexes for Duplicate Importing

[tomtommorrow]

I created a custom index in mysql labled "idx_lead_adr_all". The columns I indexed in the "leads" table are "primary_address_city", "delete", and "primary_address_postalcode". I want to check duplicates at import, based on address.

After adding the index "idx_..." , that index does not display on the "verify duplicate entries..." window on the import mapping page. I am no expert in php, but it appears in the php library "tbl_indexes.lib.php" that this file should be referencing the entire "idx_collection". Any ideas? Thanks.

tom

Sugar bitrock 4.5.0c

[tomtommorrow]

Answered my own question. This link is very helpful.

http://www.sugarcrm.com/wiki/index.p...#Indices_Array

[cbakop]

How this can be applied when you want to use custom fields to check duplicates on import? for example and concerning the Leads module, can you create a vardefs.php file in custom/modules/Leads and define fields and indexes for the Leads_cstm table (apart from creating the corresponding indexes in the db table Leads_cstm, of course)?

[saradhinc]

I also require the solution for the above query asked by "cbakop".

Pleaseee..any solutions, clues or pointers would be of great help.

Thanks in advance.