View previous topic :: View next topic |
Author |
Message |
darrend Occasional Visitor
Joined: Jan 01, 2007 Posts: 4
|
Posted: Tue May 15, 2007 12:32 pm Post subject: can i make a list of Favorites on an excel file and transfer |
|
|
hi all
can you help. i need to make a large list of Favorites for my tomtom 700 and its a pain typing them in one at a time on screen. is it possible to create a file with excel and copy it directly into the tomtom?
if so what file type would i save it at
thanks for your help
darren |
|
Back to top |
|
|
DennisN Tired Old Man
Joined: Feb 27, 2006 Posts: 14901 Location: Keynsham
|
Posted: Tue May 15, 2007 1:15 pm Post subject: |
|
|
I have no idea, but a quick use of the Search button found this. Try it and see if it gives any clues. _________________ Dennis
If it tastes good - it's fattening.
Two of them are obesiting!! |
|
Back to top |
|
|
DennisN Tired Old Man
Joined: Feb 27, 2006 Posts: 14901 Location: Keynsham
|
Posted: Tue May 15, 2007 1:22 pm Post subject: |
|
|
Apologies - I forgot to say
Even if that link doesn't help with favourites, it looks as though you could use it to make your list into a POI category so that you could navigate to POI if all else fails. _________________ Dennis
If it tastes good - it's fattening.
Two of them are obesiting!! |
|
Back to top |
|
|
Oldboy Pocket GPS Moderator
Joined: Dec 08, 2004 Posts: 10643 Location: Suffolk, UK
|
Posted: Tue May 15, 2007 1:23 pm Post subject: |
|
|
It depends what format, and details, you already have.
For any POI you will need 3 fields:
longitude, latitude, "Name Text"
The Name Text can contain what you like; name, telephone, Postcode, etc.
Do you have the long/lat of the locations you want?
Once you have the 3 field file you can save it as a Text File. A program, such as Makeov2 or POIConverter can then convert this into an OV2 File that the TT can use.
You will also need a bitmap, if you don't want the default red square. ;) _________________ Richard
TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1135 |
|
Back to top |
|
|
darrend Occasional Visitor
Joined: Jan 01, 2007 Posts: 4
|
Posted: Tue May 15, 2007 2:52 pm Post subject: |
|
|
thanks for the help so far guys. i did try the search myself but ended up with over 400 posts!!!
i was trying to aviod using POI to do this as i could end up with 300+ entries and wasnt sure what the limit was on the tt700.
i might have to try this way if all else fails
thanks all |
|
Back to top |
|
|
mikealder Pocket GPS Moderator
Joined: Jan 14, 2005 Posts: 19638 Location: Blackpool , Lancs
|
Posted: Tue May 15, 2007 5:34 pm Post subject: |
|
|
If you need a large quantity of locations the the POI file is the only real option.
Don't worry about the number of locations though, just consider the PocketGPSWorld Speed Camera file (single file version) it contains 11,000 + separate locations IIRC.
With the data in excel in the correct format conversion to the ov2 format is easy - Mike |
|
Back to top |
|
|
RQ Regular Visitor
Joined: Apr 08, 2006 Posts: 240 Location: Clevedon
|
Posted: Tue May 15, 2007 10:35 pm Post subject: |
|
|
As far as I know a favourites file can only hold 20 entries _________________ RQ
TT1v3 6.560 1713 UK&NI 660.1199
TTG700 6.520 1387 MoWE 660.1219 |
|
Back to top |
|
|
DennisN Tired Old Man
Joined: Feb 27, 2006 Posts: 14901 Location: Keynsham
|
Posted: Tue May 15, 2007 10:44 pm Post subject: |
|
|
darrend wrote: | thanks for the help so far guys. i did try the search myself but ended up with over 400 posts!!! |
I have to say I felt quite proud of myself with this search - I'm not usually this successful. For info, I searched for - Excel AND Favourites - All Terms - GO/Rider/ONE forum. And surprised the living daylights out of myself with the great result!! (the favourites was a waste of time, but Excel came up trumps)
I wish I could crack the Search here. I expect there's a RTFM about how to use it. _________________ Dennis
If it tastes good - it's fattening.
Two of them are obesiting!! |
|
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 |
|
|
|