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 <char...@kartoza.com <mailto:char...@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
    <stellar...@gmail.com <mailto:stellar...@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@lists.osgeo.org <mailto:Qgis-user@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@lists.osgeo.org <mailto:Qgis-user@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@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to