View previous topic :: View next topic |
Author |
Message |
mickego Occasional Visitor
Joined: Feb 23, 2009 Posts: 8
|
Posted: Mon Feb 23, 2009 1:18 am Post subject: Convert Garmin CSV to upi |
|
|
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] |
|
Back to top |
|
|
scarymonkey Lifetime Member
Joined: May 09, 2007 Posts: 454 Location: Worcestershire
|
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). |
|
Back to top |
|
|
mickego Occasional Visitor
Joined: Feb 23, 2009 Posts: 8
|
Posted: Mon Feb 23, 2009 1:32 am Post subject: |
|
|
it is to V 2009 |
|
Back to top |
|
|
mickego Occasional Visitor
Joined: Feb 23, 2009 Posts: 8
|
Posted: Mon Feb 23, 2009 8:46 am Post subject: |
|
|
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. |
|
Back to top |
|
|
mickego Occasional Visitor
Joined: Feb 23, 2009 Posts: 8
|
Posted: Mon Feb 23, 2009 12:51 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
scarymonkey Lifetime Member
Joined: May 09, 2007 Posts: 454 Location: Worcestershire
|
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. |
|
Back to top |
|
|
mickego Occasional Visitor
Joined: Feb 23, 2009 Posts: 8
|
Posted: Tue Mar 03, 2009 4:57 pm Post subject: |
|
|
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. |
|
Back to top |
|
|
mickego Occasional Visitor
Joined: Feb 23, 2009 Posts: 8
|
Posted: Tue Mar 03, 2009 7:08 pm Post subject: |
|
|
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. |
|
Back to top |
|
|
scarymonkey Lifetime Member
Joined: May 09, 2007 Posts: 454 Location: Worcestershire
|
Posted: Tue Mar 03, 2009 9:04 pm Post subject: |
|
|
I totally missed that in the first post ...
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. |
|
Back to top |
|
|
mickego Occasional Visitor
Joined: Feb 23, 2009 Posts: 8
|
Posted: Tue Mar 03, 2009 10:09 pm Post subject: |
|
|
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. |
|
Back to top |
|
|
scarymonkey Lifetime Member
Joined: May 09, 2007 Posts: 454 Location: Worcestershire
|
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. |
|
Back to top |
|
|
mickego Occasional Visitor
Joined: Feb 23, 2009 Posts: 8
|
Posted: Tue Mar 03, 2009 10:50 pm Post subject: |
|
|
Show me 1 line of Your format
and I can fix it |
|
Back to top |
|
|
|
Posted: Today Post subject: Pocket GPS Advertising |
|
|
We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
Have you considered making a donation towards website running costs?. Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!
|
|
Back to top |
|
|
|