tag:blogger.com,1999:blog-6019741717555751737.post6749688076786763867..comments2023-08-13T03:31:05.204-07:00Comments on Low Level Manager: Recover Iphone contacts from raw backupAndrew Grangaardhttp://www.blogger.com/profile/14818383405782029025noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6019741717555751737.post-71142764075964086042012-08-29T00:33:34.462-07:002012-08-29T00:33:34.462-07:00Risco, I don't know for certain but I'd gu...Risco, I don't know for certain but I'd guess it unlikely that your sister-in-law's overwritten contacts are recoverable. The ID number is likely an auto incrementing field, so the old ID's won't get reused.Andrew Grangaardhttps://www.blogger.com/profile/14818383405782029025noreply@blogger.comtag:blogger.com,1999:blog-6019741717555751737.post-53269071725424406652012-08-13T13:31:37.421-07:002012-08-13T13:31:37.421-07:00Is there a way to UNDELETE previously deleted reco...Is there a way to UNDELETE previously deleted records in the SQLite DB? My sister in law overwrote her contacts with 5 new records coming from the phone's SIM Card, and these new records went in with Record IDs that were in sequence above the number of contacts she previously had. This led me to believe that the old records may still be in the DB. Am I right? Is there a way to recover them?Ricsohttps://www.blogger.com/profile/17413651775724167653noreply@blogger.comtag:blogger.com,1999:blog-6019741717555751737.post-86485968208235561382012-03-09T12:11:35.580-08:002012-03-09T12:11:35.580-08:00awesome saved my buttawesome saved my buttAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6019741717555751737.post-3638674646355763012011-09-29T19:41:43.200-07:002011-09-29T19:41:43.200-07:00Thanks a lot and don't forget the ";"...Thanks a lot and don't forget the ";" after the select statement.<br /><br />A variant, showing labels (mobile/home/main etc.), removing the ID columns and sorting by first name and then last name is:<br /><br />select p.first, p.last, lbl.value, mv.value from ABPerson p join ABMultiValue mv on (p.ROWID=mv.record_id) join ABMultiValueLabel lbl on (mv.label=lbl.ROWID) order by p.first, p.last;Johan Zandinhttp://twitter.com/jzandinnoreply@blogger.com