Hello there
we have exported a GDB to XML and we want to extract the dataset name the filed type, domain name, and in another table the domain name and domain value, this information will be used for mapping purpose
Hello there
we have exported a GDB to XML and we want to extract the dataset name the filed type, domain name, and in another table the domain name and domain value, this information will be used for mapping purpose
Thanks for the question and sample data. For an example of how to read geodatabase XML documents see: https://knowledge.safe.com/articles/845/geodatabase-xml-workspace-document-schema-reader.html
I tried reading your XML source with it and it worked fine. Note that if you do not have ArcGIS installed on the same machine as FME you might want to disable the geodatabase xml schema reader part of the workspace (the second reader) as I believe this consumes an ESRI license. But the regular XML reader part will still show how to read the domain code tables with FME.
Thanks for the question and sample data. For an example of how to read geodatabase XML documents see: https://knowledge.safe.com/articles/845/geodatabase-xml-workspace-document-schema-reader.html
I tried reading your XML source with it and it worked fine. Note that if you do not have ArcGIS installed on the same machine as FME you might want to disable the geodatabase xml schema reader part of the workspace (the second reader) as I believe this consumes an ESRI license. But the regular XML reader part will still show how to read the domain code tables with FME.
@DeanAtSafe
Thanks so much, Dean this is exactly what we are looking for
******
@DeanAtSafe
Hello, Dean, I wasn't able to find a way to associate the subtype to the domain and the attributes type ( subtype )
do you have any suggestions please
Thanks
@DeanAtSafe
Hello Dean Any update on this issue
Thanks
@DeanAtSafe
Hello, Dean, I wasn't able to find a way to associate the subtype to the domain and the attributes type ( subtype )
do you have any suggestions please
Thanks
@DeanAtSafe
Hello Dean
Any chance you can help on the issue please
Thanks
@DeanAtSafe
Hello, Dean, I wasn't able to find a way to associate the subtype to the domain and the attributes type ( subtype )
do you have any suggestions please
Thanks
You will need to use both the XML reader for the GDB XML and the geodatabase reader to read in your data records. If you have the SubtypeCode in your data, you should be able to use a FeatureMerger or FeatureJoiner to match on SubtypeCode and then use that to join with the Subtype feature type from the gdbXML to get the SubtypeName. The same approach should work for DomainName and Description.
If you have any trouble with this it would probably be best to follow up via support. I will probably need to see your data and workspace in order to make more specific recommendations. Please send a note to and put 'attention Dean' in the subject line and I will pick it up.