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)
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.
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)
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.