[Qgis-user] Copy/paste non geometric data in QGis

Ramon Andinach custard at westnet.com.au
Thu Feb 2 23:22:36 PST 2017


Thanks that would be great.

I should add I was using data with geometry too.

I’d guess that it’s something to do with the providers for postgis and spatialite.


> On 3 Feb 2017, at 15:13, didier peeters <dpeeter1 at ulb.ac.be> wrote:
> 
> Thank you Ramon for these observations.  In my case I copied something like 25 rows, so it can’t be related to some lack of memory. 
> I will write a bug report.
> 
> 
>> Le 3 févr. 2017 à 00:56, Ramon Andinach <custard at westnet.com.au> a écrit :
>> 
>> I can’t help, but I bumped into something like that recently 2.18.2 on Sierra trying to copy something like 4,700,000 points from a csv into an identically formatted spatialite layer.
>> 
>> I can offer some other observations.
>> 1. I couldn’t copy the whole lot, but I could copy it in lots of 1,000,000 up to the last packet and then it crashed.
>> 2. I could copy the whole thing into a QGIS temporary layer.
>> 3. I could copy the whole thing into a shape layer.
>> 4. I could copy the whole lot from the temporal layer into the spatialite layer.
>> 
>> There was an update that caused a restart, and it seemed to work after that. 
>> 
>> Except that it worked fine copying the whole lot into a different format than spatialite (and particularly the temporary layer) I wondered if it was a memory hang up of some sort.
>> 
>> 
>>> On 3 Feb 2017, at 00:08, didier peeters <dpeeter1 at ulb.ac.be> wrote:
>>> 
>>> Hello everybody,
>>> 
>>> I’m trying to copy/paste rows between two tables (layers without geometries) loaded in QGis.  They have the same structure but one is a postgis layer and the other is a csv file.  When a click on the ‘Paste’ button in the attribute table window QGis crashes immediately.  I’m doing this on Mac OS Sierra with QGis 2.18.2 and QGis 2.14.10 (both from Kyngchaos).  My objective is to provide QGis beginners a simple way to load data from their MS Excel world to PostGis, where the data will afterward be processed and then displayed in QGis. 
>>> 
>>> Does anybody know anything about this problem ?
>>> 
>>> Thanks !
>>> 
>>> Didier
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> 
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user




More information about the Qgis-user mailing list