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]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
