Skip navigation

merging or exporting PREVIOUS RECIPIENTS databases??

824 Views 20 Replies Latest reply: Dec 28, 2012 3:37 PM by hotwheels 22 RSS
  • Csound1 Level 7 Level 7 (32,380 points)

    If you add the previous contacts to the Contacts on any iCloud connected device you have added them to all iCloud connected devices, if the Previous Contacts database on the different devices contains identical contacts you will get duplicates.

     

    Apple.com/feedback, is where you send feedback

  • Barney-15E Level 7 Level 7 (33,400 points)

    i mean, i keep asking this question and no one seems to have figured out how to use this functionality in a way that makes sense - basically because it is a very unintelligent database/functionality at the moment.

     

    and there is no way to give feedback on it that i am aware of...

    Likely because you (and very few others) are trying to make use of it.

    I put contacts in my contacts. I don't depend on Previous Recipients to do that for me. It has the capability to add a contact if I wanted, but never have.

     

    http://www.apple.com/feedback/macosx.html

     

    If you want to dump the previous recipients to a comma separated values (csv) file, copy and past this into a text document and save it to the Desktop with a name such as DumpMailRecents.sql

     

    .mode csv
    .output "Desktop/PreviousRecipients.csv"
    
    SELECT DISTINCT
              ZFIRSTNAME, ZLASTNAME, ZEMAILNORMALIZED
    FROM
              ZABCDMAILRECENT r JOIN
              ZABCDLASTEMAILDATE l ON r.Z_PK = l.ZMAILRECENT
    ORDER BY l.ZDATE DESC;
    

     

    Open Terminal and copy/paste this into the window and hit return.

    sqlite3 Library/Application\ Support/AddressBook/MailRecents-v4.abcdmr 
    

    At the sqlite> prompt, copy/paste this into the line and hit return. If you chose a different name, modify it as such:

    .read Desktop/DumpMailRecents.sql
    

    If it completes without error, you will have a file called PreviousRecipients.csv on your Desktop.

    You can edit that with any text editor or spreadsheet, then import into Contacts.

    I sorted it by most recently used email address.

     

    Type .quit at the prompt to exit sqlite3.

    MacBook Pro, OS X Mountain Lion, 13" Unibody
1 2 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.