LWP_M2_GET_NEW_SEGMENT

Description:

This procedure is responsible for gathering patron information from a list manager list for import of a new list into the mail2 dashboard. 

Executed By:

LWP_M2_GET_ELIST_DATA

Executes:

LP_M2_PROC_TO_TABLE (only if an output set is specified when LWP_M2_GET_ELIST_DATA is executed.)

Signature:

@default_cust int = NULL,
@lm_list_id int = NULL,
@eaddress_type int = NULL,
@source_no int = NULL,
@only_primary int = 0,
@output_set int = NULL,
@email_purpose varchar(2) = NULL,
@parent_key varchar(50) = NULL

This procedure makes reference to one T_DEFAULT, m2DefaultCustomer. This T_default is deprecated, but the artifact of its reference is left in place for organizations that may still have a reference to it in their T_DEFAULT table. 

NOTE: Large output sets being retrieved for large lists may cause imports to fail. Output sets that take a significant amount of time to generate can cause the Tessitura API application to time out and the mail2 import to fail. By default the Tessitura API application has a timeout period of 30 seconds that it waits for the database to respond. To extend this timeout period, organizations may adjust the web.config file for the Tessitura API application used by mail2. Please refer to Tessitura's documentation if this is required.

Default Fields returned:

address
first_name
last_name
prefix
customer_no
source_no

If an output set is specified, then all fields from the output set are returned in addition to the above. Fields with the same value as the above are not permitted in the output set being retrieved.

Still need help? Contact Us Contact Us