View previous topic :: View next topic |
Author |
Message |
Fibre Frequent Visitor
Joined: Nov 17, 2004 Posts: 368 Location: Kettering, Northants, England
|
Posted: Wed Jan 19, 2005 1:58 am Post subject: AutoRoute to Excel |
|
|
any one know of how to transfer AutoRoute Push pins into Excel so that I can edit the data and then convert it into a poi file...
I can do the AutoRoute / poi bit...
But there is so much that I need to edit in the AR push pin file it would be easier in Excel... _________________ Happy to meet -- Sorry to part -- Happy to meet again |
|
Back to top |
|
|
lbendlin Pocket GPS Staff
Joined: 02/11/2002 22:41:59 Posts: 11878 Location: Massachusetts, USA
|
Posted: Wed Jan 19, 2005 4:04 am Post subject: |
|
|
Oldie has written a POIconverter tool that can do this for you. _________________ Lutz
Report Map Errors here:
TomTom/TeleAtlas NAVTEQ |
|
Back to top |
|
|
Sniff Regular Visitor
Joined: Nov 02, 2004 Posts: 123 Location: Munich, Germany
|
Posted: Wed Jan 19, 2005 9:25 am Post subject: |
|
|
Agreed, the excellent POI converter is the way to go. Simply create a route via your pushpins, save it, and run it throught the program. It extracts the pushpins and creates a POI file for you. No need for Excel or anything else. Highly recommended! :D
One small word of warning, if you install the program anywhere else other than the recommended location, you must not have spaces in the path, otherwise it won't work. |
|
Back to top |
|
|
rkm_hm Frequent Visitor
Joined: Nov 28, 2004 Posts: 532 Location: Warwick, UK
|
Posted: Wed Jan 19, 2005 11:10 am Post subject: |
|
|
Or, if you want to edit the data, you can save it in .csv or .xls format and open it in Excel. When you've finished editing it, you can convert it to a .ov2 POI file.
Roger |
|
Back to top |
|
|
Fibre Frequent Visitor
Joined: Nov 17, 2004 Posts: 368 Location: Kettering, Northants, England
|
Posted: Wed Jan 19, 2005 1:52 pm Post subject: |
|
|
I have created pushpins in AR -- no route - just pushpins --- put hem as red dots --
How can I get these puspins OUT of AR into Excel...
then edit them - in Excel...
once in Excel I can then convert into *.cvs format...
Its the first bit I want help with.. getting them out od AR.. _________________ Happy to meet -- Sorry to part -- Happy to meet again |
|
Back to top |
|
|
DocL Regular Visitor
Joined: Nov 15, 2004 Posts: 81
|
Posted: Wed Jan 19, 2005 2:01 pm Post subject: Re: AutoRoute to Excel |
|
|
Fibre wrote: | any one know of how to transfer AutoRoute Push pins into Excel so that I can edit the data and then convert it into a poi file...
I can do the AutoRoute / poi bit...
But there is so much that I need to edit in the AR push pin file it would be easier in Excel... |
Maurice, I'm ahead of you, just :D .
See replies in this thread http://www.pocketgpsworld.com/modules.php?name=Forums&file=viewtopic&p=81558#81558.
Seemingly we need the updated version of POIConverter because that pushpin file is cluttered with too much info. (for balloons??) which the present version can't handle.
Oldie, did you get my e-mail address? If not here it is again
doc4hobby@yahoo.co.uk . Still waiting to try out your 'beta' upgrade of the program!! T.I.A. _________________ Cheers, Doc L.
|
|
Back to top |
|
|
rkm_hm Frequent Visitor
Joined: Nov 28, 2004 Posts: 532 Location: Warwick, UK
|
Posted: Wed Jan 19, 2005 3:56 pm Post subject: |
|
|
Fibre wrote: | How can I get these puspins OUT of AR into Excel...
then edit them - in Excel. |
In case you haven't found the answer in another thread, you need to save your Autoroute map - complete with pushpins - as a .axe file.
[Some earlier versions of Autoroute don't use .axe files - but I think that these can export pushpins as a .csv file - achieving the same thing. Look in Help if all else fails!]
Then use POIConverter. This can read the .axe file and extract the co-ordinates and description of each point. Then save it as a .csv or .xls file - which you can open in Excel, and edit to your heart's content!
When you're happy with it, save it as a .csv, open it again in POIConverter, and save it as a .ov2 POI file. Bingo!
Roger |
|
Back to top |
|
|
Oldie Pocket GPS Moderator
Joined: 22/11/2002 13:33:48 Posts: 992 Location: Surrey, UK
|
Posted: Wed Jan 19, 2005 6:31 pm Post subject: Re: AutoRoute to Excel |
|
|
DocL wrote: |
Oldie, did you get my e-mail address? ... Still waiting to try out your 'beta' upgrade of the program!! T.I.A. |
DocL,
Just to complete the story so that others can follow the thread. Rather than send you a beta release of POIConverter v3.10 I processed the AutoRoute file myself and emailed the extracted/converted files to you. I am glad that you like the result.
I have used the site name, with Camp/Camping removed, which keeps the majority of the POI names less than 32 characters. TTN3 displays these in Map mode without a problem.
POIConverter v3.10 is still in the pipeline. Must get back to the speed camera updates now :D
Richard _________________ Various TomToms, Garmin eTrex Legend, GPSMAP 60CSx, Oregon 550t, Forerunner 405 |
|
Back to top |
|
|
DocL Regular Visitor
Joined: Nov 15, 2004 Posts: 81
|
Posted: Wed Jan 19, 2005 11:22 pm Post subject: |
|
|
Many thanks Oldie; a great service for all those interested in French Campsites, and thanks go to John Harrison (jollyinteresting), for compiling it in the first place.
In very broken French, I've posted on the gpsPassion forum, and even the Frenchies did not have a decent POI list for Campsites. Thinking I'll post something along the lines of "Ha Ha, mes amis, it takes some Englishmen to give you your French Campsite POI's!!!" but I'll get the French checked first, . . . . . and maybe a tin hat!
Merci Bien, Richard et al. _________________ Cheers, Doc L.
|
|
Back to top |
|
|
rkm_hm Frequent Visitor
Joined: Nov 28, 2004 Posts: 532 Location: Warwick, UK
|
Posted: Wed Jan 19, 2005 11:58 pm Post subject: |
|
|
DocL wrote: | Merci Bien, Richard et al. |
Et al is Latin!! |
|
Back to top |
|
|
DocL Regular Visitor
Joined: Nov 15, 2004 Posts: 81
|
Posted: Thu Jan 20, 2005 11:18 am Post subject: |
|
|
rkm_hm wrote: |
Et al is Latin!! |
All right 'clever clogs' :P, but I don't know the French equivalent, or even if they have one! Probably use Latin, but call it old French!!
What's the French for 'only joking'?
BTW, thanks again for your help, Roger. _________________ Cheers, Doc L.
|
|
Back to top |
|
|
Tim Buxton Pocket GPS Moderator
Joined: 14/09/2002 20:56:18 Posts: 5231 Location: Surrey, United Kingdom
|
Posted: Thu Jan 20, 2005 12:07 pm Post subject: |
|
|
rkm_hm wrote: | DocL wrote: | Merci Bien, Richard et al. |
Et al is Latin!! |
So DocL is multilingual! Nothing wrong with that, I reckon. _________________ Tim |
|
Back to top |
|
|
rkm_hm Frequent Visitor
Joined: Nov 28, 2004 Posts: 532 Location: Warwick, UK
|
Posted: Thu Jan 20, 2005 12:21 pm Post subject: |
|
|
DocL wrote: | BTW, thanks again for your help, Roger. |
No problem!
BTW, are you the same 'Doc' who was extolling the virtues of TTG in uk.rec.caravanning a little while ago? If so, it was largely because of your posts (I post there as 'Hitch Lock') that I became interested in the device and eventually bought one.
Roger |
|
Back to top |
|
|
lbendlin Pocket GPS Staff
Joined: 02/11/2002 22:41:59 Posts: 11878 Location: Massachusetts, USA
|
Posted: Thu Jan 20, 2005 3:01 pm Post subject: |
|
|
Ну хватит уже! _________________ Lutz
Report Map Errors here:
TomTom/TeleAtlas NAVTEQ |
|
Back to top |
|
|
DocL Regular Visitor
Joined: Nov 15, 2004 Posts: 81
|
Posted: Thu Jan 20, 2005 3:07 pm Post subject: |
|
|
Bingo Roger/Hitchlock, Yes, I'm de one. Had to post as DocL here, because Doc was already assigned.
I don't post so much on uk.rec now, because of the idiot 'trolls' who infect the forum. I post here http://www.touringandtenting.com/index.html as Doc again, and there are some nice folks there (e.g. David Klyne from uk.rec), although it has had it's own, odd, moment with 'idiots'.
Mais c'est la vie! _________________ Cheers, Doc L.
|
|
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 |
|
|
|