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.
Procedure
- 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.
Note: 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:
Note: Profiling is not available for eMessage landing
page attributes.
- Click OK.
Results
The process is configured. You can test the process to
verify that it returns the results you expect.
Note: 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.