tag:blogger.com,1999:blog-2023001108419895986.post3815622427637635809..comments2023-04-10T17:07:35.793+00:00Comments on Andykn's miscellaneous tech tips: iphone tracker (note this is from 2011)Andyknhttp://www.blogger.com/profile/00178354643237916005noreply@blogger.comBlogger28125tag:blogger.com,1999:blog-2023001108419895986.post-33131602088563201192021-08-14T22:20:12.182+00:002021-08-14T22:20:12.182+00:00Hi, it all looks interesting,
but I don't hav...Hi, it all looks interesting, <br />but I don't have Apple Computer\MobileSync\Backup (part) <br />What do i need to do please?juan2gohttps://www.blogger.com/profile/16146667318939699610noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-43466044966097347802019-04-03T10:48:26.868+00:002019-04-03T10:48:26.868+00:00I would like more information about this, because ...I would like more information about this, because it is very nice...Thanks for sharing. Thanks a lotswati parmarhttps://www.blogger.com/profile/15425656111343302822noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-89959641269500722312015-08-11T14:11:40.243+00:002015-08-11T14:11:40.243+00:00This is a great article and I've tried followi...This is a great article and I've tried following it, however, I'm struggling and want to be sure it's not due to the fact that I have iOS 8.4 running on my phone. Does anyone know if Apple has changed how/where the CellLocation table is stored since this article was written? I'm trying to track where my phone was on a specific day/time frame. Anonymoushttps://www.blogger.com/profile/07227028420931526939noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-21619940847825556632012-04-13T15:35:36.843+00:002012-04-13T15:35:36.843+00:00So close, but I am not sure what I am doing wrong....So close, but I am not sure what I am doing wrong..found the location and file etc, but I am not sure what the Dos findstr function is doing for me?Meltingtoehttps://www.blogger.com/profile/10642951344102554126noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-54883446523992286602012-01-24T07:44:12.013+00:002012-01-24T07:44:12.013+00:00guys this tracking stuff is not working anymore ri...guys this tracking stuff is not working anymore right? since ios 4.3.3?.. pls let me know if such is the case.. many thanks!pipshttps://www.blogger.com/profile/02064089753319218280noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-65287594049320382492011-12-11T17:16:33.810+00:002011-12-11T17:16:33.810+00:00An easier option for any platform (Mac, linux, Win...An easier option for any platform (Mac, linux, Windows) is to use the free personal version of iPhone Analyzer. http://www.crypticbit.com/zen/products/iphoneanalyzerLeohttps://www.blogger.com/profile/04952359388632087167noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-18262332301648864532011-05-04T08:10:14.902+00:002011-05-04T08:10:14.902+00:00@everyone!
There's a windows application now t...@everyone!<br />There's a windows application now that does all this for you. Finds the file, extracts the data and maps it.<br />Check it out here:<br />http://huseyint.com/iPhoneTrackerWin/<br />DOWNLOAD LINK<br />http://cl.ly/0F2K460D451O2q2P1C3uBen Sharifhttps://www.blogger.com/profile/00714117367431397963noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-15203582498717036132011-05-04T05:13:03.303+00:002011-05-04T05:13:03.303+00:00I keep on getting a
" FINDSTR: cannot open &q...I keep on getting a<br />" FINDSTR: cannot open " then the directory I put in.Ariahttps://www.blogger.com/profile/14615309405321173860noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-40406175543416722522011-05-03T18:41:28.944+00:002011-05-03T18:41:28.944+00:00@t: On my PC (Win XP SP3) the path is C:\Documents...@t: On my PC (Win XP SP3) the path is C:\Documents and Settings\[username]\Application Data\Apple Computer\MobileSync\Backup\Jeffhttps://www.blogger.com/profile/03997738367757166490noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-47835270080384187842011-05-02T08:00:37.150+00:002011-05-02T08:00:37.150+00:00There is no backup folder on my computer. (C:\User...There is no backup folder on my computer. (C:\Users\t\AppData\Roaming) but no apple folder. <br /><br />Am I supposed to enable this on my iphone?thttps://www.blogger.com/profile/03117747535433733687noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-81102030233481848042011-04-28T17:32:44.338+00:002011-04-28T17:32:44.338+00:00Perfect! CheersPerfect! CheersAnonymoushttps://www.blogger.com/profile/11792986713829072782noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-53610553636439945142011-04-28T14:30:31.801+00:002011-04-28T14:30:31.801+00:00Well done! this worked perfectly for meWell done! this worked perfectly for meMatt Merrifieldhttps://www.blogger.com/profile/15734956660824044463noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-86851449200881400552011-04-27T22:18:25.901+00:002011-04-27T22:18:25.901+00:00@Jens Blueul I followed the link you suggested and...@Jens Blueul I followed the link you suggested and found that the name of the file on my computer is the same as that on yours. It is:-<br />4096c9ec676f2847dc283405900e284a7c815836 <br />Maybe it is related to the day the information was backed up. My file is dated 12/04/2011Myrtle's missushttps://www.blogger.com/profile/14416467791441464729noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-12321406111265460702011-04-27T15:28:47.722+00:002011-04-27T15:28:47.722+00:00@Ben Sharif
I've tried the formula for the ti...@Ben Sharif<br /><br />I've tried the formula for the timestamp in excell (2003 version) and I'm getting results like "3650540514" or "3659823825" tried formatiing the cell as any data format but never getting something close to a date.<br /><br />I've also noticed in SQLite that sometimes over a hundred consequtive columns have the exact same timestamp, but different long and langtitude. Whats that about, anyone noticed something similar?Antonhttps://www.blogger.com/profile/10368462395492003012noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-91310103014595334222011-04-27T13:18:13.460+00:002011-04-27T13:18:13.460+00:00@rob I expect you have some entries in the WifiLoc...@rob I expect you have some entries in the WifiLocation table though. Non-3G enabled iOS devices can still use WiFi hotspots to find their location.<br /><br />Apple has now explained what this database is for, anyway: http://www.apple.com/pr/library/2011/04/27location_qa.htmlPaulDhttps://www.blogger.com/profile/13438696497237762377noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-52981794555463360132011-04-27T09:43:51.002+00:002011-04-27T09:43:51.002+00:00This was very helpful. I created another POC with ...This was very helpful. I created another POC with Kettle (open source data integration) to read in the SQLite file:<br />http://kettle.bleuel.com/2011/04/26/iphone-tracking-how-to-read-the-consolidateddb-with-kettle/Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-65750986517157948432011-04-26T11:16:29.643+00:002011-04-26T11:16:29.643+00:00@Ben Sharif That works beautifully. I have play...@Ben Sharif That works beautifully. I have played about with it and the results are very interesting. it seems to have recorded trips over the last year only when they are within the South East, all the rest is not shown. Also the location records seem to be rather inaccurate. When I travel I quite often go into a particular service station and it shows it spread over a huge area!Myrtle's missushttps://www.blogger.com/profile/14416467791441464729noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-82924544474590901752011-04-26T10:06:19.538+00:002011-04-26T10:06:19.538+00:00@agr122954 Thank you! I had forgotten how frustr...@agr122954 Thank you! I had forgotten how frustrating DOS can be .. no cut and paste, no inserting missing characters .. the true enemy of the dyslexic!Myrtle's missushttps://www.blogger.com/profile/14416467791441464729noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-70482278596253395882011-04-26T09:38:43.434+00:002011-04-26T09:38:43.434+00:00@Mel: use a hex editor to view the file you identi...@Mel: use a hex editor to view the file you identified in the earlier steps and confirm that the first 15 bytes read in ASCII "SQLite format 3".Unknownhttps://www.blogger.com/profile/14262631448273147654noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-75327226056092495642011-04-26T09:36:15.159+00:002011-04-26T09:36:15.159+00:00happy to say my wifi only ipad data on the PC had ...happy to say my wifi only ipad data on the PC had only a single entry in the table of 0.0,0.0 lat long.Unknownhttps://www.blogger.com/profile/14262631448273147654noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-76967084355911441122011-04-26T05:35:41.810+00:002011-04-26T05:35:41.810+00:00Myrtle, Put your filename string in quotes:
find...Myrtle, Put your filename string in quotes:<br /><br />findstr /M CellLocation "C:\Users\Allan\AppData\Roaming\Apple Computer\MobileSync\Backup\eef6b1ee12ae4c6ce77436ebd44a900442fc8e5a\*.*"Unknownhttps://www.blogger.com/profile/10132045796752180143noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-21994546261932105462011-04-25T20:12:01.859+00:002011-04-25T20:12:01.859+00:00@Joe
Timestamp is in the number of seconds since ...@Joe<br /><br />Timestamp is in the number of seconds since 01.01.2001 00:00:00<br /><br />To display it in excel do this:<br />A1: 01/01/2001 00:00:00<br />B1: 319823837.4 (YOUR time value)<br />C1: =A1+B1/86400<br />(86400 is a magic number for time in excel)<br /><br />Might have to format C1 as dd/mm/yyyy hh:mm:ss to display once the formula is done.Ben Sharifhttps://www.blogger.com/profile/00714117367431397963noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-71813657706671394832011-04-25T20:07:48.191+00:002011-04-25T20:07:48.191+00:00Hi, here's a rough way to map the data to Goog...Hi, here's a rough way to map the data to Google Earth.<br /><br />1. Get the CellLocation table ipened in SQLite (should already be done)<br /><br />2. Go File>Export>Table as CSV<br /><br />3. Select the 'CellLocation' table from the dropdown<br /><br />4. Save the file as something (I suggest CellLocation.csv)<br /><br />5. Open the .csv up in excel and delete all the columns except Timestamp, Latitude, Longitude<br />(Arrange the data so that Timestap is in column A, lat in column B etc.) Then delete the headings so that the only data you have is a bunch of numbers.<br /><br />6. Then save and close the file.<br /><br />7.Go to:<br />http://www.gpsvisualizer.com/map?form=googleearth <br /><br />8. In the box that says 'Paste your data here' delete the word 'desc' so that the only text now is:<br />name,latitude,longitude<br /><br />9. Open your csv file back up but this time in a text edotor (Word or Notepad should do)<br /><br />10. Copy and paste the data into the text box on GPS Visualiser (beneath the line that says: name,latitude,longitude)<br /><br />11. Click Create KML and save the resulting file. <br /><br />12. Open in Google Earth to view your data points. The numbers for each data points are actaully the time in seconds after 01.01.2001 00:00:00<br /><br />13. That website has many other parameters that you can mess with if you know what your doing (eg. trackpoints will draw a nice line etc).<br /><br />Enjoy.Ben Sharifhttps://www.blogger.com/profile/00714117367431397963noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-24232401614476488712011-04-25T19:52:39.043+00:002011-04-25T19:52:39.043+00:00This comment has been removed by the author.Myrtle's missushttps://www.blogger.com/profile/14416467791441464729noreply@blogger.comtag:blogger.com,1999:blog-2023001108419895986.post-2699340227528438052011-04-25T19:09:27.793+00:002011-04-25T19:09:27.793+00:00What format is the timestamp columb. I can't g...What format is the timestamp columb. I can't get excel to display the date & time correctly.Unknownhttps://www.blogger.com/profile/14765099648068527118noreply@blogger.com