VERIFIED SOLUTION i

Configuring Web Map Layer Settings in Confirm

Products affected: Confirm®, ConfirmConnect® and ConfirmWorkzone®
Product feature: Mapping
 

The Web Map Layer Settings page provides the ability to configure background map layers for Confirm Web Customer Services, ConfirmConnect and ConfirmWorkzone which can be used to replace the default Bing maps, along with the preview of the map layer.  This is available in Confirm version 18.20.

The map preview displays the Bing layer, if the extents of the custom layer cannot be determined, with an option to switch to custom and aerial views (if available).

Web Map Layer Settings screen in Confirm

Note: The page removes the need to request SQL from Pitney Bowes to apply these settings. It will ensure that the entered text is within the database limit of 4000 characters and will use simple parsing to validate JSON text.

This will apply to all users of ConfirmConnect who do not have a settings.js file loaded on their device.

The script that is saved on the Web Map Layer Settings screen is slightly different to that used in a settings.js file on a device in that it does not need "mapSettings": and the associated curly brackets.

If this is an extract of the settings.js file from a device
 {
  "mapSettings":{
    "roads":{
      "type": "WMS",
      "url":...
    }
  }
}

This is what should be entered on the Web Map Layer Settings screen.
{
  "roads":{
    "type": "WMS",
    "url":...
  }
}

The json script that is used to display that maps is not related to Confirm and may need to be created by a Geographic Information System (GIS) expert.  However there is some guidance in the Confirm help file under section ConfirmConnect > Administration Guide > Setting up Mapping data, particluarly in the Web Map Service (WMS) section.

 

Map Extent Settings

The display of maps on the Web Map Layer Settings screen uses the setting_value in the system_setting table where setting_id='WEB_MAXBOUNDS'.  The value is in the order 'Maximum X,Maximum Y,Minimum X,Minimum Y' and is set when Confirm is upgraded to version 18.20 or later.  The SQL that does this in in script in C:\Program Files (x86)\Pitney Bowes\Confirm\Client\OR7V1801AM.sql on the Confirm Client server and is based on this.
 
SELECT 'WEB_MAXBOUNDS',
       TO_CHAR( MAX(site_cent_east)) || ',' ||
       TO_CHAR( MAX(site_cent_north)) || ',' ||
       TO_CHAR( MIN(site_cent_east)) || ',' ||
       TO_CHAR( MIN(site_cent_north))
FROM central_site
WHERE site_cent_east <> 0 AND site_cent_north <> 0;

This means that if some site_cent_east and site_cent_north are incorrect by a significant the value for WEB_MAXBOUNDS will be wrong and value may need to be corrrected using SQL.
UPDATED:  January 31, 2019