nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Import Associations tool fails with "Invalid Value for ASSOCIATIONTYPE"

EdwardBlair

All -

Trying to import am trying to import associations from an asset package and consistently get the error below. When I Google the error it says there is a related bug, but that seems to be for server and I'm working in an FGDB.

The associations were exported into a CSV from the C_Associations table in my Asset package and follow conventions in the UPDM sample database. A small sample from this CSV is attached.

Any suggestions would, as always, be much appreciated.

Thx,

C_Associations_Sample.csv

Find more posts tagged with

Gas

Accepted answers

MikeMillerGIS

thats the problem, you are passing in the gdb that contains the utility network. You need to pass in the Utility Network or the data base that is an asset package.

All comments

MikeMillerGIS

The format of the csv from Export Association is not the same as the format of the C_Association table. You need to ensure the rows are correct.

From/To Domain network is a coded value domain where the code is an int that represents the domain

The Class does not include the prefix

Content visible is a int based domain also(0/1)

EdwardBlair

oh... is this possibly due to a bug I saw referenced in another post that says associations can only be imported *after* topology has been enabled?

MikeMillerGIS

Are you trying to use the c_assocation table in import association? That table is not compatible. Try using the Transfer Utility Network data tool(in UDMS - https://github.com/Esri/Utility-Data-Management-Support-Tools). This will convert the c_assocation table to the correct format. You can create associations regardless of enabled state, I would be shocked if import is failing because it is disabled.

EdwardBlair

Hi @MikeMillerGIS -

Thanks for this. I tried using this tool, and then discovered another item/question. Running the toolbox errored indicating there was a domain missing in the target UN schema. The domain name was AP_Domain_Networks -- which is present in the asset package but not the UN database created by stage utility network/apply asset package. I had never noticed this, but it seems the only domains present in the UN database are those actually assigned to fields.

Is there a step I'm missing to move all other domains (including AP_* domains) from the asset package to the new UN database?

(Sorry again for the newbie question)

Thx,

MikeMillerGIS

That should not be required. Can you post a screen shot of the error and how you filled out the tool?

EdwardBlair

Here's the input. Error is below at the bottom.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.