search

nakijun / morisoliver

Automatically exported from code.google.com/p/morisoliver
0 stars 0 forks source link

Allow export of Excel and CSV from the query window #157

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Another issue addresses Excel and CSV output from the Export button.  It would 
also be nice to select a set of rows from the Feature details and go to Excel 
or CSV right from there. 

DOR's Dave Davies support this.

Original issue reported on code.google.com by Aleda.Fr...@state.ma.us on 21 Jun 2012 at 6:15

GoogleCodeExporter commented 9 years ago 
GeoServer 2.1.4 to be available approx. 10/18/2012 on giswebservices will offer 
support for .xlsx as well as .xls:

Excel 97-2003 (.xls) format:

http://giswebservices.massgis.state.ma.us/geoserver/wfs?request=GetFeature&servi
ce=wfs&version=1.0.0&typename=massgis:GISDATA.TOWNS_POLY&outputformat=excel

Excel 2007 (.xlsx) format:

http://giswebservices.massgis.state.ma.us/geoserver/wfs?request=GetFeature&servi
ce=wfs&version=1.0.0&typename=massgis:GISDATA.TOWNS_POLY&outputformat=excel2007

Original comment by Aleda.Fr...@state.ma.us on 24 Sep 2012 at 7:47

GoogleCodeExporter commented 9 years ago 
r378 commits enable this functionality.

Original comment by cpl...@gmail.com on 26 Oct 2012 at 3:10

Attachments:

GoogleCodeExporter commented 9 years ago

Original comment by cpl...@gmail.com on 26 Oct 2012 at 6:54

GoogleCodeExporter commented 9 years ago 
r389 gives these exports SDE names

Original comment by cpl...@gmail.com on 31 Oct 2012 at 5:43

GoogleCodeExporter commented 9 years ago

Original comment by Aleda.Fr...@state.ma.us on 31 Oct 2012 at 5:50

GoogleCodeExporter commented 9 years ago

Original comment by Aleda.Fr...@state.ma.us on 1 Nov 2012 at 3:17

GoogleCodeExporter commented 9 years ago 
Found something.  If I do an identify and then clear a feature or two from the 
set, they are still contained in the Excel or CSV output.  That's pretty 
inconsistent with what the user will expect.  Can we improve on that?  It's not 
an issue with Export, since that feature set is fixed by the time you go into 
the Export process.

Step by step:
1. Open 
http://maps.massgis.state.ma.us/map_ol_nov_2012/moris.php?lyrs=MWRA%20Towns%20wi
th%20Water%20or%20Sewer~massgis:GISDATA.MWRASERVICE_POLY~GISDATA.MWRASERVICE_POL
Y::Default&bbox=-73.76015721204763,41.22088718911679,-69.68302415312786,42.89158
549255219&coordUnit=dms&measureUnit=m&base=custom¢er=181892.59648199,869302.499
12763&zoom=2.732959267064107&opacity=1&baseO=1&filt=undefined
2. Use either identify tool to select a few towns
3. Notice how many towns you have
4. Select a row in the "Feature details" window
5. Right click that row and choose "Clear feature"
6. Save all records as either .xls, .xlsx or .csv - you'll get the original 
number of rows

Original comment by Aleda.Fr...@state.ma.us on 1 Nov 2012 at 3:21

GoogleCodeExporter commented 9 years ago 
Good catch.

r394 addresses this

Original comment by cpl...@gmail.com on 1 Nov 2012 at 4:05

GoogleCodeExporter commented 9 years ago

Original comment by Aleda.Fr...@state.ma.us on 1 Nov 2012 at 4:09