en	Plans and routes: create a routes plan, apply zoning, optimize routes, export routes (roadmap, mobil, GPS, etc)

en	planning, route

en	Export Routes

en	Our tool allows you to export all your tours individually or simultaneously in different formats.

en	Exports via printouts, spreadsheets, and GPX / KML tracks (for GPS models connected by cable) are always available. If you have a mobility partner configured, its export options appear in the drop-down menu. Each vehicle must be linked to the corresponding mobility device :numref:`app-plannings-my_plan-export-1-240x300`.

en	Export Routes.

en	Export options

en	|inverser| Reverse order of stops: allows easy creation of loading lists, for example.

en	|mobile| Send to TomTom as waypoints: sends all stops in a tour to the associated TomTom device, as a single TomTom order passing in front of each stop.

en	|mobile| Send to TomTom as Orders*: sends all stops of a route to the associated TomTom device, in the form of multiple TomTom orders.

en	|mobile| Clear TomTom*: clears previous routes from your TomTom GPS device*.

en	|imprimer| Print: allows you to print your routes in the form of road maps to give to your drivers.

en	|tableur| Spreadsheet CSV / Excel: allows you to export your route in a spreadsheet.

en	|mobile| GPX Route: list of way points, sent to the GPS device of your vehicle in GPX format; your GPS can calculate your route.

en	|mobile| GPX Track: exact track of the route to take, proposed by our application, sent to the GPS of your vehicle in GPX format.

en	|mobile| KML Track: ditto, in KML format.

en	|email| KML Track by email: ditto, sent to the email address registered for the vehicle doing the route.

en	|calendar| iCal calendar: provides a download link for the .ics file. You can also copy this link via "right-click" > "copy link address".

en	|email| iCal calendar by email: sends .ics files to email addresses that have been entered for vehicles.

en	TomTom*: or other mobility partner, with these features available.

en	The date of the last data transmission is also shown.

en	:numref:`app-plans-export_sent_time`

en	Date of last transmission of GPS data.

en	CSV/Excel spreadsheet

en	When you click on the CSV/Excel Spreadsheet link, a modal window opens.

en	:numref:`plan_export_modale`

en	Export window for spreadsheet

en	All the information in a plan can be exported. Sorted into three groups, all information is exported by default.

en	To open a CSV file with Excel, please see the explanatory sheet.

en	Click on the |download| button to download the CSV file. It is stored on the PC in the Downloads folder.

en	Supported mobility partners

en	Alyacom

en	Teksat

en	TomTom WEBFLEET

en	Trimble

en	SuiviDeFlotte

en	Notico Deliv

en	Praxedo

en	Interfacing with Notico Deliv

en	After getting your logins from Notico Deliv', you have to go to "Global settings" page to save them.

en	These logins allow our application to send route plans and all necessary information to the Notico server. :numref:`app-plans-export_notico_param`

en	Export plan settings to Notico

en	In the Notico Deliv interface, in the "Configuration" menu then "Delivery drivers", you have to create or identify the delivery driver ID :numref:`app-plans-export_notico_param_id`

en	Notico interface

en	In the Notico Deliv interface, in the "Configuration" menu then "Delivery drivers", you have to create or identify the delivery driver ID :numref:`app-plans-export_notico_param_id`

en	Notico vehicle id

en	Once this information is saved, for each vehicle it is now possible to send a route directly to Notico Deliv '. On the displaying routes page, just click on the routes export icon and then click on "Send to Notico Deliv" :numref: `app-plans-export_notico_plan`

en	Export a plan to Notico

en	You can now find your routes in Notico Deliv:

en	Interfacing with Praxedo

en	Configuration within Praxedo

en	After getting your logins from Praxedo, you have to go to the Praxedo site to configure some data beforehand.

en	At least one tag must be defined for interventions (otherwise Praxedo doesn't take this stop into account) and respect the format: “praxedo:CODE_TYPE_INTERVENTION” (CODE_TYPE_INTERVENTION must exist in Praxedo). Example below « praxedo:LIV »

en	A "START" and a "STOP" tag must be created for the departure and arrival stores.

en	:numref:`app-plans-export_praxedo_type_intervention`

en	Praxedo interventions

en	In the Praxedo interface, in the "Setup" menu, then Equipment type, you need to create or identify the code for the equipment type.

en	:numref:`app-plans-export_praxedo_equip_code`

en	Praxedo material

en	In the Praxedo interface, in the "Administration" menu then "Technician", you need to create or identify the ID for each technician, and the synchronization ID, needed for the mobile application.

en	:numref:`app-plans-export_praxedo_tech_id`

en	Praxedo technician ID

en	Configuration within Mapotempo

en	The following criteria must be met for Mapotempo to send data that can be understood by Praxedo: - ""More than one visit per destination" mode must be enabled (option can be activated upon request) - On the "Global settings" page, you have to save your Praxedo logins. These logins allow our application to send the route plans and all necessary information to the Praxedo server. :numref:`app-plans-export_praxedo_param`

en	Praxedo vehicle setting

en	For each route to be sent to each of the vehicles in question, go to the "vehicle configuration" page in our application and save the unique ID for the vehicle corresponding to the "technician code" in Praxedo. :numref:`app-plans-export_praxedo_vehicle_id`

en	Vehicle’s Praxedo Technician code

en	For each visit:

en	A reference on the destination can be defined (to be completed when importing). It will be sent to Praxedo to identify the equipment name (equipmentName)

en	A quantity must be associated to the visit (to be picked up by Mapotempo). Sending to Praxedo, if the quantity exists on Mapotempo side for the route in question, it is updated.

en	A reference can be defined. It will be sent to Praxedo along with the "Code of material to be delivered"

en	Then, once that information is saved, for each vehicle, a route can be sent to Praxedo directly. On the routes display page, just click on the routes export icon and then click on "Send to Praxedo" :numref: `app-plans-export_praxedo_plan`

en	Export plan to Praxedo

en	You now can get your routes in the Praxedo web application, and transfer each route to your technicians' mobile devices. :numref:`app-plans-export_praxedo_home`

en	Praxedo home page

en	Exporting routes to an Android mobile via the Waze app

en	Via the tool, you can send the plan routes to a mobile to schedule them on your calendar and use them on a mobile GPS navigation application called Waze.

en	Prerequisites: you will need to install the Waze app from Play Store.

en	Activate geolocation on your phone via the task bar :numref:`ap_activate_localisation`.

en	Enable geolocation.

en	Launch the Waze application. Press the "Next" button :numref:`app_activate_waze`.

en	Launch the Waze application.

en	Slide your finger from the bottom up and click the "Accept" button :numref:`app_accept_licence_waze`

en	Accept the license.

en	The application home screen appears :numref:`app_waze_home`.

en	Home.

en	Press the magnifier icon in Waze to bring up the application menu :numref:`app_waze_menu1`.

en	Menu.

en	In the menu, press "Planned drives" :numref:`app_planned_drives`.

en	Planned drives.

en	Press "Synch Calendar events" to start synchronization between Waze and the calendar :numref:`app_sync_calendar_events`.

en	Synch Calendar events.

en	Exit the Waze application.

en	Sending iCal file to Android mobile

en	The file in iCal format will allow you to import your tour into your mobile's calendar, then to the Waze GPS.

en	On the Plan tab, select the Plan from the drop-down menu containing the route to be sent :numref:`app_select_plan`.

en	Access the routes plan.

en	The "Edit plan" screen appears. Click the |button_export| icon.

en	From the drop-down menu, select "Calendar iCal by E-Mail" :numref:`app_ical_mail_dropdown_menu`.

en	Sending the iCal calendar by email.

en	The route is sent by e-mail to the address entered in the vehicle settings. (See the vehicle configuration). A confirmation message is displayed at the top right of the interactive map :numref:`app_confirmation_sent_ical`.

en	iCal file sent successfully.

en	On the smartphone, you receive an email in the following form: :numref:`app_email_ical`.

en	E-mail received with link to the iCal file.

en	Emails can sometimes end up in junk or spam email folders.

en	Click on the framed link, the smartphone offers to open the file with the browser of your choice :numref:`app_choice_browser`.

en	Choose a browser to start downloading the file.

en	Select the desired browser icon; the browser window opens and then the download starts :numref:`app_ical_download`.

en	Downloading.

en	Once the download is complete, check the notification bar (swipe your finger from the top to the bottom of the screen to bring up the notification bar). The downloaded iCal will be visible :numref:`app_notification_bar`.

en	File download reported in notification bar.

en	Tap the iCal file in the notification bar.

en	Depending on the Android mobile, there are different calendar apps to exploit the iCal file data.

en	Importing data into an S Planner (Samsung mobile) calendar

en	The mobile will offer you to import or save the iCal data in S Planner (the default Samsung Android calendar). Tap the "Save" or "Import" button depending on the Android version :numref:`app_import_destination_s_planner`.

en	Import the iCal data into S Planner.

en	When first used, you are asked to allow the S Planner application to access the files on your device, tap "AUTHORIZE".

en	The route is displayed in S Planner on the date of the plan in Mapotempo. Go to S Planner to view the route.

en	In the calendar, tap the date of the route you are interested in :numref:`ap_calendar_select_day`.

en	Select the desired route date.

en	A window appears with the route, and then tap the first point of the route :numref:`ap_select_first_point`.

en	Tap the first point of the tour.

en	In the form for the first point on the route, tap the point's address in the "Location" field. It is suggested that you open the file with the Waze application. Select "Open file with Waze" or tap the Waze icon. (Choose "once" or "always" depending on your needs). :numref:`ap_open_with_waze`.

en	Open the file with Waze.

en	The address opens in Waze. Tap the first address shown. :numref:`app_list_destination_waze`.

en	Select the first address shown.

en	The form for that waypoint is displayed. Click the "Go now" button :numref:`app_data_point`.

en	Start the navigation.

en	Navigation starts.

en	Have a good trip

en	Viewing data gathered while on routes with Mapotempo Live

en	Reports are CSV (comma-separated values) format files for routes sent to Mapotempo Live over a specific period, which you select at the time of extraction. They include points visited, status change history, and links to information gathered on routes.

en	In the general Mapotempo Web menu, the Reports tab opens the page where route reports can be downloaded.

en	Download the reporting

en	:numref:`reporting_form2`

en	Reportings form.

en	The form contains the following fields. 1. Begin date and End date: a calendar appears when you click on the field. Select the dates on which you want the report to start and end. 2. History of status: if the box is checked, the report lists status changes applied on the route, their date and their GPS coordinates. Status descriptions can be customized but, by default, they are “to do”, “in progress”, “done” and “not done”. 3. The Download button: When you click on |download|, the Report is downloaded to your computer’s Downloads folder, or another folder chosen by you.

en	Open the reporting with LibreOffice (Calc)

en	Go to the file where the report was downloaded, and double-click on the report.

en	Open the reporting with Excel

en	To open the reporting with Excel, open Excel.

en	Excel Datas.

en	Click on the Data tab (1). The “Get & Transform Data” section on the left (2) can be used to select “From Text/CSV” (3). :numref:`Excel_Datas`

en	Excel opening window.

en	In the window that opens, select the downloaded report from the chosen folder. :numref:`open_Excel_window` It may be that only Excel files are displayed. In the drop-down menu at the bottom right (1), above the “Import” (2) and “Cancel” buttons, selected “All files”. Click on “Import” (2).

en	File origin window.

en	Delimiter window.

en	The actual Report opens.

en	Understanding a route report.

en	Each row in the report corresponds to one mission. The information contained in a row all refers to the same mission. Missions are listed in the order in which they were planned.

en	Columns in the CSV report are broken down into the sections below.

en	Information about the route is contained in columns A and V (as per example):

en	route date: Shows the date and time for which the route is scheduled. The format is dd/mm/YYYY HH:mm:ss +*time zone* offset.

en	username: Shows the route user’s name (name of the vehicle that completed the route).

en	user email: Shows the route user’s email (email provided for the vehicle that completed the route).

en	route name: Shows the name of the route (if different than the name of the vehicle).

en	scheduled date: Shows the date and time for which the mission is scheduled. The format is dd/mm/YYYY HH:mm:ss +*time zone* offset.

en	ETA date: Shows the date and time on which the mission is completed. The format is dd/mm/YYYY HH:mm:ss +*time zone* offset.

en	mission type: Shows whether this is the departure or arrival store, a visit or a rest break.

en	reference: Shows the stable, constant and unique ID enabling this element to be updated without being deleted at the next import.

en	lat: Shows the destination’s latitude (in decimal degrees) in the range -90° to 90°. E.g. 45.91.

en	lng: Shows the destination’s longitude (in decimal degrees) in the range -190° to 180°. E.g. -0.781.

en	street: Shows the building number, street type and street name (spelling must be correct for reliable geocoding). Note: access details must be put in the “additional” field.

en	Additional: Gives access details in addition to the street so that the field agent can reach their destination doorstep. E.g. building in a complex, block of flats, staircase, floor, door number etc.

en	Postal code: Indicates the postal code of the city or locality (precision is important for reliable geocoding).

en	city: Shows the name of the city or community (spelling must be correct for reliable geocoding).

en	state: Shows the name of the state (spelling must be correct for reliable geocoding).

en	country: Shows the name of the country (spelling must be correct for reliable geocoding).

en	Comment: Gives information needed for the visit.

en	(and following) start of time window no.: Shows the start of time slot(s) (can go over 24:00) recommended for the visit.

en	(and following) end of time window no.: Shows the end of time slot(s) (can go over 24:00) recommended for the visit.

en	Information gathered during the course of a route is shown in the following columns (in the example, between columns V and AU):

en	(as per example) duration: Shows the anticipated duration of the visit.

en	(as per example) final position: Shows the last position shown for the mission.

en	(as per example) description of all positions: Shows all positions through which the mission has passed.

en	(as per example) lat all positions: Shows the latitudes of each position shown for a mission.

en	(as per example) lng all positions: Shows the longitudes of each position shown for a mission.

en	AA. (as per example) date all positions: Shows the dates of each status shown for a mission. AB. (as per example) comment found: Shows the comment written during the mission. AC. (as per example) lat found: Shows the latitude of the point identified on the map during the mission. AD. (as per example) lng found: Shows the longitude of the point identified on the map during the mission. AE. (as per example) road found: Shows the detail or the new road identified during the mission. AF. (as per example) addition found: Shows additional address information identified during the mission. AG. (as per example) postal code found: Shows the postal code identified during the mission. AH. (as per example) city found: Shows the city identified during the mission. AI. (as per example) state found: Shows the state identified during the mission. AJ. (as per example) country found: Shows the country identified during the mission. AK. (as per example) photos found: Shows the URL (web address) where to find the photos taken during the mission. AL. (as per example) signature found: Shows the URL (web address) for the image of the signature captured during the mission. AM. (as per example) signature name found: Indicates the name of the person who signed. AN. (as per example) tag IDs all temperatures: Shows the ID for the temperatures taken during the mission. AO. (as per example) latest values all temperatures: Shows the last temperature taken at the end of the mission. AP. (as per example) date all temperatures: Shows the date of each temperature reading. AQ. (as per example) units all temperatures: Shows the unit in which the temperature was taken. AR. (as per example) violations all temperatures: Indicates the number of times the temperature overshot. AS. (as per example) link to details all temperatures: Shows the URL for the page containing the temperature readings. AT. (as per example and following) quantity[nameUnitDeliverable]: Shows the quantity of the unit to deliver and, in square brackets, the name of that deliverable unit. AU. (as per example and following) quantity found[nameUnitDeliverable]: Shows the quantity of the unit delivered or collected and, in square brackets, the name of that deliverable unit.

en	Mapotempo Live

en	Export Routes to Mapotempo Live

en	When you click on the export icon, select Send to Mapotempo Live mobile app.

en	The modal window for route export to Mapotempo Live opens.

en	:numref:`MapotempoLive_export_modale`.

en	Export to Mapotempo Live modal window.

en	Over four columns, vehicles can be linked to a date and a Mapotempo Live user. Opposite the route / vehicle name, select a date from the calendar. Then select a user from the drop-down menu on the far right.

en	Only routes whose checkboxes are checked are sent to Mapotempo Live.

en	A warning message alerts you to any possible inconsistency. In this example, two routes are being sent to the same cellphone.

en	The text import window may differ according to Excel version. The important thing is to select comma as the Delimiter or Separator, and UTF-8 as the File origin. :numref:`select_Excel_window1`

en	From the choices in the “File origin” drop-down menu (1) select **65001: Unicode (UTF-8)**. From the choices in the “Delimiter” drop-down menu (2) select **Comma** :numref:`select_Excel_window2`

en	Opening csv files automatically with excel can corrupt the downloaded csv files and cause data to be shifted into the wrong columns. Depending on your browser and operating system, there are many different ways to prevent these files being opened automatically in Excel.

en	“Extra stops” can be unplanned destinations, departure and arrival stores, rest breaks and unchecked stops. “Columns” are the information contained in the routes. If information is not needed in the export, you can drag-and-drop it in the “Skip” box. If you click and hold on the information then slide it across to the gray “Skip” area, that column is removed from the export. See the explanatory video. The spreadsheet format is CSV (Comma Separated Value) format for a standard or Excel spreadsheet program.

en	Customers are imported into the S Planner calendar :numref:`app_destinations_import_splanner2`.

en	Destinations imported into S Planner.

en	name: Shows the name of the customer or destination visited.

en	phone: Shows the customer’s contact telephone number.