Files to be Identified

In this dialog box you can define the files to be prepared by the preparation routine. You also determine the file structure.

You can select the files that will be imported in two different ways:

• Click Add files to the list and select the file(s) and click Open. The file name in the File Name, File Alias, and Mask fields will be applied automatically. To modify the applied values click in the corresponding field and overwrite the values.
• The second option is to create a new file clicking Add new file.

In the File Alias field enter a name. This name will also be displayed in the File Alias area. Every file will be identified by the alias name. Therefore this name is mandatory and has to be unique.

In the Mask field you can enter a set of characters that will be used to identify the files required by the Custom Prepatation Routine. The set of characters will be used for the currently selected file.

The Mandatory option defines whether or not a file is mandatory for the preparation. If you select No, the user can decide if the file will be used for the preparation or not. If you select Yes, the file will be selected automatically for the preparation.

Names to be resolved

If you have exact knowledge of the file structure, you do not have to make any changes in this field. If you do not know the file structure or you want to create a preparation routine, that can also be used for other similar files, click the browse button to open the Specify Dynamic Field Name Resolver dialog box.

In the Required area, define if a column has to be assigned. If you select Yes, the corresponding column has to be assigned. If you do not know whether two or more columns are used for a column in the file to be checked, specify multiple columns for it, for example, by labeling one column as Mandatory and the others as Optional. With the macro you can then transform these columns into one column again.

Enter the alias name used in the macro in the Column Alias field. Then select the corresponding file type.

You can enter a description for each column. This description is shown to the user when assigning the columns. Entering a description is optional.

Click Apply and Close to apply your changes and return to the Files to be Imported dialog box.