Re: [Qgis-user] QGIS 1.7 Wrocław_problem copying entities after Joins

2011-09-13 Thread Stanca Lazarescu 
Thanks Ramon for your answer. I tryed to save the layer as a shp but it
didn't work since the name of the colomns of the joined table were at times
too long to be accepted by the shp (10 characters maximum).

I finally managed to figured it out, the problem being nothing but the
edition mode. In order to copy the selection, the vector layer mustn't be in
the edition mode, because the joined table is supposed to permit no
alteration. It was as simple as that. Edition off and the selection and copy
into a spreadsheet is possible.

Cheers
Stanca

On Tue, Sep 13, 2011 at 3:51 PM, Ramon Andiñach wrote:

> Sorry that was clumsy.
>
> Could you not save the join as a csv or a shape file and then open that up
> in excel?
>
> So for the join I usually do, I only want parts of the join, so I select
> the bits I want and use "save selection as" to save that out. Usually I save
> that as a shp file, but even then the dbf can still be opened in excel.
>
> Admittedly I'm not using postgis, so there might be a postgis thing...
>
> -ramon.
>
> On 13/09/2011, at 20:10, "s.lazarescu"  wrote:
>
> > Dear all,
> >
> > I'm using the latest version of QGIS, happy to be able to use the 'joins'
> > function. However, I'm stuck trying to exploit the information in an
> excel
> > after having joined two layers. Here's the whole story:
> >
> > I have a vector layer (PostGis) representing geolocated enteprises of a
> > region in France. To this vector layer I joined a geometryless table
> > (PostGis) in order to enrich the information of the former layer (primary
> > key of the two layers = the SIRET code indicating the activity field of
> the
> > enterprises).
> >
> > After having joined the two layers, what I need to do is select certain
> > entities and try to copy them in an excel table for further statistical
> > anylisis. The problem is that, no matter what the character enconding,
> only
> > the information from the mother vector layer is copied, while all the
> joined
> > colomns remain empty.
> >
> >
> > Thanks a lot for helping
> >
> > Stanca
> >
> > --
> > View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/QGIS-1-7-Wroc-aw-problem-copying-entities-after-Joins-tp6787206p6787206.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
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>



-- 
Stanca Lazarescu


45 Rue Hurtebise, 60200 Compiègne
+33 (0)6 31 61 80 15
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Re: Modifing the type of an attribute in a shp table

2011-07-11 Thread Stanca Lazarescu 
Thank you all for your quick answers. I finally solved the problem by
installing the "table manager" plugin, which works fine so far.

All the best
Stanca

On Mon, Jul 11, 2011 at 9:04 AM, Alister Hood wrote:

> Hi Stanca,
> Also check out the "table manager" plugin - it works by creating a copy
> of the shape file.  I think QGIS does not support deleting attribute
> columns in a shapefile yet, as this feature was only recently added to
> gdal/ogr.
>
> Regards,
> Alister
>
>
> > Date: Sun, 10 Jul 2011 12:30:19 -0700 (PDT)
> > From: "s.lazarescu" 
> > Subject: [Qgis-user] Modifing the type of an attribute in a shp table
> > To: qgis-user@lists.osgeo.org
> > Message-ID: <1310326219054-6568405.p...@n2.nabble.com>
> > Content-Type: text/plain; charset=us-ascii
> >
> > Hello everyone,
> >
> >
> > I've encountered a small problem while building the table of a
> shapefile,
> > that contains around 90 attributes. It has to do with the type of the
> > attributes that cannot be modified once the table created. I realized
> that
> > for one of the attributes, the type of data I chose is not the correct
> one,
> > and so no data can be introduced.
> >
> > I'm looking for a solution which would allow me to modify the type of
> this
> > only attribute, without having to start all over again.
> >
> > Since the attribute is followed by only several other attributes, I
> had the
> > idea to delete all the attributes together with the "ill" one and to
> add
> > them again, this time giving it the correct type. But the "delete
> attribute"
> > button is not active .
> >
> >
> > I am thanking you for your advice.
> >
> > Stanca
>



-- 
Stanca Lazarescu


45 Rue Hurtebise, 60200 Compiègne
+33 (0)6 31 61 80 15
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user