topic Attribute Assistant Update Linked Record Value Method in Water Utilities Questions

Attribute Assistant Update Linked Record Value Method

ZachLawson — Fri, 24 May 2013 20:04:05 GMT

My office maintains a point feature class of all of our force main air release valves and a separate table with all the maintenance/inspections/etc done on these ARVs. What I want to happen is when a new maintenance item (a new row) is added to my ARV_Maintenance table, the Last_Inspection_Date field of my ARV feature class is updated with the date from the Inspection_Date field of the new row. It seems that UPDATE_LINKED_RECORD should do what I want, but I can't get it to work. I'm currently trying (and some variations thereof):

Table Name: ARV_Maintenance
Field Name: Inspection_Date
Value Method: UPDATE_LINKED_RECORD
Value Info: ARV|Last_Inspection_Date|Unique_ID|Unique_ID

What am I missing here?

Re: Attribute Assistant Update Linked Record Value Method

JohnathanLaughery — Tue, 08 Sep 2015 22:59:33 GMT

I'm having the same issue. Did you ever resolve your issue?

Re: Attribute Assistant Update Linked Record Value Method

JustinFlannery3 — Thu, 12 Oct 2017 13:26:18 GMT

I'm attempting to do something very similar and have been unable to get this method to work.

Re: Attribute Assistant Update Linked Record Value Method

MikeMillerGIS — Thu, 12 Oct 2017 13:28:26 GMT

Can you enable the Attribute Assistant log file, it will help us troubleshoot the issue.

Re: Attribute Assistant Update Linked Record Value Method

JustinFlannery3 — Thu, 12 Oct 2017 13:46:21 GMT

Edit Log Started at: 10/12/2017 8:41:17 AM
-----------------------------------------
Attribute Assistant start editing
Process Count: 0
Unwiring the events
#######################################################
Inspection - ON_CHANGE
Starting AA
***********************************************************
############ 10/12/2017 8:41:37 AM ################

Setting sort order: Field - RUNORDER
Querying table for Last Value for layer: Inspection
Query Used: (TABLENAME = '*' OR TABLENAME = 'Inspection' OR TABLENAME like 'Inspection|*' OR TABLENAME like 'Inspection|%') AND VALUEMETHOD = 'Last_Value'
Number of results: 0
Querying table for rules for layer: Inspection
Query Used: (TABLENAME = '*' OR TABLENAME = 'Inspection' OR TABLENAME like 'Inspection|*' OR TABLENAME like 'Inspection|%') AND ON_CHANGE = 1
Number of results: 1
Looping through the rows
------------------------------------------------
Row Info
Row Number 1
TableName: Inspection
FieldName: DATE
ValueInfo: BMP|LAST_INSPECTED|BMP_ID|BMP_ID
ValueMethod: UPDATE_LINKED_RECORD
On Create: 1
On Change: 1

Checking for Subtype Restriction
Field Name: DATE was found at index: 2
Trying: UPDATE_LINKED_RECORD
Getting Value Info
Checking values
Checking Field in Edited Layer
Checking for related record
Trying to Copy Value to the Record
ERROR: Could not Copy: 10/13/2017 12:00:00 AM to field: LAST_INSPECTED
Related record not found.
Finished: UPDATE_LINKED_RECORD
------------------------------------------------
DONE
---------------------------------------
#######################################################
Wiring the events
Attribute Assistant start editing
Attribute Assistant is being suspended
Attribute Assistant is being turn off
Attribute Assistant is being turn off
**************************************
Closing Log File 10/12/2017 8:41:54 AM

Edit: DATE and LAST_INSPECTED are both date fields. I'm using a file geodatabase.

Re: Attribute Assistant Update Linked Record Value Method

MikeMillerGIS — Thu, 12 Oct 2017 14:01:49 GMT

Looks like a bug trying to copy a date value. Any chance you could send me a sample set of data so I can create a repo case?

Re: Attribute Assistant Update Linked Record Value Method

JustinFlannery3 — Thu, 12 Oct 2017 14:06:15 GMT

Absolutely. I have only been testing a few things so I could send a copy of the entire geodatabase if you'd like. What is the best way to send the file?

Re: Attribute Assistant Update Linked Record Value Method

MikeMillerGIS — Thu, 12 Oct 2017 14:07:50 GMT

email is good, will try to look today - mmiller@esri.com

Re: Attribute Assistant Update Linked Record Value Method

MikeMillerGIS — Thu, 12 Oct 2017 14:26:00 GMT

Justin, what version of the tools are you using? Your data worked fine for me. I changed the date of a record in the inspection table and that value was set in the parent BMP.

Re: Attribute Assistant Update Linked Record Value Method

JustinFlannery3 — Thu, 12 Oct 2017 15:07:48 GMT

I am on ArcMap 10.4.1 and the Add-In Manager tells me that my Attribute Assistant version is 6.26.2015.

Re: Attribute Assistant Update Linked Record Value Method

MikeMillerGIS — Thu, 12 Oct 2017 15:10:03 GMT

That is a very old version, please update to the latest and try again

Re: Attribute Assistant Update Linked Record Value Method

JustinFlannery3 — Thu, 12 Oct 2017 15:22:16 GMT

Ahh, works like a charm now. I was loading my Add-Ins from a folder for an old version of ArcMap ... Thanks for helping me pinpoint that.

Re: Attribute Assistant Update Linked Record Value Method

AlinaTaus — Thu, 14 Dec 2017 16:30:28 GMT

I am trying to accomplish something similar but I want to populate the Last Inspection Date in my asset feature class with the year (YYYY format). Is there a way to set up this method to return just the year part from a date field?

Thanks!

Re: Attribute Assistant Update Linked Record Value Method

MikeMillerGIS — Thu, 14 Dec 2017 16:55:58 GMT

This method will pull the value to the source feature, you could then set up expression to pull out only the date.

Re: Attribute Assistant Update Linked Record Value Method

AlinaTaus — Thu, 14 Dec 2017 17:06:40 GMT

Thank you Mike. My problem is the Last Inspection Date field is only 4 characters long so I can't store the date in it. I was hoping I could combine an expression into this method but I guess that won't work. I think I will have to create a new field.