Hello,
It's my understanding that the Utility Network functionality will auto populate the Asset ID column on features but I can't seem to find any documentation on how to do this. Does anyone have experience populating these asset IDs using the software?
Any guidance would be appreciated.
Thanks,
Hi Kevin,
Unfortunately, there is no documentation on the subject what you are asking for here. Basically it is part of configurations at an enterprise database as well as utility network. If you follow the below steps you will able auto-populate the Asset ID in the utility network.
E.g. seq_name - DEVICE_35_SEQ corresponding attribute rule - D_Device_35
Good Luck!
Manoj
Kevin -
To add onto what Manoj provided, I wanted to give you some of the places in the documentation you can piece this together for the core functionality that is used outside of an asset package.
1. You need a database sequence. You can create this in the database yourself or using the ArcGIS tool - Create Database Sequence
2. You need a calculation attribute rule created on the ASSETID field that will fire to populate the ASSETID based on a specific edit operation. This rule will use the database sequence you created along with an Arcade function to get the next value in that database sequence.
Here it the Arcade function reference for NextSequenceValue that you would use in your attribute rule: NextSequenceValue
The Attribute rule script expression examples does not have this exact example workflow, but does have a calculation attribute rule that uses the NextSequenceValue to populate based on a prefix + the next value in the sequence. In the example, it fires on insert operations (triggering event).