On Tue, 22 Aug 2017 15:45:17 +0200, Casper Bertelsen <casperb...@gmail.com> wrote:
> Hi Ross, > > If you make your project without saving username and password, the > project will prompt for a user and password when opened. Then each > member can login using their assigned login and thus making it > possible to use current_user in postgres. > > To remove saved username and password from your current project file > (make a copy, beforehand), you can open it in a text editor and seach > for <layername> untill you find > It seems to me that this can be useful for a lot of groups. Could this kind of save option be an interesting request for improvement? Slds. > <datasource>dbname='xx' host=yy port=5432 four lines above > <layername>and remove the username and password-part only . > > > Mvh. / Best regards > Casper Bertelsen > > On 22/08/2017 15:36, McDonaldR wrote: > > > > Thanks Karl-Magnus > > > > We use triggers in the database already and they work perfectly but > > if we want to record the specific user creating and editing > > features then we’d have to create separate projects for each user. > > At the moment the team of about 10 users all use a set of centrally > > stored project files – one for each different task. > > > > I found this post on Stackexchange > > (https://gis.stackexchange.com/questions/217011/how-to-automatically-update-wfs-edits-with-a-user-id) > > > > where global variables are used to populate fields when features > > are added. However, as Matthias notes in the comments this doesn’t > > work on feature “update”. If this were possible then it would > > meet all our needs. Maybe something that could be funded? > > > > Ross > > > > *From:*Karl Magnus Jönsson > > [mailto:karl-magnus.jons...@kristianstad.se] *Sent:* 22 August 2017 > > 12:34 *To:* McDonaldR; qgis-user@lists.osgeo.org > > *Subject:* SV: [Qgis-user] Updating a field set with default global > > variable on edit > > > > Hi! > > > > I’ve made the same things with triggers in the database. To avoid > > getting same username I’ve chosen not to save the username and > > password in the project. But then the user have to enter it every > > time the projects opens. If you can find a solution to your > > suggested approach it would be nice. > > > > *Karl-Magnus * > > > > *Från:*Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] *För > > *McDonaldR > > *Skickat:* den 22 augusti 2017 13:12 > > *Till:* qgis-user@lists.osgeo.org <mailto:qgis-user@lists.osgeo.org> > > *Ämne:* [Qgis-user] Updating a field set with default global > > variable on edit > > > > Hi List, > > > > Anyone know how to update a field that has a global variable set as > > the default value when records are edited (geometry and/or > > attributes)? > > > > > > We have a QGIS project with a PostGIS layer loaded and configured > > with look-ups and relations so the users can update all the > > relevant fields. There are also "*created_by*" and "*updated_by*" > > fields. These are updated by a trigger in the database with the > > "*current_user*" database variable. This works fine if you are the > > current user that added the layer to the project - the trigger > > works perfectly. > > > > If you give the project to someone else and they create and edit > > features in the layer the fields are still updated with your name > > as you are the person who added the layer to the project. Not what > > we want. > > > > QGIS has global variables and there are some new ones - > > *user_account_name* and *user_full_name* that can be set as default > > values for the fields. When a new feature is created the field is > > populated with the correct name. Which is what we want. > > > > However, when we update an existing record we'd like the > > "*updated_by*" field to be updated with the current > > "*user_account_name*". Like a trigger in the database would do on > > update. Then we would have a better idea of the history of the > > feature. > > > > Ross > > > > *Ross McDonald | *GIS Data Coordinator | Angus Council, People, IT > > | Angus House, Orchardbank Business Park, Sylvie Way, Forfar DD8 > > | 1AT*| > > t: 01307 476419* > > > > This message is strictly confidential. If you have received this in > > error, please inform the sender and remove it from your system. If > > received in error you may not copy, print, forward or use it or any > > attachment in any way. This message is not capable of creating a > > legal contract or a binding representation and does not represent > > the views of Angus Council. Emails may be monitored for security > > and network management reasons. Messages containing inappropriate > > content may be intercepted. Angus Council does not accept any > > liability for any harm that may be caused to the recipient system > > or data on it by this message or any attachment. > > > > This message is strictly confidential. If you have received this in > > error, please inform the sender and remove it from your system. If > > received in error you may not copy, print, forward or use it or any > > attachment in any way. This message is not capable of creating a > > legal contract or a binding representation and does not represent > > the views of Angus Council. Emails may be monitored for security > > and network management reasons.Messages containing inappropriate > > content may be intercepted. Angus Council does not accept any > > liability for any harm that may be caused to the recipient system > > or data on it by this message or any attachment. > > > > > > > > _______________________________________________ > > Qgis-user mailing list > > Qgis-user@lists.osgeo.org > > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > Roxo -- ---------------- Non luctari, ludare -------------------+ WYSIWYG Fernando M. Roxo da Motta <pe...@roxo.org> | Editor? Except where explicitly stated I speak on my own behalf.| VI !! ( Usuário Linux registrado #39505 ) | I see text, ------------ Quis custodiet ipsos custodes?-------------+ I get text! _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
