Import Associations (Utility Network)

Summary

Imports associations from a comma-separated values file (.csv) into an existing utility network. This tool can be used in conjunction with the Export Associations tool.

Learn more about how to import associations

Usage

• Associations must be in a single .csv file.

• Features listed in the .csv file must exist in the utility network.

• Features listed in the .csv file must have supporting rules.

• If an error occurs during import—for example, a missing rule—the entire import process will be rolled back. Review the errors and inspect the .csv file before importing the associations again.

• When working with an enterprise geodatabase, the Input Utility Network parameter value must be from a database connection established as the database utility network owner.

• The information in the .csv file is stored in the following format: ASSOCIATIONTYPE, FROMFEATURECLASS, FROMASSETGROUP, FROMASSETTYPE, FROMGLOBALID, FROMTERMINAL, TOFEATURECLASS, TOASSETGROUP, TOASSETTYPE, TOGLOBALID, TOTERMINAL, ISCONTENTVISIBLE, PERCENTALONG.

  .csv columns

  Column	Description	Example
  ASSOCIATIONTYPE	The type of association. Junction Junction Connectivity Junction Edge From Connectivity Junction Edge Midspan Connectivity Junction Edge To Connectivity Containment Structural Attachment	Containment
  FROMFEATURECLASS/TOFEATURECLASS	The feature class or object participating in the association.	ElectricDistributionDevice, ElectricDistributionAssembly, StructureJunction
  FROMASSETGROUP/TOASSETGROUP	The asset group of the feature.	Transformer, Fuse, Elbow
  FROMASSETTYPE/TOASSETTYPE	The asset type of the feature.	Streetlight, Attachment, Single-phase padmounted
  FROMGLOBALID/TOGLOBALID	The global ID of the feature.	{16558C73-013C-4169-A095-7E9DCD57EB57}
  FROMTERMINAL/TOTERMINAL	The terminal participating in the association. This is only applicable to junction-junction connectivity associations.	Single Terminal, Load, Source
  ISCONTENTVISIBLE	A Boolean flag indicating whether the content is visible. This is only applicable to containment associations.	False, True
  PERCENTALONG	The percent along value for junction-edge midspan connectivity associations between a junction object and an edge object.	0.75

Parameters

Dialog

Label	Explanation	Data Type
Input Utility Network	The utility network to which the associations will be imported.	Utility Network; Utility Network Layer
Association Type	Specifies the type of association that will be imported. All—All association types will be imported. Junction-junction connectivity—The junction-junction connectivity association type will be imported. Containment—The containment association type will be imported. Attachment—The structural attachment association type will be imported. Junction-edge connectivity (from side of edge)—The junction-edge connectivity (from side of edge) association type will be imported. Junction-edge connectivity (midspan)—The junction-edge connectivity (midspan) association type will be imported. Junction-edge connectivity (to side of edge)—The junction-edge connectivity (to side of edge) association type will be imported.	String
Input File	The .csv file from which the associations will be imported.	File

Derived Output

Label	Explanation	Data Type
Updated Utility Network	The updated utility network.	Utility Network

Python

arcpy.un.ImportAssociations(in_utility_network, association_type, csv_file)

Name	Explanation	Data Type
in_utility_network	The utility network to which the associations will be imported.	Utility Network; Utility Network Layer
association_type	Specifies the type of association that will be imported. ALL—All association types will be imported. JUNCTION_JUNCTION_CONNECTIVITY—The junction-junction connectivity association type will be imported. CONTAINMENT—The containment association type will be imported. STRUCTURAL_ATTACHMENT—The structural attachment association type will be imported. JUNCTION_EDGE_FROM_CONNECTIVITY—The junction-edge connectivity (from side of edge) association type will be imported. JUNCTION_EDGE_MIDSPAN_CONNECTIVITY—The junction-edge connectivity (midspan) association type will be imported. JUNCTION_EDGE_TO_CONNECTIVITY—The junction-edge connectivity (to side of edge) association type will be imported.	String
csv_file	The .csv file from which the associations will be imported.	File

Derived Output

Name	Explanation	Data Type
out_utility_network	The updated utility network.	Utility Network

Code sample

ImportAssociations example (Python window)

This sample script imports all types of associations into a utility network called GridNetwork.

import arcpy
arcpy.ImportAssociations_un("GridNetwork", "ALL", "C:\\Temp\\AllAssociations.csv")

ImportAssociations example 2 (Python window)

This sample script imports junction-junction connectivity associations into a utility network called GridNetwork.

import arcpy
arcpy.ImportAssociations_un("GridNetwork", "JUNCTION_JUNCTION_CONNECTIVITY", 
                            "C:\\Temp\\JJconnectivity.csv")

ImportAssociations example 3 (Python window)

This sample script imports containment associations into a utility network called GridNetwork.

import arcpy
arcpy.ImportAssociations_un("GridNetwork", "CONTAINMENT", 
                            "C:\\Temp\\Containment.csv")

ImportAssociations example 4 (Python window)

This sample script imports structural attachment associations into a utility network called GridNetwork.

import arcpy
arcpy.ImportAssociations_un("GridNetwork", "STRUCTURAL_ATTACHMENT", 
                            "C:\\Temp\\StructuralAttachment.csv")

Environments

Current Workspace

Licensing information

• Basic: No
• Standard: Yes
• Advanced: Yes