Re: [Qgis-user] Editing Joined Tables

2020-10-30 Thread Springfield Harrison
Hello Nicolas /et al,/ Thanks for your thoughts and the suggestion copied below: 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

Re: [Qgis-user] Editing Joined Tables

2020-10-28 Thread Nicolas Cadieux
> Le 29 oct. 2020 à 01:41, Springfield Harrison a écrit : > >  > Hello Nicolas, > > Thanks for the comments, I'll go over them shortly. Only a few dozen trees, > not 1 million! > Well thats easier! Funny, your message got mixed up with another email list with a question about 1.3

Re: [Qgis-user] Editing Joined Tables

2020-10-28 Thread Springfield Harrison
Hello Nicolas, Thanks for the comments, I'll go over them shortly.  Only a few dozen trees, not 1 million! - Cheers, Spring Harrison On 10/28/20 07:52, Nicolas Cadieux wrote: I have not followed this closely but see below. Le 28 oct. 2020 à 04:40, Springfield Harrison a écrit :

Re: [Qgis-user] Editing Joined Tables

2020-10-28 Thread Nicolas Cadieux
I have not followed this closely but see below. >> Le 28 oct. 2020 à 04:40, Springfield Harrison a écrit >> : >  > 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. >

Re: [Qgis-user] Editing Joined Tables

2020-10-28 Thread 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

Re: [Qgis-user] Editing Joined Tables

2020-10-27 Thread Sebastian Gutwein
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 wrote: > As far as I'm aware you cannot edit external flat

Re: [Qgis-user] Editing Joined Tables

2020-10-27 Thread Charles Dixon-Paver
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

[Qgis-user] Editing Joined Tables

2020-10-27 Thread Springfield Harrison
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