Skip to main content
Solved

Create Excel-List of layers out of GetCapabilities-Document

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

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)

​

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

hkingsbury
Celebrity
Forum|alt.badge.img+65
  • 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

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.