[Qgis-user] Excel Export from QGIS attribute table
Hi, It is a common requirement that users want to export a QGIS attribute table to Excel/CSV/Spreadsheet. While CSV is probably easy, the other two are probably more complex, but there are some good Python libraries around. For my users, Excel is the most requested table export format. I wonder if this could be made into the core, as I think that most other user want that as well. The idea is to have an export button for the table, choose the format (CSV, Excel, Openoffice) and let the user select if he wants all data export, or only filtered or selected rows. I guess it would be best to use Python for that purpose, as Python has some good Excel libraries: * pyExcelerator: http://sourceforge.net/projects/pyexcelerator/ (Excel 97/2000/XP/2003) * xlrd und xlwt (reader/writer): http://www.python-excel.org (Excel 2.0 to 2007) * openpyxl: https://bitbucket.org/ericgazoni/openpyxl/wiki/Home (Excel 2007 and higher) Do any of you have experience with one of the above listed packages or any other recommendations? How about OpenOffice writing? Goal: cross platform without the need to have MSOffice or OpenOffice installed. Would this be best implemented in C++ or in Python? Who else would be interested in such functionality? Thanks, Andreas -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] converting espg 4326
is there away to convert espg 4326 to standard shp files , that programs can use ? ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] converting espg 4326
hm - what do you mean by that? EPSG 4326 is just one projection format (like thousands of other projections). All shapefile readers should be able to deal with it. In QGIS, when you save to a Shapefiles you can even select the target projection and it will automatically project the data for you. Hope this helps, Andreas On Thu, 1 Dec 2011 18:31:10 +1000, steve sgalowski wrote: is there away to convert espg 4326 to standard shp files , that programs can use ? ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] converting espg 4326
ty for your help andreas , but the program i have on my pda , does not accept this type of shap file espg 4326 , but it accepts shape files from cloud made but only some . Stephen On 01/12/2011, Andreas Neumann a.neum...@carto.net wrote: hm - what do you mean by that? EPSG 4326 is just one projection format (like thousands of other projections). All shapefile readers should be able to deal with it. In QGIS, when you save to a Shapefiles you can even select the target projection and it will automatically project the data for you. Hope this helps, Andreas On Thu, 1 Dec 2011 18:31:10 +1000, steve sgalowski wrote: is there away to convert espg 4326 to standard shp files , that programs can use ? ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] converting espg 4326
I'm going to take a guess that you are asking if QGIS can create a prj file that contains the projection information so that other programs loading the shapefile can also read it. If that's the case I believe the Vector-Data Management-Define Projection tool is what you're looking for. Thanks, Alex On 12/01/2011 12:42 AM, steve sgalowski wrote: ty for your help andreas , but the program i have on my pda , does not accept this type of shap file espg 4326 , but it accepts shape files from cloud made but only some . Stephen On 01/12/2011, Andreas Neumanna.neum...@carto.net wrote: hm - what do you mean by that? EPSG 4326 is just one projection format (like thousands of other projections). All shapefile readers should be able to deal with it. In QGIS, when you save to a Shapefiles you can even select the target projection and it will automatically project the data for you. Hope this helps, Andreas On Thu, 1 Dec 2011 18:31:10 +1000, steve sgalowski wrote: is there away to convert espg 4326 to standard shp files , that programs can use ? ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] converting espg 4326
sorry - unless you are more specific I am unable to help. What difference does it make if it is cloude-made or QGIS/OGR-made? It seems like your PDA app is a bit picky. Maybe a projection limitation or an encoding limitation? As I already said you can change the projection to some other projection and you can also set the encoding. Andreas On Thu, 1 Dec 2011 18:42:17 +1000, steve sgalowski wrote: ty for your help andreas , but the program i have on my pda , does not accept this type of shap file espg 4326 , but it accepts shape files from cloud made but only some . Stephen On 01/12/2011, Andreas Neumann a.neum...@carto.net wrote: hm - what do you mean by that? EPSG 4326 is just one projection format (like thousands of other projections). All shapefile readers should be able to deal with it. In QGIS, when you save to a Shapefiles you can even select the target projection and it will automatically project the data for you. Hope this helps, Andreas On Thu, 1 Dec 2011 18:31:10 +1000, steve sgalowski wrote: is there away to convert espg 4326 to standard shp files , that programs can use ? ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] OSGeo Charter Members election results
Hello all, Congratulations to all new charter members! Many of them are developers and users of QGIS: http://wiki.osgeo.org/wiki/Election_2011#Charter_Member_Election all the best, Anne -- http://gis.cri.fmach.it/ghisla/ signature.asc Description: PGP signature ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: [Qgis-developer] Excel Export from QGIS attribute table
Hi Andreas Who else would be interested in such functionality? this is one of the features qgis users/trainees ask more around here. So I guess that if they represent a part of the qgis users universe, such feature will interest quite a lot of people :) cheers -- Giovanni -- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Re: [Qgis-developer] Excel Export from QGIS attribute table
Hello, I agree that such a tool would be very useful for many people. In my work I frequently have to collect environmental variables in a GIS and then export them to Excel/Calc for processing. To be able to this quickly with a few clicks would save me (and many people) a lot of time and patience. In ArcGIS this is only possible via the XtoolsPro extension (which is partly free), which directly exports the attribute table to a Excel spreadsheet ( http://www.xtoolspro.com/tools.asp#e5 ). I used ArcGIS for several years and during that time users kept asking ESRI to include the extension in core, with no success. This is obviously a detail for QGIS development, but for many end users like me, it makes a LOT of difference. Sometimes small details like these play a huge role when it comes to decide to start using a software. Best regards On Thu, Dec 1, 2011 at 10:06 AM, Giovanni Manghi giovanni.man...@gmail.comwrote: Hi Andreas Who else would be interested in such functionality? this is one of the features qgis users/trainees ask more around here. So I guess that if they represent a part of the qgis users universe, such feature will interest quite a lot of people :) cheers -- Giovanni -- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: Excel Export from QGIS attribute table
Hi I think it would also be nice to be able to make joins directly to an Excel spreadsheet, since a lot of attribute data are available in this format. With this even non-GIS users will be able to deliver and update data for direct use in Qgis. Andreas Neumann wrote Hi, It is a common requirement that users want to export a QGIS attribute table to Excel/CSV/Spreadsheet. While CSV is probably easy, the other two are probably more complex, but there are some good Python libraries around. For my users, Excel is the most requested table export format. - Regards Morten (Qgis 1.7.1 and Win 7) -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Excel-Export-from-QGIS-attribute-table-tp7049674p7050209.html Sent from the qgis-user mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Excel Export from QGIS attribute table
Hi, The functionality that I rely on to do this operation in ArcGIS and MapInfo is the windows clipboard - if tab delimited data is present on the clipboard, then it will paste with the expected tabular format into Excel (and many other applications). This is far and away the quickest method I have found (in terms of UI actions - clicks / keypresses) for transferring attribute data out of a GIS and is not format or software specific. QuantumGIS already has this functionality available from the attribute table (QGIS v1.7.1), however the clipboard data generated by QGIS also contains a WKT representation of the geometry along with the attribute columns. A useful extension to the existing functionality would be to be able to disable the WKT column transfer in some way which would significantly reduce the volume of data being transferred via the clipboard, and consequently speed up the process. Whilst I would always try this method over exporting to an intermediate file, whether that is CSV or Excel native, I suspect that with very large numbers of records there may be problems with system resources, so the file method is probably useful in addition. Being a Windows user with little experience of Linux though, I'm not sure whether this method is also applicable in that OS family. Andy Andreas Neumann wrote: Hi, It is a common requirement that users want to export a QGIS attribute table to Excel/CSV/Spreadsheet. While CSV is probably easy, the other two are probably more complex, but there are some good Python libraries around. For my users, Excel is the most requested table export format. I wonder if this could be made into the core, as I think that most other user want that as well. The idea is to have an export button for the table, choose the format (CSV, Excel, Openoffice) and let the user select if he wants all data export, or only filtered or selected rows. I guess it would be best to use Python for that purpose, as Python has some good Excel libraries: * pyExcelerator: http://sourceforge.net/projects/pyexcelerator/ (Excel 97/2000/XP/2003) * xlrd und xlwt (reader/writer): http://www.python-excel.org (Excel 2.0 to 2007) * openpyxl: https://bitbucket.org/ericgazoni/openpyxl/wiki/Home (Excel 2007 and higher) Do any of you have experience with one of the above listed packages or any other recommendations? How about OpenOffice writing? Goal: cross platform without the need to have MSOffice or OpenOffice installed. Would this be best implemented in C++ or in Python? Who else would be interested in such functionality? Thanks, Andreas -- Andy Harfoot GeoData Institute University of Southampton Southampton SO17 1BJ Tel: +44 (0)23 8059 2719 Fax: +44 (0)23 8059 2849 www.geodata.soton.ac.uk --- For further information about GeoData's Training Courses, please visit: www.gis-train.com --- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Fwd: QGIS for android
Hi Marco -- Nice work! I tested it with Android 2.3.4 on HTC Incredible 2, and most things worked well. I have a couple of suggestions and a couple of bugs (one serious): are you collecting feedback somewhere? Jerry On Thursday, December 01, 2011 2:10:08 AM Marco Bernasocchi wrote: Hi All, Finally (for android QGIS) I'm back home. I've spent the last two weeks getting things up and running and updating QGIS for android and its whole infrastructure. Here the news: - pulled QGIS master - updated al code to the newest necessitas version - created an installer that will download qgis for you the installer is ment for the market, since the market seem so have troubles with big apk (althoug I just read that google might have changed that) so when i publish a new version of the installer, the market would notify the user of the available update. At the moment android QGIS is alpha and so it is not on the market. so you will just have to start the instller now and then to se if there is a new version or to get the latest nightly. - new website android.qgis.org (not fancy, but up-to-date) - solved some bugs, discovered others :) - sent pull request to get the android specific stuff accepted into master What works: - postgis (no SSL) - shape files with numeric attributes - spatialite - raster - wfs - wms - C++ plugins (all but Globe and Georeferencer) - most dialogs What doesn't: - postgis over ssl - shapefiles with string attributes - right click - gps tracking (might get founding for that soon) - pinch zooming (zoom works like with a mouse, click=touch - drag and release) - stability issues - python so here it goes to the installer: http://android.qgis.org/qgis.apk Here a Screenshot : http://hub.qgis.org/attachments/download/4087/qgisOnAndroid.jpg ciao Marco ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Fwd: QGIS for android
Report bugs here http://hub.qgis.org/projects/android-qgis 2011/12/1 Jerry Bond gb...@rochester.rr.com: Hi Marco -- Nice work! I tested it with Android 2.3.4 on HTC Incredible 2, and most things worked well. I have a couple of suggestions and a couple of bugs (one serious): are you collecting feedback somewhere? -- Alexander Bruy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Excel Export from QGIS attribute table
A useful extension to the existing functionality would be to be able to disable the WKT column transfer in some way which would significantly reduce the volume of data being transferred via the clipboard, and consequently speed up the process. I agree, such option would be very useful. cheers -- Giovanni -- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Re: [Qgis-developer] Excel Export from QGIS attribute table
If the QGIS team decides to add this feature, they might want to look at the freexl library. (Brought to you by Sandro of SpatiaLite fame. http://www.gaia-gis.it/FreeXL/freexl-1.0.0a-doxy-doc/index.html David. On Thu, Dec 1, 2011 at 4:34 AM, Filipe Silva Dias filipesd...@gmail.com wrote: Hello, I agree that such a tool would be very useful for many people. In my work I frequently have to collect environmental variables in a GIS and then export them to Excel/Calc for processing. To be able to this quickly with a few clicks would save me (and many people) a lot of time and patience. In ArcGIS this is only possible via the XtoolsPro extension (which is partly free), which directly exports the attribute table to a Excel spreadsheet ( http://www.xtoolspro.com/tools.asp#e5 ). I used ArcGIS for several years and during that time users kept asking ESRI to include the extension in core, with no success. This is obviously a detail for QGIS development, but for many end users like me, it makes a LOT of difference. Sometimes small details like these play a huge role when it comes to decide to start using a software. Best regards On Thu, Dec 1, 2011 at 10:06 AM, Giovanni Manghi giovanni.man...@gmail.com wrote: Hi Andreas Who else would be interested in such functionality? this is one of the features qgis users/trainees ask more around here. So I guess that if they represent a part of the qgis users universe, such feature will interest quite a lot of people :) cheers -- Giovanni -- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Decoupling of Layer structuring and Rendering Order
Hi all, Some people already discovered it ;-): http://darrencope.com/2011/12/01/new-control-rendering-order-option-in-qgis/ Thanks to the work of Jürgen there is now a decoupling of the layer structuring and the rendering order available in current master. It allows you to group layers thematically but decouple it from the rendering order. There is a separate panel called Layer Order available with a flat list of all layers where you can drag layers around to change the rendering order. There is a checkbox at the bottom of the two panels Layers and Layer Order to control which one takes precedence. The typical use case is that one generally wants polygon layers at the bottom, then line layers and point layers and labeling, but one does not want to wildly mix different topics. With the decoupling now you can group layers by topics in the regular layer panel and control the rendering order separately in the Layer Order panel. Be careful with using this new feature with QGIS Webclient - currently it will screw up if you use this mechanism. QGIS Webclient needs to be made aware that the rendering order is now different from the order in the layer tree. But with some modifications, QGIS Webclient will benefit from this enhancement as well. Please test this new functionality and report bugs, Andreas -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
