Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Remove duplicated field data in iCal and Address Book Apps
A number of AppleScripts are floating around online for removing duplicate entries from Address Book and iCal, such as this one by John Maisey. Sometimes, however, individual fields within a contact or event can be duplicated, in which case these scripts aren't any help.

I recently had this problem due to a combination of bugs in The Missing Sync 5.0 for Palm OS (which is otherwise an excellent piece of software) and Tiger's Sync Services. A large portion of my Address Book contacts ended up with duplicated emails, and my iCal calendars had duplicate alarms.

I was able to eliminate these duplicate fields by writing some AppleScript. Even though most Mac users don't sync with other devices, I suspect someone might still find these scripts useful, so I've posted them on my site. Even if they don't meet your exact needs, they can serve other purposes. For instance, the Remove Duplicate Emails script can easily be modified to remove duplicate phone numbers instead.

[robg adds: I have also mirrored these scripts [16KB download] here on macosxhints.com, just to make sure they're available in the future.]
    •    
  • Currently 3.20 / 5
  You rated: 4 / 5 (5 votes cast)
 
[35,210 views]  

Remove duplicated field data in iCal and Address Book | 7 comments | Create New Account
Click here to return to the 'Remove duplicated field data in iCal and Address Book' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Works for me
Authored by: krrt on Dec 23, '05 08:17:19AM

Thanks for the script, it worked like a charm



[ Reply to This | # ]
Remove duplicated field data in iCal and Address Book
Authored by: tomem on Dec 23, '05 10:45:56AM

Very cool. I just couldn't face 1200 corrections by hand. Great to have this tool! Guess I'll eventually learn some applescript...

---
TomEM
Crofton, MD



[ Reply to This | # ]
Remove duplicated field data in iCal and Address Book
Authored by: felixv on Dec 26, '05 09:13:20AM

Hi

I've tried to adapt it to remove duplicate addresses (for example, work addresses seem to get duplicated within individual cards quite often by Missing Sync), but can't get it right. Would you mind posting how I can find and delete duplicated addresses within cards?

Thanks very much!



[ Reply to This | # ]
Remove duplicated field data in iCal and Address Book
Authored by: mirv42 on Dec 29, '05 11:38:33AM

Please add my thanks for posting these applescripts. I was hit by the Missing Sync duplicate problem too. I have some events (eg. an annual repeating event) that appear to be hidden and iCal can't see or delete them, but they appear about 27 times on my Treo. This applescript managed to delete all but 5 of them for some reason.

Did anyone figure out how the duplicate problem happened? It appears that with the latest Missing Sync betas there are no longer duplicates added to my calendar, thankfully.



[ Reply to This | # ]
Remove duplicated field data in iCal and Address Book
Authored by: MagicMike on Jan 11, '06 07:00:14AM

Doesn't work at all for me. I have OS X 10.4.3 in German.
When i put it into scripteditor I get 100's of error messages. Any help ?

Rgds



[ Reply to This | # ]
Remove duplicated field data in iCal and Address Book
Authored by: dfbills on Nov 06, '07 06:20:44AM

Has anyone attempted updating this script for Leopard's iCal 3.0?

---
-d



[ Reply to This | # ]
Remove duplicated field data in iCal and Address Book
Authored by: dfbills on Nov 06, '07 06:23:35AM