Mar 01 2013

Exclude sensitive speed data in certain reports

A customer recently requested that we not include “Max Speed” in a summary report for them, where the recipient only wanted to see utilization, mileage, and idling information (etc.).

We added this account/user level permission here under user options:

Exclude Max Speed from summary reports

Exclude Max Speed from summary reports

When running a typical Summary Report:

Running a Summary Report with/without Max Speed

Running a Summary Report with/without Max Speed

With the Max Speed included:

Max Speed Included

Max Speed Included

And removing it by checking the “Suppress Max Speed” box, the entire column disappears from this and other reports (as well as scheduled versions of this and other reports):

Max Speed Column is removed

Max Speed Column is removed

Thankfully, customer requests such as this are easy for GPS Insight to accommodate given our flexible architecture.  We’re always happy to implement customer requirements as options which benefit our overall customer-base.

Thanks,

Rob.

 

Tags: , , , , ,


Nov 26 2012

New jobsite mileage GPS tracking report saves customer 4 hours a month

We have a new customer with a few hundred vehicles.  But they have 4 delivery vehicles whose miles need to be internally billed to each of their various job sites for accounting purposes.  It takes one of their employees about 4 hours each month to get this data out of the current stop detail report we provide.

They asked us if we would build them a custom GPS tracking report to help.

Here’s a depiction of how they assign mileage to job sites:

Delivery workflow & mileage calculation

Delivery workflow & mileage calculation

All mileage from the warehouse or another job site needs to be allocated to the NEXT job site reached, to include miles spent going to non-job sites (such as McDonald’s, above).

The mileage spent heading BACK to the warehouse needs to be assigned to the most recent job site serviced.

Rather than go through a stop/detail report, line by line, for hundreds or thousands of trips for a month, we created this consolidated GPS tracking report, called the “Delivery Vehicle Mileage” report:

New Custom Delivery Mileage Report

New Custom Delivery Mileage GPS Tracking Report

Here is the output with client specific information blurred out:

Easy totals for mileage to job sites

Easy totals for mileage to job sites

Note the red arrows illustrate mileage TO the job site, and a couple blue arrows show mileage FROM the job site deadheading back to the yard.

Any group of vehicles as well as starting/reset landmarks such as a warehouse and job site landmarks may be chosen and it can be run for 31 days at a time (and we can always increase that restriction if the number of vehicles/landmarks are reasonable and you need quarterly reports instead).

And the best part: Instead of it taking this customer 4 hours a month to tabulate through a mind-numbing stop detail report, they can now run it in about 2 seconds with this report we built for them (and any customers who may require it in the future):

2 seconds to do 4 hours work

2 seconds to do 4 hours work

As always, we appreciate customer requests, and accommodate them better than any other GPS Tracking provider out there.  Keep them coming — when we help our customers, we help the product as well!

Rob.

Tags: , , , , , , , , , , , , , , , , , , , , ,


Oct 17 2012

Add Custom Fields to your GPS Tracking Reports (plus bonus columns)

We give customers the ability to create and populate their own custom attributes and categories for vehicles and other GPS Insight objects.  Now you can add them to your GPS tracking reports!

First you have to create and assign attributes and values to vehicles like this:

Assign "Compressor Type" to your vehicles

Assign "Compressor Type" to your vehicles

(this is just a test but you get the idea!)

Then you can add that and other custom attributes to your report definition:

Add Custom Attributes

Add Custom Attributes

Just choose each attribute you want, in the order in which you want them to appear in the report.  If you decide to remove one, just check the “remove X” next to it.

Note there is a new extra “bonus” option of “show current location” which allows you to add the vehicle’s CURRENT location to most reports where it was typically left off (e.g. monthly utilization reports like this one).  It is highlighted above, and I check it before running this report, but it’s off by default, as shown.

Now your GPS tracking report will contain YOUR custom data, as shown below:

Custom Attributes in Reports

Custom Attributes in GPS Tracking Reports

Note that you can now see Compressor Type, Bed_length, and Order Number (all just for illustration purposes) on the report as well as on the maps in the custom tab (below):

Custom Attributes and Categories in GPS Insight maps

Custom Attributes and Categories in GPS Insight maps

We also support this in our 3D Google Earth-based maps (with a scrollable window so that you can fit everything in a single “bubble”):

Custom Attributes and Categories in GPS Insight maps

Custom Attributes and Categories in GPS Insight maps

We need to complete the addition of these to our scheduled reports mechanism, but that will be available soon.

Eventually we will allow you to also SORT, FILTER, and GROUP BY by these custom attributes, but for now, much of that is possible just by utilizing the Excel/CSV export of the report.

Please get with our Support staff if you need any training or further information on these powerful GPS tracking capabilities.

Thanks,
Rob.

 

Tags: , , , , , , , ,


Oct 17 2012

Just a couple days to improve several capabilities

A prospective customer gave us some feedback on their pilot late in the day Friday.

By Monday and then by today, we had two of their requests finished:

When clicking on an address in a report, a map pops up.  It’s always been a “Street” map only, with no option for Hybrid or Satellite.

We changed this on Monday, since the customer needed to see an aerial photo more than a plain map.  Now you can choose which type of map is shown:

Inline report maps now show satellite view

Inline report maps now show satellite view

The other quick change was to be more proactive about warning them when drivers might be inadvertently changed via the web interface when there was already a driver assigned, or that driver was assigned to a different vehicle.  Here is the warning which they requested, and we put together in a couple days as a result:

Driver Assignment warning

Driver Assignment warning

These are just two of hundreds of customer requests which make their way into the product every quarter.

And the best thing about GPS Insight is that you don’t need to wait 6-12 months for each “new release.”  Our architecture allows us to make quick changes in near-real time, safely and after adequate testing and QA.  When customers need something to solve a business problem, they want to know they are more than a feature request which may take months or years to become reality.  While we aren’t always able to turn requests around within days, often times we are — and it helps to have a flexible architecture like this for everyone involved with GPS Insight.  Keep the requests coming!

Rob.

Tags: , , ,


Oct 03 2012

Show drivers in vehicle list – feature request completed within days

We had a couple customers ask to view driver names as well as vehicle names in vehicle-centric report choosers.

Thanks to our speedy development team, this got completed quickly as it was simple to make a few changes to our adaptable framework.

Here is how to choose that, and what it looks like now:

New Driver-centric report pull-down list

New Driver-centric report pull-down list

Thanks to our customers for the good ideas and our developers for making them reality!

Rob.

 

Tags: , , , , ,


Sep 27 2012

New USER ACTIVITY report lets you report on your users’ usage

By the way, this is our 300th blog post!  I’ve gotten very fast typing since starting the GPS Insight blog years ago.

We have had several customers ask about reporting on THEIR USERS (not drivers, users).

They want to see who is running reports, logging in to look at vehicles, and receiving scheduled reports and alerts.

We now have this functionality available here:

New GPS Insight User Activity Report

New GPS Insight User Activity Report

Bear in mind you can choose a range of dates the same way you always do within GPS Insight, by choosing a shortcut for Today, Yesterday, Week to date, last 7 days, Month to date, last 30 days, etc., or just choose the start/end date to choose a custom range.

Here is the output for our account for yesterday:

New GPS Insight User Activity GPS Tracking Report

New GPS Insight User Activity GPS Tracking Report

Note this is only available for administrative users currently.

Thanks,

Rob.

Tags: , , , , , , ,


Sep 11 2012

New Time Format Preference (17:00 vs. 5:00 PM)

We’ve been asked to add this capability for a long time, and finally went through the entire product and added the ability for customers to choose which time format they prefer — 12 or 24 hour (military).  We used to ONLY allow military time across the entire site.

Just open up user preferences, and choose your time format preference:

Change your Time Format user preference

Change your Time Format user preference

And all Reports, Administration, Alerts, Maps, etc. will show the proper time format moving forward:

GPS Insight Activity Alert with AM/PM time

GPS Insight Activity Alert with AM/PM time

AM/PM Time in Administration Screens

AM/PM Time in Administration Screens

And here are side-by-side alerts (different alerts), one with an account which chooses military time (the default) and one with 12 hour format AM/PM time:

2 different time formats in GPS Insight

2 different time formats in GPS Insight

This is probably the longest-standing customer request we had, and we finally took the time to make all the customers who wanted this feature happy.

Sorry it took so long, but now you can have your time format your way!

Thanks,
Rob.

 

Tags: , , , , , , , ,


Aug 29 2012

New Landmark filter in Odd Hours Report

Category: Landmarks,New Features,New Features,Reporting,Reportsrdonat @ 6:47 pm

A customer asked us to allow for landmark restrictions on the Odd Hours Report, so we added it.

Now you can:

  • Report Odd-Hours activity ONLY WITHIN certain landmarks
  • Report Odd-Hours activity ONLY OUTSIDE OF certain landmarks

You can specify either (or neither, e.g. how it used to work) as well as which group of landmarks you wish to include:

Choose only activity NOT IN certain landmarks

Choose only activity NOT IN certain landmarks

This is what the report looks like:

Choose only activity INSIDE a certain landmark

Choose only activity INSIDE a certain landmark

We hope this helps you to tune your reports to avoid legitimate activity (such as night driving within the yard) and also find troublesome activity (take home vehicles going to the yard at night, maybe to pick up materials for side jobs).

Enjoy!

Rob.

Tags: ,


Aug 19 2012

2 REALLY POWERFUL new features coming soon

GPS Insight is about to launch two new highly powerful capabilities:

  • Hierarchy-based vehicle permissions
  • Custom Filters for Attribute and Category data

They may not sound like much, but for very large deployments, they’re CRITICAL to help avoid nightmarish administration tasks.

Here’s how they’ll work:

Hierarchy-based vehicle permissions:

First, you need a hierarchy (or 3, as shown in this example — one for geographic location, one for type of vehicle, and one for type of fuel):

Geographic "nodes" assigned to a user

Geographic "nodes" assigned to a user

Let’s say we want a new user (in this case, called “ar-atl”) to have access to Georgia (GA), Nevada (NV), as shown in green above, plus ALL THEIR CHILDREN.

We can assign ONLY these 2 nodes to that user, and specify how “far down” the tree we want to grant permission (e.g. maybe down to the city such as Reno, NV (REN), but NOT beyond that to the West Reno, East Reno, etc. levels, if they existed).

We can do that like this, as well as add all “Function: Delivery” and “Type of Fuel: Green” to this user.  This way they’ll get ALL the members of Delivery and Green (e.g. CNG, Electric, Hybrid, Volt, etc.), as shown below.  We can add multiple nodes to a user per hierarchy, such as BOTH GA and NV for the US (Geographic) hierarchy:

Assigning permissions on Hierarchy Nodes to users

Assigning permissions on Hierarchy Nodes to users

Hovering over the user now shows you the permissions assigned to that user:

Permissions assigned and inherited by users

Permissions assigned and inherited by users

This allows us to provide Hierarchy capabilities to ALL users — not just administrators, as it has previously been available.  PLEASE BEAR IN MIND that the hierarchy is available ONLY to large accounts (e.g. > 100 vehicles) as it is generally unnecessary for small fleets, since they can use vehicle groups to do the same thing.  If you are a large fleet customer of ours, and are not currently using the hierarchy, you can contact Sales or Support to ask for it to be turned on for  your account.  It is a HUGE time-saver in many ways, and you can click here for more information on the Hierarchy capabilities of GPS Insight.

Now onto Custom Filters for Attribute and Category data:

Initially they will be available on 2D mapping, shown here, by pressing the “Attributes and Categories” button (and I’ve already restricted the vehicles by choosing a Group when launching the map (All Vehicles) and choosing ONLY vehicles with the letter “e” in them, using the “Filter List:” box:

Accessing Filters in GPS Insight

Accessing Filters in GPS Insight

This opens up a screen which allows you to create a highly specific filter, based on any category and attribute data you may have specified for your vehicles.

Here, I’ll create a very loose filter which requires ANY (vs. ALL) of the 3 conditions to be met:

Filtering vehicles with custom categories and attributes

Filtering vehicles with custom categories and attributes

Since “Alena” has one of the “Compressor, Generator, Jackhammer & Winch” which are specified in the 2nd criteria, the vehicle shows up on the map:

Vehicle matches the filter

Vehicle matches the filter

If I change the filter to ALL (and some other changes), we get only the single vehicle which meets those criteria:

New, more restrictive filter

New, more restrictive filter

Fewer vehicles match this filter

Fewer vehicles match this filter

Fewer vehicles match this filter

Fewer vehicles match this filter

And note that you can SAVE your filters for future use:

Saving a custom filter in GPS Insight

Saving a custom filter in GPS Insight

And use them like this:

Using a previously saved filter

Using a previously saved filter

This will really help ALL our customers to better utilize and benefit from this functionality by filtering maps, and soon reports, dashlets, and alerts with HIGHLY custom data which they can assign to vehicles.  Filters will also eventually apply to OTHER areas of GPS Insight where categories and attributes are assigned — for instance running a report on only landmarks in the “Customers” group of landmarks which have a “to be serviced by” date in the next 7 days.  Or sending idle alerts for vehicles which don’t have the “ignore idle” attribute set to “yes.”

There’s no practical limit to how complicated you can make these filters — there is the ability to “nest” them within each other so you can say things like:

“Only show vehicles which are corporate unless they are both personal and have a winch, but exclude all of those whose registration expired before today.

Both custom filters and hierarchy based permissions will be available to all customers by the end of August, and as always, we will continue to add functionality as it is required by our customers.

Enjoy & Thanks!

Rob.

Tags: , , , , , , , , , , , , , , ,


Jul 03 2012

Unsafe Golf Cart Usage by Rob (with alert follow-up)

We have a golf cart and our house is near a really steep hill.

Doing 16 MPH up to the top of the hill in my golf cart

Doing 16 MPH up to the top of the hill in my golf cart

The golf cart is limited to 25 MPH, even downhill (it engine-brakes to keep you from going too fast).

Unless you turn the ignition off…

Then you can zoom down as long as you have guts before stomping on the brake or turning the car back on:

racing to the bottom of a hill in my golfcart

racing to the bottom of a hill in my golfcart

But when you turn the ignition off, you lose your speedometer, so you don’t know how fast you’re going.

I was curious how fast I could get it to go down the hill, & realized I could just look it up in GPS Insight:

Running an Activity Detail Report for my golfcart

Running an Activity Detail Report for my golfcart

And I can easily see the max speed of 45:

Going 45 MPH in a golfcart meant for 25

Going 45 MPH in a golf cart meant for 25

The reason the device keeps reporting even though the ignition is off is because I wanted an easy install & just wired it straight to the battery and programmed it to only report when the vehicle is moving.

This helps me to see that my golf cart hit 45 MPH max on the way down the hill.  And notice that it interprets 5 minutes of non-movement in my garage as “Off” and stops reporting.

And the next step?  Create an alert to let me know any time this is happening so that if my kids try it, they’re in huge trouble:

Alert to let me know any time the golf cart goes > 30 MPH

Alert to let me know any time the golf cart goes > 30 MPH

Any time “Rob Gemcar” goes > 30 MPH (only possible down a hill with the ignition turned off — otherwise it hits 28 or so absolute max), WITHIN our subdivision called Forest Highlands, I will get an SMS text message instantly, as well as an email, alerting me to this fact (along with a map of the location in the email).  I included it in our subdivision so that if it’s ever put on a flatbed for transportation to the dealer or something, it won’t alert as it’s going > 30 MPH on surface streets outside our community (it’s not licensed for streets > 35 MPH).

By the way, we’ve worked with companies in the past to prove that their vehicles were going DOWNHILL when they exceeded the supposed maximum set by them in their rig — they did it by putting the truck in neutral and coasting to more than the max allowable speed.  That’s where I got the idea to check GPS Insight to see how fast the vehicle was actually going (it felt more like 50!).  I promise, it wasn’t that unsafe though…  I value my life.

Don’t try this at home!

Rob.

[Update: I was late for dinner last night & at a friend's house, & in a hurry, so I performed the "go fast downhill" trick and predictably, got an alert emailed and via text to my phone -- here they are:]

GPS Insight alert email for speeding down the hill

GPS Insight alert email for speeding down the hill

And here’s the text I got:

GPS Insight SMS alert for speeding down the hill

GPS Insight SMS alert for speeding down the hill

Note that the actual reporting time of the point as 6:47:32 PM, and it was sent at 6:48:30 PM, which is why the alert appears to be 2 minutes later [it was only 58 seconds, which is typical].  We round “down” and the email/sms round “up” with dates:

Raw GPS Data for golf cart speeding event

Raw GPS Data for golf cart speeding event

Running an alert report shows it was sent at 18:48:30:

Running an alert report

Running an alert report

Running an alert report

Alert sent at 18:40:30

Just a good example of how much information we have available to support the alerts we send.

Rob.

 

Tags: , , , , , , , ,


Next Page »