Converting TomTom POI's to CSV

paulsto · Occasional Visitor Joined: Feb 13, 2005 Posts: 7

Hi All,

got my 4420 today and I was wondering if there is any easy way to convert TomTom POI's to CSV format so that we can use them with SmartST Pro V3?

Thanks
Paul

lbendlin · Posted: Tue Feb 15, 2005 9:25 pm Post subject:

Yes, you use DumpOV2.exe , then import the ASC file into Excel (tab delimited) and then export from Excel into CSV format.

Alternatively you find a text editor that allows replacing of Tabs with commas.
_________________
Lutz

Report Map Errors here:
TomTom/TeleAtlas NAVTEQ

Tim Buxton · Posted: Tue Feb 15, 2005 9:35 pm Post subject:

Or, you could use this, from our very own Oldie.

Open as an .ov2 file, save as a .csv file. Use Notepad to open the resulting .csv file, strip out the top line and resave. Then load the final file onto your iPAQ using the Navman Desktop.
_________________
Tim

icsys · Posted: Tue Feb 15, 2005 9:39 pm Post subject:

Alternatively you can check here to see if there are any that interest you.
If you don't see what you want just let us know what you would like.

Alternatively try POIConverter which is available from the download section to convert your own.
_________________
Ian.
iPAQ 2210 | Navman 4100 BT Receiver
Navman iCN 635
TomTom GO
Anquet OS mapping

paulsto · Occasional Visitor Joined: Feb 13, 2005 Posts: 7

Thanks guys, loads of help...

Just a couple of questions, I'm doing the conversion to CSV and the long and lat seem correct, removing the header columns, but when imported i can't see the POI icons on the map... I have set the visibility to high and I can see all of the speed camera icons (also at high), but i can't see them...

Any idea's?

icsys · Posted: Wed Feb 16, 2005 1:56 am Post subject:

Check you have specified the correct path to the icon file in the POI Options window.
It may be defaulting to the camera icon.
_________________
Ian.
iPAQ 2210 | Navman 4100 BT Receiver
Navman iCN 635
TomTom GO
Anquet OS mapping

paulsto · Occasional Visitor Joined: Feb 13, 2005 Posts: 7

Ok, I worked it out... the CSV files saved from Excel do not have "" surrounding the text, when these are missing it appears that this fails.

Mmmm lots of manual editing....

lbendlin · Posted: Wed Feb 16, 2005 2:38 am Post subject:

I think you can set this somewhere in Excel so that the quotes are included
_________________
Lutz

Report Map Errors here:
TomTom/TeleAtlas NAVTEQ

Tim Buxton · Posted: Wed Feb 16, 2005 7:21 am Post subject:

paulsto · Occasional Visitor Joined: Feb 13, 2005 Posts: 7

, wow take a chill pill, I just do things my own way... :-)

Anyway, I would recommend using export to AutoRoute Pushpin format and then use Word to find and replace ,"" with nothing and its the fastest way. Much faster than editing the files manually...

I am going to put the POI files up on an FTP site if anyone is interested, will update soon... I converted the following:

Woodlands
AA Walks in Berkshire
AA Walks in Surrey
Perhistoric Monuments
National Trust Sites

Cheers
Paul

Simon1 · Posted: Wed Feb 16, 2005 3:13 pm Post subject:

I'd be really interested in some of those POI's - please let us know where and when you post them!!!

Tim Buxton · Posted: Wed Feb 16, 2005 5:26 pm Post subject:

paulsto · Occasional Visitor Joined: Feb 13, 2005 Posts: 7

Noted, I can appreciate how annoying n00bs must be... hmmm... like me... anyway I'll make sure I follow instructions explicitly so as not to incure your "Red Wrath" again... :-)

Well, I have finished with the databases and thought I would share. I have converted the following but included the original files...

AA_walks_Berks
AA_walks_Surrey
Attractions_UK
Brochs
Lighthouses
London_Congestion_Zone_Entry_Points
National_Trust_Sites
nature_reserves
Prehistoric_Monuments
Roman_Sites
Woodlands
Zoo

http://eyeforimages.members.winisp.net/poi.zip

Hope this of use to someone...

Cheers
Paul

paulsto · Occasional Visitor Joined: Feb 13, 2005 Posts: 7

Just added Early_Churches to the list as well... same URL.

	PocketGPS
	Web