We are hosting a video premiere where our goal is to get as many viewers as possible while gathering e-mails for future followup. So we're looking for a very streamlined signup process that will allow us to gather firstname, lastname, e-mail, and (optionally) zip, and then send them the link to the premiere page. We would obviously like to capture these signups for future communication in Tessitura.
I've set up a wordfly pages form that can gather the info, and presumably this will work for getting the info into a table in Tessitura. But I would like to develop a process for matching it up to constituents, adding a relevant activity flag for those who already exist, and, more importantly, creating a new skeleton constituent record for those who don't.
I have never programmatically created a constituent record before, and don't quite know where to start. I can see that there is code in AP_CONSTITUENT_IMPORT I could probably crib from, but is massively complex compared to the four data fields I basically have to start from.
I'm wondering if there exists somewhere an example of the minimal SQL needed to create a very basic constituent record.
You can just use the constituent import utility for that.
(If you want very much to get code-y about it, you could script an insert from the table holding your wordfly data to the C_PRIMARY_CUSTOMER conversion table and then call the conversion procedure, learn more about that from the Advanced Data Import session powerpoint from TLCC 2019. https://www.tessituranetwork.com/Community-and-Events/Conference-Archive/tlcc2019archive )
On Feb 26, 2021, at 7:28 PM, Andrea Crain <bounce-andreacrain7514@tessituranetwork.com> wrote:
<Tessitura_2D00_Network_2D00_logo_5F00_1500x421-png_2D00_150x42-png> Update from Tessitura Network RE: Is there a code example for creating a basic constituent record in SQL? <4UBFWY7D6JDW-jpg_2D00_70x70x2-jpg> Andrea Crain You can just use the constituent import utility for that. Did this answer your question? Verify it as the answer or Reject it as the answer View online You received this notification because you subscribed to the forum. To unsubscribe from only this thread, go here. Flag this post as spam/abuse.
RE: Is there a code example for creating a basic constituent record in SQL?
Did this answer your question?
Verify it as the answer or Reject it as the answer
View online
You received this notification because you subscribed to the forum. To unsubscribe from only this thread, go here. Flag this post as spam/abuse.
Personally I'd sell/register them through TNEW(orother transactional path) and send them the link in the order confirmation. That way they set themselves up. We do this a fair bit and I don't think that the pathway is long enough to be off putting to signups especially given the wins on customer sign up. You can also out a couple of survey questions for data enrichment in the sign up (event detail) page and run that through a stored proc to update their records.
To go full WFPages and record the data back in Tessitura WF tables I think that unless you use a link to the WFPage survey with the Tessitura Constituent ID already created you are not going to save it back to Tess (I could be very wrong and want to test it now). So capturing the survey results in WF alone you could lay out the data according to the constituent import utility and import it but you'd have to do a match up to remove (and update) your current constituent records.
That being said you could create a link to your survey using a generic Tessitura constituent (like New 42 did in their attached mini magic which works a treat) and run the match up on the eaddress column. Then you would be able to do as Andrea says.
MM19-23.pdf
You can get a little less hacky than this, actually. Instead of leveraging the conversion tables and procedure, just load your constituent import data into TW_CONSTITUENT_IMPORT and then call AP_CONSTITUENT_IMPORT directly. You will need to generate an import session ID using AP_GET_NEXTID_function @type = 'CI', but AP_CONSTITUENT_IMPORT is absolutely designed with this pattern in mind.