Re: [Qgis-user] new xytools plugin: now open and save simple Excel files

[Richard Duivenvoorde]

On 2011-12-15 23:24, Filipe Silva Dias wrote:
> But was wondering if there was a way to prevent Excel from doing this.
> The equivalent function in Xtools Pro (ArcGIS) exports the data to Excel
> "as they are" with no need to convert characters into numbers.

Hi Filipe,

the xlrd lib has the possibility to set the format of the cell. So I
could do that for every cell by checking if I have a number or so...
Please add it as a feature in the issue list. We can add it later.

> I forgot to mention before: if Richard hadnt introduced the plugin and
> its functionality in this list, I would never have guessed from the name
> of plugin, that it included the function "export table to excel".

The plugin just started as a dedicated 'click in map and get
xy'-plugin And it was just easier to add this to this plugin
(because it shared the 'choosing of a x-y-column etc).

I added a tag 'excel' in the new infrastructure so hopefully people will
find it...

Regards,

Richard
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] new xytools plugin: now open and save simple Excel files

[Andreas Neumann]

Hi Richard,

Thank you for the improved plugin! The Excel export was high on the 
list of many people.


I tested now only the excel export and import. A few 
ideas/observerations:


* whe exporting, I always get a double file extension: filename.xls.xls 
- no matter whether I specify the filename with or without the extension
* when exporting, it would be nice to optionally offer additional x/y 
columns for point geometries, or the option to export as wkt geometry. 
These additional columns could be appended to the end of the attribut 
columns.
* If the import would also support import of wkt, one could round-trip 
data through export to excel --> editing of data in Office/Openoffice 
(e.g. for people who do not have QGIS installed) and then import it 
again.
* when importing data it would be nice if the importer allows a better 
option to import data without a geometry or x/y columns. Currently one 
can import data without x/y column, but only by clicking the "cancel 
button". It would be good to have an additional button labeled "Import 
without geometry".


These are mostly enhancement ideas, not bugs.

Thanks a lot for making these available!

Andreas

On Thu, 15 Dec 2011 21:33:26 +0100, Richard Duivenvoorde wrote:

Hi List,

I uploaded a new version of the xytools plugin. After some questions 
and
discussion on the list about Excel files, I added simple capability 
to

open and save excel files.

It uses the python xlw and xlrd libs for that
(http://www.python-excel.org/). Those are available for windows users 
in
the osgeo4w package. Linux users can probably get it from there 
package

manager. If all fails, go to http://www.python-excel.org/ and get it
from there.

In short: it can save the attributes of a vector layer to a simple 
(one

worksheet containing) xls file.
It can open an xls file and load it in a memory layer. You can either
point to an x and y column, and those values will be used for the x 
and
y of the Point features. Or you can cancel choosing the x and y, and 
the

attribute data will just be loaded taking 0/0 as x and y coordinates.

There is a help file availabe via the xytools plugin menu with more
information.

Let me know if you find problems with it or have ideas to improve 
(see

docs for earlier ideas).

plugin via plugin menu
or
http://plugins.qgis.org/plugins/xytools/

source
http://hub.qgis.org/projects/xytools/repository

project page
http://hub.qgis.org/projects/xytools

Regards,

Richard Duivenvoorde

ps if you find the plugin really usefull, I'm also trying out paypal
buttons on the project page :-) Half of the profit (?) goes to the 
qgis

project for this one I promised Paolo and Tim...



___
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] new xytools plugin: now open and save simple Excel files

[Paolo Cavallini]

Il 15/12/2011 21:33, Richard Duivenvoorde ha scritto:
> Hi List,
> 
> I uploaded a new version of the xytools plugin. After some questions and
> discussion on the list about Excel files, I added simple capability to
> open and save excel files.

Thanks Richard. I do not especially like the idea of promoting (making easier 
to use)
excel over free and open source alternatives. Would it be possible to add 
support for
LibreOffice?
Thanks again.

-- 
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Re: new xytools plugin: now open and save simple Excel files

[gene]

Many thanks, 
I had made a first version (in French), also using xlw and xlrd (
http://www.portailsig.org/content/python-lire-et-ecrire-des-fichiers-microsoft-excel-application-quantum-gis
) Python : lire et écrire des fichiers Microsoft Excel, application à
Quantum GIS  and published on the "Quantum GIS Code Snippets" 
http://plugins.qgis.org/snippets/3/ Convert a Microsoft Excel file with X,Y
coordinates to a shapefile (or a memory layer)  but I did not have time to
create a plugin. Now, we have a plugin !

--
View this message in context: 
http://osgeo-org.1803224.n2.nabble.com/new-xytools-plugin-now-open-and-save-simple-Excel-files-tp7098439p7099937.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

FW: [Qgis-user] Python modules (dependencies?)

[Alister Hood]

Forwarding to the list without the attachment.

> -Original Message-
> From: Alister Hood
> Sent: Friday, 16 December 2011 11:53 a.m.
> To: 'qgis-user@lists.osgeo.org'
> Cc: 'thomas.b...@nrl.navy.mil'
> Subject: [Qgis-user] Python modules (dependencies?)
> 
> > Date: Thu, 15 Dec 2011 10:03:08 -0500
> > From: "Thomas J. Boyd" 
> > Subject: [Qgis-user] Python modules (dependencies?)
> > To: qgis-user@lists.osgeo.org
> > Message-ID: <4eea0c2c.10...@nrl.navy.mil>
> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> >
> > Dear List users,
> >
> > I have been unable to find an answer to this via searching, so here
> > goes: I use QGIS v.1.7.2 (now 1.7.3) windows binaries. I want to use
> > the contour plugin. According the docs, it requires shapely, numpy,
> > and matplotlib. The contour python files are loaded into my
documents
> > directory in sub /.qgis/python/plugins/contour.
> 
> As already mentioned, those dependencies are all available in the
> osgeo4w installer (the first two are listed under "python-").  They
are
> also all included in the standalone QGIS installer.  The contour
plugin
> used to work out of the box.
> 
> > After installing either the 2.5 or 2.7 python binaries and libraries
> > (including numpy, shapely and matplotlib), I still get errors trying
> > to use contour.
> 
> Is the error "Exception struck: 'module' object has no attribute
> 'tricontour'"?
> It seems the contour plugin has been updated and now requires a later
> version of matplotlib than is included with QGIS / OSGeo4W :(
> 
> > I did default install(s) for python (in the "Program files"
> > directory). I tried copying over the numpy, shapely and matplotlib
> > python files to my .qgis/python/plugins folder
> 
> If you do need to install python modules manually, they go in
> "C:\Program Files\Quantum GIS Wroclaw\apps\Python25\Lib\site-packages"
> with a standalone QGIS install or "C:\OSGeo4W\apps\Python25\Lib\site-
> packages" with an OSGeo4w install.
> 
> But in this case it doesn't work.  If I install a later matplotlib, I
> can run `import matplotlib` in the QGIS python, but `import
> matplotlib.pyplot as plt` crashes it (Python itself, not just when run
> in the QGIS python console).
> Maybe this matplotlib was build with an incompatible compiler or
> something...
> Of course I can't build my own matplotlib to see if it works:
> 
> running build_ext
> error: Python was built with Visual Studio 2003; extensions must be
> built with a compiler than can generate compatible binaries.
> Visual Studio 2003 was not found on this system. If you have Cygwin
> installed, you can try compiling with MingW32, by passing "-c mingw32"
> to setup.py.
> 
> Well, maybe I could trick it into compiling, but I'm not sure it would
> be worth the effort.
> Conclusion: use a real operating system.
> Or use the slight workaround described at
> http://youarealegend.blogspot.com/2011/10/contour-plugin-for-qgis-
> version-090.html
> Or use an old version of the plugin (I've attached one I had lying
> around, but I think there might have been more recent versions that
> still worked).
> 
> > but get errors loading
> > QGIS (for either 2.5 32-bit or 2.7 64-bit python installs).
> 
> Since the QGIS install is 32bit, with Python 2.5, any Python modules
> you use will need to be the as well.
> 
> > I can run
> > "other" python scripts in a command window (so the python
interpreter
> > is "registered" I think). I can run numpy, shapely and matplotlib
> > functions in IDLE without issue.
> >
> > Has anyone had experience running contour plugin on a windows
> machine?
> > Any install tips? I am using Win7 64-bit. Thanks in advance for any
> > assistance.
> >
> > Tom
> 
> Alister
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] new xytools plugin: now open and save simple Excel files

[Brad Nesom]

hmm,
unless it has to do with the version exported, I thought that it was excel.

On Thu, Dec 15, 2011 at 4:24 PM, Filipe Silva Dias wrote:

> Thx Brad. That works fine.
>
> But was wondering if there was a way to prevent Excel from doing this. The
> equivalent function in Xtools Pro (ArcGIS) exports the data to Excel "as
> they are" with no need to convert characters into numbers.
>
> I forgot to mention before: if Richard hadnt introduced the plugin and its
> functionality in this list, I would never have guessed from the name of
> plugin, that it included the function "export table to excel".
>
> Thanks
>
>
>
> On Thu, Dec 15, 2011 at 10:14 PM, Brad Nesom  wrote:
>
>> Filipe,
>>   You should note that excel does that on it's own.
>> if you look at your data and there is a small green triangle in the upper
>> left corner, that means the data is "available" to be formated as numeric.
>> simply select all the cells that show that (don't select the column
>> heading name) and then go to the top of the selection. (a little tricky to
>> explain further).
>> There is a "yellow" exclamation mark to the left. carefully hover cursor
>> to the left over the mark then pick the down arrow that appears.
>> select "convert to number".
>> there ya go.
>>   On Thu, Dec 15, 2011 at 3:59 PM, Filipe Silva Dias <
>> filipesd...@gmail.com> wrote:
>>
>>> Thanks Richard. This tool was on my "Top ten list of things that would
>>> make my work a lot less annoying".
>>>
>>> Possible problem: exported the attribute table of a shapefile to an
>>> Excel spreadsheet, but the values of the columns appeared formated as
>>> characters (even though they're numbers). Anyonelse can confirm this?
>>>
>>> Best regards
>>> Filipe
>>>
>>> On Thu, Dec 15, 2011 at 8:33 PM, Richard Duivenvoorde <
>>> rdmaili...@duif.net> wrote:
>>>
 Hi List,

 I uploaded a new version of the xytools plugin. After some questions and
 discussion on the list about Excel files, I added simple capability to
 open and save excel files.

 It uses the python xlw and xlrd libs for that
 (http://www.python-excel.org/). Those are available for windows users
 in
 the osgeo4w package. Linux users can probably get it from there package
 manager. If all fails, go to http://www.python-excel.org/ and get it
 from there.

 In short: it can save the attributes of a vector layer to a simple (one
 worksheet containing) xls file.
 It can open an xls file and load it in a memory layer. You can either
 point to an x and y column, and those values will be used for the x and
 y of the Point features. Or you can cancel choosing the x and y, and the
 attribute data will just be loaded taking 0/0 as x and y coordinates.

 There is a help file availabe via the xytools plugin menu with more
 information.

 Let me know if you find problems with it or have ideas to improve (see
 docs for earlier ideas).

 plugin via plugin menu
 or
 http://plugins.qgis.org/plugins/xytools/

 source
 http://hub.qgis.org/projects/xytools/repository

 project page
 http://hub.qgis.org/projects/xytools

 Regards,

 Richard Duivenvoorde

 ps if you find the plugin really usefull, I'm also trying out paypal
 buttons on the project page :-) Half of the profit (?) goes to the qgis
 project for this one I promised Paolo and Tim...



 ___
 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

Re: [Qgis-user] new xytools plugin: now open and save simple Excel files

[Filipe Silva Dias]

Thx Brad. That works fine.

But was wondering if there was a way to prevent Excel from doing this. The
equivalent function in Xtools Pro (ArcGIS) exports the data to Excel "as
they are" with no need to convert characters into numbers.

I forgot to mention before: if Richard hadnt introduced the plugin and its
functionality in this list, I would never have guessed from the name of
plugin, that it included the function "export table to excel".

Thanks



On Thu, Dec 15, 2011 at 10:14 PM, Brad Nesom  wrote:

> Filipe,
>   You should note that excel does that on it's own.
> if you look at your data and there is a small green triangle in the upper
> left corner, that means the data is "available" to be formated as numeric.
> simply select all the cells that show that (don't select the column
> heading name) and then go to the top of the selection. (a little tricky to
> explain further).
> There is a "yellow" exclamation mark to the left. carefully hover cursor
> to the left over the mark then pick the down arrow that appears.
> select "convert to number".
> there ya go.
> On Thu, Dec 15, 2011 at 3:59 PM, Filipe Silva Dias 
> wrote:
>
>> Thanks Richard. This tool was on my "Top ten list of things that would
>> make my work a lot less annoying".
>>
>> Possible problem: exported the attribute table of a shapefile to an Excel
>> spreadsheet, but the values of the columns appeared formated as characters
>> (even though they're numbers). Anyonelse can confirm this?
>>
>> Best regards
>> Filipe
>>
>> On Thu, Dec 15, 2011 at 8:33 PM, Richard Duivenvoorde <
>> rdmaili...@duif.net> wrote:
>>
>>> Hi List,
>>>
>>> I uploaded a new version of the xytools plugin. After some questions and
>>> discussion on the list about Excel files, I added simple capability to
>>> open and save excel files.
>>>
>>> It uses the python xlw and xlrd libs for that
>>> (http://www.python-excel.org/). Those are available for windows users in
>>> the osgeo4w package. Linux users can probably get it from there package
>>> manager. If all fails, go to http://www.python-excel.org/ and get it
>>> from there.
>>>
>>> In short: it can save the attributes of a vector layer to a simple (one
>>> worksheet containing) xls file.
>>> It can open an xls file and load it in a memory layer. You can either
>>> point to an x and y column, and those values will be used for the x and
>>> y of the Point features. Or you can cancel choosing the x and y, and the
>>> attribute data will just be loaded taking 0/0 as x and y coordinates.
>>>
>>> There is a help file availabe via the xytools plugin menu with more
>>> information.
>>>
>>> Let me know if you find problems with it or have ideas to improve (see
>>> docs for earlier ideas).
>>>
>>> plugin via plugin menu
>>> or
>>> http://plugins.qgis.org/plugins/xytools/
>>>
>>> source
>>> http://hub.qgis.org/projects/xytools/repository
>>>
>>> project page
>>> http://hub.qgis.org/projects/xytools
>>>
>>> Regards,
>>>
>>> Richard Duivenvoorde
>>>
>>> ps if you find the plugin really usefull, I'm also trying out paypal
>>> buttons on the project page :-) Half of the profit (?) goes to the qgis
>>> project for this one I promised Paolo and Tim...
>>>
>>>
>>>
>>> ___
>>> 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

Re: [Qgis-user] new xytools plugin: now open and save simple Excel files

[Brad Nesom]

Filipe,
  You should note that excel does that on it's own.
if you look at your data and there is a small green triangle in the upper
left corner, that means the data is "available" to be formated as numeric.
simply select all the cells that show that (don't select the column heading
name) and then go to the top of the selection. (a little tricky to explain
further).
There is a "yellow" exclamation mark to the left. carefully hover cursor to
the left over the mark then pick the down arrow that appears.
select "convert to number".
there ya go.
On Thu, Dec 15, 2011 at 3:59 PM, Filipe Silva Dias wrote:

> Thanks Richard. This tool was on my "Top ten list of things that would
> make my work a lot less annoying".
>
> Possible problem: exported the attribute table of a shapefile to an Excel
> spreadsheet, but the values of the columns appeared formated as characters
> (even though they're numbers). Anyonelse can confirm this?
>
> Best regards
> Filipe
>
> On Thu, Dec 15, 2011 at 8:33 PM, Richard Duivenvoorde  > wrote:
>
>> Hi List,
>>
>> I uploaded a new version of the xytools plugin. After some questions and
>> discussion on the list about Excel files, I added simple capability to
>> open and save excel files.
>>
>> It uses the python xlw and xlrd libs for that
>> (http://www.python-excel.org/). Those are available for windows users in
>> the osgeo4w package. Linux users can probably get it from there package
>> manager. If all fails, go to http://www.python-excel.org/ and get it
>> from there.
>>
>> In short: it can save the attributes of a vector layer to a simple (one
>> worksheet containing) xls file.
>> It can open an xls file and load it in a memory layer. You can either
>> point to an x and y column, and those values will be used for the x and
>> y of the Point features. Or you can cancel choosing the x and y, and the
>> attribute data will just be loaded taking 0/0 as x and y coordinates.
>>
>> There is a help file availabe via the xytools plugin menu with more
>> information.
>>
>> Let me know if you find problems with it or have ideas to improve (see
>> docs for earlier ideas).
>>
>> plugin via plugin menu
>> or
>> http://plugins.qgis.org/plugins/xytools/
>>
>> source
>> http://hub.qgis.org/projects/xytools/repository
>>
>> project page
>> http://hub.qgis.org/projects/xytools
>>
>> Regards,
>>
>> Richard Duivenvoorde
>>
>> ps if you find the plugin really usefull, I'm also trying out paypal
>> buttons on the project page :-) Half of the profit (?) goes to the qgis
>> project for this one I promised Paolo and Tim...
>>
>>
>>
>> ___
>> 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

Re: [Qgis-user] new xytools plugin: now open and save simple Excel files

[Filipe Silva Dias]

Thanks Richard. This tool was on my "Top ten list of things that would make
my work a lot less annoying".

Possible problem: exported the attribute table of a shapefile to an Excel
spreadsheet, but the values of the columns appeared formated as characters
(even though they're numbers). Anyonelse can confirm this?

Best regards
Filipe

On Thu, Dec 15, 2011 at 8:33 PM, Richard Duivenvoorde
wrote:

> Hi List,
>
> I uploaded a new version of the xytools plugin. After some questions and
> discussion on the list about Excel files, I added simple capability to
> open and save excel files.
>
> It uses the python xlw and xlrd libs for that
> (http://www.python-excel.org/). Those are available for windows users in
> the osgeo4w package. Linux users can probably get it from there package
> manager. If all fails, go to http://www.python-excel.org/ and get it
> from there.
>
> In short: it can save the attributes of a vector layer to a simple (one
> worksheet containing) xls file.
> It can open an xls file and load it in a memory layer. You can either
> point to an x and y column, and those values will be used for the x and
> y of the Point features. Or you can cancel choosing the x and y, and the
> attribute data will just be loaded taking 0/0 as x and y coordinates.
>
> There is a help file availabe via the xytools plugin menu with more
> information.
>
> Let me know if you find problems with it or have ideas to improve (see
> docs for earlier ideas).
>
> plugin via plugin menu
> or
> http://plugins.qgis.org/plugins/xytools/
>
> source
> http://hub.qgis.org/projects/xytools/repository
>
> project page
> http://hub.qgis.org/projects/xytools
>
> Regards,
>
> Richard Duivenvoorde
>
> ps if you find the plugin really usefull, I'm also trying out paypal
> buttons on the project page :-) Half of the profit (?) goes to the qgis
> project for this one I promised Paolo and Tim...
>
>
>
> ___
> 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] new xytools plugin: now open and save simple Excel files

[Milo van der Linden]

Nice work!

I will see if I can find time to give it a spin soon.

Regards
Op 15 dec. 2011 21:34 schreef "Richard Duivenvoorde" 
het volgende:

> Hi List,
>
> I uploaded a new version of the xytools plugin. After some questions and
> discussion on the list about Excel files, I added simple capability to
> open and save excel files.
>
> It uses the python xlw and xlrd libs for that
> (http://www.python-excel.org/). Those are available for windows users in
> the osgeo4w package. Linux users can probably get it from there package
> manager. If all fails, go to http://www.python-excel.org/ and get it
> from there.
>
> In short: it can save the attributes of a vector layer to a simple (one
> worksheet containing) xls file.
> It can open an xls file and load it in a memory layer. You can either
> point to an x and y column, and those values will be used for the x and
> y of the Point features. Or you can cancel choosing the x and y, and the
> attribute data will just be loaded taking 0/0 as x and y coordinates.
>
> There is a help file availabe via the xytools plugin menu with more
> information.
>
> Let me know if you find problems with it or have ideas to improve (see
> docs for earlier ideas).
>
> plugin via plugin menu
> or
> http://plugins.qgis.org/plugins/xytools/
>
> source
> http://hub.qgis.org/projects/xytools/repository
>
> project page
> http://hub.qgis.org/projects/xytools
>
> Regards,
>
> Richard Duivenvoorde
>
> ps if you find the plugin really usefull, I'm also trying out paypal
> buttons on the project page :-) Half of the profit (?) goes to the qgis
> project for this one I promised Paolo and Tim...
>
>
>
> ___
> 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: [Qgis-developer] Georeferencer produces wrong (shifted) result

[Agustin Lobo]

Giovanni,

2011/12/15 Giovanni Manghi :
>> But I'm a bit surprised
>> by the little attention that this problem is raising among developers.
>> A correct georeferencing is a critical
>> issue for a GIS. If this bug is confirmed, users should be warned.
>
> probably because if the proper developer (Manuel) cannot replicate the
> issue it is hard to take any action :)
It's not a critique to Manuel, but to the whole community (including
myself). I think
we should take more steps so that qgis is not released with errors
such as this,and if this happens, then users must be
warned in the downloading page (a prominent note with important known bugs).
qgis is good: warning about important errors will make users be more
confident on the package, not less.

> By the way, using your input data I get also the shift (on both Linux
> and Windows).
This is very useful information, thanks.

> cheers
>
> -- Giovanni --
>
> ___
> Qgis-developer mailing list
> qgis-develo...@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] new xytools plugin: now open and save simple Excel files

[Richard Duivenvoorde]

Hi List,

I uploaded a new version of the xytools plugin. After some questions and
discussion on the list about Excel files, I added simple capability to
open and save excel files.

It uses the python xlw and xlrd libs for that
(http://www.python-excel.org/). Those are available for windows users in
the osgeo4w package. Linux users can probably get it from there package
manager. If all fails, go to http://www.python-excel.org/ and get it
from there.

In short: it can save the attributes of a vector layer to a simple (one
worksheet containing) xls file.
It can open an xls file and load it in a memory layer. You can either
point to an x and y column, and those values will be used for the x and
y of the Point features. Or you can cancel choosing the x and y, and the
attribute data will just be loaded taking 0/0 as x and y coordinates.

There is a help file availabe via the xytools plugin menu with more
information.

Let me know if you find problems with it or have ideas to improve (see
docs for earlier ideas).

plugin via plugin menu
or
http://plugins.qgis.org/plugins/xytools/

source
http://hub.qgis.org/projects/xytools/repository

project page
http://hub.qgis.org/projects/xytools

Regards,

Richard Duivenvoorde

ps if you find the plugin really usefull, I'm also trying out paypal
buttons on the project page :-) Half of the profit (?) goes to the qgis
project for this one I promised Paolo and Tim...



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] How to reclassify?

[arunthe...@gmail.com]

Hello Etienne,

On Thu, Dec 8, 2011 at 11:31 PM, Etienne Tourigny
wrote:

> I don't know how to do it in QGis, but I do it with a python script
> using the GDAL Python bindings and numpy.
>
> It's a little slow but works well, and I use a csv file to write the
> mapping values.
> The code is not very clean, but I could post it if you like.
>

Sorry for the late reply. Kinely do post the script.



-- 
Regards
Arunmozhi
Twitter: @tecoholic
Website: http://arunmozhi.in
IRC Nick: teco
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Python modules (dependencies?)

[Giovanni Manghi]

On Thu, 2011-12-15 at 17:23 +0200, Alexander Bruy wrote:
> Hi Thomas,
> 
> how you install QGIS: via OSGeo4W or using standalone installer?
> If you use OSGeo4W you can get all dependencies. The standalone
> installer includes some additional deps, but if you need to add another
> packages — install them into Python bundled with QGIS not into
> system wide Python

In this case the standalone should already install all the necessary
python dependencies, while using osgeo4w you will need to add them
manually looking into the "libs" category when using the "advanced"
install mode.

In this case the pyhton error you are getting seems not related to a
dependency problem, but you can extract isolines using the "contour"
tool in the "raster" menu, as Paolo pointed.

By the way Thomas, is the Navy interested in supporting QGIS? :)


cheers

-- Giovanni --

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Python modules (dependencies?)

[Paolo Cavallini]

Il 15/12/2011 16:03, Thomas J. Boyd ha scritto:

Dear List users,

I have been unable to find an answer to this via searching, so here 
goes: I use QGIS v.1.7.2 (now 1.7.3) windows binaries. I want to use 
the contour plugin. According the docs, it requires shapely, numpy, 
and matplotlib. The
Ant special reason to use it? The same function is available through 
GDALTools (installed by default).

All the best.

--
Paolo Cavallini
See: http://www.faunalia.it/pc

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Python modules (dependencies?)

[Alexander Bruy]

Hi Thomas,

how you install QGIS: via OSGeo4W or using standalone installer?
If you use OSGeo4W you can get all dependencies. The standalone
installer includes some additional deps, but if you need to add another
packages — install them into Python bundled with QGIS not into
system wide Python

2011/12/15 Thomas J. Boyd :
> Dear List users,
>
> I have been unable to find an answer to this via searching, so here goes: I
> use QGIS v.1.7.2 (now 1.7.3) windows binaries. I want to use the contour
> plugin. According the docs, it requires shapely, numpy, and matplotlib. The
> contour python files are loaded into my documents directory in sub
> /.qgis/python/plugins/contour.
>
> After installing either the 2.5 or 2.7 python binaries and libraries
> (including numpy, shapely and matplotlib), I still get errors trying to use
> contour. I did default install(s) for python (in the "Program files"
> directory). I tried copying over the numpy, shapely and matplotlib python
> files to my .qgis/python/plugins folder but get errors loading QGIS (for
> either 2.5 32-bit or 2.7 64-bit python installs). I can run "other" python
> scripts in a command window (so the python interpreter is "registered" I
> think). I can run numpy, shapely and matplotlib functions in IDLE without
> issue.
>
> Has anyone had experience running contour plugin on a windows machine? Any
> install tips? I am using Win7 64-bit. Thanks in advance for any assistance.

-- 
Alexander Bruy
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Python modules (dependencies?)

[Giovanni Manghi]

Hi,

can you paste here the python error messages you are getting using the
plugin?

cheers

-- Giovanni --

On Thu, 2011-12-15 at 10:03 -0500, Thomas J. Boyd wrote:
> Dear List users,
> 
> I have been unable to find an answer to this via searching, so here 
> goes: I use QGIS v.1.7.2 (now 1.7.3) windows binaries. I want to use the 
> contour plugin. According the docs, it requires shapely, numpy, and 
> matplotlib. The contour python files are loaded into my documents 
> directory in sub /.qgis/python/plugins/contour.
> 
> After installing either the 2.5 or 2.7 python binaries and libraries 
> (including numpy, shapely and matplotlib), I still get errors trying to 
> use contour. I did default install(s) for python (in the "Program files" 
> directory). I tried copying over the numpy, shapely and matplotlib 
> python files to my .qgis/python/plugins folder but get errors loading 
> QGIS (for either 2.5 32-bit or 2.7 64-bit python installs). I can run 
> "other" python scripts in a command window (so the python interpreter is 
> "registered" I think). I can run numpy, shapely and matplotlib functions 
> in IDLE without issue.
> 
> Has anyone had experience running contour plugin on a windows machine? 
> Any install tips? I am using Win7 64-bit. Thanks in advance for any 
> assistance.
> 
> Tom
> 


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Python modules (dependencies?)

[Thomas J. Boyd]

Dear List users,

I have been unable to find an answer to this via searching, so here 
goes: I use QGIS v.1.7.2 (now 1.7.3) windows binaries. I want to use the 
contour plugin. According the docs, it requires shapely, numpy, and 
matplotlib. The contour python files are loaded into my documents 
directory in sub /.qgis/python/plugins/contour.


After installing either the 2.5 or 2.7 python binaries and libraries 
(including numpy, shapely and matplotlib), I still get errors trying to 
use contour. I did default install(s) for python (in the "Program files" 
directory). I tried copying over the numpy, shapely and matplotlib 
python files to my .qgis/python/plugins folder but get errors loading 
QGIS (for either 2.5 32-bit or 2.7 64-bit python installs). I can run 
"other" python scripts in a command window (so the python interpreter is 
"registered" I think). I can run numpy, shapely and matplotlib functions 
in IDLE without issue.


Has anyone had experience running contour plugin on a windows machine? 
Any install tips? I am using Win7 64-bit. Thanks in advance for any 
assistance.


Tom

--
Thomas J. Boyd, PhD
Marine Biogeochemistry
US Naval Research Laborotory
4555 Overlook Ave., SW
Washington, DC  20375
202-404-6424

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] RE: Qgis-user Digest, Vol 70, Issue 29

[Julia R. Charvat]

"
>>
>> May be you have a working exemple for doing this ?!
>>
>> Best regards
>>
>>
>> Patrice Vetsel
>> patr...@kagou.fr
>> http://blog.kagou.fr
>>
>>
>>
>>
>>
>> ___
>> 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

Patrice Vetsel
patr...@kagou.fr
http://blog.kagou.fr

-- next part --
An HTML attachment was scrubbed...
URL: 
http://lists.osgeo.org/pipermail/qgis-user/attachments/20111215/9fe2072d/attachment-0001.html

--

Message: 7
Date: Thu, 15 Dec 2011 07:04:42 +0100
From: Agustin Lobo 
Subject: [Qgis-user] Re: [Qgis-developer] Georeferencer produces wrong
(shifted) result
To: qgis-developer ,
m.mass...@warped-space.de
Cc: qgis-user 
Message-ID:

Content-Type: text/plain; charset=ISO-8859-1

Manuel answers a message I  sent to him only. He includes all relevant parts of 
my message except the link to the arcgis result:
https://sites.google.com/site/openfiles2/home/ilerfly125v2geoarcgis.7z?attredirects=0&d=1

Manuel,
There is no wld file for the input layer The GCP table with errors can be seen 
here:
https://sites.google.com/site/filestemp2/home/GCP.jpeg?attredirects=0&d=1

As I'm using gdallib1-1.8.0.2, could this be a gdal problem? Could anybody else 
using gdallib1-1.8 amd qgis1.7.3 verify (I provided all necessary material)?

We have solved the practical issue for this particular image using another 
software, so we are not in a hurry. But I'm a bit surprised by the little 
attention that this problem is raising among developers.
A correct georeferencing is a critical
issue for a GIS. If this bug is confirmed, users should be warned.

Agus

2011/12/14 Manuel Massing :
> Hi Agus,
>
>
>> Cannot download
>> http://www.warped-space.de/Ilerfly125v2_modifziert.tif,
>
>> I get:
>
>> Oops! This link appears to be broken.
>
>
> sorry, the correct link is
>
>
> http://www.warped-space.de/Ilerfly125v2_modifiziert.tif
>
>
>> The procedure we follow is:
>
>> 1. Set project to CRS EPSG:23031
>
>> 2. No On the fly reprojection
>
>> 3. Start georeferencer and open ilerfly125v2.tif and its points file
>
>> with the settings displayed
>
>
> thats correct, and I did exactly the same (except for the scale change
> - might be worth checking out), but couldn't reproduce the shiftr (my
> results match
>
> the output of the arcgis version).
>
>
> I've got a lot on my plate right now, but if I find the time I'll try
> to look this is a regression in qgis or the georeferencer, as I said
> I'm still on 1.7 atm.
>
>
> How do the residuals look in the georeferencer? Is there a noticable
> bias
>
> (i.e. do they all point in one direction?)
>
>
> Also, make sure there was no world file influencing the unreferenced
> file
>
> (something like Ilerfly125v2.wld), the georeferencer can't handle that.
>
>
> I also noticed that you used a scale change, does the shift also
> appear
>
> without scale change?
>
>
> cheers,
>
>
> Manuel
>
>
>
>
>
> ___
> Qgis-developer mailing list
> qgis-develo...@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>


--

Message: 8
Date: Thu, 15 Dec 2011 09:04:46 +0100
From: Fabio De Francesco 
Subject: [Qgis-user] Installing Quntum GIS
To: Qgis-user@lists.osgeo.org
Message-ID:

Content-Type: text/plain; charset="iso-8859-1"

Dear All,

I'm a new quantum gis user and i found very easy to install on a Microsoft 
environment.
But now the trouble is how to install Q GIS Wroclaw in Ubuntu 11.10 "oneric 
Ocelot".

Thanks in advance


--
Fabio De Francesco
-- next part --
An HTML attachment was scrubbed...
URL: 
http://lists.osgeo.org/pipermail/qgis-user/attachments/20111215/3ae1c1d8/attachment.html

--

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user


End of Qgis-user Digest, Vol 70, Issue 29
*





This email transmission is intended only for the use of the individual or 
entity that it is addressed to, and may contain information that is privileged, 
confidential, and exempt from disclosure under applicable Laws (including 45 
CFR, Parts 160 & 164, Standards for Privacy of Individually Identifiable Health 
Information; and 42 CFR, Part 2, Confidentiality for Alcohol and Drug Abuse 
Patient Records and all applicable state laws). The Federal rules restrict any 
use of the information to criminally investigate or prosecute any alcohol or 
drug abuse patients. If the reader of this message is not the intended 
recipient, or is the employee or agent responsible for delivering the message 
to the intended recipient, you are hereby notified that any dissemination, 
distribution or copying of this communication is strictly prohibited. If you 
have received this email transmission in error, please notify the sending party 
immediately. Thank you for your courtesy and consideration for confidentiality 
and security.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Announcing the release of QGIS 1.7.3

[Werner Macho]

Dear QGIS Developers, Users and Supporters!

We are pleased to announce that QGIS 1.7.3 is now available. This is a
bugfix release over version 1.7.2. A detailed changelog is available on
our home page[1].

Binary downloads[2] are already available but some are still making
their way to the download page so if you don't see your preferred OS
there please check again in a day or two.

Thanks to bug reporters who have reported bugs using upgraded issue
tracker[3] and special thanks to all developers who fixed those reported
bugs.

As always, if you find a bug please report it on [3].

QGIS is the collaborative effort of many coders, translators,
documentors, bug reporters and other community members.

QGIS continues to have great momentum - we recently branched the code
base for an upcoming release of QGIS 1.8.0 and we are about to break API
compatibility in our 'master' branch to start us down the road towards
the eventual release of QGIS 2.0. If you enjoy using QGIS and are able
to, please consider sponsoring our project - the money you donate helps
us to run our developer meetings and generally keep the project moving
forward. You can find more details on how to sponsor QGIS on our home
page[4]. QGIS recently obtained it's second Silver Sponsor for 2011!
Thank you Kanton Solothurn, Switzerland (Silver Sponsor from April
2011)[5] and the State of Vorarlberg, Austria (Silver Sponsor from
November 2011)[6], your financial help is greatly appreciated!

[1] http://tinyurl.com/release173
[2] http://download.qgis.org
[3] http://hub.qgis.org
[4] http://qgis.org/en/sponsorship.html
[5] http://www.agi.so.ch/
[6] http://www.vorarlberg.at/

on behalf of the QGIS Team
Werner Macho
QGIS Release Maintainer
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Installing Quntum GIS

[Giovanni Manghi]

On Thu, 2011-12-15 at 10:43 +0100, Fabio De Francesco wrote:
> I need to download this synaptic pakage manager ? How to ?



https://help.ubuntu.com/community/SynapticHowto

if in 11.10 is not installed by default you can use the Software Center
(edit -> software sources)




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Installing Quntum GIS

[Robin Cura]

Alright, from start :
Go to System -> Administration -> Synaptic package Manager
Then, once launched :
Settings -> Repositories -> Other softwares tab
Add -> Put this (without the quotes) : "deb
http://qgis.org/debianoneiric main"
Apply and quit.

Then, open a terminal :
Applications -> Accessories -> Terminal
Copy this line (without the quotes) and press enter : "gpg --keyserver
keyserver.ubuntu.com --recv 1F9ADD375CA44993"
If requested, enter your password and press enter
Then, copy this line and press enter again : "gpg --export --armor
1F9ADD375CA44993 | sudo apt-key add -"

Now, enter this in the terminal :
"sudo apt-get update && sudo apt-get install qgis"
Press enter, confirm when asked, and qgis will install on your computer.


Robin.

2011/12/15 Fabio De Francesco 

> I need to download this synaptic pakage manager ? How to ?
>
> Thanks
>
>
>
> 2011/12/15 Giovanni Manghi 
>
>>
>> >
>> > But I cant copy the string on such .lis file on my sistem folder, how
>> > to do it ?
>>
>> use synaptic package manager to add your extra repos, no need to edit
>> manually the repositories source file.
>>
>> cheers
>>
>> -- Giovanni --
>>
>>
>>
>
>
> --
> Fabio De Francesco
>
> ___
> 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] Installing Quntum GIS

[Fabio De Francesco]

I need to download this synaptic pakage manager ? How to ?

Thanks



2011/12/15 Giovanni Manghi 

>
> >
> > But I cant copy the string on such .lis file on my sistem folder, how
> > to do it ?
>
> use synaptic package manager to add your extra repos, no need to edit
> manually the repositories source file.
>
> cheers
>
> -- Giovanni --
>
>
>


-- 
Fabio De Francesco
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Installing Quntum GIS

[Giovanni Manghi]

> 
> But I cant copy the string on such .lis file on my sistem folder, how
> to do it ?

use synaptic package manager to add your extra repos, no need to edit
manually the repositories source file.

cheers

-- Giovanni --


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Installing Quntum GIS

[Giovanni Manghi]

> 
> But I cant copy the string on such .lis file on my sistem folder, how
> to do it ?

use synaptic package manager to add your extra repos, no need to edit
manually the repositories source file.

cheers

-- Giovanni --


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Installing Quntum GIS

[Fabio De Francesco]

Dear All:
I'm in trouble again for the installation process in general:

Add the lines for one of the repositories of the following sections to your
/etc/apt/sources.list file

*But I cant copy the string on such .lis file on my sistem folder, how to
do it ?*
*
*




2011/12/15 Richard Duivenvoorde 

> On 2011-12-15 09:04, Fabio De Francesco wrote:
> > I'm a new quantum gis user and i found very easy to install on a
> > Microsoft environment.
> > But now the trouble is how to install Q GIS Wroclaw in Ubuntu 11.10
> > "oneric Ocelot".
>
> Hi Fabio,
>
> Oneiric is in the list now (Thanks Jef!):
> http://hub.qgis.org/wiki/quantum-gis/Download#Ubuntu
>
> Please try and let us know if there are problems with it (or if it was
> better then on windows ;-) )
>
> Regards,
>
> Richard Duivenvoorde
>



-- 
Fabio De Francesco
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Installing Quntum GIS

[Richard Duivenvoorde]

On 2011-12-15 09:04, Fabio De Francesco wrote:
> I'm a new quantum gis user and i found very easy to install on a
> Microsoft environment.
> But now the trouble is how to install Q GIS Wroclaw in Ubuntu 11.10
> "oneric Ocelot".

Hi Fabio,

Oneiric is in the list now (Thanks Jef!):
http://hub.qgis.org/wiki/quantum-gis/Download#Ubuntu

Please try and let us know if there are problems with it (or if it was
better then on windows ;-) )

Regards,

Richard Duivenvoorde
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Installing Quntum GIS

[Fabio De Francesco]

Dear All,

I'm a new quantum gis user and i found very easy to install on a Microsoft
environment.
But now the trouble is how to install Q GIS Wroclaw in Ubuntu 11.10 "oneric
Ocelot".

Thanks in advance


-- 
Fabio De Francesco
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user