Extracting data from an eMessage landing page

You can use the Extract process in a flowchart to extract data from an eMessage landing page. The Extract process selects fields from one table and writes them out to another table for subsequent processing.

Ensure that your IBM® environment meets the requirements before attempting to extract eMessage landing page data. For more information, see Prerequisites for extracting data from eMessage landing pages.

In a flowchart in Edit mode, double-click the Extract process in the flowchart workspace.

The process configuration dialog appears.

On the Source tab, select eMessage Landing Pages.

In the popup window, select an eMessage landing page as input.

You can select only one eMessage landing page as input to an Extract process. To extract data from more than one landing page, configure multiple Extract processes.

If there is more than one audience level available for the landing page, select the appropriate audience level from the drop-down list. If there is only one audience level available, it is automatically selected.

Click OK.

On the Extract tab, select an output location.

To store the data in binary format, select IBM® Campaign Server.

To store the data in a uniquely named table with a UAC_EX prefix, select an available database.

Select fields to extract from the list of Candidate Fields.

Click Add to add selected fields to the list of Fields to Extract.

To remove fields from the list of Fields to Extract, select them and click Remove.

Use the Up 1 and Down 1 buttons to change the order of fields in the Fields to Extract list.

To change the default output name of a field to extract, select the field in the Fields to Extract list, click the name in the Output Name column, then enter the new name.

For information about the fields on the Extract tab, see Extract tab reference.

Perform any of the following optional tasks:

Add a derived field to the list of candidate fields. See Derived fields

Specify that duplicate IDs are excluded from the output. See Skipping duplicate IDs in process output.

Limit the size of the output cell (that is, limit the number of IDs generated by the process). See Limiting the size of output cells.

Click the General tab to modify the Process Name, Output Cell names, or Cell Codes, link to a target cell, or enter a Note about the process.

For information about linking to target cells, see Linking flowchart cells to targeted offers defined in a TCS.

Profiling is not available for eMessage landing page attributes.

Click OK.

The process is configured. You can test the process to verify that it returns the results you expect.

During the extraction process, Campaign creates an intermediate view in the system tables database with a UCC_LPV prefix. This internal view remains in the database until the process box is deleted. If you remove the view, you must reconfigure its corresponding Extract process before rerunning the process or flowchart; otherwise, Campaign generates a missing table error.