Results 1 to 2 of 2
-
11th May 2020, 07:03 PM #1
POI Manager Excel
Dear forum friends,
In the emptiness of the corona time, I tried to make a new useful tool for you.
This is my POI_Manager_Excel in Excel.
For the moment you can read and write TomTom OV2-files and universal CSV-files with it.
A read file can be changed (edited) and wrote back as a CSV- or OV2-file.
You can also create your own files with it by typing the POI-s in the sheet and write the to a CSV- or OV2-file.
This is the first version and I hope to expand it in later versions.
You are free to suggest new parts for it.
To understand TomTom OV2 file you got to know some things about them.
They are binary files with different sorts of records.
Record type 0, 2, or 3 are all build in the same structure:
These records has variable record lengths because of the string part which describes the POI.Record Byte(s) Contents 0 Record Type (0, 2, or 3) 1 through 4 Record Length 5 through 8 Longitude 9 through 12 Latitude 13 through (Record Length - 1) Null-terminated string value(s)
Type 2 is a regular POI record, type 0 is a deleted POI record and type 3 is an Extended POI record.
And record type 1 has the following structure:
These records are so called “Skippers” and are used by TomTom devices for index purposes.Record Byte(s) Contents 0 Record Type (1) 1 through 4 Block Length (bytes to skip) 5 through 8 Longitude of NE corner 9 through 12 Latitude of NE corner 13 through 16 Longitude of SW corner 17 through 20 Latitude of SW corner
If you make a (large) POI files without Skipper-records your device needs a lot of time to search in the file. With type 1 records it can jump (Skipping) faster through the file.
I have managed to integrate a little (free) program I found on the internet called OV2optimizer.
This program adds and corrects the Skipper-records to a set of POIs. It runs on the moment the POIs are saved, if you choose so. Otherwise the POIs are saved without Skipper records.
In the map you find a sub map OV2optimizer. Just leave it there and the program can use it.
You can also run the OV2optimizer by hand by starting OV2optimizer.exe. It will first ask you for the input .ov2 file and after processing ask you for the name of the output .ov2 file.
The rar-file needs to be unpacked with rar 5.x
There are 3 example OV2-file in it. 2 of camper places in the Netherlands and Belgium.
The third one are a few Hotels and camper-places in New Zealand from a personal journey in that fantastic part of the world , which I added because it is small (fast) and to prove myself that my tool also works correct with coordinates ”Down under”.
So have fun with this POI_Manager_Excel and please let me know what you think of it.
Regards
Peter
Last update June 5 8:00 PM
Added OV2optimizer to the toolPeterHimself Reviewed by PeterHimself on . POI Manager Excel Dear forum friends, In the emptiness of the corona time, I tried to make a new useful tool for you. This is my POI_Manager_Excel in Excel. For the moment you can read and write TomTom OV2-files and universal CSV-files with it. A read file can be changed (edited) and wrote back as a CSV- or OV2-file. You can also create your own files with it by typing the POI-s in the sheet and write the to a CSV- or OV2-file. This is the first version and I hope to expand it in later versions. You Rating: 5Last edited by PeterHimself; 5th June 2020 at 11:58 PM. Reason: once again a new update
Collection; NAV2: GO 300 (M1); ONE XL (L1); GO XXL (GQ); GO XL (RS); GO 910 (V7); GO 950 LIVE (W1)
NAV3: GO 820 LIVE (FU) NAV5: GO 5200 (ZB)
-
The Following 9 Users Say Thank You to PeterHimself For This Useful Post:
- [ Click To Expand ]
-
4Wheel (22nd May 2020), biggerdave (11th May 2020), jpgblue (6th June 2020), k1w1_123 (9th November 2023), Orni (11th May 2020), pe1agp (6th June 2020), pelopinm (7th July 2020), Poteo_Roke (11th May 2020), Xius27 (13th May 2020)
-
5th June 2020, 11:59 PM #2
Update in post #1: June 5 8:00 PM
Added OV2optimizer to the tool.
PeterCollection; NAV2: GO 300 (M1); ONE XL (L1); GO XXL (GQ); GO XL (RS); GO 910 (V7); GO 950 LIVE (W1)
NAV3: GO 820 LIVE (FU) NAV5: GO 5200 (ZB)
-
The Following 8 Users Say Thank You to PeterHimself For This Useful Post:
- [ Click To Expand ]
-
biggerdave (6th June 2020), jpgblue (6th June 2020), Orni (7th June 2020), pe1agp (6th June 2020), pelopinm (7th July 2020), Poteo_Roke (6th June 2020), vista00 (6th June 2020), Xius27 (6th June 2020)
iGO R3 HERE EUROPE 2023.Q4
Thank you very much for the contribution