[Qgis-user] Editing Joined Tables

[Springfield Harrison]

Hello Charles & Sebastian,

Thanks very much for your suggestions.  I did try the Geopackage but it 
seems much less convenient for my needs than shapefiles or CSV files.  I 
didn't try the xlsx option as I require a CSV table as the primary table 
in the join (to import UTM coordinates). Other spreadsheet formats do 
not trigger the X/Y georeferencing options found in the delimited text 
file type.

I need to frequently add UTM positions to the primary table plus make 
manual edits to it so it needs to be a shapefile.  However, with care, I 
can copy and paste new UTM records from a CSV file into the primary 
shapefile.

Anyway, thanks again, your suggestions helped me along . . . . .

-----
Cheers, Springfield



On 10/27/20 09:14, Sebastian Gutwein wrote:
> 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 <mailto: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 <mailto: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 <mailto: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 <mailto: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/20201028/22a3fddb/attachment.html>