Question

How to write esri fgdb metadata to a table

  • 22 November 2017
  • 1 reply
  • 1 view
N

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

1 reply

M
Badge +2

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


Community Stats

28,670
Posts
109,366
Replies
36,531
Members
Terms & ConditionsCookie 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.