I am currently working in QGIS 2.18 with Qfield to collect address information.
I currently have a list of addresses (.csv) that were given as part of the project which contains a variety of information, including point XY co-ordinate for each address (although these appear to be wrong and need geocoding.)I have made this into a shapefile for use in QField offline editing.
Samplers will use Qfield and walk around each town, moving the existing address point features to within buildings polygons at the correct addresses and updating the attributes of each point with the required information. They will also be adding new point features for those addresses which are currently not in the existing address list.
Each evening, I download the QField shapefiles from each of the samplers containing the updated existing points and the new points that they have taken in the day.
If it was just a case of updating the old points with the new attribute information, I understand that I can join across a common field and repopulate each field with the new information provided. I have tried this, however with multiple files to add (5 samplers/folders a day) and manually repopulating the old columns with the updated fields is taking an enormous amount of time especially as I need the new XY coordinate for each feature. It also means that my original shapefile is getting confusing as I have so many joined columns.
As they will also be adding new point features, I cannot find a way to add these new points without updating the .csv itself and re-adding it to QGIS as they do not have a common column with the original .csv to be included in the join above.
Can anyone suggest the ideal/most efficient way of using the shapefiles from each sampler to update the attributes for each existing point feature as well as including the newly created ones?
I chose QField as QGIS is the software i'm most comfortable working in. If there is a significantly easier alternative to Qfield for gathering and integrating the new data then yes I am more than happy to try others but they would have to be free.