Deleting individual entries from Location History

 

menu36a.jpg

The primary improvement that the Version 3.6 upgrade to my Routes Menu allows is the ability to be able to delete individual Location History items from your iGo.db file vs. your only option previously which was to CLEAR ALL.    I wish to thank WildBill very much for seeing this project through to fruition.   It serves it’s mission quite nicely considering that it isn’t a dedicated program like POI Explorer.   He has come through with a SQL script that does the actual repairs to a temporary working copy of iGo.db and “vacuums” it when it is completed.   You do not have to know SQL to take advantage of this program  )

The file includes Version 3.6 of Routes.mscr and the SQL file that WildBill wrote.  The menu has been rewritten to coincide with the LITE Unlock as well, and will serve as my upgrade for that version without the need for a seperate version.

Simply download the  upgrade  and extract all of the files into the Script folder.

Routes.mscr will create a working folder on your SD card for the temp file and will copy the SQL script there as well, so that if you use a SD card reader, you will not have to link up your Mio to your PC to perform this editing.   This also allows you to revert back to the original iGo.db file if you decide you are unhappy with the results of your editing.

NOTES:

  1. For those not using a Mio C230 or not using my Unlock packages, or not wishing to take advantage of the Menu to prep the working file, I’ve explained exactly what steps 1 and 9 do, so that you can edit the file regardless, but you will need to create   \Storage Card\iGo_Work   folder, and copy   Reset_History.sql   to that folder.   That is the only file you need to extract in this case.
  2. For those not using a SD card, I suggest either editing Routes.mscr by replacing  “\Storage Card\iGo_Work”  with   “\My Flash Disk\Script\iGo_Work”   (use the Find and Replace tool in your editor so as to catch all instances <without the quotes> in the file)   OR   simply alter the manual process instructions mentioned in Note 1.
  3. The SQL script only addresses HISTORY_V4 changes.   Do not manually delete entries in other tables like City History and expect the SQL script to patch-up the database for those changes.
  4. As we gain more confidence in this procedure, we may be able to skip the working file concept altogether, and edit the actual iGo.db, but it would involve linking your Mio to the PC each time which would in turn result in a soft or hard reset being required after unlinking.
  5. When you back up your Mio C230 (saves your POIs, favorites, Recent Cities and other History lists as well as your preferences within the various settings menus) within MioMap 3.3, it saves the data as iGo_backup.db in the root of your SD card so that you are able to restore your settings.   So if you don’t back-up your C230 after you’ve edited your Location History entries, they may reappear again should you ever use the Restore option.

You will need to download the free Personal version of SQLite Expert to your PC in order to be able to perform this editing.    Bill has asked that I convey heartfelt thanks to the author of SQLite Expert, Bogdan Ureche as well, since he makes this great tool available free of charge and helped in the development of the SQL script. 

Instructions

[BEFORE YOU FOLLOW THE PROCEDURES TO MODIFY YOUR MIO C230, KNOW THAT YOU MIGHT RENDER YOUR C230 UNUSABLE AND YOU MIGHT VOID YOUR WARRANTY. YOU DO THIS AT YOUR OWN RISK.]

  1. Choose the “Prep Location History file” option in the MioMap menu (which first backs up \My Flash Disk\MioMap\MioMap2\iGo.db    to    \My Flash Disk\MioMap\MioMap2\iGo_orig.db    and then copies  \My Flash Disk\MioMap\MioMap2\iGo.db    to     \Storage Card\iGo_Work\iGO_working.db3).     Then, either link up your Mio and your PC with the SD card inserted  OR  if you have a SD card reader attached to your PC, remove the SD card and insert it into your reader
    menu36b.jpg
  • Run SQLite Expert Personal and open the working file \Storage Card\iGo_Work\iGO_working.db3  which will show up in your PC as the drive letter assigned to your SD card  (ie.  g:\iGo_Work\iGO_working.db3 ) 
    step3.jpg
  •  

  • The tables and views will be displayed in the left tree panel. Click on the HISTORY_V4 table to display it in the right panel.
  • Click on the DATA tab to display the records in the table.
  • To reveal the blob information stored the DATA field for a record, double click on the BLOB to open the hex editor.
    step5.jpg
  • To delete a highlighted record, click on the delete record button ( – ).
  • Repeat for any other entries you wish to delete from the HISTORY_V4 table. Then click on the SQL tab to open the upper SQL edit window.
  • Select SQL >> Load the SQL Script (\Storage Card\iGo_Work\Reset_History.sql) >> Execute the SQL script (F5 or the folder with the lightning bolt icon).  The working file is now ready to replace your iGo.db file.  
    step8.jpg
  • Power up your C230 and reinsert the SD card into it.    Choose the “Save edited Location History file” option in the MioMap menu (which copies \Storage Card\iGo_Work\iGO_working.db3    back to    \My Flash Disk\MioMap\MioMap2\iGo.db).   If you wish to revert back delete \My Flash Disk\MioMap\MioMap2\iGo.db and rename iGo_orig.db to iGo.db
  • Advertisements

    12 Comments »

    1. eric orsini said

      aaagghh! i’m a lazy sumbum. there’s gotta be an easier way to delete history entries individually. please…

    2. c230 said

      Eric,

      Until this routine was developed, the only choice was Delete All. I agree it isn’t the easiest, but it works! I’ll be the first to publish any alternatives you come up with 🙂

    3. murphyfields said

      C230

      Do you know of any way to access the most recent history entry outside of miomap. I am thinking of a geocaching application where you use miomap to get you close, then exit miomap and use beeline or something similar to take you the rest of the way. If that could be semi-automated, it would be great.

    4. c230 said

      No, but perhaps the exit script could copy the destination coordinates into the clipboard, which could then pasted (cntl-V) into BeeLine using the vrtual keyboard via the taskbar.

    5. murphyfields said

      I was thinking of something like that, but I guess the trick is determining the destination coordinates.

    6. Wild Bill said

      murphyfields,

      I use GPS Visualizer.com to convert the loc files to kmz format, the converter will allow you to combine up to six pages of cache locations into one kmz file. Then I use POI Explorer to load the kmz file into a MIO POI folder and the loc files are copied to the SD card and imported into BeeLine. Use MIO to get you close, then start BeeLine and sort the stored caches by distance from your present location.

    7. murphyfields said

      Wild Bill

      Almost exactly my plan (although I am hoping to write a GSAK macro to do those steps, and hopefully modify some icons to help. Then I would like to exit miomap, and automatically open BeeLine and have it go to whatever I was seeking in miomap. Not sure if I can, but that is the goal.

    8. Larry said

      It’s very confusing as to which files to download. I guess I need a “cookbook method” from download to installation including file names. For us dummies it doesn’t seem very easy.

    9. c230 said

      Larry,
      I don’t know what could be easier than…

      Simply download the upgrade and extract all of the files into the Script folder.

      and I think I explain what each file does, so that you have the option of performing the function manually without the menu.

    10. Larry said

      I was looking in the wrong place. What a DUH. I’ve got the files now. Tks.

    11. pat said

      bought a c230 on ebay used. it still has the previous owners home address icon. how do i delete it and put mine there?

    12. ameridan said

      General Settings, Set Favorite Destinations, Home, Change address

    RSS feed for comments on this post

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s

    %d bloggers like this: