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.
- 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.
- 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.
- 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.
- 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.
- 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.
[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.]
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.