topic Re: Attribute Assistant Not Populating AssetID in State & Local Government Questions

Attribute Assistant Not Populating AssetID

MatSavage1 — Thu, 12 Feb 2015 23:18:38 GMT

Hello,

I'm trying to use Attribute Assistant in my organization, and I'm trying to get AssetIDs to populate based on this rule, but it won't work. Any ideas?

Table Name: sdManhole

Field Name: ASSETID

Value Method: GENERATE_ID_BY_GRID

Value Info: MapIndex|PageName|Seq_Num|[id][seq]

SYSID generation is working perfectly. I turned on debugging in the config file and receive this error (despite getting a message box from AA that all operations succeeded):

------------------------------------------------

Row Info

Row Number 1

TableName: sdManhole

FieldName: ASSETID

ValueInfo: MapIndex|PageName|Seq_Num|[id][seq]

ValueMethod: GENERATE_ID_BY_GRID

On Create: 1

On Change: 1

Checking for Subtype Restriction

Field Name: ASSETID was found at index: 4

ERROR: GENERATE_ID_BY_GRID for layer sdManhole is not a valid method, check the dynamic value table

Any help would be much appreciated in this matter.

Re: Attribute Assistant Not Populating AssetID

DrewLindow — Fri, 13 Feb 2015 18:34:21 GMT

It looks like the method you want in this case is "GENERATE_ID_BY_INTERSECT". Likely just a typo. Here is the help page on it: http://resources.arcgis.com/en/help/localgovernment/10.2/028s/028s00000089000000.htm

Re: Attribute Assistant Not Populating AssetID

MatSavage1 — Tue, 17 Feb 2015 17:33:54 GMT

I've tried both to no avail, unfortunately.

Re: Attribute Assistant Not Populating AssetID

DrewLindow — Tue, 17 Feb 2015 18:45:06 GMT

It looks like you are also missing the width parameter. Your Value Info statement should look like: MapIndex|PageName|Seq_Num|0|[id]-[seq]

Re: Attribute Assistant Not Populating AssetID

MatSavage1 — Tue, 17 Feb 2015 18:57:36 GMT

Unfortunately that didn't do it. The width parameter is actually optional, anyhow, according to the documentation: ArcGIS for Local Government 10.2

Re: Attribute Assistant Not Populating AssetID

DrewLindow — Tue, 17 Feb 2015 19:45:30 GMT

To skip an optional parameter you should place two vertical bar characters consecutively to mark the skipped parameter: MapIndex|PageName|Seq_Num||[id][seq]. This is functionally the same as putting a zero for the width in this case.

Ensure the field ASSETID is of the correct type to hold the identifier (integer vs string). Also make sure you are using the actual field names in the value info statement and not an alias. If all this checks out, rerun it making sure to use GENERATE_ID_BY_INTERSECT and properly skipping the width parameter and let me know if the debug message has changed at all.

Re: Attribute Assistant Not Populating AssetID

DrewLindow — Tue, 17 Feb 2015 19:56:04 GMT

Also ensure that your GenerateID table is properly complying with the instructions in the documentation:

The GenerateID table must contain rows where the SEQNAME field has a combination of Sequence Name and grid identifier. For example, to generate identifiers for features in grids with identifiers 5 and 6 using the Sequence Name GRIDIDX, two rows must be added to the GenerateID table where the SEQNAME field has a value of GRIDIDX5 for one, and GRIDIDX6 for the other.

Re: Attribute Assistant Not Populating AssetID

MatSavage1 — Thu, 19 Feb 2015 00:46:53 GMT

Well this is odd. I just understood what you were saying about GENERATE_BY_GRID being a typo. That's actually a value in my domain for the Dynamic Value table in the Value_Method field so it seems that perhaps my implementation (this was given to me by another contractor) has been messed with and that's why I can't get it to work. I'll keep you posted in case I find something different. Thank you for all your help. I'll mark your above answer as the correct one shortly.

Re: Attribute Assistant Not Populating AssetID

AlexBaker1 — Tue, 29 Sep 2015 20:28:20 GMT

Where is this original Documentation located? I have just been able to find limited documentation on this specific Attribute Assistant Value Method of GENERATE ID BY INTERSECT.

I am coming across issues working with sample data. The GENERATE ID works fine when using MANHOLE|0|MH-[seq], but I want to use GENERATE ID BY INTERSECT.

When using the GENERATE ID BY INTERSECT Value Method and using

WUD_GRID|SEQNAME|MANHOLE|0|[id]-[seq] as the Value Info, the FacilityID field is returning

NULL.

Table NAme - ssManhole

Field Name - FACILITYID

Value Method - GENERATE ID BY INTERSECT

Value Method: WUD_GRID|SEQNAME|MANHOLE|0|[id]-[seq]

Create - True

Change - True

On Manuel - False

On Change (Geometry) - False

WUD_GIS us the grid polygon feature class with the grid information within the SEQNAME field we want to use as part of our FACILITYID unique identifier. Is it because the WUD_GIS feature class is not within a dataset within the database? Does this grid feature class need to have a certain schema & reside in a particular dataset?

Very stumped as to what I am doing wrong? Do I need to edit something in the Attribute Assistant CONFIG file to make it possible? Let me know if either of you have any recommendations. Thanks!