<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div dir="ltr">I have not followed this closely but see below.<br><div dir="ltr"><br><blockquote type="cite">Le 28 oct. 2020 à 04:40, Springfield Harrison <stellargps@gmail.com> a écrit :<br><br></blockquote></div><blockquote type="cite"><div dir="ltr">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<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.</p></div></blockquote><div>I thing you said you had over a million tree? Shapefile will be very slow even if you create a spatial index. You would be better using a geopackage. What make geopackage less convenient? Do you have a work flow that can only produce a csv and a shapefile?</div><blockquote type="cite"><div dir="ltr"><p> I didn't try the xlsx option as I require a CSV table
as the primary table in the join (to import UTM coordinates). </p></div></blockquote><div>With over a million object, you will go over the xlsx max limit. </div><blockquote type="cite"><div dir="ltr"><p>
Other spreadsheet formats do not trigger the X/Y georeferencing
options found in the delimited text file type.</p></div></blockquote>Csv table is a convenient way manually adding coordinates but if all you need is to have access to the x/y georefencing options, you can do that with any filed in any vector file by updating the geometry from a field using the field calculator. Using something like <span style="color: var(--black-800); font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-style: inherit; font-variant-caps: inherit; white-space: inherit; font-size: 13px; -webkit-text-size-adjust: auto;">geom_from_wkt('POINT('||"x"||' '||"y"||')'). </span><div><div><br></div><div><a href="https://gis.stackexchange.com/questions/285634/qgis-update-feature-geometry-from-attribute-fields">https://gis.stackexchange.com/questions/285634/qgis-update-feature-geometry-from-attribute-fields</a></div><div><br></div><blockquote type="cite"><div dir="ltr">
<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></div></blockquote><br><blockquote type="cite"><div dir="ltr">
<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>
<span>_______________________________________________</span><br><span>Qgis-user mailing list</span><br><span>Qgis-user@lists.osgeo.org</span><br><span>List info: https://lists.osgeo.org/mailman/listinfo/qgis-user</span><br><span>Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user</span></div></blockquote></div></div></body></html>