Tutorial POI TomTom Best is to use the CSV file and make it TomTom Compliant

From FON Wiki Beta

Jump to: navigation, search

CONVERSION of FON POI data to TomTom OV2 format

by Legiers

Created in January 2008 

This conversion is only 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 themselves!
  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. In this window (2 of 3) enable ; and click on NEXT
  13. In window 3 enable "Text" (first column) and then choose NEXT
  14. In the spreadsheet there are now the coördinates in column A and the address 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 cell C1 and paste/type the text [=TEXT.CONCAT(A1;B1)] without the []
  22. Copy this cell 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 to 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 the same 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.
Retrieved from "http://wiki.fon.com/wiki/Tutorial_POI_TomTom_Best_is_to_use_the_CSV_file_and_make_it_TomTom_Compliant"
Personal tools