<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    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!<br>
    <br>
    Alan.<br>
    <br>
    <div class="moz-cite-prefix">On 16/09/15 13:58, Tony Sandman wrote:<br>
    </div>
    <blockquote
cite="mid:CAKAD3=aoZ8jX_-FQ3F_2jUAh3Nm84shZ9M2hfpfCk+fSf-0vvA@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div>
          <div>
            <div>I would recommend to keep "delete user permanently" 
              option, but don't delete (reassign) trace of his previous
              actions (eg. record creation, comment authoring).<br>
            </div>
            In this way you will keep history what in many scenarios
            will allow trace path of communication and responsibilities
            for past actions.<br>
            <br>
          </div>
          Stacey is right - reassigning for example authors of comments
          removing potential evidence in tracking some unwanted actions
          in the past<br>
          <br>
        </div>
        T<br>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">On Wed, Sep 16, 2015 at 7:55 PM, Tony
          Sandman <span dir="ltr"><<a moz-do-not-send="true"
              href="mailto:tonysandman999@gmail.com" target="_blank">tonysandman999@gmail.com</a>></span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div dir="ltr">
              <div>
                <div>I would recommend to keep "delete user
                  permanently"  option, but don't delete (reassign)
                  trace of his previous actions (eg. record creation,
                  comment authoring).<br>
                </div>
                In this way you will keep history what in many scenarios
                will allow trace path of communication and
                responsibilities for past actions.<br>
                <br>
              </div>
              Stacey<br>
            </div>
            <div class="gmail_extra"><br>
              <div class="gmail_quote">
                <div>
                  <div class="h5">On Wed, Sep 16, 2015 at 7:01 PM,
                    Sreenivas Kanumuru <span dir="ltr"><<a
                        moz-do-not-send="true"
                        href="mailto:svk@vtiger.com" target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:svk@vtiger.com">svk@vtiger.com</a></a>></span>
                    wrote:<br>
                  </div>
                </div>
                <blockquote class="gmail_quote" style="margin:0 0 0
                  .8ex;border-left:1px #ccc solid;padding-left:1ex">
                  <div>
                    <div class="h5">
                      <div dir="ltr">This is the popup that comes before
                        the transfer option, when user is deleted.
                        <div><br>
                        </div>
                        <div><img moz-do-not-send="true"
                            src="http://sc.vtiger.net/screenshots/Screenshot-at-17-26-10.png"
                            height="110" width="472"><br>
                          <br>
                        </div>
                        <div class="gmail_extra">
                          <div>Stacey, are you recommending to remove
                            the option to "Delete User Permanently"?</div>
                          <br>
                          <div class="gmail_quote">
                            <div>
                              <div>On Wed, Sep 16, 2015 at 4:54 PM,
                                Stacey Johnson <span dir="ltr"><<a
                                    moz-do-not-send="true"
                                    href="mailto:stacey.johnson110@gmail.com"
                                    target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:stacey.johnson110@gmail.com">stacey.johnson110@gmail.com</a></a>></span>
                                wrote:<br>
                              </div>
                            </div>
                            <blockquote class="gmail_quote"
                              style="margin:0 0 0 .8ex;border-left:1px
                              #ccc solid;padding-left:1ex">
                              <div>
                                <div>
                                  <div dir="ltr">
                                    <div>Deleting user can not allow for
                                      deleting evidence.  This is still
                                      bug.<br>
                                      <br>
                                    </div>
                                    Stacey<br>
                                  </div>
                                  <div class="gmail_extra"><br>
                                    <div class="gmail_quote">
                                      <div>
                                        <div>On Wed, Sep 16, 2015 at
                                          6:15 PM, Sreenivas Kanumuru <span
                                            dir="ltr"><<a
                                              moz-do-not-send="true"
                                              href="mailto:svk@vtiger.com"
                                              target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:svk@vtiger.com">svk@vtiger.com</a></a>></span>
                                          wrote:<br>
                                        </div>
                                      </div>
                                      <blockquote class="gmail_quote"
                                        style="margin:0 0 0
                                        .8ex;border-left:1px #ccc
                                        solid;padding-left:1ex">
                                        <div>
                                          <div>
                                            <div dir="ltr">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.
                                              <div><br>
                                                <div><br>
                                                </div>
                                                <div><img
                                                    moz-do-not-send="true"
src="http://sc.vtiger.net/screenshots/Screenshot-at-16-43-44.png"
                                                    height="228"
                                                    width="472"><br>
                                                  <br>
                                                </div>
                                              </div>
                                              <div class="gmail_extra"><br
                                                  clear="all">
                                                <div>
                                                  <div>
                                                    <div dir="ltr">
                                                      <div>
                                                        <div><br>
                                                        </div>
                                                        <div>thank you,</div>
                                                        <div>Sreenivas</div>
                                                      </div>
                                                    </div>
                                                  </div>
                                                </div>
                                                <div>
                                                  <div>
                                                    <br>
                                                    <div
                                                      class="gmail_quote">On
                                                      Wed, Sep 16, 2015
                                                      at 2:30 PM, Alan
                                                      Lord <span
                                                        dir="ltr"><<a
moz-do-not-send="true" href="mailto:alanslists@gmail.com"
                                                          target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:alanslists@gmail.com">alanslists@gmail.com</a></a>></span>
                                                      wrote:<br>
                                                      <blockquote
                                                        class="gmail_quote"
                                                        style="margin:0
                                                        0 0
                                                        .8ex;border-left:1px
                                                        #ccc
                                                        solid;padding-left:1ex">I
                                                        think this is a
                                                        fairly big bug
                                                        but it needs
                                                        some
                                                        discussion...<br>
                                                        <br>
                                                        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).<br>
                                                        <br>
                                                        <blockquote
                                                          class="gmail_quote"
                                                          style="margin:0
                                                          0 0
                                                          .8ex;border-left:1px
                                                          #ccc
                                                          solid;padding-left:1ex">
                                                          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?<br>
                                                        </blockquote>
                                                        <br>
                                                        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.<br>
                                                        <br>
                                                        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...<br>
                                                        <br>
                                                        This customer is
                                                        using 5.4.0 but
                                                        I suspect the
                                                        same issues
                                                        apply with
                                                        6.3.0.<br>
                                                        <br>
                                                        Discuss.<br>
                                                        <br>
                                                        Al<br>
                                                        <br>
_______________________________________________<br>
                                                        <a
                                                          moz-do-not-send="true"
href="http://www.vtiger.com/" rel="noreferrer" target="_blank"><a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></a><br>
                                                      </blockquote>
                                                    </div>
                                                    <br>
                                                  </div>
                                                </div>
                                              </div>
                                            </div>
                                            <br>
                                          </div>
                                        </div>
_______________________________________________<br>
                                        <a moz-do-not-send="true"
                                          href="http://www.vtiger.com/"
                                          rel="noreferrer"
                                          target="_blank">http://www.vtiger.com/</a><br>
                                      </blockquote>
                                    </div>
                                    <br>
                                  </div>
                                  <br>
                                </div>
                              </div>
_______________________________________________<br>
                              <a moz-do-not-send="true"
                                href="http://www.vtiger.com/"
                                rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
                            </blockquote>
                          </div>
                          <br>
                        </div>
                      </div>
                      <br>
                    </div>
                  </div>
                  _______________________________________________<br>
                  <a moz-do-not-send="true"
                    href="http://www.vtiger.com/" rel="noreferrer"
                    target="_blank">http://www.vtiger.com/</a><br>
                </blockquote>
              </div>
              <br>
            </div>
          </blockquote>
        </div>
        <br>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
    </blockquote>
    <br>
  </body>
</html>