Time on Site reports measure how much time vehicles have spent at different Points of Interest (POI’s). These reports can show how much time is spent at customer sites, in distribution centrals or in the company parking lot. You can also see how many times different POI’s have been visited and if some POI’s have been missed completely.

Time on Site reports answer questions like:

• How much time do we spend at our customers per week?
• How many customer visits do we make per day?
• How many times did we visit our warehouses last month?
• What customers have not been visited at all this month?

In this guide we will setup a Time on Site report that lists customer visits for our vehicles.

The setup process is a one-time task where you can configure the reports to your needs.

Install reports

Follow these steps to install the reports on your server:

1. Login to your SiteAdmin application
2. Install (or update) Time On Site Report from the menu Plugins.
   Note: you may also need to update to the latest version of the plugins Core, Reporting and PointsOfInterest
3. Follow step 1 and 2 in the guide Activate Reports in GpsGate Server 3.0 to activate the reports.
   Note: select the Time On Site Report in the list of plugins

Import a list of customers

Time on Site reports work with Points of Interest (POI’s), POI’s are positions with a description.  You can import a list of POI’s in CSV or KML format. A sample CSV file is shown below:
(Latitude,Longitude,Name)
59.34575,18.07182,Tekniska Högskolan
59.34295,18.08169,Stadion
59.34057,18.05878,Rådmansgatan
59.33549,18.06358,Hötorget
59.34297,18.04968,Odenplan
59.33879,18.09083,Karlaplan
59.3472,18.09882,Gärdet

Follow these steps to import a POI list of customers:

1. Login to your SiteAdmin application
2. Go to the tab Import and select Points of Interest. You can import POI lists in CSV or KML format. The Help section at the bottom of the page shows the supported formats.
3. Import a list of your customer POI’s in the above format into the category Customer
4. Go back to the Applications tab and click on the application you want to enable the POI list in.
5. Enable the POI category Customer in “Enable/Disable features - Plugins - PointsOfInterest - _EditLocationCategory”
6. Enable the POI category Customer in “Enable/Disable features - Plugins - PointsOfInterest - _ReadLocationCategory”
7. Save the application settings

Note: You can import multiple POI lists to different categories like “Customer” and “Warehouse” for different reports.

Create an Event Rule

You need to create an event rule for your POI’s. Event rules are used to detect when vehicles enter a POI. It is recommended to create one event rule per POI category. This helps to avoid potential confusion when POI’s in different categories overlap each other.

Note: Other options in the event rules can be used to define when to trigger a Time on Site Event, you can for example set a minimum time for a visit to be valid so that vehicles just passing a POI are ignored.

Below we create an event rule that checks if a vehicle has been at a customer site, defined by the list of imported POI’s.

1. Log in to your VehicleTracker application with a user that is allowed to edit event rules
2. Go to the menu Admin / Event Rules and click on Add new Event Rule
3. In “1. Rule name and description”, give the event rule a suitable name, like Customer visit. The name is used in the Time on Site reports and should describe the included POI category. You should also select Analyze only, as we only use the event rule for reporting and do not want real time alerts in the map view
4. Click Next in step 2 and 3 (keep the default settings)
5. In “4. Expressions”, add a Points of Interest expression. Select the POI category Customer for the rule to trigger on. You can also optionally select the event to be a Delayed event, requiring that a vehicle is at the POI for a specified amount of minutes before triggering the event
6. In “5. Notifications”, click the Message drop down list and clear the message textbox contents. From the Insert variable drop down list, select POI_ID and click OK.
   Note: it is VERY IMPORTANT that the message textbox only contains the value [POI_ID], since the message will be used in the report
7. Save the event rule

Configure the report

Follow these steps to create a Time on Site report with the Customer visits event rule.

1. Start from the main Map view in your VehicleTracker application (with a user that is allowed to create reports)
2. Go to the menu Reports / Manage Reports and select the report definition TS1003 Time on Site (Vehicle) and click Open
3. Give the report the name “Customer visits”
4. Select the suitable reporting period Daily
5. Select the EventRule Customer visit
6. Select the Tag Show on map, or another tag that includes your vehicles
7. Save your report

View your report

Now you can look at your report directly by selecting Customer visits in the Reports menu. The image below shows the result:

Blog categories