Convert Garmin CSV to upi

mickego · Occasional Visitor Joined: Feb 23, 2009 Posts: 8

I Just found McGuider the other day :-)

I have accesss to daily updated speedcams for GArmin in csv format
and I needed a tool to convert them to UPI.

I made one in VB6, and maybe some other guy need it.

It has Poi Convertor.exe buildin
and converts csv to txt and then uses Poi Convertor.exe
to get the final Output.

here´s a link to it

http://rapidshare.de/files/45557319/CSV2UPI.zip.html

------ ReadMe.txt ----------

Drag and drop a Garmin csv Cam file on this one
to convert to upi file.
UPI will be located in same folder as csv-file.

If You keep Iconfile with same name as CSV file
(Cam_90.csv Cam_90.bmp)
in same folder as csv file, upi file will use that bmp.

If No Icon files in Folder,
there are Build in Icons for
30-40-50-60-70-80-90-100-110-120-130

Make sure speed is inside name of csv file,
it will trig soft to use embedded Icon.

Make sure path to exe is not a huge one,
VB6 dont like long path or spaces inside path.

Smart way to use this is to make a Shortcut to EXE and put it in Send To folder,
this will make it possible to rightclick a csv-file and select SendTo CSV2UPI.exe

Another option is to start CSV2UPI.exe with Argument ALL
(c:\CSV2UPI.exe ALL)
It will convert all csv-files located in tha folder of the exe.[url][/url][url][/url]

scarymonkey · Posted: Mon Feb 23, 2009 1:29 am Post subject:

Which version of McGuider does this convert files to? There is a difference between the UPI files in 2008 (Drive 7.5) and 2009 (Drive 7.7).

mickego · Occasional Visitor Joined: Feb 23, 2009 Posts: 8

it is to V 2009

mickego · Occasional Visitor Joined: Feb 23, 2009 Posts: 8

Updated version now.

http://rapidshare.de/files/45564311/CSV2UPI.zip.html

It can get CSV files from URL's specified in config file

Example attached in Zip

_-------------------------------------------_

######## Updated function to get CSV from net and directly convert ###########

This means a MSinet.ocx must be registered on Your System,
and when using it, maybe Your firewall will tell You
some soft will connect to Net.

This is of cause a must if You want to get files from Net :-)

No danger what so ever.

Add a textfile
Garmin_Url.txt
to Same folder as EXE file.

Format like this
AAA;BBB;CCC;DDD
all 4 positions MUST be set !!!

AAA= Info You will see in listbox
BBB= Url to specific CSV-File
CCC= Name of file after fetched from URL
(Will be used in UPI and TXT output)
DDD= If set to 1, Entry will be Checked in Listbox
When program is loaded

(You can set up to 200 lines in file.)
Like this:
SWE-All Cam;http://hem.bredband.net/speedcam/filer/gar_fartkameror.csv;All_Cams.csv;1
SWE-30 Cam;http://hem.bredband.net/speedcam/filer/gar_30.csv;30_Cams.csv;1
SWE-50 Cam;http://hem.bredband.net/speedcam/filer/gar_50.csv;50_Cams.csv;1
SWE-60 Cam;http://hem.bredband.net/speedcam/filer/gar_60.csv;60_Cams.csv;1
SWE-70 Cam;http://hem.bredband.net/speedcam/filer/gar_70.csv;70_Cams.csv;1
SWE-80 Cam;http://hem.bredband.net/speedcam/filer/gar_80.csv;80_Cams.csv;1
SWE-90 Cam;http://hem.bredband.net/speedcam/filer/gar_90.csv;90_Cams.csv;1
SWE-100 Cam;http://hem.bredband.net/speedcam/filer/gar_100.csv;100_Cams.csv;1
SWE-Laser Pos;http://hem.bredband.net/speedcam/filer/gar_la.csv;Laser.csv;1
SWE-Control Place;http://hem.bredband.net/speedcam/filer/gar_ko.csv;Control.csv;1

If Program is started with
URL as argument
and a Garmin_Url.txt is present,
Then checked entries in list will be fetched
converted and soft will close down after job is done.

mickego · Occasional Visitor Joined: Feb 23, 2009 Posts: 8

I´m so sorry, Bug in last version in Embedded Icons :-(
Didnt work as it should do, Full Path of Icon.bmp were used
when only Filename should be handled.

Embedded Icon also in wrong format :-(
did crash McGuider for me.

http://rapidshare.de/files/45566701/CSV2UPI.zip.html

Updated version again, using McGuiders own Cam-Icons
and fixed the first bufg with full path in UPI.

rgds Mickego

scarymonkey · Posted: Tue Mar 03, 2009 4:42 pm Post subject:

Do you have a version of this which will parse a folder for .csv files and then batch convert these (using an icon of the same name)?
The reason for asking is to get an easy convertor for the free POI files here. Currently the only way is to download them as TomTom files, convert using OV2UPI v2.3 and then convert again using Sygic POI Convertor.

mickego · Occasional Visitor Joined: Feb 23, 2009 Posts: 8

Do You mean a Local Folder in Your PC containing csv-files
and You will have them converted like above method ?

All in one go ?

Should be no problem to add this function.

mickego · Occasional Visitor Joined: Feb 23, 2009 Posts: 8

HeHe I allready got it implemented :-)

Another option is to start CSV2UPI.exe with Argument ALL
(c:\CSV2UPI.exe ALL)
It will convert all csv-files located in tha folder of the exe.

If Icon with same name as csv exist, it will be used.

scarymonkey · Posted: Tue Mar 03, 2009 9:04 pm Post subject:

I totally missed that in the first post Laughing Out Loud

...
In a future update, is it possible for an All tick box to be in the gui so you don't need to add the ALL parameter to a shortcut (or run from the command line)?

It would be good if the icon didn't have to be present and it just used the same name (with .bmp instead of .csv for the extension of course). I tend to forget about icons once I have installed the first set of POI, so in future updates I might end up with the wrong icon.

mickego · Occasional Visitor Joined: Feb 23, 2009 Posts: 8

Tickbox thing will be OK in next version
It will be an INI-file created when Tickbox is checked.
if Tickbox is set at startup, it will be started with ALL as Argument.

(Allready inside)
If no correct Icon is present, embedded icon vill be used
and extracted with Same name as poi file.
If You want to use another Icon, only replace it with Your own.

With correct name of course.

scarymonkey · Posted: Tue Mar 03, 2009 10:13 pm Post subject:

Cheers

Unfortunately the application doesn't like the fre poi downloads from here, though since they do not claim to be Garmin compatible I am not too surprised.

mickego · Occasional Visitor Joined: Feb 23, 2009 Posts: 8

Show me 1 line of Your format
and I can fix it

	PocketGPS
	Web