GPS Forums

GPS POI Tools Forum

Compiling a huge CSV into TomTom OV2

Message
Posted by lewis4
Compiling a huge CSV into TomTom OV2

Hello all, after spending most of the weekend trying to make this work I am now ready to farm this out for help! :)

I need to create a OV2 file for TomToms, the data I need to use is the location name "1 ST SWATHING LN" for example, then the Lat Long. This is currently spread over three columns in an Excel CSV, there are about 40,000 entries that all need to be compiled into the same OV2 file.

I have managed to create a working OV2 file but on checking this there are only 23,000 entries when there should be about 40,000. Can anyone offer any assistance please, If needed I can post a link to the CSV file.

This is a snippet of the CSV content:

1 ST SWITHINS LN -0.088781343 51.513065
2 DELETE - FARRINGDON -0.10480009 51.516022
3 KENNINGTON 1 -0.10726592 51.487825
4 OLYMPIA -0.20488783 51.496105


Thanks to anyone that can help!

Posted by Mark
Re: Compiling a huge CSV into TomTom OV2

Hi Lewis,
I do not use tomtom anymore, but if I remember correctly:
Create 2 files, 20,000 lines each and copy them together:
e.g. Start > Command Prompt > copy 1.ov2 + 2.ov2 3.ov2

However, why not to keep 2 files?
Regards

GPS POI Tools



Page 1 of 1
Permalink Compiling a huge CSV into TomTom OV2