ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Setup Customers Using Tabular Data

  • Summary
  • Usage
  • Syntax
  • Code Sample
  • Environments
  • Licensing Information

Summary

Geocodes tabular data and defines the output feature class as a customer file for use in the Analysis And Trade Areas tools.

Learn more about Setup Customers Using Tabular Data

Usage

  • When geocoding stores, it is best to have address, city, state, and ZIP Code fields to ensure the best results for the geocoder.

  • View the geocoding output log to examine the match rate of your input addresses.

  • The standard input tabular data formats used are .dbf (IV), .csv, and tab-delimited text (.txt).

  • Relational database files can also be accessed through this tool utilizing the Database Connections wizard in ArcCatalog.

  • If importing from Excel to .dbf, make sure your field headers are eight characters or less and do not have special characters embedded in the description.

Syntax

SetupCustomersByTable_ba (Table, Locator, MatchFields, NameField, LinkField, OutputFeatureClass, {CS_AppendsegmentationCodes}, {CS_CreateCustomerProfile}, CS_CustomerProfileName, {InputVolumeInfoFieldName}, SegmentationBase)
ParameterExplanationData Type
Table

The input table used for setting up your customer layer.

Table View
Locator

The predefined address locator service.

Address Locator
MatchFields

Input fields for geocoding addresses.

Field Info
NameField

The unique identifier for the input feature class (commonly the customer name).

Field
LinkField

Unique ID linking the customer file with the store file.

Field
OutputFeatureClass

The feature class that will contain the customer points.

Feature Class
CS_AppendsegmentationCodes
(Optional)

Appends Tapestry Segmentation codes to the customer layer.

  • True —Appends the Tapestry Segmentation code to the customer file.
  • False —Will not append Tapestry Segmentation codes to the customer file. This is the default.
Boolean
CS_CreateCustomerProfile
(Optional)

Creates a Tapestry Segmentation Profile based on the customer layer.

  • True —Creates a apestry Segmentation Profile based on the customer layer.
  • False —Will not create a apestry Segmentation Profile based on the customer layer. This is the default.
Boolean
CS_CustomerProfileName

The name of the customer profile.

String
InputVolumeInfoFieldName
(Optional)

The field containing your volumetric field. Typically this is a sales filed associated with customer data.

Field
SegmentationBase

The base data to be used in creating the customer profile.

  • Total Households —This option will use the Total Households segmentation base to create the customer profile. This is the default.
  • Total Adult Population —This option will use the Adult Population (18+) segmentation base to create the customer profile.
String

Code Sample

SetupCustomersByTable Example (Stand-alone Script)
# Name: SetupCustomersByTable.py
# Description: Geocodes San Francisco customers using tabular data. 
# Author: Esri

# Import system modules
import arcview
import arcpy

arcpy.ImportToolbox("C:\Program Files (x86)\ArcGIS\Desktop10.3\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx")
 
try:
# Acquire extension license 
  arcpy.CheckOutExtension("Business") 
 
# Defines the parameters for the Setup Customers Using Tabular Data tool
  Input = 'C:/ArcGIS/Business Analyst/US_2014/Datasets/Tutorial/sf_custs.dbf'
  OutFC= "C:/temp/sf_customers.shp"
  Locator = "C:/ArcGIS/Business Analyst/US_2014/Data/Geocoding Data/USA Geocoding Service.loc"
  CustName = "NAME"
  StoreId = "STORE_ID"
  FldCol = "Addr ADDRESS VISIBLE;City City VISIBLE;State State VISIBLE;ZIP ZIP VISIBLE"
 
# Generate customer layers with tabular data
  arcpy.SetupCustomersByTable_ba(Input, Locator, FldCol, CustName, StoreId, OutFC)
 
# Release extension license 
  arcpy.CheckInExtension("Business") 
 
except:
  print arcpy.GetMessages(2)

Environments

This tool does not use any geoprocessing environments

Licensing Information

  • ArcGIS for Desktop Basic: Requires Business Analyst
  • ArcGIS for Desktop Standard: Requires Business Analyst
  • ArcGIS for Desktop Advanced: Requires Business Analyst

Related Topics

  • An overview of the Customer Setup toolset
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal