Skip to main content
Question

Schema/Attribute Validation

  • May 1, 2013
  • 2 replies
  • 97 views
M
Hi everyone :)

 

 

I have (another!) newbie question. I'm attempting to set up a workbench whose purpose is to do attribute validation/checking between a shapefile and a feature class in an ESRI SDE geodatabase.

 

 

What I need to do is compare attribute existence and some key properties (attribute name/alias/data-type/precision/length etc) between the two datasets. If the attributes/properties are the same, then proceed with some further processing of the shapefile, but if they are different to end processing and generate a basic log-like tabular/text based output detailing the differences.

 

 

Is there a particular methodology that can easily acheive this? So far I'm struggling to understand the best way to set up a flow of transformers that collects and examines attribute properties of feature type(s) (as opposed to attribute values on a per feature basis).

 

 

Any ideas/suggestions appreciated :)

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

fmelizard
Safer
Forum|alt.badge.img+22
  • fmelizardSafer
  • Safer
  • May 1, 2013
Hi,

 

 

For this case I would look at the schema readers to extract the schema properties before comparison.

 

Hope this helps. 
fmelizard
Safer
Forum|alt.badge.img+22
  • fmelizardSafer
  • Safer
  • May 10, 2013
Yes, the key thing is to use the SchemaReader, and set it up to read schema from one of your datasets, and then use another to get the other schema. Then you can use things like the Matcher to compare the key things you want compared.  I'd use the Logger to see exactly what information is coming through from the SchemaReader as well.

Community Stats

32,673
Posts
123,981
Replies
41,108
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.