Select to view content in your preferred language

Using Generate ID with Attribute Assistant

10192
16
02-20-2014 11:05 AM
WestervilleGIS
Regular 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
WestervilleGIS
Regular Contributor
Here is the info for my field to show that it is correct.
0 Kudos
WestervilleGIS
Regular Contributor
I do not think so.....
0 Kudos
JeffWard
Honored Contributor
It may be that you are trying to put an integer in a double field.
Jeff Ward
Summit County, Utah
0 Kudos
WestervilleGIS
Regular Contributor
does the generate id only work with integers?
0 Kudos
JeffWard
Honored Contributor
I think it actually needs a string field so it can add the constant prefixes like I mentioned in an earlier post.  Like MH-00025.  I was assuming it entered an integer because that's essentially what mine are, but the field is actually a string field.
Jeff Ward
Summit County, Utah
0 Kudos
WestervilleGIS
Regular Contributor
And that is where I get lost.  This is what I put into it.

ADDR_ID_SEQ|7|[seq].0

7 is the length of the number that I am using (it is predetermined because I have a valid range of 3,500,000-3,999,999)

If I need to make it a double, then I added the .0

I do not want to take any more of your time and I appreciate all of your help, but am I not understanding it correctly?  I can contact tech support.
0 Kudos
JeffWard
Honored Contributor
I would enable the log file and see what it says.  Here is a link that describes how to turn on the log file and where it is located.  But if you are using 10.1, here is a link showing how to turn on the log file and configure the AA for 10.1.

I am assuming that you are unable to change the field types, or add intermediary fields that you could use to construct your ID?  For example, you could create a string field called PRE_ADD_ID, have the GenerateID populate that one, then have another entry in the DynamicValue table that used the Expression value method to convert that string to a double.  With the Expression value method you can use a VB expression to populate the field.

You could set up another copy of the feature class that would allow you to add intermediary fields, use them to populate the original field after it is converted to the correct type, then append the features to the original feature class.
Jeff Ward
Summit County, Utah
0 Kudos