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]> 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]>
> 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
>
>
------------------------------------------------------------------------------
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
