To create a new File Definition follow these steps:

  1. On the PROIV Developer toolbar, click the arrow next to the New icon New Object Icon and select New File Definition. Alternatively, click the Developer menu, hover the mouse on the New option and then click New File Definition.
    The Name the new file definition window appears.

  2. In the File name box, enter the file name.

  3. In the Description box, enter the description.

  4. On the File Type list, select the database for the file definition. For example, Oracle, MySQL.

  5. On the Category list, select the required security category for the File Definition.

  6. Enter the name of the Physical File, where the data will be stored. If you do not enter a name for the physical file, the logical file name is used as the physical file name.

  7. You can copy details from an existing File Definition by selecting the file from the File drop-down list in the Copy from File section. Select the appropriate option from the Copy As section.

  8. Click OK to create the File Definition.
    The Editing File Definition window appears. Enter the File Variables for the File Definition, for more information about the window, click here.

Item

Description

File name

Enter the name of the file name.

Description

Enter the description of the file.

File Type

Select the type of file used for the File Definition.

Category

Select the security category for the File Definition.

Physical file

Enter the name of the physical file where the data will be stored. If you do not enter a name for the physical file, the logical file name is used as the physical file name.

Copy from File

You can copy details from an existing File Definition by selecting the file from the File drop-down list.

File

Select the file from the drop-down list that you want to copy the details from.

Copy As

This section is enabled if you select a file from the File drop-down list in the Copy From File section.

New File

Select to create a new file with the same fields as the Copy From File, but with no relationship to it. It can be changed with no impact on the original.

Child

Select to create a new logical view on the Copy From File, identical in all respects except that the file name and fields have the suffix entered.  This cannot be edited, but it is kept in step with the original if the original is edited.

Associate

Select to create an Associate file, it is similar to a Child File but can be edited and is not automatically kept in step with original. You can specify a postfix to be appended to the copied fields to identify them as copied.

These can be applied to Key Fields, Fields or both.

Postfix

Enter the details of the postfix that you want to append to the fields.

Keys

Select to add the postfix to the Key Fields.

Fields

Select to add the postfix to all Fields.

Both

Select to add the postfix to both Keys and Fields.

OK

Click OK to save the File Definition and to open the Editing File Definition window to enter the File Variables. However, the window does not open if the file is a Child File. If the file has been copied, the File Variables are automatically populated.

Cancel

Click Cancel to exit the window without saving the details.

Comment on this topic

Topic ID: 500062