Customizing the Import Procedure

Knowledge Level: 
Time: 25 minutes
Suggested Skills: Tessitura, SQL
Objective: To edit or add custom fields to every import into mail2, you can update the procedure to include those fields.

There are two types of procedures that run during an import: 

LWP_M2_GET_NEW_SEGMENT (import into a new list or any active contact within mail2)

LWP_M2_GET_EXISTING_SEGMENT (import into an existing visible list)

1

Create a local version of the above procedures

Modify both of the procedures to include the custom fields you'd like to be imported with every Tessitura import.

2

Create a local version of the LWP_M2_GET_ELIST_DATA procedure

Modify the procedure to contain the new local procedure names created during step 1. (ex: LWP_M2_GET_NEW_SEGMENT_LOCAL/LWP_M2_GET_EXISTING_SEGMENT_LOCAL)

3

Go to System Table TR_LOCAL_PROCEDURE

Find LWP_M2_GET_ELIST and modify the procedure and description name to reflect the updated name you created in Step 2 (ex: LWP_M2_GET_ELIST_DATA_LOCAL).  This should contain the same procedure ID. 

Still need help? Contact Us Contact Us