[Qgis-user] Editing Joined Tables

Sebastian Gutwein bas at rdgland.com
Tue Oct 27 09:14:20 PDT 2020


I have found that CSV layers are not editable but .xlsx layers are. I just
tried editing a joined field in 2 .xslx layers and it worked if I have
upsert on edit checked. QGIS 3.14.16

On Tue, Oct 27, 2020 at 5:02 AM Charles Dixon-Paver <charles at kartoza.com>
wrote:

> As far as I'm aware you cannot edit external flat file tables like csv as
> they are imported into a QGIS project in a read only state.
>
> I would try exporting those tables to a database table (like a geopackage
> table without geometry) and then performing the join to see if you get the
> desired result.
>
> On Tue, 27 Oct 2020 at 10:03, Springfield Harrison <stellargps at gmail.com>
> wrote:
>
>> Hello All:
>>
>> Using version 3.10.10, I have joined two MS Excel files: Positions.csv
>> and catalogue.xls using a common field called Tag. This is a tree
>> inventory project.
>>
>> All is well except I cannot edit either table from within QGIS. I need
>> to create some new positions manually and generally update the tables
>> continuously.
>>
>> In the Join dialogue, I have selected Enable Editing but it has no effect.
>>
>> I feel that different file types or a different procedure may facilitate
>> this process but am exhausted from trying so many blind alleys.
>>
>> Is there a trick to being able to edit joined tables?
>>
>> Thanks very much . . . .
>>
>> -----
>> Cheers, Springfield Harrison, British Columbia
>>
>>
>> _______________________________________________
>> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20201027/2c3c0166/attachment.html>


More information about the Qgis-user mailing list