Remove duplicates from your PC

From CLWiki
Jump to: navigation, search


Microsoft Outlook

Outlook 2010 and 2013

  1. Go to the Contacts window.
  2. Right-click on the fields at the top of the screen.
  3. Click 'View Settings'.
  4. Click Group By.
  5. At the bottom-left of the screen, select 'All Contact Fields' from the dropdown.
  6. At the top-left of the screen, select Created.
  7. Click OK.
  8. Expand it so that the dates and times can be read.
  9. What you are looking for is the same date and same time and then just highlight and delete all dupes.

(Note: This may be also done by changing the View to By Category and adding the column 'Modified'. By changing the view to By Category, you can do this for any area of OL.)

For Calendar, repeat the same steps above for your Outlook Calendar.

Outlook 2007

  1. Go to the Contacts window in Outlook
  2. Right-click on the fields at the top of the screen
  3. Click 'Customize current view.'
  4. Click Group By
  5. At the bottom-left of the screen, select 'All Contact Fields' from the dropdown.
  6. At the top-left of the screen, select Created.
  7. Click OK.
  8. Expand it so that the dates and times can be read.
  9. What you are looking for is the same date and same time and then just highlight and delete all dupes.

(Note: This may be also done by changing the View to By Category and adding the column 'Modified'. By changing the view to By Category, you can do this for any area of OL.)

For Calendar, repeat the same steps above for your Outlook Calendar.

Outlook 2003

  1. Go to the Contacts window.
  2. Click on the 'View' Menu, then 'Arrange By', then 'Current View', then 'By Category'.
  3. Right-click on the fields at the top of the screen.
  4. Click 'Customize Current View...'.
  5. Click Group By.
  6. At the bottom-left of the screen, select 'All Contact Fields' from the dropdown.
  7. At the top-left of the screen, select Created.
  8. Click OK.
  9. Expand it so that the dates and times can be read.
  10. What you are looking for is the same date and same time and then just highlight and delete all dupes.

(Note: This may be also done by changing the View to By Category and adding the column 'Modified'. By changing the view to By Category, you can do this for any area of OL.)

For Calendar, repeat the same steps above for your Outlook Calendar.

ACT! 2005 or higher

  1. Go to the Lookup menu.
  2. Choose By Example.
  3. Go to Advanced
  4. Find the field, Create Date.
  5. Put in the date of the sync. For example, 4/23/07.
  6. Click on the Search button.
  7. A box will prompt you to select a query option. Select 'Replace lookup'.
  8. The contact list will now display those contacts that match the query terms. Delete contact records from this date that are already included in your ACT database.


ACT! activities: You can select multiple activities by holding down the CONTROL button and clicking on the items you want to erase. Once you have them selected, right-click the items and choose Clear Multiple Activities. From the next window, select Erase, and choose OK.

ACT! 3.0 to 6.0

Below are some instructions for removing duplication for ACT! 3.0 to 6.0, including ACT! 2000. Before doing any major changes to your database, please first create a new backup of your database.

To remove duplicate contacts: Use an ACT! query to select all the contacts added the day the duplicates were created, then delete these.

  1. Go to the Lookup menu.
  2. Choose By Example.
  3. Find the field, Create Date.
  4. Put in the date of the sync. For example, 4/23/07.
  5. Click on the File menu.
  6. Choose Save.
  7. Click on the Query menu.
  8. Choose Run.
  9. The contact list will now display those contacts that match the query terms. Delete all the items in the contact list. This will remove all the entries created on the day of the sync.

To remove duplicate activities:

  1. Go to the Task List.
  2. Make sure all types, priorities, dates, and cleared records are displayed.
  3. Click on the Date column to sort.
  4. Delete the duplicate records.

NOTE: Make sure to choose Erase, not Clear.


GoldMine

Note: You must have master rights to delete records in GoldMine.

  1. Go to Lookup > Filters.
  2. Click the New button.
  3. Provide a name for the filter, then click the Build tab.
  4. Under the Field Name drop-down menu, choose 'Creaton'.
  5. Under the Operator drop-down menu, select 'Equal to'.
  6. In the Value field, enter the date on which the duplicates were created in the following format: mm/dd/yy
  7. Click the Insert Condition button, then click OK.
  8. Highlight your new filter in the Filters list, then click the Activate button.
  9. Go to Tools > Delete Records Wizard.
  10. Select 'Delete ALL (filtered) contact records)', and click Next.
  11. In the drop-down box, select the filter you've just created, and click Next.
  12. Check all boxes. Type the phrase in the box, and click Next.
  13. Uncheck Synchronize Deletions, and click Finish.