{"id":177,"date":"2009-10-01T23:33:04","date_gmt":"2009-10-01T22:33:04","guid":{"rendered":"http:\/\/simkin.org\/wordpress\/?p=177"},"modified":"2010-01-08T17:40:40","modified_gmt":"2010-01-08T16:40:40","slug":"recovering-iphone-contacts-from-a-backup","status":"publish","type":"post","link":"http:\/\/simkin.org\/wordpress\/?p=177","title":{"rendered":"recovering iphone contacts from a backup"},"content":{"rendered":"<p>So your iphone died and it killed your contacts list? It is not easy to recover it but not impossible either:<\/p>\n<p>Find your last backup file: c:\\users\\xxx\\AppData\\Roaming\\Apple Computer\\MobileSync\\Backup and look for your contacts file called <strong>31bb7ba8914766d4ba40d6dfb6113c8b614be442.mdbackup <\/strong>which is a plist file containing sqlitite v3 encoded content stored in xml.<\/p>\n<p>For the lazy people, there is a useful tool to extract the content as plaintext: http:\/\/insend.de\/ or http:\/\/www.reincubate.com\/labs\/iphone-backup-extractor-how-extract-files-iphone-backup-windows\/#\/res\/i\/labs\/iphonebe\/3_wizard.png<\/p>\n<p>If you export from sqlite to Excel and use and dated fields, this query is vaery handy:<\/p>\n<p>select strftime(&#8216;%d\/%m\/%Y %H:%M&#8217;,1257961471, &#8216;unixepoch&#8217;);<\/p>\n<p>Alternatively, get Excel to do the work (Converts to GMT):<\/p>\n<pre>=(((A1\/60)\/60)\/24)+DATE(1970,1,1)   [taken from <a href=\"http:\/\/spreadsheetpage.com\/index.php\/tip\/converting_unix_timestamps\/\">this site<\/a>]<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>So your iphone died and it killed your contacts list? It is not easy to recover it but not impossible &hellip; <a class=\"more-link\" href=\"http:\/\/simkin.org\/wordpress\/?p=177\">More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":""},"categories":[11,3],"tags":[188,187,57],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/simkin.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/177"}],"collection":[{"href":"http:\/\/simkin.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/simkin.org\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/simkin.org\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/simkin.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=177"}],"version-history":[{"count":0,"href":"http:\/\/simkin.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/177\/revisions"}],"wp:attachment":[{"href":"http:\/\/simkin.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/simkin.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=177"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/simkin.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}