This page explains the user interface and the components of Layout Builder that you can use for creating the following types of layouts in Adeptia Connect.
Options of the Tool bar are explained in the table below.
Button
Name
Function
Save layout
To save the text layout.
File View
To view the uploaded Text file.
Data View
To view, edit, and delete the Table Data and Control Total of text Layout.
XSD View
To view and download the XSD format of text Layout.
Test Layout
To test the similar layout as per the structure defined and generates the output and error files.
Help
To check the help documentation for text Layout.
Details
Displays the control total and table data.
You can also get this tool bar in Data View area:
Button
Name
Function
Zoom Out
To zoom out the text file in File View area.
Zoom In
To zoom in the text file in File View area.
Reset View
To reset the text layout.
Sheet
To select the sheet.
Definition Panel
This panel contains the list of properties that are used to define the Text layout.
Property
Description
Layout Name
Name of the Text layout. Only alphanumeric and underscore are allowed and you must start the layout name with an alphabet or underscore.
Layout Description
Description of the Text layout. Only alphanumeric and few special characters(_ - . : , @ $ ? \\ and space) are allowed and you must start the description with an Alphabet/Underscore/Number.
Layout Type
By default, Layout Type field reflects the same layout type which you are creating.
Data Header Present
Check this if you want to add the titles of the fields in your text file.
Record Separator
Provide the record separator, for example, \n for newline or " " for space, in the Record Separator. The record separator is used to separate the records.
Field Separator
Provide the field separator, for example, \t for Tab or " " for space, in the Field Separator. Field Separator is used to separate fields.
Upload Data File
To upload the text file which displays the uploaded text file in File View area.
Reference Layout Type
Specify the reference layout type for the current layout.
Reference Layout
Displays the defined reference schema in the drop-down list.
Project
Specify the project for text layout. This option is visible only when GAC is enabled.
Row Start Position
Row Start Position specifies which row of the text Sheet is counted as first row.
Bottom Row Skip Count
To skip certain bottom row from the text file then define the row count from Bottom Row Skip Count field.
Character Set Encoding
Define the Character-set encoding for your text layout from the drop-down list of Character Set Encoding field. The available options are UTF-8, UTF-16, and ISO-8859-1.
Handle Enclosing Character
Type the enclosing characters to remove from the data file while parsing in the Handle Enclosing Character.
Dynamic Header Support
Select this option to insert the data of input file under the same header name as defined in the layout.
Quotes Handling On
Select Quotes Handling check box to enable quotes handling.
Enclosed Target Field Values In Double Quotes
Select the to enclose the target field values in double quotes.
Allow Less Fields
Check this if you want to generate empty fields when record data length is less than defined in schema.
Remove Last New Line Record Separator
Select Remove Last New Line Record Separator check box if you want to remove the new line record separator from the target file.
Filter Invalid XML Character
Select this option if you want to replace xml invalid character.
File View Area
File View area is the area where the text file is displayed. You can select the row and column to define the table data and control total of the text layout. The file view area can also be resized using zoom in/zoom out icon from toolbar.
Detail Panel
Detail Panel displays the defined table data and control total of the text layout.