Please Help.....Domain Code Values

Hi,

 

if the attribute mapping is static as is the case for domain values you can make use of the attribute value mapper to map the excel attributes.

 

 

To make sure you domain values are valid you can set the option to validate to yes on the writer properties (navigator window).

 

 

Hope this helps ,

 

Itay

Hi,

 

 

Alternatively, if the code-value mapping is defined in a table, you can also read the table and merge a value matched with the code to each feature using the FeatureMerger.

 

As another option, the Joiner might be also usable if it's guaranteed that all the codes are valid.

 

 

Takashi

I do not think Data Interoperability has the validate option? I looked for it and seen in a screen shot on a help doc, but still can not find it in the program? Are you aware if it does or not? thanks again.

The Data Interoperability Extension shouls have the "Validate Features" parameter. I found it in ArcGIS 10.1 Data Interop. It is an Advanced Parameter under the Writer parameters in the Navigate pane. All features in all feature classes will be validated if you set this to "Yes" - which can result in slower loading of the features. 

 

 

If you are confident in the values in the Excel spreadsheet it is also possible to load them by using the _resolved option of an attribute which is linked to domain values. For example 

 

 

The Attribute Size (say) has the code value 78 but Size_resolved has the value 8"x6"

 

 

So it is possible to load the data into the geodatabase by renaming the incoming source attribute to the Size_resolved attribute and have the data load correctly into the Geodatabase. 

 

 

If you don't validate the features then it will load invalid values but you could use a Toolbox Tool to validate after the fact.

 

 

I hope this helps.

 

 

Regards,

 

Robyn Rennie

 

 

 

 

I found it!!!! Thank you VERY much FME experts. Also it should not matter if the excel file i am using has "List" pulldowns in the cells does it?

 

Robyn what you said here "load the data into the geodatabase by renaming the incoming source attribute to the Size_resolved attribute and have the data load correctly into the Geodatabase" is exactly what i am trying to accomplishWhat transformer do you use? Thanks again for all the help.