Email Import /Short Reg/TNEW

Former Member
Former Member $organization

Hey Folks,

Version 2.5 of TNEW introduced a Short Reg Email field for email signups.  I know it grabs a bunch of default settings to create full constituent profiles, by my question is how?

i'm looking for a quick, easy, repeatable process for importing a list of email addresses, as "short reg" constituents.

Ideally, i could loop a procedure on a table and declare the input variable as the email address and the proc would do the rest.

I know there is the "Constituent Import Utility." But then i need to set up all sorts of my own default data.  Anyone have any thoughts?

James

  • Hi James,

     

    TNEW uses entries in the T_DEFAULTS table to populate the required postal address fields.  I believe that any website can use those default settings; they are built into the standard API methods you use to create accounts.  I imagine that your procedure could reference the same defaults if you wanted.  I’m not really a coder though, so it might be just as easy or easier to build those values directly into your code.

     

    Kevin Sheehan

    Senior Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     

  • Former Member
    Former Member $organization in reply to Kevin Sheehan

    Thanks Kevin,

    Easier, maybe, but a better practice to use the same reference to t_defaults, for future changes and all.  I intent to go down this road and give it a try.  for reference i got a similar, but slightly more detailed response from Heather at TNEW:

    "The Short Registration feature of TNEW just uses the good-ol ‘Register’ API method – which relies on WP_MAINTAIN_CONSTITUENT to create the customer record (and a handful of other sprocs to create a web session and associated the user to it).  No special stored procedures are part of this type of account creation."

    If i get through this with any success, i'll be sure to post back soon.

    Thanks!

    James


  • Former Member
    Former Member $organization in reply to Former Member

    I knew it wasn't all in t_defaults;

    FYI, TNEW users;  The sproc also grabs some data from LTR_TN_EXPRESS_WEB_CONTENT

    Primarily fname and lname defaults, which are required values...more from me later.

    JB