[Qgis-user] any ideas how to get data from attribute table out of qgis

[Lee Hachadoorian]

On Thu, Jun 21, 2012 at 1:25 PM, Giovanni Manghi
<giovanni.manghi at faunalia.pt> wrote:
> On Thu, 2012-06-21 at 17:59 +0100, M.E.Dodd wrote:
>> When there are more than 65000 rows in the data?  On windowsxp.  Have
>> tried save as .csv but this is still broken,
>
>
> just tested on a 3.5 Million table (postgis) and it returns a correctly
> formatted CSV.
>
> QGIS 1.8 on Ubuntu.
>
>
> cheers
>
> -- Giovanni --

Also working for me on Windows Vista with QGIS 1.7.4 installed via OSGeo4W.

Not knowing exactly your source format, I can think of two ways around
this. One is to try saving to SQLite instead, then export to CSV using
the QSpatiaLite plugin or the standalone SpatiaLite-GUI (or spatialite
command line).

But all of this is just GUI wrappers for ogr2ogr, so the other way is
to use ogr2ogr directly. What happens if you do:

ogr2ogr -f "CSV" layer.csv layer.shp (<--or whatever your input layer is?)

--Lee

-- 
Lee Hachadoorian
PhD, Earth & Environmental Sciences (Geography)
Research Associate, CUNY Center for Urban Research
http://freecity.commons.gc.cuny.edu/