Pages - Menu

November 14, 2011

Filter Your Address Book on Mac Apple


On 14-Nov-2011, at 1:12 PM, TSK Gmail wrote:

Attached link to script which filter the Address Book and creates Groups as follows for you to manually clean the mess.. 

Yes the script will not do any delete or modify the data, its just sort the address book for you and you can easy do manual corrections..


1. "xxx No Name" -- No Name..  Address Book will Show Email ID is there is no Name
2. "xxx Duplicate Names" -- Simple where the First + Middle + Last Name is Matched
3. "xxx Duplicate Emails" -- all Contacts with duplicate Email.. in this Group Search for the Email to have those listed.. Warning Do Not delete all because this group contains the original ID also, it all contacts with that email ID.. 
4. "xxx Duplicate Phone" -- all Contacts with duplicate Phone.. in this Group Search for the Email to have those listed.. Warning Do Not delete all because this group contains the original ID also, it all contacts with that Phone Number..
5. "xxx inCorrect Emails" -- Simple.. if the email Id is not correct, ie does not have @ or . or if there are Space..  It also add email id entered as Srikanth Kamath <srikanth@tskamath.com> because this is not expected entry in Address Book.. change these field to srikanth@tskamath.com
6. "xxx inCorrect Phones" -- Simple.. Phone nos with non numerical Char..or not allowed Char
7. "xxx only Emails" -- Contacts without Phone
8. "xxx only Phone" -- Contacts without Emails..


xxx = your user Name in the MAC..
WARNING:  Do not delete the all contacts within the Duplicate Group.. because it has the original contact also.. hence you have to manually select the actual duplicate one and delete.. 
Example 1 Duplicate Name Group
1 Contact "Srikanth Kamath" with Phone + 91 990 60797, Email; srikanth@anixter.com: Company: Anixter
2 Contact "Srikanth Kamath" with Phone + 91 990 03382, Email; srikanth.kamath@mobotix.com: Company: Mobotix
3 Contact "Srikanth Kamath" with Phone + 91 990 60797, Email; srikanth@tskamath.com: Company: Kamath

All three contacts will be in Duplicate Names.. you must select the Ones you want to delete and delete them, in the example I would select the 1 & 3 and press del.. hope its clear.. do not delete all 3.. only ones that are actually duplicate..

Example 2 Duplicate Email Group
1 Contact "Srikanth Kamath" with Phone + 91 901 60797, Email; srikanth@tskamath.com: Company: Anixter
2 Contact "Srikanth" with Phone + 91 99000 082, Email; srikanth@tskamath.com: Company: Mobotix
3 Contact "Kamath" with Phone + 91 9901 697, Email; srikanth@tskamath.com: Company: Kamath

All three contacts will be in Duplicate Emails.. you must select the Ones you want to delete and delete them, in the example I would select the 1 & 3 and press del.. hope its clear.. do not delete all 3.. only ones that are actually duplicate..

Example 3 Duplicate Phone Group
1 Contact "Srikanth Kamath" with Phone + 91 9901 0797, Email; srikanth@anixter.com: Company: Anixter
2 Contact "Srikanth Kamath" with Phone + 91 9901 0797, Email; srikanth.kamath@otix.com: Company: Mobotix
3 Contact "Srikanth Kamath" with Phone + 91 9901 0797, Email; srikanth@tskamath.com: Company: Kamath


All three contacts will be in Duplicate Emails.. you must select the Ones you want to delete and delete them, in the example I would select the 1 & 3 and press del.. hope its clear.. do not delete all 3.. only ones that are actually duplicate.. 

Some of the bugs with this script which i can live with

1.  Contact "Srikanth Kamath" with Phone + 91 990 60797, Email Work ; srikanth@anixter.com:  Email Home ; srikanth@anixter.com: Company: Anixter
is also listed in the Duplicate Email Group.. because the email is listed twice in the contact.. feature or bug...? for me its a feature

2. Contact "Kamath" with Mobil + 91 990 60797, Phone Work: 080 2266496 Email; srikanth@anixter.com: Company: Anixter and Contact "Srikanth" with Mobil + 91 9900 032, Phone Work: 080 080 2266496, Email; srikanth.kamath@mobotix.com: Company: Mobotix
both these contact are listed in duplicate Phone because they share a common work number.. hence these are not actually duplicates.. but have common numbers.. 

sorry i cannot make the computer more intelligent than this..  yep i can program to ignore these types.. but from my experience with address book.. i use this feature (opps its bug) to filter on company name of people, ie if i have not changed the contact's company details although i had changed the contact's telephone numbers.. 

pls provide the feedback or any feature that you would want.. will try to do this when in airports or when i want jog my mind to sleep. the link for download 
https://files.me.com/tsk.kamath/ursk3q for the Send Email from Groups with WhiteList and BlackList