Loading

Resolve duplicate entries found in Email Log

Veröffentlichungsdatum: Oct 1, 2024
Beschreibung

When conducting a review of the email log file, you may observe the presence of duplicate message IDs following the pattern AA/AA-AAAAA-AAAAAAAA where A can be a letter or number. These duplicate lines may occur intermittently due to the current configuration of our email log model. Presently, we employ an 'at least once' model as opposed to an 'exactly once' model. The 'at least once' model ensures data delivery with no loss of information, but it can result in intermittent duplication, particularly under heavy search loads. This occurrence arises to maintain robust data integrity, sometimes necessitating the submission of duplicate entries to the indexers. To address this, we recommend deduplicating the email log entries.

Lösung

Remove duplicates in Excel: 

  1. Download your email log file (.zip) in Salesforce
  2. Open the .csv file in Excel
  3. Select the range of cells that has duplicate values you want to remove (message IDs for example)
  4. On the top, select Data > Remove Duplicates, and then under Columns, check or uncheck the columns where you want to remove the duplicates
  5. Select "OK"

Remove duplicates in Google Sheets: 

  1. Download your email log file (.zip) in Salesforce
  2. Open the .csv file in Google Sheets
  3. On the top, select Data > Data cleanup
  4. Select Remove Duplicates
  5. Check or uncheck the Columns where you want to remove the duplicates
  6. Select Remove Duplicates
  7. Select "OK"
Nummer des Knowledge-Artikels

001537345

 
Laden
Salesforce Help | Article