To specify a database table for contact logging

You can log contact information to a database when configuring a contact process.

In the process configuration dialog, select New Mapped Table or Database Table from the Export To or Log To drop-down list. This option usually appears at the bottom of the list, following the list of mapped tables.

The Specify Database Table window appears.

Specify the table name.

You can use user variables in the table name. For example, if you specify MyTable<UserVar.a> as the table name, and the value of the user variable "a" is "ABC" at the time that the process is run, the output is written to a table named MyTableABC. You must set the Initial Value and the Current Value of the user variable before executing the flowchart.

Select the database name from the drop-down list.

Click OK.

The Specify Database Table window closes. The Export/Log to field in the process configuration dialog displays the name of the database table that you entered.

If a table of the name you specified exists, choose an option for writing the output data:

Append to Existing Data: If you choose this option, the existing table must have a schema compatible with the output data. In other words, field names and field types must match, and field sizes must allow for the output data to be written.

Replace All Records: If you choose this option, existing rows in the table are replaced with the new output rows.