View data collected during routes with Mapo Driver

Reports are csv (comma-separated values) files of routes sent to Mapo Driver over a selected period when exporting. They include the points visited, the history of status changes, and links to information recorded during the routes.

In the main Mapo menu, the Reports tab opens the page for downloading route reports.

Download the report

The form consists of the following fields:

Start date and End date: When you click on the field, a calendar appears. Select the date the report should start and the date it should end.
Status history: If this box is ticked, the report lists the status changes made during the route, their date, and their GPS coordinates. Statuses can be customised but by default are “to do”, “in progress”, “done”, and “not done”.
The Download button: When you click Download , the report is downloaded to your computer in the Downloads folder or the folder you have chosen.

Open the report with LibreOffice (Calc)

In the folder where the report was downloaded, double-click the report.

Open the report with Excel

To open the report with Excel, open Excel.

Click on the Data menu (1). On the left,
the “Get & Transform Data” section (2)
lets you choose “From Text/CSV” (3).

In the window that opens, select the downloaded report in the chosen folder. It’s possible that only Excel files are shown. In the drop-down menu at the bottom right (1), above the “Import” (2) and “Cancel” buttons, select “All files”. Click “Import” (2).

Note:
Depending on your version of Excel, the text import window may look different. The important thing is to select comma as the Delimiter or Separator, and UTF-8 as the File Origin.

From the options in the “File Origin” drop-down menu (1), select 65001: Unicode (UTF-8). From the “Delimiter” drop-down menu (2), select Comma.

The report will open correctly.

Note:
Automatically opening csv files with Excel can corrupt downloaded csv files and cause columns to shift. Depending on your browser or operating system, there are various ways to prevent files from opening automatically with Excel.

Understanding the route report.

Each line of the report corresponds to a mission. The information on a line relates to the same mission. Missions are listed in the order they are scheduled.

The columns in the csv report are divided into the following sections.

The data relating to the route is found between columns A and V (as in the example):

route date: Shows the date and time the route is scheduled. The format is dd/mm/YYYY HH:mm:ss +*time zone*.
user name: Shows the name of the user for the route (name of the vehicle that completed the route).
user email: Shows the email of the user for the route (email entered for the vehicle that completed the route).
route name: Shows the name of the route (if different from the vehicle name).
scheduled date: Shows the date and time the mission is scheduled. The format is dd/mm/YYYY HH:mm:ss +*time zone*.
eta date: Shows the date and time the mission was completed. The format is dd/mm/YYYY HH:mm:ss +*time zone*.
mission type: Indicates whether it’s the departure or arrival depot, a visit, or a break.
reference: Shows the stable, constant, and unique identifier allowing non-destructive updates of this item during the next import.
name: Shows the name of the destination.
lat: Shows the latitude of the destination (in decimal degrees) between -90° and 90°. E.g. 45.91.
lng: Shows the longitude of the destination (in decimal degrees) between -180° and 180°. E.g. -0.781.
street: Shows the building number, street type, and street name (spelling must be correct for reliable geocoding). Note: access details should be entered in the “additional info” field.
additional info: Shows extra access details to help the field agent reach the front door of the destination. E.g. Building in a complex, residence, staircase, floor, door number, etc.
postcode: Shows the postcode of the town or city (accuracy is important for reliable geocoding).
city: Shows the name of the town or city (spelling must be correct for reliable geocoding).
state: Shows the name of the state (spelling must be correct for reliable geocoding).
country: Shows the name of the country (spelling must be correct for reliable geocoding).
phone: Shows the phone number for the destination to contact.
comment: Shows the information needed for the visit.
(and following) time slot start n: Shows the start of the recommended time slot(s) for the visit (can go beyond 24:00).
(and following) time slot end n: Shows the end of the recommended time slot(s) for the visit (can go beyond 24:00).

The data collected during routes appears in the following columns (in the example, between columns V and AU):

(as in the example) duration: Shows the expected duration of the visit.
(as in the example) final status: Shows the last status recorded for the mission.
(as in the example) all statuses label: Shows all statuses the mission has gone through.
(as in the example) all statuses lat: Shows the latitude(s) for each status recorded for a mission.
(as in the example) all statuses lng: Shows the longitude(s) for each status recorded for a mission.
AA. (as in the example) all statuses date: Shows the date(s) for each status recorded for a mission.
AB. (as in the example) recorded comment: Shows the comment written during the mission.
AC. (as in the example) recorded lat: Shows the latitude of the point recorded on the map during the mission.
AD. (as in the example) recorded lng: Shows the longitude of the point recorded on the map during the mission.
AE. (as in the example) recorded street: Shows the precise or new street recorded during the mission.
AF. (as in the example) recorded additional info: Shows the additional address info recorded during the mission.
AG. (as in the example) recorded postcode: Shows the postcode recorded during the mission.
AH. (as in the example) recorded city: Shows the city recorded during the mission. AI. (as in the example) recorded state: Shows the state recorded during the mission.
AJ. (as in the example) recorded country: Shows the country recorded during the mission.
AK. (as in the example) recorded photos: Shows the url (web address) where you can find the photo(s) taken during the mission.
AL. (as in the example) recorded signature: Shows the url (web address) of the image of the signature recorded during the mission.
AM. (as in the example) recorded signatory name: Shows the name of the person who signed.
AN. (as in the example) all temperature tag ids: Shows the tag identifiers for the country recorded during the mission.
AO. (as in the example) all temperature last values: Shows the last temperature recorded at the end of the mission.
AP. (as in the example) all temperature dates: Shows the date of each temperature reading.
AQ. (as in the example) all temperature units: Shows the unit in which the temperature is recorded.
AR. (as in the example) all temperature violations: Shows the number of times the temperature was exceeded or breached.
AS. (as in the example) all temperature details link: Shows the url of the page with the recorded temperatures.
AT. (as in the example and following) quantity[nomUnitéLivrable]: Shows the quantity of the deliverable unit and in brackets the name of this deliverable unit.
AU. (as in the example and following) recorded quantity[nomUnitéLivrable]: Shows the quantity of the unit delivered or collected during the route and in brackets the name of this deliverable unit.