From FON Wiki Beta

Cette page n'est pas encore intégralement traduite !

Vous pouvez aider à la traduire en Français en suivant le guide de traduction.

CONVERSION of FON POI data to TomTom OV2 format

by Legiers

Created on Januari 2008

This conversion is needed as long as the file provided by the FON maps is not specifying the
location of the FONspot inside the OV2 file.
The characters specified between brackets [] need to be used. Not the brackets itself!

1. Download the FONspot data of the country you need in CSV format. The name will be FON_XX.CSV, whereas XX is the countrycode of the chosen country (BE=Belgium, DE=Germany, FR=France, ES=Spain, ...)
2. Open the CSV file inside Microsoft Excel or Openoffice Calc
3. Choose the head of Column A
4. Choose the menu option EDIT and choose "replace"
5. Search for : [,"]
6. Replace by : [,";"]
7. choose "replace all"
8. close the window
9. Select again Column A
10. Choose now the menu DATA and it's function "Text to columns"
11. Enable "Split" and click on NEXT
12. On this window (2 of 3) enable ; and click on NEXT
13. On window 3 enable "Text" (first column) and then choose NEXT
14. In the spreadsheet are now the coördinates in column A and the adres data in column B
15. Select column B
16. Choose menu option "EDIT" and function "REPLACE"
17. Search for : [,] (comma)
18. Replace by [ ] (3 spaces)
19. Choose "replace all"
20. Close the window
21. Put your cursor on cel C1 and paste/type the text [=TEXT.CONCAT(A1;B1)] without the []
22. Copy this cel untill the last line
23. Select Column C and right-click on Copy
24. Now select Column D and right-mouse-click on "paste special"
25. Enable "Values" and click on OK
26. Execute Notepad or [www.editpadpro.com/editpadlite.html Editpad Lite]
27. Paste the contents of Column D in the Empty File. Save as FON_XX.ASC (but instead of XX choose the countrycode)
28. Do not save the Spreadsheet file (don't react on alerts; you can still repeat these instructions later)
29. Close Excel
30. Start [www.poiedit.com/ PoiEdit]
31. Choese menu "Extra" and function "Batch Convert"
32. Select in the Left window the ASC file you just created and convert it in the right window to OV2-format
33. Copy the OV2 file to a map of the fitting map on your TOMTOM and add an icon file with thesame name (but with extension .BMP instead of ASC)
34. If you are using maps of Europe, you can put multiple FON_XX.OV2 files inside that same map.

Texte de sous-titre