Latest Contributions by JeremiahMartin

‎01-04-2019

I believe it is the latest version as of June 27, 2018, as that is when I downloaded it from Git. I don't think there have been any new releases since January 8, 2018.

‎01-04-2019

I have attached two log files. One where I am splitting the line with a valid relationship, ServiceID = 007000026, and one where I entered an invalid one, ServiceID = 12345. You can see that when the ServiceID = 007000026 the AA returns Null/Empty String, but when it's 12345 it correctly returns 12345. I am still working on getting you a small dataset.

‎01-04-2019

Let me try to explain the data model a little better: There is a table called P_ServicesSummary. This table gets a uniqueid called ServiceID generated by Attribute Assistant. There is a 1:M relationship between P_ServicesSummary (Origin) ServiceID (PK) to the feature class P_Service(Destination) ServiceID (FK). If the P_Service feature that I am splitting has a ServiceID value that matches a ServiceID in the P_ServicesSummary, it will return null as the value; however, if I enter "dumb data" into the ServiceID field like "12345", so there isn't a matching record in P_ServicesSummary table. The get value will return the "12345" and copy it to the newly created service feature correctly. I will send the log information shortly.

‎01-04-2019

OK, so I tested changing this value from "False" to "True" and it still doesn't work. The fields that do not have a relationship class with a link record work correctly, but the ServiceID field doesn't. For example, my InServiceDate and InServiceYear will copy to the newly created split feature, but the ServiceID does not.

‎01-04-2019

The key "OnCreateWhenSplit" has it's value set to "False". Should I change this to "True"?

‎01-04-2019

Michael Miller attributeassistant‌ I have Attribute Assistant configured to copy a ServiceID (Foreign Key field) from one Intersecting Service Pipe to another Intersecting Service Pipe. This works correctly when placing a new Service Pipe feature; however, I get inconsistent results when splitting an existing Service Pipe feature. If the ServiceID field has a value that doesn't link to a record, it will work correctly and copy the ServiceID to the new Service Pipe feature that gets created by the split. However, if the ServiceID field has a value that does link to a record, the value is not copied. In the AA code, sourceFeature.get_Value(sourceField) returns null if there is a linked record, but returns the ServiceID value when I put in a ServiceID that doesn't match a record. Is this a bug, or does anyone know a way to work around this? Here is the exact configuration: TABLENAME FIELDNAME VALUEMETHOD VALUEINFO ON_CREATE ON_CHANGE ON_CHANGEGEO ON_MANUAL RUN_WEIGHT COMMENTS P_Service ServiceID INTERSECTING_FEATURE P_Service|ServiceID 1 0 1 0 10

‎09-11-2018

This is resolved now. I didn't catch that I had typed IFF instead of IIF. Thanks to Michael Miller‌!

‎09-11-2018

I'm an idiot! That was it. I stared at this forever and didn't catch that. You rock and thanks for the fast reply!

‎09-11-2018

I have tried the same thing, but I get a Type Mismatch error. Do you know what might cause this? Row Info Row Number 29 TableName: Building FieldName: CityVillage ValueInfo: IFF(isNull([CityVillage]), [Township], [CityVillage]) ValueMethod: EXPRESSION On Create: 1 On Change: 1 Checking for Subtype Restriction Field Name: City Village was found at index: 20 Trying: EXPRESSION replace field: Township with a value replace field: CityVillage with a value replace field: CityVillage with a value Checking to verify there is a field to store the expression Expression to be eval: IFF(True, "OAKLAND", "") ERROR: evaluating the expression for feature in Building with OID of 15859 System.Runtime.InteropServices.COMException (0x800A000D): Type mismatch: 'IFF' at MSScriptControl.ScriptControlClass.Eval(String Expression) at ArcGIS4LocalGovernment.AttributeAssistantEditorExtension.SetDynamicValues(IObject inObject, String mode, List`1& ChangeFeatureList, List`1& NewFeatureList, List`1& ChangeFeatureGeoList) in C:\Projects\GitHub\local-government-desktop-addins\Attribute Assistant Add In\AttributeAssistantAddIn\AttributeAssistantEditorExtension.cs:line 12514 Finished: EXPRESSION

‎09-11-2018

Attribute Assistant - Expressions: I am getting an error with my IFF expression that I cannot figure out how to resolve. I am using Version 3.1.17 of the Attribute Assistant. Here is my configuration values: TABLENAME FIELDNAME VALUEMETHOD VALUEINFO Building CityVillage EXPRESSION IFF(isNull([CityVillage]), [Township], [CityVillage]) Here is the error log: ---------------------------------------------------------------------------------------------------------- Row Info Row Number 29 TableName: Building FieldName: CityVillage ValueInfo: IFF(isNull([CityVillage]), [Township], [CityVillage]) ValueMethod: EXPRESSION On Create: 1 On Change: 1 Checking for Subtype Restriction Field Name: City Village was found at index: 20 Trying: EXPRESSION replace field: Township with a value replace field: CityVillage with a value replace field: CityVillage with a value Checking to verify there is a field to store the expression Expression to be eval: IFF(True, "OAKLAND", "") ERROR: evaluating the expression for feature in Building with OID of 15859 System.Runtime.InteropServices.COMException (0x800A000D): Type mismatch: 'IFF' at MSScriptControl.ScriptControlClass. at ArcGIS4LocalGovernment.AttributeAssistantEditorExtension.SetDynamicValues(IObject inObject, String mode, List`1& ChangeFeatureList, List`1& NewFeatureList, List`1& ChangeFeatureGeoList) in C:\Projects\GitHub\local-government-desktop-addins\Attribute Assistant Add In\AttributeAssistantAddIn\AttributeAssistantEditorExtension.cs:line 12514 Finished: EXPRESSION -------------------------------------------------------------------------------------------------------- The goal is to copy the Township value to the CityVillage field if the CityVillage is null and do nothing if it isn't null. I have tried to use the following expression, but get the same error: IFF(isNull([CityVillage]), [Township], "<NULL>"). I even downloaded the AA source code and traced through it to see why it was failing. It fails on the following line of code: Looking at what the string newValue has stored prior to the above call is IFF(True, \"Oakland\", \"\") I have look at other posts, but haven't found anything that helped. Does anyone know what could be causing this?

Online Status	Offline
Date Last Visited	‎02-07-2024 06:01 PM

My Ideas

Latest Contributions by JeremiahMartin

Re: Attribute Assistant: INTERSECTING_FEATURE doesn't work with split and there is a relationship using the field to copy.

Re: Attribute Assistant: INTERSECTING_FEATURE doesn't work with split and there is a relationship using the field to copy.

Re: Attribute Assistant: INTERSECTING_FEATURE doesn't work with split and there is a relationship using the field to copy.

Re: Attribute Assistant: INTERSECTING_FEATURE doesn't work with split and there is a relationship using the field to copy.

Re: Attribute Assistant: INTERSECTING_FEATURE doesn't work with split and there is a relationship using the field to copy.

Attribute Assistant: INTERSECTING_FEATURE doesn't work with split and there is a relationship using the field to copy.

Re: Attribute Assistant - Expressions: Why am I getting a Type mismatch error with IFF?

Re: Attribute Assistant: Populate Field if NULL

Re: Attribute Assistant: Populate Field if NULL

Attribute Assistant - Expressions: Why am I getting a Type mismatch error with IFF?