The Houston Symphony is interested in knowing if anyone uses an online RSVP system that connects to Tessitura. We want to provide our patrons with the ability to reply to an invitation via a website, and then upload the data into Tessitura.
If so, what is the name of the program? How does it update Tess? How well does it work?
Thank you,
Jan LaRocque
Houston Symphony
I think adding the info to this thread would help everyone!
Michael JoyalDirect 204 954 6411
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Tara UppmanSent: May-17-17 10:04 AMTo: mjoyal@royalmtc.caSubject: RE: [Tessitura Development Forum] RSVP program
We would too! Does this work for adding guest names as well?
Tara Uppman
Director of Development Operations
t 651.221.2515 | tuppman@smm.org
Science Museum of Minnesota
120 West Kellogg Boulevard | St. Paul, MN 55102
Turn on the science: Inspire learning. Inform policy. Improve lives.
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Brian ColumbusSent: Wednesday, May 17, 2017 8:38 AMTo: bmurphy@smm.orgSubject: RE: [Tessitura Development Forum] RSVP program
I would love to get the get the set up info/custom code.
This functionality would make a huge difference around here!!
Best regards,
Brian Columbus
212 King Street West, 6th Floor
T. 416. 593.7769 X 394
F. 416.977.2912
TSO.CA | TSOUNDCHECK.COM
@torontosymphony | facebook.com/torontosymphonyorchestra
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Jatin ManiarSent: Tuesday, May 16, 2017 9:18 PMTo: bcolumbus@tso.caSubject: RE: [Tessitura Development Forum] RSVP program
We are using wordfly as well and I found all reply coming back from wordfly into Tessitura.
Now I have update the activity according to the respond we get from customers.
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Sheila Kearney MillerSent: Wednesday, 17 May 2017 6:01 AMTo: Jatin Maniar <jatinm@australianballet.com.au>Subject: RE: [Tessitura Development Forum] RSVP program
We also do this through WordFly. Invitation emails include buttons with unique links for each of the possible reply options, which then talk to Tessitura to update the activity records.
The set up is pretty easy, but requires a little bit of custom code to be written into a procedure by your DBA. When I was setting this up, I found that the linked document from WordFly didn't really give all the necessary details-- so if anyone who uses WordFly would like info on our set-up/code, feel free to reach out.
From: Jatin Maniar <bounce-jatinmaniar6810@tessituranetwork.com>Sent: 5/16/2017 12:49:56 AM
Thank you
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!
Please consider the environment before printing this email
DISCLAIMER: PLEASE NOTE This email is confidential to the intended recipient. If you receive this email in error please advise by return mail. You should not copy, use or disclose this email or its contents. Information may be subject to change without notice. See our Privacy Policy
Hi all,
Sorry for the delay—am replying from email so hopefully this formats correctly! Please note that neither of these solutions will add notes/guests/etc—they just update the status of an activity record in an account (or create one with the correct status if none exists).
What I did originally-- and this is probably the simplest if you a) want it to work today, or b) only use the functionality occasionally, or c) will not recycle links-- was simply insert the following into our LP_UPDATE_EMAIL_PROMOTIONS procedure which updates the activity records, using the urls linked by buttons in a WordFly email:
if @response_code = 4 and @url is not null
begin
if @url = 'https://www.soulpepper.ca/rsvp/development/CCrsvp2'
If Exists
(
Select * from T_SPECIAL_ACTIVITY
where
customer_no = @customer_no
and sp_act = '260' --activity id
and sp_act_dt = '2017-05-16 00:00:00.000' --date of activity to be updated
)
Update T_SPECIAL_ACTIVITY
Set
status = 4,
num_attendees = 2 -- accepted & 2
Where
end
Else
Insert t_special_activity (customer_no, sp_act, sp_act_dt, perf, status, num_attendees)
Select @customer_no, '260', '2017-05-16 00:00:00.000', 'for colored girls', 4, 2 --activity, date, title, status, # attendees
End
(repeating for each unique url)
Buuuut…. because we have TONS of urls, and we recycle them and I want this to be hands-off for me, as the DBA, I have since created a (only slightly) more involved solution. I created a local table (ltr_email_promo_actvity) that I then made into a system table that contains rows for each unique landing page we create, with drop-down editable fields for activity type, status, performance, etc. This way, I can update the procedure once, and leave the on/off/switch info for the individual urls up to the departmental power users. Then, I edited the insert in the LP_UPDATE_EMAIL_PROMOTIONS procedure to look like this:
if @url in (select url from LTR_EMAIL_PROMO_ACTIVITY)
and sp_act = (select activity from ltr_email_promo_activity where url=@url) --picks activity type for this url
and sp_act_dt = (select act_dt from ltr_email_promo_activity where url=@url) --picks act date for this url
status = (select act_status from LTR_EMAIL_PROMO_ACTIVITY where url=@url), --updates to correct status
num_attendees = (select num_attendees from ltr_email_promo_activity where url=@url) -- updates to correct number of attendees
and sp_act = (select activity from ltr_email_promo_activity where url=@url) --updates to activity type for this url
and sp_act_dt = (select act_dt from ltr_email_promo_activity where url=@url) --updates to act date for this url
Select @customer_no, activity, act_dt, act_perf_name, act_status, act_attendees from LTR_EMAIL_PROMO_ACTIVITY where url=@url --creates new activity record if does not exist
And here is a screenshot of first couple of rows/columns of the local system table:
Feel free to shoot me an email with any further questions.
Cheers,
Sheila