RE: [Qgis-developer] Re: Excel Export from QGIS

2011-12-01 Thread Bob and Deb
This discussion reminds me of the reasons why I'm excited about the Vistrails plugin for QGIS (see http://code.googlegroups.com/p/eo4vistrails/). Has anyone given it a try yet? On Dec 1, 2011 11:34 PM, "Alister Hood" wrote: > Hi Tim, > > > -Original Message- > > From: Tim Sutton [mailto:l

Re: [Qgis-developer] Why is scrolling in the attribute table so slow?

2011-12-01 Thread Anita Graser
Hi, On Fri, Dec 2, 2011 at 8:28 AM, Andreas Neumann wrote: > > > I am not yet fully convinced if people understand what "Select at ID" > means ... any suggestions? It is derived from the fact that if a provider > has getFeatureAtId available it will not cache locally, otherwise it will. > I woul

[Qgis-developer] Decoupling of Layer structuring and Rendering Order

2011-12-01 Thread Andreas Neumann
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 thema

Re: [Qgis-developer] Why is scrolling in the attribute table so slow?

2011-12-01 Thread Nathan Woodrow
+1 to local cache as Select at ID would just confuse people. - Nathan On Fri, Dec 2, 2011 at 5:28 PM, Andreas Neumann wrote: > Hi, > > Fyi - Jürgen just included an option in the Postgis Table Connection > dialogue allowing to cache a Postgis table or view locally. There is a > separate column

RE: [Qgis-developer] Re: Excel Export from QGIS

2011-12-01 Thread Alister Hood
Hi Tim, > -Original Message- > From: Tim Sutton [mailto:li...@linfiniti.com] > Sent: Friday, 2 December 2011 7:16 p.m. > To: Alister Hood > Cc: qgis-developer@lists.osgeo.org > Subject: Re: [Qgis-developer] Re: Excel Export from QGIS > > Hi Alister > > On Fri, Dec 2, 2011 at 12:55 AM, Al

Re: [Qgis-developer] Why is scrolling in the attribute table so slow?

2011-12-01 Thread Andreas Neumann
Hi, Fyi - Jürgen just included an option in the Postgis Table Connection dialogue allowing to cache a Postgis table or view locally. There is a separate column called "Select at ID" (german "Abfrage nach ID") which is checked by default. If you disable this checkbox it will activate "local ca

Re: [Qgis-developer] Re: Excel Export from QGIS

2011-12-01 Thread bernhard . stroebl
Hi Andreas, I am running JasperReports from QGIS Python plugins using PyJasper https://github.com/hudora/pyJasper I do not know if it is elegant but it works :) I can send you an example if you drop me a line. Bernhard Am 02.12.2011 07:44, schrieb Andreas Neumann: Hi, These are almost exact

Re: [Qgis-developer] Re: Excel Export from QGIS

2011-12-01 Thread Andreas Neumann
Hi, These are almost exactly the reasons why want to export to spreadsheet: * people want to print tables * people want to reformat tables * people want to share the data (e.g. sending an email, post results on the webpage) - for this purpose a PDF would also be good enough often. For the lon

Re: [Qgis-developer] Re: Excel Export from QGIS

2011-12-01 Thread Tim Sutton
Hi Alister On Fri, Dec 2, 2011 at 12:55 AM, Alister Hood wrote: > Hi everybody, > Just a couple of thoughts: > > As others have mentioned, many people want to export to Excel mainly for > formatting and printing, perhaps with some added calculations.  The > ideal would be to improve formatting an

[Qgis-developer] Re: Excel Export from QGIS

2011-12-01 Thread Alister Hood
Hi everybody, Just a couple of thoughts: As others have mentioned, many people want to export to Excel mainly for formatting and printing, perhaps with some added calculations. The ideal would be to improve formatting and printing in QGIS so that this isn't necessary. Spreadsheets aren't particul

Re: [Qgis-developer] Globe crashes QGIS

2011-12-01 Thread Giovanni Manghi
I tested also under Windows, it crashes too. cheers -- Giovanni -- On Thu, 2011-12-01 at 11:42 +0100, Paolo Cavallini wrote: > See below. > All the best. > === > Warning: Object::connect: No such signal QgsGdalProvider::statusChanged( > QString ) in > /home/paolo/build/qgis/Quantum-GIS/src/cor

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Yves Jacolin (free)
Le jeudi 1 décembre 2011 17:50:29, Guy Roussin a écrit : > Hi > > > Microsoft Office 2010 don't open nor create DBF files anymore (that's > > what said one of my customer this week)! > > You can open but not save DBF files with Microsoft Excel 2010. > > http://office.microsoft.com/en-us/excel-he

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Guy Roussin
Hi Microsoft Office 2010 don't open nor create DBF files anymore (that's what said one of my customer this week)! You can open but not save DBF files with Microsoft Excel 2010. http://office.microsoft.com/en-us/excel-help/file-formats-that-are-supported-in-excel-HP010014103.aspx -- Guy ___

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Giovanni Manghi
> By the way, copying (and pasting) rows from a table with no geometries > returns only NULL > > should I file a ticket? it happens only with postgresql tables, not with csv or dbf. cheers -- Giovanni -- ___ Qgis-developer mailing list Qgis-develop

[Qgis-developer] Re: [Qgis-user] Excel Export from QGIS attribute table

2011-12-01 Thread Giovanni Manghi
> 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

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Giovanni Manghi
> I also tested the idea with the clipboard. On Linux Ubuntu it works > fine if one copies from the QGIS table and pastes in > LibreOffice/OpenOffice Calc. On pasting, it opens the CSV dialogue for > importing. By the way, copying (and pasting) rows from a table with no geometries returns

[Qgis-developer] Re: [Qgis-user] Fwd: QGIS for android

2011-12-01 Thread Alexander Bruy
Report bugs here http://hub.qgis.org/projects/android-qgis 2011/12/1 Jerry Bond : > 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 so

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Etienne Tourigny
It has been suggested to support LibreOffice/OpenOffice Calc in addition to XLS. How hard would it be to improve the FreeXL library to support ods , or incorporate support for ods into OGR's xls driver? I might also add that the FreeXL does not (yet?) support the newer XML SS file format specific

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Andreas Neumann
Hi, Thanks all for your ideas. I agree - it makes sense to me to improve and use OGR for this purpose. I also tested the idea with the clipboard. On Linux Ubuntu it works fine if one copies from the QGIS table and pastes in LibreOffice/OpenOffice Calc. On pasting, it opens the CSV dialogue fo

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Etienne Tourigny
To add to Even's suggestion, I think it would be best to improve the xls driver in OGR and integrate that into QGis, rather than develop a standalone QGis plugin. That way you make both better! Etienne On Thu, Dec 1, 2011 at 6:41 AM, Even Rouault wrote: > >> > I'd be much more interested in re

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Yves Jacolin
Alex, Le jeudi 01 décembre 2011 09:26:45, Alex Mandel a écrit : > Both also open dbf, > though saving back to either csv or dbf can be extremely tricky. Microsoft Office 2010 don't open nor create DBF files anymore (that's what said one of my customer this week)! I agree that if we (user) can u

Re: [Qgis-developer] backports for 1.7.3

2011-12-01 Thread Yves Jacolin
Le mercredi 30 novembre 2011 13:09:08, Paolo Cavallini a écrit : > >> What event could make it impossible to release 1.7.whatever ? > > > > I didn't mean a specific event. > > It's just impossible to make a release for every bug that has been > > fixed. Therefore my proposition to wait a bit until

[Qgis-developer] Globe crashes QGIS

2011-12-01 Thread Paolo Cavallini
See below. All the best. === Warning: Object::connect: No such signal QgsGdalProvider::statusChanged( QString ) in /home/paolo/build/qgis/Quantum-GIS/src/core/raster/qgsrasterlayer.cpp:2445 Warning: Application asked to unregister timer 0x6312 which is not registered in this thread. Fix a

Re: [Qgis-user] Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Filipe Silva Dias
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.

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Giovanni Manghi
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 -- ___

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Alex Mandel
On 12/01/2011 12:32 AM, Andreas Neumann wrote: Hi Alex, My biggest question is why do you need anything other than CSV? Excel and OpenOffice both open CSV automatically already. Both also open dbf, though saving back to either csv or dbf can be extremely tricky. Not to mention everything else s

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Even Rouault
> > I'd be much more interested in reading of xls, xlsx, ods etc as > > tables for joining or generating spatial X,Y layers. FYI, Sandro Furieri has created a lightweight FreeXL library that can read XLS files. It can be integrated with spatialite (through a VirtualXLS module), or standalone. I'v

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Andreas Neumann
Hi Alex, My biggest question is why do you need anything other than CSV? Excel and OpenOffice both open CSV automatically already. Both also open dbf, though saving back to either csv or dbf can be extremely tricky. Not to mention everything else scientific can use csv - for example R, python,

Re: [Qgis-developer] versions of QGIS dependency packages

2011-12-01 Thread Otto Dassau
Hi, I found that all Qt >= 4.4.0 is fine, so it seems to be something else. I opened a ticket with the CMakeError.log. http://hub.qgis.org/issues/4585 Regards Otto Am Wed, 30 Nov 2011 12:05:34 +0100 schrieb Otto Dassau : > Hi, > > is there a list, what versions the QGIS dependencies have to p

Re: [Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Alex Mandel
On 12/01/2011 12:19 AM, 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 th

[Qgis-developer] Excel Export from QGIS attribute table

2011-12-01 Thread Andreas Neumann
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 won