Assign Customers By ID (Business Analyst)

Summary

Assigns customers to stores based on an existing store ID field in the customer table.

Usage

• If you already have a field in your layer that contains the assignment of a store ID to each customer, this method alerts Business Analyst to make use of that field for the assignment.

• This tool can be used if you have coded each customer record in the database based on the store they actually visited.

• When assigning customers by ID, the assignment can be alphanumeric or numeric.

Syntax

AssignCustomersByID_ba (CustomerLayer, LinkField, {CreateNewFeatureClass}, {OutputFeatureClass})

Parameter	Explanation	Data Type
CustomerLayer	The customer layer used to make the customer assignments to each store.	Feature Layer
LinkField	The store ID field that will be used to assign customers.	Field
CreateNewFeatureClass (Optional)	Generates a new feature class based on the existing layer or uses the existing layer. True —Creates a new feature class. False —Does not create a new feature class. The original layer will be used.	Boolean
OutputFeatureClass (Optional)	The feature class that will contain the customer features.	Feature Class

Code Sample

AssignCustomersByID Example (Stand-alone Script)

# Name: AssignCustomersByID.py
# Description: Assigns customers in the San Francisco area to their designated store by a corresponding ID field in both layers.
# Author: ESRI

# Import system modules
import arcview
import arcpy

arcpy.ImportToolbox("C:\Program Files\ArcGIS\Desktop10.0\ArcToolbox\Toolboxes\Business Analyst Tools.tbx")
 
try:
# Acquire extension license 
arcpy.CheckOutExtension("Business") 
 	
# Defines the parameters for the Assign Customers by ID tool
CustPath = "C:/temp/sf_cust.shp"
StoreId = "STORE_ID"
 
# Assign Customers by ID 
arcpy.AssignCustomersByID_ba(CustPath, StoreId, "false")
 
# 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