...
The Text Layout screen is divided into following sections:
- 2022-02-11_04-57-54_.Layout Builder vAdeptia_Connect_v4.01#Toolbar
- 2022-02-11_04-57-54_.Layout Builder vAdeptia_Connect_v4.01#Definition Panel
- 2022-02-11_04-57-54_.Layout Builder vAdeptia_Connect_v4.01#File View Area
- 2022-02-11_04-57-54_.Layout Builder vAdeptia_Connect_v4.01#Detail Panel
Anchor
| Table of Contents | ||||
|---|---|---|---|---|
|
Toolbar
Options of the Tool bar are explained in the table below.
...
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.Anchor
Detail Panel
Detail Panel displays the defined table data and control total of the text layout.