Using Generate ID with Attribute Assistant

5884
16
02-20-2014 11:05 AM
Labels (1)
WestervilleGIS
Occasional Contributor
I have never used the generate ID option on attribute assistant and I am having a hard time understanding what the values are in the 2 tables. 

http://resources.arcgis.com/en/help/localgovernment/10.1/index.html#/Generate_ID_table/028s0000009p0...

Tells me what goes in the GenerateID table, but I am not completely sure on the explanations that it is giving. 

Same thing with the Value Info for the DynamicValue table.

What I need to do is generate an ID starting at a certain number (say 35000) and then it increments by 1. I do not understand where I specify this start value of 35000.  I realize that this should be simple and I am apparently over complicating it.  Any help would be
great.  Thanks!
0 Kudos
16 Replies
JeffWard
Occasional Contributor III
Courtney,

In the GenerateID table you would create an entry with a name for your ID like AddressID in the Sequence Name field, then you would put 3500 in the sequence counter field.  Then in your Dynamic Value table you would put the name of your layer (actual name not the name in the TOC) in the Table Name field, then the ID field name in the Field Name field and GENERATE_ID in the Value Method field.  Then in the Value Info field you need to put the name of your ID value you created in the GenerateID table for example AddressID that I mentioned earlier.

The value in the sequence counter field of the Generate ID is the next value that will go into your ID field of your layer.

I blogged about some of my experience with the Attribute Assistant here.

Hope that helps.
Jeff Ward
Summit County, Utah
0 Kudos
JeffWard
Occasional Contributor III
Shoot, I should have used your values from your image as an example.

So in your case you want to change the value in the Sequence Counter field to 3499 (the field contains the last value assigned, so 3500 will be the next id to go to the new feature, I was wrong in my first post).  If you wanted your first ID to be 1 you would enter 0 in the Sequence Counter field.

Then in the Dynamic Value table for your LBRSADDRESSPOINTS_FRA entry all you need to change in your Value Info field is the name of the sequence, in your case - ADDR_ID_SEQ.  Those other things in brackets are optional and are used to add zeros or text portions to the ID, like if you were creating manholes you could use those optional parts to create MH-0025.  But where you are just incrementing integers, all you need in the Value Info field is ADDR_ID_SEQ.

Here is a link to the Generate ID value method.  And here is a link to all of the value methods.
Jeff Ward
Summit County, Utah
0 Kudos
WestervilleGIS
Occasional Contributor
Thanks for the reply.  I did find your link prior to submitting to this forum and I tried to use it along with a couple of other and I still can not get it to work. See the attachement to view all parts.

I have the layer properties there so you can see that the feature class name that = the Table Name in the DynamicValue table.

The table for that feature class is open to show that the Addr_ID is still null on the new one I created with the setting in that GenerateID and DynamicValue tables that are visible.
0 Kudos
JeffWard
Occasional Contributor III
I would change your entry in the Dynamic Value table in the Table Name field to match your layer's name exactly.  So I would change it to be LBRSaddresspoints_Fra to match the Feature Class name exactly.
Jeff Ward
Summit County, Utah
0 Kudos
WestervilleGIS
Occasional Contributor
Unfortunately that doesn't make a difference.  The other methods work just fine, just not this one.  I have been waiting a few hours for tech support to call me back about something else, maybe I can ask about this too. 🙂  Thanks for trying
0 Kudos
JeffWard
Occasional Contributor III
You might also have problems because you are trying to use the ADDR_ID field to calculate your ADDR_UNIQ field.  The Attribute Assistant runs the value methods in order they are in the table, so in your case it is attempting to create your ADDR_UNIQ field value based on your ADDR_ID field which it hasn't created yet.  In 10.2 there is another field added to Dynamic Value table called Run Order where you can specify which order the value methods are executed.

Also, make sure the field names are exact the way they show up in the layer properties dialog on the fields tab.  You need the actual names of the fields, not the alias.
Jeff Ward
Summit County, Utah
0 Kudos
JeffWard
Occasional Contributor III
Another thing with the Attribute Assistant, after you save edits in your Dynamic Value or GenerateID tables, you need to stop and start the Attribute Assistant.  It will re-read the dynamic value table.
Jeff Ward
Summit County, Utah
0 Kudos
WestervilleGIS
Occasional Contributor
I tried to reorder the table so that the Generate ADDR_ID was at the top and also to stop the attribute and restart the attribute assistant.  Still nothing.
0 Kudos
JeffWard
Occasional Contributor III
Do you have the log file option turned on?
Jeff Ward
Summit County, Utah
0 Kudos