External transfer profiles

You can use external transfer profiles to process a data file in one format, from an application external to SunSystems, and save the processed data in a new file with a different format. You can use all the facilities of Transfer Desk to process the data, such as map, lookup, assign to and function. Use Format Designer to define a format for the source or target data file and use Transformation Designer to define the structure of the target data file. For example you can transfer the data from a flat file from another system to XML or comma delimited format.

Use External Transfer Profile Designer to create a new external transfer profile:

Select TRD from the main SunSystems window to open Transfer Desk.
The form to create a new profile opens automatically.
Select External Transfer as the profile type.
Specify a unique profile name. This name is used to identify the profile in Transfer Desk.
Specify a description for the external transfer profile.
Select a source data format for the external data to be transferred. The source runtime options relevant to the source data format are displayed.
Select a target data format for the converted data. The target runtime options relevant to the converted data file are displayed. The number and content of the runtime options tabs vary depending on the source or target data format you have selected.

Overridable

Each of the Overridable check boxes determine whether the relevant runtime option can be overridden during the transfer process.
Create a new transformation or edit an existing transformation by clicking the Manage button.
Click Save. You can use the '*' asterisk wild-card, and the '?' question mark, when entering the source and target file names.