HELP - Import issues with dedupe

[khinester]

Hello,
I have spend one day today, trying to figure this out ;'(

I have a small CSV of about 12,000 records exported from our web site, I am trying to import this, but make the dedupe against the email address as some users have registered 4 or 5 times.

BUT I cannot see where I can set the index to de-dupe aginst the email address.

There is an option when you import in the Leads, but I am trying to import into the Targets.

Any help or advise as to how to set this would be most greatfull.

Also, I have only three

Verify duplicate entries against selected indexes
Index(es) used Index(es) not used
Tracker Key
Last Name, First Name, Deleted
Last Name, Deleted


I have tried all versions and get very odd imports, in that if I use the Last Name, Delete, SugarCRM only imports 47 records and tells me that there are 11,953 duplicates

What is all this about?!?!

Many thanks

Norman

[ruchida]

Hi

I think the Import function is scanning the table indices to find out a duplicate record. The indices are defined in modules/Prospects/vardefs.php as below.

     'indices' => 
            array (
                array('name' =>'prospectspk', 'type' =>'primary', 'fields'=>array('id')),
                array(
                        'name' => 'prospect_auto_tracker_key' , 
                        'type'=>'index' , 
                        'fields'=>array('tracker_key')
                ),
                   array(    'name'     =>    'idx_prospects_last_first',
                        'type'     =>    'index', 
                        'fields'=>    array(
                                        'last_name', 
                                        'first_name', 
                                        'deleted'
                                    )
                ),
                   array(
                        'name' =>    'idx_prospecs_del_last', 
                        'type' =>    'index', 
                        'fields'=>    array(
                                        'last_name', 
                                        'deleted'
                                        )
                ),
            ), 
  

So you may need to define another index here to check the email1 field. It will look like below but I've not tested this though.

                    array(
                        'name' =>    'idx_prospecs_del_email1', 
                        'type' =>    'index', 
                        'fields'=>    array(
                                        'email1', 
                                        'deleted'
                                        )
                ), 
  

[khinester]

Hi and thanks for your reply.

This did not work, I changed the code and then run the Import Wizard, loaded the data and selected the newly created index from th elist and click on Umport... this just hanged for about an hour.

Had to restart apache and revert back the code.

Just curious, why is this not part of the standard import feature, usually emails are specific to one user!

Any other advice is much welcomed.

Cheers

Norman

[ruchida]

Hi
Is the index created?