POST
|
I have an Attribute Assistant rule set up to pull attributes from the nearest feature but when it doesn't find the feature it overwrites every field with null values.
... View more
07-11-2016
05:50 AM
|
1
|
0
|
695
|
POST
|
This one has me stumped. What do I need to do to get this to work? My goal is to populate a value from an intersecting polygon. The value will come from one of two polygons and the choice is made based on the value in the "TOWNCODE" field. Row Info Row Number 1 TableName: SAWS_Addresses FieldName: MCYCLE ValueInfo: BNDRY_Meter_Routes|CYCLE ValueMethod: INTERSECTING_FEATURE On Create: 0 On Change: 0 Checking for Subtype Restriction Field Name: MCYCLE was found at index: 29 Trying: INTERSECTING_FEATURE Starting to process rule Value Info is: BNDRY_Meter_Routes|CYCLE Layer Found: Meter Routes CYCLE: at 1 Searching on feature Class Cursor created Starring Loop of found features Checking Class Different FCs Setting Value: 09 Value Set Finished: INTERSECTING_FEATURE ------------------------------------------------ ------------------------------------------------ Row Info Row Number 2 TableName: SAWS_Addresses FieldName: TPROD ValueInfo: DSP_Meter_Routes|CYCLE ValueMethod: INTERSECTING_FEATURE On Create: 0 On Change: 0 Checking for Subtype Restriction Field Name: TPROD was found at index: 68 Trying: INTERSECTING_FEATURE Starting to process rule Value Info is: DSP_Meter_Routes|CYCLE Layer Found: DSP Meter Routes CYCLE: at 2 Searching on feature Class Cursor created Starring Loop of found features Checking Class Different FCs Setting Value: 02 Value Set Finished: INTERSECTING_FEATURE ------------------------------------------------ ------------------------------------------------ Row Info Row Number 3 TableName: SAWS_Addresses FieldName: MCYCLE ValueInfo: IIF([TOWNCODE]="Q",[TPROD],IIF([TOWNCODE]="U",[TPROD],IIF([TOWNCODE]="Z",[TPROD],IIF([MCYCLE] IS NULL,"NA",[MCYCLE])))) ValueMethod: EXPRESSION On Create: 0 On Change: 0 Checking for Subtype Restriction Field Name: MCYCLE was found at index: 29 Trying: EXPRESSION replace field: MCYCLE with a value replace field: MCYCLE with a value replace field: TOWNCODE with a value replace field: TOWNCODE with a value replace field: TOWNCODE with a value replace field: TPROD with a value replace field: TPROD with a value replace field: TPROD with a value Checking to verify there is a field to store the expression ERROR: evaluating the expression for feature in SAWS Addresses with OID of 532962 Object required Finished: EXPRESSION I'm working with the slightly older Infrastructure Editing Template from 6-29-2012.
... View more
10-15-2013
06:21 AM
|
0
|
1
|
2109
|
POST
|
Thanks so much!! The isnull works! I also did not realize the iif statement evaluated both true/false parts. So now when I evaluate the is null I populate a string "SetFromSomeField" and then use the Replace() to set it, works with Year() too. Run_order | Value_info 1] | [UNITDESC] & ", MH DEPTH " & IIF(isNull([MHDPTH]),"UNKNOWN","SetMhDpth") 2] | REPLACE([UNITDESC],"SetMhDpth",[MHDPTH] & "FT")
... View more
09-19-2011
12:48 PM
|
0
|
0
|
273
|
POST
|
What I am trying to do is populate a unit description field. A text field verbally describing the asset's attributes. The difficulty with this is that I need to say when I don't have attributes. i.e.; ASBUILT NONE, MANHOLE DEPTH UNKNOWN. As opposed to ASBUILT 05-1515, MANHOLE DEPTH 5.7FT. So what I attempted to do was evaluate if the attribute had a value or not and then populate accordingly. Well this works fine if it's a new feature. But when I find that my manhole depth is incorrect because the invert was set to "0" and I "<null>" the data the attribute assistant fails. And I was trying to use the ="" where I could because the isnull has a syntax error when the value IS NULL. I attempted to us Cstr() to force it to work too. Oh well. Words are such a sorry example of actual work. 😞 I can only hope this explanation will help in the understanding of the previous post. 🙂
... View more
09-16-2011
01:29 PM
|
0
|
0
|
273
|
POST
|
Ok, I have the Beta installed and tested. The isNull still doesn't work, the same way it didn't work before. If there is a value it passes a "false" if the value is <null> I get a syntax error. IIF([INSTDATE]="","NONE",YEAR([INSTDATE])) First run results: INSTDATE=somevalue I get the year of that value! yeah. First run results: INSTDATE=<null> I get "NONE"! yeah. run results: INSTDATE=somevalue then set it to null I get a data type error. Boo! run results: INSTDATE=<null> then set a date I get the year of that date! yeah! One more issue, when I set a nonstring data type fields (ie; Double) ="" I get a data type error if it is null. Here's to me wishing there was an emoticon beating it's head against the wall because thats how I feel.
... View more
09-16-2011
11:53 AM
|
0
|
0
|
997
|
POST
|
Row Info Row Number 1 TableName: SWR_Manholes FieldName: UNITDESC ValueInfo: IIF(isNull([MHDPTH]),"UNKNOWN",[MHDPTH]) ValueMethod: EXPRESSION On Create: 1 On Change: 0 Order: 6 Checking for Subtype Restriction The Field in the Field Name is not found: value(25) Trying: EXPRESSION replace field: MHDPTH with a value replace field: MHDPTH with a value ERROR: evaluating the expression for feature in SWR Manholes with OID of 24849 Syntax error Finished: EXPRESSION After we translate the fields to values, we pass the expression to the MSScriptControl.ScriptControlClass object. I think you want to us the isNull expression, so like below: IIF(isNull([FIELD]),TrueValue,FalseValue)
... View more
09-16-2011
06:25 AM
|
0
|
0
|
997
|
POST
|
Where can I find documentation on what type of arguments work with the expression value method in the DynamicTable for the infrastructure editing toolbar's attribute assistant? I'm having some trouble with data types among other things. One example looks like this: ...IIF([INSTDATE]="","NONE",YEAR([INSTDATE]))... I get an error of wrong data type while this work fine: ...", YEAR INSTALLED " & YEAR([INSTDATE])... I used the "" because I could not figure out the syntax for ISNULL. I get alot of syntax errors not knowing what functions/operators work with the Expression Value Method.
... View more
09-15-2011
01:46 PM
|
0
|
12
|
6177
|
POST
|
Thank you for your reply, it points out how poor of a post I made. My problem comes from having many (400,000+) records needing updated. If this data were in a file geodatabase it would be fine because I can set the number of records to write in a transaction. The problem is I'm working in a version and can't run transactions. What I want to avoid is having to manually split the data into smaller sets and run one after the other instead of automating the whole process in Data Interoperability (DI).
... View more
05-03-2010
08:18 AM
|
0
|
0
|
269
|
POST
|
I have been trying to find a way to run my Spatial ETL tools in smaller sets and need help. I work in a version and process 400000+ records in a single translation and that wrecks havoc on the server and the adds/deletes tables. Any advice on how to run these large data sets would be greatly appreciated.
... View more
04-30-2010
06:52 AM
|
0
|
3
|
857
|
Title | Kudos | Posted |
---|---|---|
1 | 07-11-2016 05:50 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|