View previous topic :: View next topic |
Author |
Message |
ChillyCat Occasional Visitor
Joined: Sep 24, 2006 Posts: 6
|
Posted: Sun Mar 04, 2007 3:15 pm Post subject: Help to update Pilot Travel POI's |
|
|
Managed to get my TomTom Nav [PPC] working well
using the POI [truck stop] collections found @ GpsPasSion
The current POI listing [there] for Pilot Tavel is outdated.
[it's the one i'm curently using]
I accessed the online files:
http://www.pilotcorp.com/Locations/Find_Locations/#Downloadable_Locations_File
I downloaded both the .xls & .csv
I then attempted to make the .ov2 file using both POIedit & the online poi format app. FAILED. I keep getting all kinds of error messages
with both programs. Banged my head for a couple hours now....
So, would someone kindly make me a working file ? The Pilot link/url
above will lead you to the data base files. The POI datbase here on
this site has the .bmp and the .gpx file. [if needed]
Extremly gratefull for any/all assistance you'd give me.
If you could, please copy the file to here and chillycat3@gmail.com |
|
Back to top |
|
|
theripper Pocket GPS Verifier
Joined: Feb 07, 2006 Posts: 581 Location: Medway Towns, Kent
|
Posted: Sun Mar 04, 2007 5:40 pm Post subject: |
|
|
Hi ChillyCat
Have just tried using poi converter and it gives the message that it is an invalid format.
Looking at the xls file in exel I think there is just too much info in too many fields.
Tomtom requires only name.lat,long,info AFAIK
regards
theripper |
|
Back to top |
|
|
ChillyCat Occasional Visitor
Joined: Sep 24, 2006 Posts: 6
|
Posted: Sun Mar 04, 2007 7:09 pm Post subject: |
|
|
theripper wrote: | Hi ChillyCat
Have just tried using poi converter and it gives the message that it is an invalid format.
Looking at the xls file in exel I think there is just too much info in too many fields.
Tomtom requires only name.lat,long,info AFAIK
regards
theripper |
Well thanks for given it a go.
I'm thinking you ran into the same problem I did...... possibly suggesting
i'm not as mentally challenged as some would think. |
|
Back to top |
|
|
Andy_P Pocket GPS Moderator
Joined: Jun 04, 2005 Posts: 19991 Location: West and Southwest London
|
Posted: Sun Mar 04, 2007 9:59 pm Post subject: |
|
|
What you need to do is open up the downloaded file (either excel or csv) in excel.
Then delete all the columns EXCEPT the longitude, Latitude and Name columns.
Next, delete the first row (which are just the column headings)
Next, rearrange them so they are in the order Long, Lat, name (I think - it COULD be lat, long, name)
Finally, save as a csv format file.
This should open in POI Edit, from which you should then be able to save as an .ov2 format file. |
|
Back to top |
|
|
ChillyCat Occasional Visitor
Joined: Sep 24, 2006 Posts: 6
|
Posted: Mon Mar 05, 2007 12:29 am Post subject: |
|
|
Andy_P2002 wrote: |
Next, rearrange them so they are in the order Long, Lat, name (I think - it COULD be lat, long, name)
Finally, save as a csv format file.
This should open in POI Edit, from which you should then be able to save as an .ov2 format file. |
Lat.....then Long........name
worked !!!!!!
PoiEdit - had to jump thru hoops till it accepted the proper choice i had choose in wizard thangy.
Saved and dragged into me SD card. [overwriting existing]
Anyhoo..... seems to be working just fine. I'm sitting for the night, but tomorrow i'll give it a real world test.
Thanks alot for the assistance....greatly appreciated Mate |
|
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 |
|
|
|