LINKS
ABOUT

support@adaptpoint.com

Cary, North Carolina

SOCIAL
  • Black LinkedIn Icon

© 2017 AdaptPoint, LLC. All rights reserved.

Frequently Asked Questions

1. My HandyMap add-in is prompting me to upgrade to a new version. How do I update the add-in?

We periodically update the HandyMap add-in version when new features and fixes are implemented. When a new version of an add-in is available, your HandyMap instance will notify you to upgrade via an in-app prompt. To get the revised version of the add-in, you will have to clear your browser cache and force the HandyMap add-in to reload itself.

 

To clear the cache, please first close any running instances of Excel or Excel 365;  if using the desktop version of Excel, launch the Internet Explorer 11 browser and use the ‘Tools (gear icon in the top right corner) – Safety – Delete browsing history’ menu commands to delete all cached settings. The Microsoft Office desktop applications internally use the older IE 11 instance for running Office Store add-ins, and hence the need to clear the IE 11 cache. Once done with IE 11, please go ahead and launch the Microsoft Edge browser (if you have Edge installed on your system), and then clear out the browser cache on it as well.

 

If you happen to be using the Office 365 version of Excel Online, it is sufficient to clear the browser cache of just the browser that you are running it in.

 

Once the browser cache has been cleared, please re-launch Excel/Excel 365, and re-load your HandyMap add-in. This will load the updated version of the add-in.

2. What are the marker colors that can be specified when creating maps by importing addresses from an Excel table?

When creating maps by importing address data from Excel or Word, your table can list any of the 140 standard html color name values for the map markers, routes and regions. You can find the full list of colors here

3. How do I change the color and style for all my place markers?

You can change the default color used for all place markers by opening the Place Customization view, selecting the ‘All Markers’ option in the top dropdown and picking the color/image/size that you want for place markers. This setting will then be used by all new and existing place markers that have not had a customization value directly set on them. Any style changes applied directly to a marker will take precedence over the ‘All Markers’ color value.

4. Do the HandyMap routing add-ins provide traffic time adjusted data? Is there an easy way to get the distance and time for all my routes?

Yes, the HandyMap routing add-ins provide traffic adjusted travel time for your route calculations. The prevailing traffic at the time of execution of the route query is used to estimate the traffic adjusted travel time.

 

You can use the new ‘Route Summary’ feature accessible from the Route Customize (or Route Settings for task pane add-ins) page to add a table to your document summarizing the waypoints, distance, travel time (with and without traffic), and the individual segment distance/time breakdown for all your calculated routes. You can then get the time and distance for all routes from this summary table, without the need to manually extract them for each calculated route.

5. I use a non-English keyboard and have noticed that I sometimes get a 'Failed to resolve address' message when attempting to import my address data.  

We have noticed that when using certain non-English keyboard characters such as Ø, Æ and Å, the mapping service used by the HandyMap add-ins is unable to parse the address, resulting in the above error message. Replacing the native language spelling with the English equivalent normally resolves this issue.

6. I use a non-English keyboard and have noticed that I sometimes get a 'Failed to resolve address' message when attempting to import my address data.  

We have noticed that when using certain non-English keyboard characters such as Ø, Æ and Å, the mapping service used by the HandyMap add-ins is unable to parse the address, resulting in the above error message. Replacing the native language spelling with the English equivalent normally resolves this issue.

7. Is it possible to creating driving routes with multiple waypoints using the HandyMap routing add-ins?  

Yes, it is possible to create driving routes with multiple waypoints.  To manually input the route, first select ‘Driving’ mode and then enter your start address in the ‘Start’ input box, followed by the 1st way point in the Destination address input box. You can then click the small marker icon on the right of the address input boxes to add the additional waypoints. Your route destination will the last waypoint that you add.

 

You can also use the add-in’s Data Import feature to import address data from an Excel table that lists the start, destination and waypoint addresses. The primary steps for building a route map using the Data Import feature are,

 

  1. Launch the Data Import view by clicking the ‘Data Import’ button in the Map Settings panel.

  2. Select the Excel data table containing your start and destination address, and optionally, waypoint addresses and marker descriptors. The column names can be anything, but it is key that the table be a properly structured Excel table.

  3. Use the 'Start Address' dropdown to set your start address data column. Using the 'Destination' dropdown, set your route destination address column. 

  4. The Start and Destination address columns are the minimum required and you will notice that the ‘Add To Map’ button is enabled once they have been assigned.

  5. If your route data has way stops, use the 'Waypoints' dropdown list to select the table columns that provide your route waystop addresses. Waystops will be created in the same order as your table columns.

  6. Optionally, if your table has color information for your routes, you can use the 'Color' dropdown to select the table column listing the route color. The color value should be a HTML compatible color name from this list.

  7. Now click the ‘Add to Map’ button to generate your map.

You can also use the 'Full Bind' data import option for setting individual route markers and colors.