Import Contact Permissions

I just did this with a few lines of SQL yesterday. I used the constituent import utility to import a file of new subscribers from our retail site into Tessitura, then hit the results with a quick insert statement after the fact. Happy to share if you want to see it.

I just did this with a few lines of SQL yesterday. I used the constituent import utility to import a file of new subscribers from our retail site into Tessitura, then hit the results with a quick insert statement after the fact. Happy to share if you want to see it.

Yes please

Scott Colby (Past Member)

I'd also love to see the code. 

Thanks.

--Tom

P.S. You may be able to post a .zip file of your code here in this thread on TessituraNetwork.com

Here you go! It's just a simple insert of the id of the contact point (the email address, mailing address, or phone number), the purpose, and the category. I cleared out the selection logic from the "in" portion because it was just a big list of addresses.

ContactPointPurposes.zip

Thanks, Scott.  It's the stuff that goes in the second set of parentheses ( ) that our team is trying to figure out.

--Create your contact point purpose records
insert into TX_CONTACT_POINT_PURPOSE (purpose_id, contact_point_id, contact_point_category)
select 7, eaddress_no, -2 from t_eaddress where address in (  )

Gotcha. This worked for me because I had a .csv file of all the addresses to which I wanted to add the purpose. So what I had between those parentheses was basically just this:

(

'address1@domain.com',

'address2@domain.com',

'address3@domain.com'

)

It wouldn't be too difficult to adapt this to look for an attribute, or an interest, or membership in a list, or whatever other data you're using as the basis for planning your purposes. I'm happy to help you with that if you'd like.

Or if you have a way to get the addresses you want into Excel, you can quickly adjust them to include the apostrophes and the comma by changing the cell format to '@', and then paste the whole column into those empty parentheses.

Thanks for sharing.  Our current issue is more about deciding what we think we want to migrate to contact point purposes and restrictions and how those will impact operations.  Lists & Extractions.  Web site.