Importing tomtom POIs into sygic

[andy_p2uk]

Here's a program to sort POIs in csv files and filter them by coordinate ranges.

The process to get a load of POIs from tomtom is then:

for each OV2 file to import:
* run PoiConverter to convert tomtom ov2 file into csv file
* run PoiFilter to strip out POIs that aren't in the area of interest and put on the sygic header
run the sygic rupi import tool to turn all the csv files into rupi files
copy all the .rupi files onto the phone
add bitmaps
run sygic so it picks up the new POIs
associate POIs with bitmaps and alerts

The items in the 'for each' section can be done in a batch file, which means the while process can be repeated easily if the POIs are updated. There's a sample batch file that processes all ov2 files in a directory here

Usage: PoiFilter -i <inputfile> -o <outputfile> -f <filterfile> [-s <sortorder>] [-v] <inputfile> is just a csv file containing longitude, latitude, and a load of other fields that are passed through verbatim. <outputfile> starts with a header for sygic ("delimiter=,") then any lines from the input that match the specified filter. <filterfile> defines a csv file containing multiple rectangles, one on each line, that cover the area on the map to include. Each line contains min longitude, min latitude, max longitude and max latitude of a rectangle. If a point in the input file falls in any of the rectangles it is sent to the output file. I've worked out some filter rectangles to cover the uk mainland and ireland, but it shouldn't be difficult to create one for e.g. the whole of europe. <sortorder> is a number from 1 to 4 1: ascending latitude, west to east 2: descending latitude, east to west (recommended) 3: ascending longitude, south to north 4: descending longitude, north to south other numbers or not specified: sort randomly -v just turns on some extra debugging output.

I've included the program and the source, in case it helps anyone else.

[356Speedster]

I've been trying to import POIs into the Windows XP/7 version of Sygic with no joy.... it won't pick up the .upi files from the map\import folder and the Sygic Convertor program (which is supposed to convert .upi files to .rupi files, as you note above), won't run on Win8. Can anyone advise an alternative tool to convert to .rupi files and whether the process of dropping the files into maps\import is correct for the XP/7 version of Sygic? Thanks!

[andy_p2uk]

I've not heard of an alternative tool.
You should be able to run the sygic converter in a virtual xp machine under win8 though - I do this for some x86-only service manual cds on win7 x64.
Virtual XP mode was included with win7, but these posts show ways to do it in win8 too:

• Win XP mode in Win 8
• How to Run Windows XP for Free in Windows 8

[Enzolino]

in this post is write....



Framework libraries are needed

and for used SYGIC RUPI CONVERTER :
If you get error: "side-by-side configuration is incorrect" and you cannot run convertor, you must install :
Microsoft Visual C++ 2005 Redistributable Package
Microsoft Visual C++ 2005 SP1 Redistributable Package
and then
Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package ATL Security Update
Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package MFC Security Update

[andy_p2uk]

I was creating rupi files from the SCDB speed cameras and came across a csv file that the rupi converter silently failed on, creating a 0 byte rupi file.
If I edit the file so the second half was processed first, it was ok, so all the points in the file are valid.
I modified the PoiFilter program to sort the points and tried different orders, and the only order where every file converted and imported without error was East to West (i.e. descending latitude).
Here's the new command line option:

Usage: PoiFilter -i <inputfile> -o <outputfile> -f <filterfile> [-s <sortorder>] [-v] <sortorder> is a number from 1 to 4 1: ascending latitude, west to east 2: descending latitude, east to west (recommended) 3: ascending longitude, south to north 4: descending longitude, north to south other numbers or not specified: sort randomly

I don't bother separating points into individual countries, but I still filter the world file to get just European POIs out (using eur.flt) as it makes the import files smaller.

Here's the batch file I use to process multiple ov2 files into csv for the rupi converter. It should be easy enough to adapt to different layouts
BatchImport.zip

While I'm here, does anyone else actually use PoiFilter, or is it just me?

[andy_p2uk]

deleted - duplicate of first post

[VGCC]

Hi,

I'm posting this reply to ask for some help for poi import.

I'm using sygic 12.2.2 for android. But i for my professional usage i've to import some poi's created by my client, but the sent folder are in KMZ, OV2.

So after following the above steps, I managed to import the data, it turns out that I can not see them, because the section of POI's is shaded, it is not possible to select / query this data.

One strange situation is the file in OV2 have 6,533kb, CSV have 6,888kb and after using the sygic convertion tool this stays with 21,388kb.

So can some one help me? If necessary i post here the file that i want to convert and import.

Best regards,

VGCC

[VGCC]

Hi,

I'm posting this reply to ask for some help for poi import.

I'm using sygic 12.2.2 for android. But i for my professional usage i've to import some poi's created by my client, but the sent folder are in KMZ, OV2.

So after following the above steps, I managed to import the data, it turns out that I can not see them, because the section of POI's is shaded, it is not possible to select / query this data.

One strange situation is the file in OV2 have 6,533kb, CSV have 6,888kb and after using the sygic convertion tool this stays with 21,388kb.

So can some one help me? If necessary i post here the file that i want to convert and import.

Best regards,

VGCC

[andy_p2uk]

Hi,

I'm posting this reply to ask for some help for poi import.

I'm using sygic 12.2.2 for android. But i for my professional usage i've to import some poi's created by my client, but the sent folder are in KMZ, OV2.

So after following the above steps, I managed to import the data, it turns out that I can not see them, because the section of POI's is shaded, it is not possible to select / query this data.

One strange situation is the file in OV2 have 6,533kb, CSV have 6,888kb and after using the sygic convertion tool this stays with 21,388kb.

So can some one help me? If necessary i post here the file that i want to convert and import.

Best regards,

VGCC

The only way to approach this is to break the problem into smaller parts and narrow in on where it's breaking.
For example:

• When you run PoiConverter on your OV2 and KMZ files, does the generated CSV look correct? Can you convert it back into OV2 or KMZ files that other programs can read? Are the POIs where you expect them?
• When you run the CSV through PoiFilter, does the CSV output look sensible? Has it filtered the points by the coordinates in the filter file you gave it?
• When you run the rupi converter, does it generate RUPI files with data in them?
• When you put the RUPI file in the right place on the phone and start sygic, does it see the files and offer to start importing them?
• It sounds like you've got this far, at least
• Do you have maps for the regions covering the POIs?
• If you try the entire process with just one POI, e.g. a csv with one line of data in it, does that work?

[scassar]

Hi,

You specify those package to be installed :
Microsoft Visual C++ 2005 Redistributable Package
Microsoft Visual C++ 2005 SP1 Redistributable Package
and then
Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package ATL Security Update
Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package MFC Security Update[/QUOTE]

I've got Windows Seven x64 in french release

Questions :
- Do I need to install those in x86 or x64
- Do I need to install those US version
- I can't find the ...ATL... and ...MFC... packages... could you help me ?

Thx in advance


EDIT : I've installed both x86 and x64 version in french and it's working like a charm

Thank you very much