Using the Export-Import Data Template

Use the Export-Import Data template to export data from, or import data into, a location in the database outline. If you export a binary file, you can also import it using the Export Data template.

To use the Export-Import Data template:

1. Create or open a business rule or a template.
2. Do one of the following:

   • For a graphical rule or template, under New Objects, select Export-Import Data, and then drop it into the flow chart between Begin and End.

   • For a script rule or template, expand System Templates, then select Export-Import Data, and then drop it into the desired area in the script.

3. Enter the requested information in the Export-Import Data Wizard.

Table 4-10 Export-Import Data Wizard Steps

Step	Explanation
Mode	Specify whether to export or import data.
Export Data Range	Specify the range of data to export. The following options are available to specify the range of data: Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values. Click next to Member Selector, to select members for each dimension. Select a dimension, and then click to select a variable, member, or function. Select the type of file to which to export the data: Flat file Database table Binary file Note: To import the file after you export it, the file must be a binary file.
Output - File	If you are exporting to a flat file: Enter the file name and path surrounded by quotation marks. Select a column delimiter. Optional: Enter a text string, surrounded by quotation marks, to denote missing data values, or use the Actions icon to select one. If you are exporting to a database table: Enter the data source name surrounded by quotation marks. Enter the data source table name surrounded by quotation marks. Enter the data source logon name and password surrounded by quotation marks. If you are exporting to a binary file, enter the file name and path surrounded by quotation marks.
Processing	Specify the settings on the step.