[Vtigercrm-developers] Delete User destroys Activity History & Comment trail

[Alan Bell]

users don't have an entry in vtiger_crmentity so it isn't a case of 
setting deleted=1 there. Delete permanently removes their line in 
vtiger_users, like deleting and purging the recycle bin. If they are 
utterly gone like that then comments can't link back to their user id 
and get the name. Clearly reassigning stuff to a new user should exclude 
modtracker and modcomments, but there is no point in doing that if the 
user is deleted permanently, and there is no way to reassign unless the 
user is deleted permanently!

Alan.

On 16/09/15 13:58, Tony Sandman wrote:
> I would recommend to keep "delete user permanently" option, but don't 
> delete (reassign) trace of his previous actions (eg. record creation, 
> comment authoring).
> In this way you will keep history what in many scenarios will allow 
> trace path of communication and responsibilities for past actions.
>
> Stacey is right - reassigning for example authors of comments removing 
> potential evidence in tracking some unwanted actions in the past
>
> T
>
> On Wed, Sep 16, 2015 at 7:55 PM, Tony Sandman 
> <tonysandman999 at gmail.com <mailto:tonysandman999 at gmail.com>> wrote:
>
>     I would recommend to keep "delete user permanently"  option, but
>     don't delete (reassign) trace of his previous actions (eg. record
>     creation, comment authoring).
>     In this way you will keep history what in many scenarios will
>     allow trace path of communication and responsibilities for past
>     actions.
>
>     Stacey
>
>     On Wed, Sep 16, 2015 at 7:01 PM, Sreenivas Kanumuru
>     <svk at vtiger.com <mailto:svk at vtiger.com>> wrote:
>
>         This is the popup that comes before the transfer option, when
>         user is deleted.
>
>
>
>         Stacey, are you recommending to remove the option to "Delete
>         User Permanently"?
>
>         On Wed, Sep 16, 2015 at 4:54 PM, Stacey Johnson
>         <stacey.johnson110 at gmail.com
>         <mailto:stacey.johnson110 at gmail.com>> wrote:
>
>             Deleting user can not allow for deleting evidence.  This
>             is still bug.
>
>             Stacey
>
>             On Wed, Sep 16, 2015 at 6:15 PM, Sreenivas Kanumuru
>             <svk at vtiger.com <mailto:svk at vtiger.com>> wrote:
>
>                 Alan, This is already addressed in 6.3. Deleted User
>                 will be marked as inactive, if the 'Delete User
>                 Permanently' option is not selected. All the updates
>                 and comments will remain associated with the deleted
>                 user.
>
>
>
>
>
>
>                 thank you,
>                 Sreenivas
>
>                 On Wed, Sep 16, 2015 at 2:30 PM, Alan Lord
>                 <alanslists at gmail.com <mailto:alanslists at gmail.com>>
>                 wrote:
>
>                     I think this is a fairly big bug but it needs some
>                     discussion...
>
>                     Our customer has just asked about their process
>                     when they have churn with employees in their
>                     business (churn in this case means multiple people
>                     leaving and joining their business, e.g. staff
>                     turnover).
>
>                         We've had a bit of staff churn recently and
>                         I've struggled to keep up with the data
>                         re-assigning. We used to delete a user when
>                         they left and re-assign everything to admin.
>                         This was really straightforward as the system
>                         did all the hard work for you in the
>                         background. However, we soon realised that
>                         this messed with the audit trail in the "View
>                         history" and it changed the owner of the
>                         comment to admin so you couldn't tell who had
>                         made the notes. We changed our process to
>                         making the user inactive and then manually
>                         re-assigning the records. This take a while
>                         and there is a lot of room for human error. Is
>                         there a quicker way of doing this that I'm
>                         missing or something at point of deleting a
>                         user that maintains the audit trail?
>
>
>                     It seems to me that when you delete a user from
>                     vtiger somehow the data in ModTracker needs to
>                     retain the fact that that earlier changes were
>                     made by that user (a new field to hold the User's
>                     name rather than their ID?), and *not* the user
>                     you have just re-assigned everything too. The same
>                     goes for comments too.
>
>                     Secondly, he makes a valid point about making a
>                     user Inactive instead... There should probably be
>                     an option to re-assign related records when making
>                     a user Inactive...
>
>                     This customer is using 5.4.0 but I suspect the
>                     same issues apply with 6.3.0.
>
>                     Discuss.
>
>                     Al
>
>                     _______________________________________________
>                     http://www.vtiger.com/
>
>
>
>                 _______________________________________________
>                 http://www.vtiger.com/
>
>
>
>             _______________________________________________
>             http://www.vtiger.com/
>
>
>
>         _______________________________________________
>         http://www.vtiger.com/
>
>
>
>
>
> _______________________________________________
> http://www.vtiger.com/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150916/1fea8303/attachment-0001.html>