Layouts
Because in an ASCII "flat" file there is no layout or data schema defined, you have to add a layout to the object. The object needs this layout to organize the data in the file correctly. A single layout table may be assigned to multiple files.
To add a layout, you can take the following steps:
-
Open the object to which you want to add the layout.
- Open the node "Files".
- Specify a new file layout.
You can do this by selecting the subnode "Layouts" and clicking "Add new file layout" in the right pane. In the dialog box that will be displayed next, you have to specify a name for the layout. An empty layout will now be created under the (sub)node "Layouts". On the right side, you will see the table in which the layout controls can be inserted to organize a text file.
- Edit the table to define the layout.
You can define file's layout by right-clicking on the layout grid in the main window. You can choose the Inset option from the menu to add definitions via the Object Browser or you can use the Import Table option to copy the schema from an existing database table attached to you environment. The options that apply for the items that you insert to the layout table are the same as for the items you use in your local definitions. Within the right-click menu is a Bulk Mode option that allows you to add and edit the layout via plain text. See Bulk Mode for more information. - Format.
It is possible to set a Format for each layout field. The Format string to use follows the rules of the Local Definitions Format option. - Structure.
To insert fields inside a structure, create a Structure field and then select the END_STRUCTURE field. Inserting fields will then add the fields inside the structure.
Alternatively the Bulk Mode option can be used to place fields inside the structure.
When you right click on the layout in the left pane, you can rename or delete it.