Add conflict management to offline editing

[qgib]

Author Name: colin east (colin east)
Original Redmine Issue: 15208

Redmine category:c++_plugins/offline_editing

---

I wanted to understand if the Offline tool could be used for concurrent editing. The idea is to have the organisation's primary data stored in a PostGIS database. If an Offline project was created, could a user safely make edits to the primary data (source). However, it appears that the Offline tool will overwrite edits made to source data.
Test workflow:
Create Offline project for a PostGIS point layer.
Toggle editing on and move a single point by dragging it to a new llocation.
Save edit and toggle editing off of the Offline project layer.
Add source PostGIS layer.
Edit the same point in the source layer by to a different location.
Save and toggle editing off.
Synchronise the Offline project.
Outcome: Source layer edit is overwritten by Offline project with no warning.
Note: If this how the tool is designed then locking the layer could be and option. There is some discussion about table/row locking in #11031

The way the tool currently works means that if an Offline project is created then the source data cannot be modified until the Offline project is synchronised. This would not be workable for many business applications. It would good if a check could be run against the source data (perhaps a comparison of a row's last modified time stamp) to identify features that were modified after the Offline project was created so that the user can determine which edits are appropriate.

---

Related issue(s): #11031 (relates)
Redmine related issue(s): 972

---

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

I think that this is how the tool is intended to work. It could be improved, but that would be a feature request, not a bug.

Meanwhile you may want to look to this plugin

https://github.com/Oslandia/qgis-versioning

---

• operating_system was changed from qgis-windows 10, PostGIS 2.2 Ubuntu 16.04 to
• status_id was changed from Open to Feedback

[qgib]

Author Name: Matthias Kuhn (@m-kuhn)

---

• subject was changed from Offline tool overwrites source PostGIS data to Add conflict management to offline editing
• tracker_id was changed from 1 to 2

[qgib]

Author Name: Matthias Kuhn (@m-kuhn)

---

• assigned_to_id removed Matthias Kuhn

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0

[github-actions]

The QGIS project highly values your report and would love to see it addressed. However, this issue has been left in feedback mode for the last 14 days and is being automatically marked as "stale".
If you would like to continue with this issue, please provide any missing information or answer any open questions. If you could resolve the issue yourself meanwhile, please leave a note for future readers with the same problem and close the issue.
In case you should have any uncertainty, please leave a comment and we will be happy to help you proceed with this issue.
If there is no further activity on this issue, it will be closed in a week.

[github-actions]

While we hate to see this happen, this issue has been automatically closed because it has not had any activity in the last 42 days despite being marked as feedback. If this issue should be reconsidered, please follow the guidelines in the previous comment and reopen this issue.
Or, if you have any further questions, there are also further support channels that can help you.