Different amount of records in Goldmine Connect (WEB) interface and GoldMine version

Version 2

    Details

    Different amount of records in Goldmine Web (GMWEB) interface and GoldMine version

     

     

     

     


    Resolution

    [REASON]
    The reason for the difference is that the current database has duplicate primary email addresses on one or more contact records

     

    The  reason why this appears in GMWEB is that for the CONTACTS page listing  GoldMine Web will create a separate temporary table #allPrimaryEmails,  so that the primary email address is displayed in the Contact listing.  After that a LEFT JOIN query from the CONTACT1 with this temporary table  is done which leads to the 'wrong' count. A LEFT JOIN keyword returns  all rows from the left table (here CONTACT1), with the matching rows in  the right table (#allPrimaryEmails).

     

    This is done by the query
    SELECT COUNT(*) FROM GoldMine.dbo.CONTACT1 contact
    LEFT JOIN #allPrimaryEmails contsuppemail on (contact.accountno = contsuppemail.accountno)

     

    Now  for example the email address test@test.com (while  for GMWEB only the 'duplicate primary email addresses' are impacted, it  is anyway not recommended to have duplicate email addresses) but such duplicates lead now to 'appear' in the count of GMWEB view.

     

    I  strongly recommend that you verify all duplicate email addresses

     

    The following query helps to  identify duplicate email addresses (although they can be either primary,  additional or other email addresses)

     

    SELECT     CONTSUPREF as duplicate_E_mail_address
    FROM         CONTSUPP
    WHERE     (RECTYPE = 'P') AND (CONTACT = 'E-mail address')
    GROUP BY CONTSUPREF
    HAVING      (COUNT(*) > 1)

     

     

     

    The following query helps to  identify duplicate primary email addresses (although they can be on different contact records which does not have impact in the current behavior)

     

    SELECT     CONTSUPREF as duplicate_E_mail_address
    FROM         CONTSUPP
    WHERE     (RECTYPE = 'P' AND CONTACT = 'E-mail address' and zip LIKE '_1%')
    GROUP BY CONTSUPREF
    HAVING      (COUNT(*) > 1)

     


     

    Within  GoldMine the Contact Search Center can be set to E-mail and then you  can search and verify and if applicable adjust the email addresses.

     

    While not recommended to have duplicate email addresses GoldMine Web is not impacted when the duploiacte email address is located at 2 different contact records

     

     

    but is impacted when the primary email address is located on a single contact record

     

     

    Resolve by opening the email address list and clicking on one of the duplicate email addresses (GoldMine will remove instantly the primary email address flag for one of the email addresses) but it is recommended to take care anyway for example by deleting the duplicate.

     


    OK >> click on a different areas e.g. CASES and back to CONTACTS and verify again