Creating a New File Definition |
DEVELOPER |
To create a new File Definition follow these steps:
On the PROIV Developer toolbar, click the arrow next to the New icon and select . 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.
In the File name box, enter the file name.
In the Description box, enter the description.
On the File Type list, select the database for the file definition. For example, Oracle, MySQL.
On the Category list, select the required security category for the File Definition.
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.
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.
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. |
Topic ID: 500062