This item is now retired. Please see What's new for more information.


Customer Complaints Overview

The Customer Complaints solution allows a utility to make a spreadsheet spatial by mapping a CSV file of customer service calls from a customer information system. This solution is a configuration of ArcGIS to schedule the publishing of current customer complaints and archiving of customer complaints. When configured, customer service can use Operations Dashboard for ArcGIS to view the current customer complaints.


Customer Complaints requires specific technical experience and software.

Requirement Description
  • Scheduling Windows tasks
  • Modifying JSON files
  • Publishing GIS services
  • Authoring maps
  • Administering groups and organizing content in an ArcGIS organization
Data Publishing
  • ArcMap (Standard or Advanced) 10.2.1, 10.3, 10.4
  • Python 2.7.x
  • Windows Task Scheduler
Map authoring
  • ArcMap (Standard or Advanced) 10.2.1, 10.3, 10.4
Map Service Hosting
  • ArcGIS Online
  • ArcGIS Enterprise (Standard or Advanced) 10.5
  • ArcGIS for Server (Standard or Advanced) 10.3, 10.4
    • Portal for ArcGIS
Application hosting
  • ArcGIS Online, or
  • ArcGIS Enterprise 10.5, or
  • Portal for ArcGIS 10.4

What you get

When you download Customer Complaints, you'll find the following in the zip file:

Directory Item Description
Application A folder containing a set of Python scripts to create groups and content including services, maps, and apps in your organization.
Maps and GDBs CustomerComplaints.gdb A sample geodatabase containing the customer complaints schema and sample data.
CustomerComplaints.mxd A map document used to publish the Customer Complaints service.
CIS_Complaints.csv A CSV file with sample customer service calls data that is used to add data to the Customer Complaints service.

What's new

Below are the release dates and notes for Customer Complaints.

Date Description
June 2018
June 2017
February 2016
August 2015
  • Most recent version of the ArcREST tools (version 3).
  • Configuration file enhancements.
May 2015
  • Most recent version of the ArcREST tools.
    • ArcREST Helper is now included with ArcREST
  • Report modules moved to solutionreporttools python package
  • Config file schema changes
    • ReportingAreas and ReportingAreasIDField moved to ReportDetails section
    • PublishData added to PublishingDetails section to allow the user to quickly bypass this entire section
    • EnableEditTracking & Capabilities parameters in FeatureServices has been replaced with the Definition section
    • RunReport added to ReportDetails section to allow the user to quickly bypass this entire section
    • Data added to ReportDetails to centrally define the data layers
    • Data parameter in each report now uses a value from the RunReports Data section instead of path to data
    • CSVOutputLocation added to ReportDetails to allow a merged CSV file result from selected reports
    • ExportDataLocally added to ReportDetails to copy the data from the data section to a local GDB before running the reports
    • TempExportLocation added to ReportDetails. Specify the path to a File GDB when you set ExportDataLocally to True
    • SchemaGDB & ResultsGDB sections added to ReportDetails to remove the redundant list of database in each report
    • ReportResultSchema & ReportResult in each report section list the layer location in the database defined in SchemaGDB and ResultGDB
    • ReportMerge added to each report to append results after each run instead of overwriting output
December 2014
  • Latest versions of the ArcREST and ArcREST Helper tools
  • Config files schema changes
    • FeatureService section to FeatureServices
    • Login info only defined in the GlobalLoginInfo file
    • EnableEditTracking parameter added to FeatureServices section
    • UpdateItemContent changes to UpdateService in MapDetails
    • Portal in login section changed to Orgurl
    • ExistingService change to ExistingServices
    • ExistingServices ReportResult tag changes to FeatureClass
    • ReplaceTag added to section
    • ReplaceInfo Section now uses the following three parameters, SearchString, ReplaceString and ReplaceType
August 2014
  • First release of Customer Complaints

Known issues

  • The automated setup uses ArcREST, which does not support application and enterprise logins.
  • When publishing to Portal for ArcGIS, the Hosting Server must use an ArcGIS Data Store as a managed geodatabase.
  • When publishing to Portal for ArcGIS with an ArcGIS Data Store Hosting Server, field names will be auto converted to lowercase. The tools will update the maps created, but apps are not updated to handle this conversion.
  • The script is delivered using relative paths. To use this without changing to absolute paths, you need to have python.exe as the default file extension for .py files and the path to Python in your systems path variable.

Get started with Customer Complaints

You may be interested in