• Replies 9 replies
  • Subscribers 338 subscribers
  • Views 221 views
  • Users 0 members are here
Related

Running UP_CLEAN_EXTRACTIONS

Henry Kelly
$organization

Is anyone running UP_CLEAN_EXTRACTIONS on a regular basis?  If so, how far back do you run it for?  I don't know how many years it makes sense to save this data.

Thanks

Henry

 

Parents
  • $organization

    We use system tables to flag the items, so we have a system table called LTRX_PERMANENT_EXTRACTS (consortium members access the control-grouped view) that offers a dropdown with extraction names. If a user wants to keep their extraction from getting removed by the utility, they just have to add it to the system table.

     

    A few years ago I shared the equivalent list and report schedule utilities to the network. If you log into TASKàShared Reports and search on the keyword “Manage” you should see them. I believe they include the “permanent” system tables as well.

     

    ~Katie

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Summer Hirtzel
    Sent: Tuesday, April 11, 2017 3:07 PM
    To: Catherine Lachance-Duffy
    Subject: Re: [Tessitura Technical Forum] Running UP_CLEAN_EXTRACTIONS

     

    Love this! Katie, what do you use to allow users to flag lists, extractions etc. to keep them from being deleted?

    From: Katie Lachance-Duffy <bounce-katielachanceduffy1902@tessituranetwork.com>
    Sent: 4/11/2017 12:03:29 PM

    Our consortium discussed it at one of our regular "Operations" meetings, and for the same reasons that Chris mentioned the consortium agreed that it would be easier to use the system if older, unused items weren't cluttering it up.

    Our cleanup utilities allow users to flag lists, extractions, etc. that should be excluded from cleanup, and power users review the items that will be inactivated or deleted via scheduled reports before anything is removed.




    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!

Reply
  • $organization

    We use system tables to flag the items, so we have a system table called LTRX_PERMANENT_EXTRACTS (consortium members access the control-grouped view) that offers a dropdown with extraction names. If a user wants to keep their extraction from getting removed by the utility, they just have to add it to the system table.

     

    A few years ago I shared the equivalent list and report schedule utilities to the network. If you log into TASKàShared Reports and search on the keyword “Manage” you should see them. I believe they include the “permanent” system tables as well.

     

    ~Katie

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Summer Hirtzel
    Sent: Tuesday, April 11, 2017 3:07 PM
    To: Catherine Lachance-Duffy
    Subject: Re: [Tessitura Technical Forum] Running UP_CLEAN_EXTRACTIONS

     

    Love this! Katie, what do you use to allow users to flag lists, extractions etc. to keep them from being deleted?

    From: Katie Lachance-Duffy <bounce-katielachanceduffy1902@tessituranetwork.com>
    Sent: 4/11/2017 12:03:29 PM

    Our consortium discussed it at one of our regular "Operations" meetings, and for the same reasons that Chris mentioned the consortium agreed that it would be easier to use the system if older, unused items weren't cluttering it up.

    Our cleanup utilities allow users to flag lists, extractions, etc. that should be excluded from cleanup, and power users review the items that will be inactivated or deleted via scheduled reports before anything is removed.




    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!

Children
No Data