<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello Charles & Sebastian,</p>
<p>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.</p>
<p>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.</p>
<p>Anyway, thanks again, your suggestions helped me along . . . . .<br>
</p>
<pre class="moz-signature" cols="72">-----
Cheers, Springfield
</pre>
<div class="moz-cite-prefix">On 10/27/20 09:14, Sebastian Gutwein
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAED_52qVCPVf3gZH5+e3V-RLnEMxGwZZ0bT5JMi26+QyzGoOhg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">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</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Oct 27, 2020 at 5:02
AM Charles Dixon-Paver <<a
href="mailto:charles@kartoza.com" moz-do-not-send="true">charles@kartoza.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">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.
<div><br>
</div>
<div>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.</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, 27 Oct 2020 at
10:03, Springfield Harrison <<a
href="mailto:stellargps@gmail.com" target="_blank"
moz-do-not-send="true">stellargps@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">Hello All:<br>
<br>
Using version 3.10.10, I have joined two MS Excel files:
Positions.csv <br>
and catalogue.xls using a common field called Tag. This is
a tree <br>
inventory project.<br>
<br>
All is well except I cannot edit either table from within
QGIS. I need <br>
to create some new positions manually and generally update
the tables <br>
continuously.<br>
<br>
In the Join dialogue, I have selected Enable Editing but
it has no effect.<br>
<br>
I feel that different file types or a different procedure
may facilitate <br>
this process but am exhausted from trying so many blind
alleys.<br>
<br>
Is there a trick to being able to edit joined tables?<br>
<br>
Thanks very much . . . .<br>
<br>
-----<br>
Cheers, Springfield Harrison, British Columbia<br>
<br>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank"
moz-do-not-send="true">Qgis-user@lists.osgeo.org</a><br>
List info: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote>
</div>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank"
moz-do-not-send="true">Qgis-user@lists.osgeo.org</a><br>
List info: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote>
</div>
</blockquote>
</body>
</html>