#Contacts4 discutindo

🗞 [Product & Service: Monthly Buzz] June 2026 🗞NEW CONTENT EVERY MONTH! Be sure to read the best of our content in your inbox 

🚀 Community Highlights 

This month we saw amazing engagement across the community:

• 809 questions answered by community experts
• 21% Accepted Answers by community members

A big thank you to everyone who continues to support and help others in the community! 

 Here are a few updates you should know about: 

1. Step-Up Authentication for Report Actions. Read more here >> 

https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX00000pNc5L0AS

2. Add Custom Link to Lightning App Record Page. Read more >> 

https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX00000pNIVX0A4

3. Step-Up Authentication for Report Actions. Read more >> 

https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX00000pNc5L0AS

🏆 Member Spotlight

This month we’re recognizing  Eric Burté for an awesome deep dive on "Manage Duplicate Leads & Contacts in Salesforce"

💡

We published two Knowledge Articles under the topic #Contacts#Contacts & #SalesCloudEssentials#SalesCloudEssentials with the help of our Forum Ambassadors, @Eric Burté & @Piyusha Pilania. Thank you for your valuable contributions. 

The topics included: 

1. Manage Duplicate Leads & Contacts in Salesforce. Read more >> https://help.salesforce.com/s/articleView?id=005386514&type=1

2. Calculate Business Hours duration between twTimestamps. Read more >> 

https://help.salesforce.com/s/articleView?id=005321712&type=1

❤️ Thank You

Thank you for to everyone for being part of our growing community. Your participation and engagement make this space valuable for everyone. 

#Product#Product & Service New

I've written an Apex class with methods that parse data out of a CSV file, create account and contact lists with custom fields used as external IDs, and upsert that data using the custom fields as the comparison for duplicates. However, Apex thinks the data in the contact list contains duplicates. I have confirmed in the file itself and via debug code (comparing against a set) that it does not, and I can see when I write debug code to only add the contact to the list if it is not already in the list that Apex thinks every record is a duplicate. 

I've written code to ensure and confirm that the list is empty before I start adding to it, I've edited the match rules so they only match on the external ID, and I've uninstalled Dupe Eliminator and Duplicate Check (installed by my predecessor) to be sure they aren't creating restrictions I can't access. Also, I've tried to check Apex triggers, but they are managed and can't be viewed/edited. We do have quite a few other packages/apps installed. Could these be the issue? Could it be a scope of the variable issue? Does anyone have any suggestions on what else might be the issue? 

I am including my code below with the caveat that it is pretty messy right now with all my debug code, comments, and variables for other methods in place. Below that code is a screenshot of the debug log starting at the beginning where you can see the first test for the contact existing in the list results in TRUE, before any other contact has been added to the list, and that there is no debug output for the code outputting

 any contacts already in the list before I start adding to it. Finally, I am also including a screenshot of our installed packages.

public class mkfa_ImportLegacyData {
    //Create an affiliation, contact, and account list for those being manipulated by methods.
    public static List<npe5__Affiliation__c> affiliationList = new List<npe5__Affiliation__c>();
    public static List<Contact> contactList = new List<Contact>();
    public static List<Account> accountList = new List<Account>();
    //Create string lists for holding all data & 1 row from document
    public static List<String> dataRecs = new List<String>();
    public static List<String> fieldValues = new List<String>();
    public static List<List<String>> parsedData = new List<List<String>>();
    public static Boolean proceedFlag = true;
    //Create a contact,account, affiliation, and IDs
    public static Contact tempContact = new Contact();
    public static VOID parseFileRecs(string docName){
        //Get the file
        final ContentVersion doc = [SELECT VersionData FROM ContentVersion WHERE Title = :docName AND IsLatest = true];
        //******CSV file must be in UTF-8 format******
        String bodyString = doc.VersionData.toString();
		//Split the content into records by new line character
        dataRecs = bodyString.split('\n');    
        //Debug code
        //system.debug('Body of the document to import:'+bodyString);  
        //Iterate through the records in the file to create a list of recs, sans the header, each of which is a list of fields
        for(Integer i=1;i<dataRecs.size();i++){
            fieldValues = dataRecs[i].split(',');				
            parsedData.add(fieldValues);                
        }   
    }
    public static VOID parseContactFields(String fileName){
		//Make sure the contact list to upsert is empty.
        contactList.clear();
        /*Debug code to be sure contactList is empty. */
        for (Contact thisContact : contactList){
            System.debug(thisContact);
        }
        //Parse the data from the file
        parseFileRecs(fileName);
        proceedFlag = true;
	List<Account> contactAcctList = new List<Account>();
        List<String> AccountNumList = new List<String>();
        String tempVal;
        //Set to test for duplicates
        //Set<Contact> externalIDs = new Set<Contact>();
        //Retrieve all the account numbers from the CSV file
        for(Integer j=0;j<parsedData.size();j++){
            AccountNumList.add(parsedData[j][1]);
            //Debug code
            //system.debug('Acct # added: '+AccountNumList[j]);
        }
        //Query the db for all accounts matching the list of account numbers
        contactAcctList = [SELECT Id, mkfa_AccountNum__c FROM Account WHERE mkfa_AccountNum__c IN :AccountNumList];   
        //Iterate through the records in the file
        for(Integer i=0;i<parsedData.size();i++){
            //Create contact from this row of data
            tempContact.mkfa_External_ID__c = parsedData[i][2];
            //Checking for duplicates
/*
            if(externalIDs.contains(tempContact)){
                system.debug('This ID is a duplicate: ' + tempContact);
            }
            else{
                externalIDs.add(tempContact);
            }
*/
            //debug Code
            //system.debug(i+': Contact External ID: '+ tempContact.mkfa_External_ID__c);
            tempContact.FirstName = parsedData[i][4];
            //debug code
            //system.debug('Contact First Name: '+ tempContact.FirstName);          
            tempContact.LastName = parsedData[i][5];
            //debug code
            //system.debug('Contact Last Name: '+ tempContact.LastName);
            //Get the account # from the file, test it against the list of accounts we queried earlier in SoQL
            tempVal = parsedData[i][1];
            for(Integer k=0;k<contactAcctList.size() && proceedFlag==true;k++){
                if(contactAcctList[k].mkfa_AccountNum__c==tempVal){
            		tempContact.AccountId = contactAcctList[k].Id;
                    proceedFlag = False;
                }     
            }                
            //Add the contact to the contact list
            if(!contactList.contains(tempContact)){
            	contactList.add(tempContact);
                system.debug('Contact added: ' + tempContact);
            }
            else{
                system.debug('Contact is dup: ' + tempContact);
            }
            //debug code
            //system.debug('Added contact: '+tempContact); 
            proceedFlag = true; 
        }  
        //Testing for duplicates. Makes sure the set used to look for dups is the same size as the list of contacts.
/*        if(contactList.size()==externalIDs.size()){
            system.debug('No problems with dups. Proceed.');
        }
        else{
            system.debug('Hold up. There are dups the SS did not find.');
        }
*/
                    //Try to upsert the contacts *****Use external ID
		Database.UpsertResult[] upsertResults = Database.upsert(contactList,Contact.mkfa_External_ID__c,true);		        
/*        try{
            upsert contactList Contact.fields.mkfa_External_ID__c;
        } catch(DmlException e) {
            System.debug('The upsert failed. That is OK. Return to the maze and take this message to guide you: ' +
                         e.getMessage());
        }          
*/
    }
}

#Apex #Duplicates #Contacts #Matching Rules