Skip to main content
Solved

Create Excel-List of layers out of GetCapabilities-Document

  • February 15, 2024
  • 1 reply
  • 40 views
vki
Contributor
Forum|alt.badge.img+7
  • vkiContributor
  • Contributor

I would like to create an Excel list from our GetCapabilities document, where all our wms services are listed.
Some of our services are grouped together and I don't want to list these group layers, just the lowest level of layers.
The list should include name, title, abstract and metadata link (xlink:href).
I have searched the community for examples, and although there are many questions about XML, I have not been able to apply these solutions to my problem and thus create a list.
I probably have to use the XQueryExtractor to find the desired layer elements, but I am not able to insert the XQuery expression (Layer[child::CRS]).

URL: https://map.geo.sz.ch/mapserv_proxy?SERVICE=WMS&REQUEST=GetCapabilities&lang=de

Any help will be appreciated!

Thanks in advance
Vera

Best answer by hkingsbury

​I was able to achieve it using an XML fragmenter and to break it down to a feature per layer.

I had to go two layers deep as there seems to be only one layer at the top level, with (i’m assuming) the layers you want under that.

The attached is in 2023.1 (had to zip it as the platform doesn’t seem to like me uploading an FMW @mark2atsafe)

​

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

1 reply

hkingsbury
Celebrity
Forum|alt.badge.img+54
  • hkingsburyCelebrity
  • Celebrity
  • Best Answer
  • February 15, 2024

​I was able to achieve it using an XML fragmenter and to break it down to a feature per layer.

I had to go two layers deep as there seems to be only one layer at the top level, with (i’m assuming) the layers you want under that.

The attached is in 2023.1 (had to zip it as the platform doesn’t seem to like me uploading an FMW @mark2atsafe)

​

1 Attachments
danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme

Reply


Helpful Members This Week

Community Stats

31,341
Posts
118,850
Replies
38,930
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.