POI import in C710

[fable]

Hi,
I read many people struggling with importing their own POI sets into C710. Has anyone tried yet to download the igo.db, insert POIs with poiconvert, then put the file back?

http://www.pdamill.com/~fable/poiconvert.exe


Fable

[Sallyann]

iGO.db is a 'sqlite' database. It contains several different tables to hold your own manually created POI's, as well as all your user settings. I would be surprised if POIConvert could change it.
You can open iGO.db using sqlite3.exe which you can get from www.sqlite.org, and if you are familiar with the SQL language you should be able to import POI's. However I've not tried this because I'm not interested in POI's except cameras. Cameras are NOT saved in iGO.db.
Let us know how you get on.

Sal

[mgrah]

I just had this idea myself, for my purposes importing POIs via the user data / user POIs is enough.

I'll check out your app when I get home.

/M

[mgrah]

Hmmm... Looks neat. I'll see if I can play around with it for a while, maybe try to add a few csv from POIHandler. I have some files here already, would be interesting to see if it's a good solution.

It lacks some info, though, like icons etc.

/M

[Simebaby]

POIConvert does work - it converts iGO.db into a .kml (google earth) file, which is jsut an XML document.

I've managed to write a script that converts a .csv file (from POIHandler) into a google .kml file. I then used POIConvert to convert this back to iGO.db, which worked fine.

Be aware that you do lose your saved settings when you do this (preferences, home location etc) - I assume they are stored in iGO.db as well.

[fable]

[fable]

You can import your POIs through an SD card as well. Backup your database (settings/advanced/user data management/backup DB), then import your pois into igo_backup.db, then do a "Restore DB"

[mgrah]

The SD card solution suits me best, easy to arrange things without having to unlock the device.

I've got it working as well, editing the finle manually. Before continuing though I have some questions:

Is it possible to crate an infinite number of user groups? I'd rather stick to putting items in groups.

Is it possible to change the icons somehow? That data is not included in the kml file, as far as I could see... It's present in the db-file though... But writing an application for SQLite sounds a bit too much work for me ;-)

/M

[fable]

No, you can't change the icon. I'll probably implement that too sometime.
I know a guy who wrote a free windows app which can do that but he hasn't released it yet.

[vladraq]

I've created an application that is creating iGO.KML (file with POIs to use with POICONVERT.EXE) with ICONS and PHONE NUMBERS.

Try it

http://pdi.romania.googlepages.com/

in iGO 2006 section, download iGO_POI.zip and read the README file.

Enjoy

[mgrah]

Anyone tried this on a C710/C510??

/M

[ernest_mio]

Tried it on my 710 (v3.11) and works fine.

[IronSoil]

I have also tried it on my C510 and it works fine...

[DeeJay01]

[ernest_mio]

The process if followed was:

Create ascii files for each category of POI (I created one for BMW dealerships, one for attractionsd etc).

Save these files in the ASC directory

Copy the - iGO.db from the C710 in the same folder with iGO_POI.EXE and POICONVERT.EXE

Run iGO_POI.EXE

This will open up with each of the ASCII filenames.

Select a POI category and icon for each file.

Run CREATE iGO.KML

This will create a single database file with all the categories merged together.

Run POICONVERT.EXE and press ENCODE button

Copy the new iGO.db back to the C710.

I now have all the original POIs plus the imported merged file. Some duplications but I can lib=ve with that - until SallyAnn works out how to edit the original Mio file

We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
Have you considered making a donation towards website running costs?.
Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!