Assign Customers By ID (Business Analyst)
Assigns customers to stores based on an existing store ID field in the customer table.
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.
The customer layer used to make the customer assignments to each store.
The store ID field that will be used to assign customers.
Generates a new feature class based on the existing layer or uses the existing layer.
The feature class that will contain the customer features.
# 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)