Skip to main content

I must be underfed or under caffeinated as this seems to be a simple logical sequence:use workbench to read a fgdb (metadata), use xmlflattener transformer and write attributes to an excel table, however all features are rejected in the XML Flattener:

things to note:

at the end of the day i am trying to compare a certain subset of the esri metadata attributes and i know the xpaths of the attributes that i want to compare so if there is an easier way to achieve this i am all ears:

ex:

/metadata/dataIdInfo/idCitation/resTitle

/metadata/dataIdInfo/idPurp

/metadata/dataIdInfo/idAbs

/metadata/dataIdInfo/idCredit

thanks

I can't reproduce your issue with the rejected feature. You should be able to enter the Elements to Match something like: 

metadata/dataIdInfo

and that will flatten all the items below that. 

One trick when trying to figure out the structure of your XML file: If you save one of your metadata examples to a file, you can then use the tree view in the XML reader to find the nested tags and select the one you want. You can then copy and paste the selected item into your XMLFlatterner Elements to Match : 

0684Q00000ArKZUQA3.jpg

The tree view was added in FME 2017 and helps you visualize the hierarchy of the XML file. 


Reply