I am digging around and with the WPS Request Builder I used vec:Transform as
the process. This process allows me to change the column name of the data
returned which is good news. The other piece of this is the process outputs. I
do not see an output for Excel. I ran fiddler2 as a proxy to modify the http
request to state the RawDataOutput MimeType as excel instead of
application/json. This gives me an error “An error occurred while encoding the
results of the process INVALID_CHARACTER_ERR: An invalid or illegal XML
character is specified.” From the following java object
“org.geoserver.wps.WPSException: An error occurred while encoding the results
of the process” (complete stack below) I also noticed the wps:DataInputs
contain an outputFormat which always appears as GML2. I would like to
understand the difference in the two output formats. I suspect that the excel
plugin isn’t configured to work with the output specification of this WPS
process… Any thoughts from someone more knowledgeable than me?
org.geoserver.wps.WPSException: An error occurred while encoding the results of
the process
at
org.geoserver.wps.response.ExecuteProcessResponse.writeComplex(ExecuteProcessResponse.java:200)
at
org.geoserver.wps.response.ExecuteProcessResponse.write(ExecuteProcessResponse.java:169)
at org.geoserver.ows.Dispatcher.response(Dispatcher.java:919)
at
org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:276)
at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:27)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:74)
at
org.geoserver.flow.controller.IpBlacklistFilter.doFilter(IpBlacklistFilter.java:87)
at
org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:70)
at
org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:45)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:49)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
at
org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68)
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
at
org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.geoserver.security.filter.GeoServerAnonymousAuthenticationFilter.doFilter(GeoServerAnonymousAuthenticationFilter.java:53)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68)
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
at
org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
at
org.geoserver.security.filter.GeoServerBasicAuthenticationFilter.doFilter(GeoServerBasicAuthenticationFilter.java:82)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at
org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1.doFilter(GeoServerSecurityContextPersistenceFilter.java:46)
at
org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
at
org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at
org.geoserver.security.GeoServerSecurityFilterChainProxy.doFilter(GeoServerSecurityFilterChainProxy.java:103)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:75)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:48)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:47)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.w3c.dom.DOMException: INVALID_CHARACTER_ERR: An invalid or
illegal XML character is specified.
at org.apache.xerces.dom.CoreDocumentImpl.checkQName(Unknown
Source)
at org.apache.xerces.dom.ElementNSImpl.setName(Unknown Source)
at org.apache.xerces.dom.ElementNSImpl.<init>(Unknown Source)
at
org.apache.xerces.dom.CoreDocumentImpl.createElementNS(Unknown Source)
at
org.geotools.xml.impl.ElementEncodeExecutor.<init>(ElementEncodeExecutor.java:63)
at
org.geotools.xml.impl.ElementEncoder.encode(ElementEncoder.java:84)
at org.geotools.xml.Encoder.encode(Encoder.java:1136)
at org.geotools.xml.Encoder.encode(Encoder.java:864)
at org.geoserver.wps.ppio.WFSPPIO.encode(WFSPPIO.java:191)
at
org.geoserver.wps.XMLEncoderDelegate.encode(XMLEncoderDelegate.java:30)
at
org.geoserver.wps.response.ExecuteProcessResponse.writeComplex(ExecuteProcessResponse.java:196)
... 83 more
From: Nowak, Michael J.
Sent: Tuesday, September 16, 2014 7:48 AM
To: 'Jody Garnett'
Cc: [email protected]
Subject: RE: [Geoserver-users] transform columns of excel output plugin
I will look into this now. Thank you so much for the lead. I’ll write back with
an update when I have it.
-Mike
From: Jody Garnett [mailto:[email protected]]
Sent: Monday, September 15, 2014 5:37 PM
To: Nowak, Michael J.
Cc:
[email protected]<mailto:[email protected]>
Subject: Re: [Geoserver-users] transform columns of excel output plugin
Thanks Mike, can you try the WPS process? I am not sure if it supports Excel
output (or if supporting Excel output would be easy to add).
Jody Garnett
On Mon, Sep 15, 2014 at 2:18 PM, Nowak, Michael J.
<[email protected]<mailto:[email protected]>> wrote:
I originally talked with Jody about my question at FOSS4G and I followed up by
email. I am documenting this email here… My original problem/question is that I
have looked at the excel plugin for geoserver. This plugin copies the names of
the columns in my database. The database column names are not user friendly
names and the excel plugin could allow an easy way to grab the data filtered
out by CQL if I was able to change the column names through some means in
geoserver.
Andrea said he would follow up with this request this week.
Jody mentioned there may be a way using the Transform Operation. I followed up
by email today, and he suggested a couple of things. I am hoping to spark
discussion to figure out if anyone has done what I am hoping to do or if anyone
has any feedback on how this might be accomplished. I believe the quickest way
for me to try anything out is the WPS process. I will look into that solution
first but would appreciate it if anyone could give me advice/help on if I am
barking up the wrong tree.
-Mike
Morning Mike: we should have this conversation on the geoserver-users list (or
geotools users list).
Here is the original functionality (with user interface):
* http://udig.github.io/docs/user/reference/Transform%20operation.html
It has been packaged as a WPS process here (does WPS support CSV or Excel
output?)
*
http://docs.geotools.org/latest/userguide/unsupported/process/process-feature.html
Andrea has also packaged it up for developers as a FeatureSource / FeatureStore
wrapper:
*
http://docs.geotools.org/latest/javadocs/org/geotools/data/transform/TransformFeatureSource.html
*
http://docs.geotools.org/latest/javadocs/org/geotools/data/transform/TransformFeatureStore.html
This should mean we could create a proposal to add a GeoServer "java view"
(similar to sql view) allowing us to create new feature types directly in
GeoServer. I should put that our "wishlist" for good ideas needing a volunteer
or sponsor.
--
Jody
On Mon, Sep 15, 2014 at 10:12 AM, Nowak, Michael J.
<[email protected]<mailto:[email protected]>> wrote:
Jody,
Thank you for the geotools tutorial on Tuesday. I am also thankful for your
assistance while out at FOSS4G. One of the issues we talked about in passing
is if I can change the column names of the excel output format on the Excel
plugin for GeoServer. You mentioned I may have some luck with the transform
plugin. I’ve done some digging around and I suspect I just don’t know where to
look for what you described. Where can I find documentation of the transform
plugin that may be able to accept the output format of the excel format?
-Mike Nowak
Argonne National Laboratory
------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce.
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
