• Replies 3 replies
  • Subscribers 338 subscribers
  • Views 24 views
  • Users 0 members are here
Related

Automating Regular List Pulls/Extractions

Charles Buchanan
$organization

I already posted this on the Marketing forum but wanted to give it one last shot here.

http://www.tessituranetwork.com/Community/forums/t/9395.aspx

Has anyone setup a customization to automate extraction list pulls?  We do several extraction sets that are on a daily or weekly basis and would like to find a way to automate this work - e.g. extract the names, promote to an appeal, run the output set and email the final file to a group of email addresses all without touching it.  Has anyone found a way to do this? 

Thanks,

Chuck

  • $organization

    Hi Chuck,

    Did you ever sort this out?

    I would love to know how you solved this....

    Thank you...

    Michael 

  • $organization in reply to Michael Sampson

    Yes, well, sort of.  

    What we did was replicated all of the logic in the extraction set as a stored procedure that identified the group of constituents and the fields for output and creates the file which is emailed from the backend to an inbox.  I could get more details on the technical aspects of this process if you'd like.  Unfotunately there is still no front end way to automate extractions if you don't have a DBA.  

  • $organization

    Thank you for responding, that is basically what I expected the response to be.

     

    Michael (Vati) Sampson

    Director of Information Technology

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Charles Buchanan
    Sent: Thursday, April 27, 2017 1:23 PM
    To: Michael Sampson <MSampson@thesmithcenter.com>
    Subject: Re: [Tessitura Technical Forum] Automating Regular List Pulls/Extractions

     

    Yes, well, sort of.  

    What we did was replicated all of the logic in the extraction set as a stored procedure that identified the group of constituents and the fields for output and creates the file which is emailed from the backend to an inbox.  I could get more details on the technical aspects of this process if you'd like.  Unfotunately there is still no front end way to automate extractions if you don't have a DBA.  

    From: Michael Sampson <bounce-michaelsampson2310@tessituranetwork.com>
    Sent: 4/26/2017 6:32:16 PM

    Hi Chuck,

    Did you ever sort this out?

    I would love to know how you solved this....

    Thank you...

    Michael 




    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!