Discussion:
Exporting list of stops in a route
(too old to reply)
Traveller
2010-07-24 17:11:45 UTC
Permalink
Is it possible to either export or print just the list of stops in a route in
MapPoint (or Streets & Trips) to an Excel, Word or any other kind of file?
Thanks.
Marvin Hlavac
2010-07-26 13:33:01 UTC
Permalink
Post by Traveller
Is it possible to either export or print just the list of stops in a route in
MapPoint (or Streets & Trips) to an Excel, Word or any other kind of file?
Hi Traveler,

In the new version of Streets & trips (or Mappoint), you may export your
route as .GPX file. Open that file in Excel, and then use the columns you
need, for example you may use just the column that contains addresses, or
you may use just the latitude and longitude columns.

The ability to export .GPS file is a new feature added to the product in the
current 2010 version. You are welcome to read more of what's new in Streets
& Trips 2010 in this review:
http://www.laptopgpsworld.com/2380-review-microsoft-streets-trips

Marvin


--------------------------------

Marvin Hlavac

Laptop GPS World
Website - http://www.laptopgpsworld.com/
Blog - http://www.laptopgpsworld.com/blog/
Facebook - http://www.facebook.com/laptopgpsworld
Twitter - http://twitter.com/laptopgpsworld
Richard Marsden
2010-07-26 16:18:26 UTC
Permalink
Post by Traveller
Is it possible to either export or print just the list of stops in a route in
MapPoint (or Streets & Trips) to an Excel, Word or any other kind of file?
Thanks.
As well as the GPX export, our RouteWriter product could be used with
MapPoint. Supports MapPoint 2002 onwards, but it does not support
Streets & Trips.

Further information and a free trial download can be found on the
RouteWriter website, here:

http://www.routewriter.com
--
Richard Marsden
Winwaed Software Technology LLC
http://www.winwaed.com
Tools and Add-ins for MapPoint - http://www.mapping-tools.com
The Geoweb Guru: http://www.geowebguru.com
unknown
2010-07-29 18:05:31 UTC
Permalink
hi,
Post by Traveller
Is it possible to either export or print just the list of stops in a route in
MapPoint (or Streets & Trips) to an Excel, Word or any other kind of file?
with Mappoint you have you WayPoint set and can Calculate Route ?
if yes, you just have to use ActiveRoute Object to find all Stops.

*** Xbase++ Code ***
//
// for Stops use geoPrintDirections
//
::lDirections:selected := {|| ::nPrintArea := geoPrintDirections }


METHOD MapBig:Printmap()
LOCAL lExit := .F.
LOCAL nEvent, oXbp, mp1, mp2
LOCAL oApp
LOCAL OutputFileName := ""
LOCAL Title := "Job MP Ausdruck"

IF ::oAXControl:ActiveMap:ActiveRoute:IsCalculated()
ELSE
::oStatus:Setcaption( "bitte warten ... Route wird berechnet" )
::oAXControl:ActiveMap:ActiveRoute:Calculate()
::oAXControl:ItineraryVisible := .F.
::oStatus:Setcaption("Entfernung
"+LTRIM(STR(::oAXControl:ActiveMap:ActiveRoute:Distance(),10,2) )+" KM")
ENDIF

oApp := DlgPrint():New()
oApp:close := {|| lExit := .T. }
oApp:ButtonCancel:activate := {|| lExit := .T. }
oApp:ButtonOK:activate := {|| ::oAXControl:ActiveMap:PrintOut(;
OutputFileName ,;
Title ,;
oApp:nCopies:getdata() ,;
oApp:nPrintArea ,;
oApp:nQuality ,;
oApp:nOrientation ,;
oApp:lCollate ,;
oApp:lLegend ,;
oApp:lOverview ,;
oApp:lFaxable ) ,;
lExit := .T. }

oApp:oCollate:selected := {|lCheck, uNIL, self | oApp:lCollate :=
!lCheck }
oApp:oLegend:selected := {|lCheck, uNIL, self | oApp:lLegend :=
!lCheck }
oApp:oOverview:selected := {|lCheck, uNIL, self | oApp:lOverview :=
!lCheck }
oApp:oFaxable:selected := {|lCheck, uNIL, self | oApp:lFaxable :=
!lCheck }

oApp:Create()
oApp:oDetail:show()
oApp:oDetail:dohotkey()
SetappFocus(oApp:oDetail)

nEvent := xbe_None
DO WHILE .NOT. lExit
nEvent := AppEvent ( @mp1, @mp2, @oXbp )
oXbp:HandleEvent ( nEvent, mp1, mp2 )
ENDDO

oApp:destroy()

SetAppFocus(::oExit)

RETURN self
*** eof ***

greetings by OHR
Jimmy

Loading...