{"id":177,"date":"2009-10-01T23:33:04","date_gmt":"2009-10-01T22:33:04","guid":{"rendered":"http:\/\/simkin.org\/wordpress\/?p=177"},"modified":"2009-10-01T23:33:04","modified_gmt":"2009-10-01T22:33:04","slug":"recovering-iphone-contacts-from-a-backup","status":"publish","type":"post","link":"https:\/\/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 either: Find your last backup file: c:\\users\\xxx\\AppData\\Roaming\\Apple Computer\\MobileSync\\Backup and look for your contacts file called 31bb7ba8914766d4ba40d6dfb6113c8b614be442.mdbackup which is a plist file containing sqlitite v3 encoded content stored in xml. For the lazy people, there is [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,15],"tags":[34,86,160],"class_list":["post-177","post","type-post","status-publish","format-standard","hentry","category-events","category-tech-stuff","tag-address-book","tag-contacts","tag-iphone"],"_links":{"self":[{"href":"https:\/\/simkin.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/simkin.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/simkin.org\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/simkin.org\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/simkin.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=177"}],"version-history":[{"count":0,"href":"https:\/\/simkin.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/177\/revisions"}],"wp:attachment":[{"href":"https:\/\/simkin.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/simkin.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/simkin.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}