CiviCRM Community Forums (archive)

Hi - using Find Member or Adv Search there is a problem - for me at least - in that the Search finds eg 11 contacts but the export file contains 14 records because it replicates the record for any person who has more than one 'phone' field - i suspect it will do this also for other fields where there is more than just the primary data
eg in your sandbox - Find Members >> Memb Type = General >> 11 records found including Mrs Demo Demo

>> Export and I end up with Mrs Demo Demo being listed three times because three of her phone fields have got data in them (in this case on 000 but that isn't the problem).

This is causing us serious problems with exporting lists for use - can this be fixed easily?

And I will note that having tried the 'batch update' to see what would happen I got an error
which may be to do with these duplicates - or maybe not -
Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_value_1_officers_and_roles  SET position_or_role = '', branch_officeholder = '', domain_id = 1, entity_id = 12906  [nativecode=1062 ** Duplicate entry '1-12906' for key 2]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_value_1_officers_and_roles  SET position_or_role = '', branch_officeholder = '', domain_id = 1, entity_id = 12906  [nativecode=1062 ** Duplicate entry '1-12906' for key 2]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_value_1_officers_and_roles  SET position_or_role = '', branch_officeholder = '', domain_id = 1, entity_id = 12906  [nativecode=1062 ** Duplicate entry '1-12906' for key 2]"]
)


Hi - okay so it is the multiple primary that is the issue - i didn't create Mrs Demo Demo so can't comment but obviously lots of our records have this problem. And I note that, as you say, if I open and save a record, the multiple BOLD numbers on the Contact record change to just showing one.
So, ugly, but can it be automated. I note that when the contacts were not 'mapping' there was an option to run 'something' that caused every record to basically recalculate its co-ordinates - would a cron job on the Address records be an option or am i thinking out of the wrong end of my spine?
I will see if Chris can shed any light on why ours have so many with multiple primary - but have lost sight of hiim to BIRT for the recent past 

Good luck getting hold of chris - but seriously - has this bug got anything to do with this inexplicable problem. Or have I hit another one - or is it a clue to the first one.

So i just did an import and successfully allocated lots of 'office roles' to members (yes i am moving away from relationships!) - so I then 'exported' my smart group - which shows the import was good - other than the export produced 3 x Steffan - because of this bug - so, then i open his summary and hit save so he only has the one primary - and reconduct my search hoping to show that the export now only has one of him and guess what - no steffan at all in the search results - and when I go and check his record his 'office roles' are all cleaned out.

And just to verify, I opened another contact from my search result who I know was being exported twice, hit save, and bingo, my custom data for officers has been cleaned out. Now I am beginning to worry that it may be cleaning out other data too (which may explain concerns that some of our data is getting lost). Of course I can't tell what I have lost without doing some more digging (and people have gone home) but will try and find another example I can mess with.

This was a nasty bug (IMO) and has been present since CiviCRM v1.8. It is now fixed in v2.0

the relevant issue is here: http://issues.civicrm.org/jira/browse/CRM-2763

lobo

Here's the issue:

If you were using tabbed custom groups in v1.8 / v1.9

AND

if the tabbed group had a multi-select OR checkbox custom field

THEN

on any contact edit, the values would be reset for ALL the above multi-select / checkbox custom fields

unfortunately i cant think of any way folks can recover this lost data in a easy manner. I'm a bit down that we did not catch this issue earlier

lobo