Imports associations from a comma-separated values file (.csv into an existing utility network.
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.
This tool can be used in conjunction with the Export Associations tool.
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 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.
Column Description Example
The type of association.
- Junction Junction Connectivity
- Junction Edge From Connectivity
- Junction Edge Midspan Connectivity
- Junction Edge To Connectivity
- Structural Attachment
The feature class or object participating in the association.
ElectricDistributionDevice, ElectricDistributionAssembly, StructureJunction
The asset group of the feature.
Transformer, Fuse, Elbow
The asset type of the feature.
Streetlight, Attachment, Single-phase padmounted
The global ID of the feature.
The terminal participating in the association. This is only applicable to junction-junction connectivity associations.
Single Terminal, Load, Source
A Boolean flag indicating whether the content is visible. This is only applicable to containment associations.
The percent along value for junction-edge midspan connectivity associations between a junction object and an edge object.
ImportAssociations(in_utility_network, association_type, csv_file)
The utility network receiving the associations.
|Utility Network; Utility Network Layer|
Specifies the type of association to import.
The .csv file containing the associations to import.
The updated utility network.
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")
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")
This sample script imports containment associations into a utility network called GridNetwork.
import arcpy arcpy.ImportAssociations_un("GridNetwork", "CONTAINMENT", "C:\\Temp\\Containment.csv")
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")
- Basic: No
- Standard: Yes
- Advanced: Yes