• Replies 3 replies
  • Subscribers 337 subscribers
  • Views 47 views
  • Users 0 members are here
Related

UserID scheduling merge

Stephen Lang
$organization

I was wondering if anyone knew of a way to see who would be scheduling each merge.  We have a fair number of duplicates that have piled up and we're doing some heavy cleanup, and I would love to be able to see who scheduled what.

 

Thanks,

Stephen



[edited by: Stephen Lang at 12:12 PM (GMT -6) on 25 Sep 2014]
  • $organization

    Stephen,

    We have a custom report that shows who scheduled a particular merge for a set of constituent accounts.  We use it in our consortium so organizations can review what is scheduled before the weekly merge process runs on Monday afternoons. We stop scheduling at Noon on Thursday and then everyone has to opportunity to run the report and notify us of any scheduled merges they have issues with before the merge happens at Noon on Monday.  I'm happy to share a screen shot or sample report output offline if you're interested. 

    Teresa

     

  • Former Member
    Former Member $organization

    You should be able to see the login id of who scheduled a particular merge by reviewing the data in the T_POTENTIAL_DUPS.

    Any pair of rows with matching values in the "criterion" column, with values of "K" (for Keep) and "D" (for Delete) are scheduled; the last_updated_by column should show the user that scheduled those rows (ie, moved their status from "P", for Potential, to "K" or "D").

    Hope this helps!

  • $organization

    Teresa, I’d like to see that report as well if possible.

     

    Thanks!

     

    Randall A. Mitchell
    Director of Information Systems | The Phoenix Symphony | Tel. (602) 452-0440 | Mobile. (602) 796-9323 | Fax. (602) 253-1772
    RMitchell@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Teresa Dean
    Sent: Thursday, September 25, 2014 10:34 AM
    To: Randall A. Mitchell
    Subject: Re: [Tessitura Technical Forum] UserID scheduling merge

     

    Stephen,

    We have a custom report that shows who scheduled a particular merge for a set of constituent accounts.  We use it in our consortium so organizations can review what is scheduled before the weekly merge process runs on Monday afternoons. We stop scheduling at Noon on Thursday and then everyone has to opportunity to run the report and notify us of any scheduled merges they have issues with before the merge happens at Noon on Monday.  I'm happy to share a screen shot or sample report output offline if you're interested. 

    Teresa

     

    From: Stephen Lang <bounce-stephenlang9123@tessituranetwork.com>
    Sent: 9/25/2014 12:04:20 PM

    I was wondering if anyone knew of a way to see who would be scheduling each merge.  We have a fair number of duplicates that have piled up and we're doing some heavy cleanup, and I would love to be able to see who scheduled what.

     

    Thanks,

    Stephen




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!