Skip to main content
Solved

Extract domain and value from XML file

  • December 17, 2018
  • 6 replies
  • 56 views
boubcher
Contributor
Forum|alt.badge.img+11

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

 

 

 

 

Best answer by deanatsafe

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.

View original
    Did this help you find an answer to your question?

    6 replies

    deanatsafe
    Safer
    Forum|alt.badge.img+6
    • deanatsafeSafer
    • Safer
    • Best Answer
    • December 17, 2018

    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.

    boubcher
    Contributor
    Forum|alt.badge.img+11
    • boubcherContributor
    • Author
    • Contributor
    • December 18, 2018
    deanatsafe wrote:

    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

    ******

     

    boubcher
    Contributor
    Forum|alt.badge.img+11
    • boubcherContributor
    • Author
    • Contributor
    • December 31, 2018

    @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

    boubcher
    Contributor
    Forum|alt.badge.img+11
    • boubcherContributor
    • Author
    • Contributor
    • January 4, 2019

    @DeanAtSafe

    Hello Dean Any update on this issue

    Thanks

     

    boubcher
    Contributor
    Forum|alt.badge.img+11
    • boubcherContributor
    • Author
    • Contributor
    • January 8, 2019
    boubcher wrote:

    @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
    Safer
    Forum|alt.badge.img+6
    • deanatsafeSafer
    • Safer
    • January 8, 2019
    boubcher wrote:

    @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.

    Reply


    Helpful Members This Week

    Community Stats

    31,341
    Posts
    118,858
    Replies
    38,942
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    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.