• Replies 3 replies
  • Subscribers 336 subscribers
  • Views 41 views
  • Users 0 members are here
Related

TMS

Revanth Anne
$organization

Hi,

When a web customer selects to unsubscribe from the email list, this information is not being passed to tessitura.

So,I go through the Stored Procedures WP_UPDATE_PROMOTION and LP_UPDATE_EMAIL_PROMOTION. I find everyhting is fine except the hardcoded value 215 for keyword_no .

Kindly, let me know if I need to make any changes to make it work.

Thank you,

Revanth.

Parents
  • $organization

    Hi ,

    I would like to describe in detail which would make things more easy,

    I have activated the stored procedure Lp_update_email_promotion.

    I have enabled the code to unsubscribe

    If @response_code = 5

      Begin

          Update      t_customer

          Set   emarket_ind = 1   -- tickets only

          Where customer_no = @customer_no

      End

     

    If @response_code = 5

      Begin

          If Exists (Select * from tx_cust_keyword where customer_no = @customer_no and keyword_no = 215)

                Update      tx_cust_keyword

                Set   key_value = 'Unsubscribe'

                Where customer_no = @customer_no

                      and keyword_no = 215

          Else

                Insert      tx_cust_keyword(customer_no, keyword_no, key_value)

                Select      @customer_no, 215, 'Unsubscribe'

      End

    RETURN

    @responce_code is 5 ,which I have checked.

    I have gone through the user tickects in TASK regarding this issue,I guess I am unable to visualize the change which needs to be made.

    Any suggestions regarding this problem would be appreciated.



    [edited by: Revanth Anne at 11:01 AM (GMT -6) on 6 Aug 2009]
  • $organization in reply to Revanth Anne

    Are you tracking unsubscribes via an attribute or the emarket indicator or both? If using the attribute, are you sure the patrons in question have the attribute that is keyword 215? (Is 215 definitely the subscribe/unsubscribe attribute?) If they don't have that attribute, then it wouldn't be able to update the key value. Or if that attribute is not valid for the cust type in question that could also be a problem.

Reply
  • $organization in reply to Revanth Anne

    Are you tracking unsubscribes via an attribute or the emarket indicator or both? If using the attribute, are you sure the patrons in question have the attribute that is keyword 215? (Is 215 definitely the subscribe/unsubscribe attribute?) If they don't have that attribute, then it wouldn't be able to update the key value. Or if that attribute is not valid for the cust type in question that could also be a problem.

Children
  • $organization in reply to A. Freeman

    Thank you Amanda for you reply..

    we are suppressing them with the emarket indicator “Tickets Only,” but their unsubscribe action should also show up in the Promotions tab, directly from the feedback loops. 

    Coming to the Keyword_no 215 has Description: Inactive Reason Detail Tbl : t_customer

    Detail Col: !.inactive_reason Ref Tbl: tr_inactive_reason Refidcol: id Refdesccol: description

    Hope this information helps for you to suggest.

    Thank you ,

    Revanth.