Text Layout additional configurations

The Definition section in the Text Layout allows you to further customize and refine how the data is interpreted and processed. Here, you can define settings such as Target Field Separator, Reference Layout type, and other field and record level specifications to ensure accurate data parsing and transformation.

To configure additional settings for a Text Layout, follow the steps outlined below:

1. Click Definition from the toolbar. 

2. On the Definition screen, you can modify the name and description of the Layout.

3. Select the Data Header Present check box if you want to add the titles of the fields in your file. The Data Header usually contains the name of the fields in the file.

4. In the Record Separator and Field Separator field, you can modify the record and field separator to correctly parse and interpret the data within each record and field of the text file during integration.

5. If you want to change the definition file used to create the layout, browse and upload a new data file in the Upload Data File field. 

   This option is available only when you select Import Definition File as the Definition Mode for the Text Layout.

6. In the Reference Layout Type field, select the type of layout from the drop-down list that you want to take as a reference.

7. In the Reference Layout field, select the layout that you want to use as a reference file from the drop-down list.

8. Expand Advanced Properties to view the advanced properties of the text layout. 

   1. Type the row start position in the Row Start Position textbox. Row Start Position specifies which row of the text file is counted as the first row. 
      For example, if you enter the value as 5 in the Row Start Position, the 5th row of the text file is counted as the first row. If this layout is used at the source end, the data from the 5th row onward is taken for processing.

   2. To skip a specific number of rows from the start of the text file, define the row count. In case, you want to skip certain bottom row from the text file then define the row count in the Bottom Row Skip Count field.  

   3. Define the Character-set encoding for your text layout from the drop-down list of the Character Set Encoding field. The available options are UTF-8, UTF-16, and ISO-8859-1.
      In case, the data you are processing through Adeptia Connect contains characters that are part of another character set encoding, for example, UTF-8, then you need to change the character set encoding.

   4. In the Handle Enclosing Character field**,** type the enclosing characters to remove from the data file while parsing. Currently, the following enclosing characters are supported:

      Handling Enclosing Character is supported for source layout only. If Quotes Handling On is checked, the value of the data file at the target layout will be appended with the enclosing character.

      • Single Quote (')
      • Double Quote (")
      • Less than symbol (<)
      • Greater than symbol (>)

   5. Dynamic Header Present checkbox is used to parse text, if:
      FieldNames defined in the source layout and the Data Headers (Column Name) of the text file is the same but not in the same order.
      FieldNames defined in the source layout and the Headers of the text file is not same. They may or may not be in the same order.

      If the headers are not matched between layout Definition and Source File then XML (output of Layout) will only have Root rather than any Record entry. For instance, if the headers of the source layout are Id, Name, and Age and the headers of the data file are Emp Id, Emp Name, and Emp Age then the output of the layout will be blank.  

   6. Select Quotes Handling On check box to enable quotes handling.
      For example, if there is a field data record, "Chocolate$20$perpack" and you set a field separator as $ then the layout will ignore the $ even though it's a part of the data. To avoid such situations you need to put that field within a double quote like this, (Chocolate"$"20$perpack"). When you use Quotes Handling on in a Layout then regular expression does not work on any field.
       

   7. When using Text layout at the target side, select the Enclose Target Field Values in Double Quotes checkbox to enclose the target field values in double quotes. For example, "John","Smith". 

   8. Select Allow Less Fields check box to process the data in case the number of fields in the data file is less than the number of fields defined in the Layout.

   9. Select Remove Last New Line Record Separator check box if you want to remove the new line record separator from the target file.

      When the number of fields in the data file is less than the number of fields defined in the Layout then the Layout will not process the data and give an error during execution. When you select the Allow Less Field check box the Layout generates an empty tag for fields that are not present in the data file. This option is applicable only when you use the Layout at the source end.

   10. In case the input data contains some characters that are invalid in XML then this may result in the aborted mapping. You can filter these invalid XML characters by selecting the Filter Invalid XML Characters checkbox.​

9. Click Save.