Page Comparison

This feature helps you to upload a sample or an exact source file to define the layout by custom selection. By default, this feature remains disabled in the product. You need to enable this feature before you start working on this. 

Steps to create positional layout:

1. Click Configure > LAYOUTS > Positional.
2. Click Create Positional Layout.
   
3. On

1. the Create Layout screen, select

1. the Layout Builder option from the drop-down list

1. of Select Layout UI

1. Type field.
   Image Modified
2. Click Next. The Create New Positional screen is displayed in a new page.
   

   1. Type the name and description of the new mapping service in the Name and Description text boxes.
      Name: Only alphanumeric and underscore are allowed and you must start the layout name with an alphabet or underscore.
      Description: Only alphanumeric and few special characters(_ - . : , @ $ ? \\ and space) are allowed and you must start the description with an Alphabet/Underscore/Number.
      

   2. Select the Array Fields Present checkbox if you want the Layout to parse the files having data in single or composite array format. 
      
      

      Warning
      title Important
      The Layouts created for files containing the data in array format can only be used at the Source.

      
      

   3. When you select Array Fields Present checkbox, you need to perform step 7, and then click Continue to define the records on the Record Definition screen. Once you have defined the records, perform step 10 to save the layout. Follow the steps given here to define the records.
   4. Select the Data Header Present check box if you want to add the titles of the fields in your text file. Data Header usually contains the name of the fields in text file. If layout is used at the source end and data header is present in the file. If the layout is used at the target end, and the Data Header Present check box is checked, the Header will be written in the target text file.
   5. Define the Definition Mode either using definition file or entering the fields sequentially.
      Using Import Definition File
      
      1. Select Import Definition File.
      2. Select the type of file from the 

1. 1. 1. Definition File drop down list box. The available options are Data and JSON.

      2. Browse and upload the data file in Upload Data File field.

      3. Select the project from the Project drop-down box.

      4. Click Continue.

      Using Entering the Fields Sequentially
      1. Select Enter the Fields Sequentially as a definition mode.
      2. Select the

1. 1. 1. Field Separator - Field Length or Start & End Positions.
         Field Length: Select this option if the field length is used to set the field positions.
         Start & End Positions: Select this option if the start and end positions are used to set the field positions.
      2. Select the project from the Project drop-down box.

      3. Click Continue.

2. In Definition panel, select the type of layout from the drop-down list of Reference Layout Type field that you want to take as a reference.
3. Select the layout which you want to use as a reference file from the drop-down list of Reference Layout field.
4. Select the Project from the drop-down list of Project. 
   
5. Expand Advanced Properties to view the advanced properties of positional layout.
   
   1. In case, you want to prevent the header rows from being parsed then define a number in Header Skip Row(s) field.
   2. In case, you want to prevent the footer rows from being parsed then define a number in Footer Skip Row(s) field.
   3. Define the Character-set encoding for your positional layout from the drop-down list of 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 a part of another character set encoding, for example, UTF-8, then you need to change the character set encoding.
   4. Enter the target record separator in the textbox Target Record Separator, if you want to write each record in new line in target file. By default records are written in single line. This option is applicable only for the schema used at target end.
   5. Disable the Handle CR/LF (Source Data) check box, if the source file does not have any carriage return. By default, this option is checked, and schema expects file with carriage return. Handle CR/LF (Source Data) option is applicable only for the schema used at the source end.

   6. Select the Data Truncation check box, in case the data length is more than specified in the schema and you want to pass the specified length of data and ignore the rest of the data.

      Info
      The schema that you use at the target end has the option of Data Truncation.

      
      

   7. Select Allow Less Fields check box if you want to parse the data even if the number of fields in the data file is less than the number of field specified in the schema. If Allow Less Fields checkbox is selected and the schema is used at source end, schema will parse the input data and insert the empty tag of missing fields. If the schema is used at target end, it will write all the tags coming in input XML.
   8. In case number of fields in source data is more than the number of fields specified in the schema, only those fields are parsed, which are specified in schema. Other fields are ignored. If you want to generate error records, when number of fields in source data is more than the number of fields specified in schema, disable the Allow More Fields check box.

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

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

      
      

   10. In case the input data contains some characters that are invalid in XML, then this may result in the mapping getting aborted. You can filter these invalid XML characters by selecting the Filter Invalid XML Characters checkbox.
   11. Select Remove Space(s) check box if you want to remove all the leading and trailing spaces(s) from the data value on the source side.
   12. Select Remove Leading Zero(s) check box if you want to remove all the leading zero(s) from the numeric data value on the source side.

6. Once the required properties are defined, you can create the Table Data and Control Total

1. Data, or Record Definition using their respective screens. 

   Tip
   The Record Definition screen appears only when you have selected Array Fields Present checkbox on the Create New Positional screen.

   
   

   Steps to define the Table Data:

   1. In File View Area, select the row which you want to define as a header.
   2. Right-click and select New Table option to display the Table Data screen.
   3. On Table Definition screen,
      
      Image Modified
      
      
      1. You can adjust the data length, start and endpoint of a data field using scale. You can also add column by clicking Add Column button. 
      2. You can Insert column left or right, delete column, and split column using the column menu by right click on columns.
      3. Click on the column to rename it.  
      4. Click Next.
         
         
   4. On Table Column Definition screen, 
      
      Image Modified
      
      

      1. You can edit the Field Name value. If reference layout is defined, click the field to get the suggestions based on the reference layout.

         Info
         You can use spaces and other special characters (~`! @ # $%^&*() {} [] | \\ : ; " ' - + =<> / ? . ,  ) in the field names. The special characters are rendered as underscores (__) if you use this layout in a Mapping.

         
         

      2. Select the type of data from the Data Type

1. 1. 1. drop-down list. The supported data types for text Layout are:

         Data Type	Description
         String	Select this data type if the field accepts a string value.
         Number	Select this data type if the field accepts a numeric value.
         Date	Select this data type if the field accepts a Date or Date and Time value.

1. 1. 1. 
         

      2. In the Format field, select the date and time format

1. 1. 1. for the Date or Date Array data type. This field is applicable only for Date data type.

      2. In the Start and End fields, provide start and end positions of the field value that you want to parse.

         Note
         These fields are enabled only when you have selected Start & End Positions in the Field Separator field on the Create New Positional screen. The value for Length field changes based on the value you enter here.

         
         

      3. In the Length field, provide a length of the field up to which you want to parse its value. 
         

         Note

         This field is enabled only when you have selected the Field Length in the Field Separator field on the Create New Positional screen. You cannot modify the values for Start and End fields. The value for the Start field remains 1 and that for the End field changes based on the value you enter here. For example, if you provide 10 as the value for this field, the values for the Start and End fields are 1 and 10 respectively.

         
         

      4. Select the alignment of the field from the

1. 1. 1. drop-down list Align.

          L if the field is left aligned.
          R if the field is right aligned.

      2. Select Skip check box if you want to skip some fields while generating the XML for your layout. For example, your source file has over 1500 fields, but you only need to use 1000 fields. This Skip check box will omit the 500 fields and it will not read them when it parses the data to XML. However, the fields will be visible in the file. If you create the layout using an existing XSD, then the skipped fields will appear blank. However, when you will use the same layout in other activities such as Mapping, it will display all the fields of the file.
         
         

         Info
         The skipping of fields is useful in case where a standard XSD has a large number of fields. Skipping reduces the size of the XML that will now contain the required fields.

         
         

      3. To insert rows, specify the number and position of the rows that you want to add in the Number of Rows and at Position fields respectively and click Add Row button. You can add a maximum of 99 rows at a time.

      4. Click Save to save the table data.

         You can see the created Table data in Details Panel. 

         Info
         Click Image Modified button to open table data in data view panel. Also, click Image Modified button to delete the table data.

         
         

   
   Steps to define the Control Total
   Before defining the control total value, you must specify these values:

   • Define the Header Skip Row(s) in case you want to parse value in header. 

   • Define the Footer Skip Row(s) in case you want to parse value in footer. 
     
     
   Follow these steps to define the control total:
   1. In File View area, select the row (based on the defined Header Skip Row(s) or Footer Skip Row(s)) which you want to parse to the source side. 
   2. Right-click and select Control Total option.
      
      Image Modified
      
      
   3. On Control Total Definition screen:
      
      Image Modified
      
      
      1. Control Total Position and Control Total Row Number are automatically updated based on the user selection.
      2. You can adjust the data length, start and endpoint of a data field using scale. You can also add column by clicking Add Column button. 
      3. You can Insert column left or right, delete column, and split column using the column menu by right click on columns.
      4. Click on the column to rename it.  

   4. Click Next.

   5. On Control Total Column Definition screen, you can get the suggestion for the Field Name if you have selected Reference Layout in the Definition panel. To achieve this, click on the Field Name to view the suggestion. 

   6. Click Save to save the control data and perform step 10 to save the layout.

      You can see the created Control Total in Details Panel. 
      
      Image Modified
      
      

      Info
      Click Image Modified button to open control total in data view panel. Also, click Image Modified button to delete the control total.

      
      

      Anchor
      Record Definition Record Definition

      Steps to define the records
      1. On Record Definition screen, type the name of each field in the Field Name text box.

      2. Select the type of data from the Data Type drop-down list.
         The supported data for text Layout are described in the following table:

         Data Type	Description
         String	Select this data type if the field contains a string value.
         Number	Select this data type if the field contains a numeric value.
         Date	Select this data type if the field contains a Date or Date and Time value.
         Number Array	Select this data type if the field contains values of numeric data type.
         String Array	Select this data type if the field contains values of string data type.
         Date Array	Select this data type if the field contains values of Date or Date and Time type.
         Composite Array	Select this data type if the field contains values in a combination of numeric, string, Date/Date and Time data types.  If you select Composite Array as the data type for a field in the file, you need to define the subfields of the Composite Array field by following the steps given below: ClickImage Added(Add Sub Fields) against the Composite Array field.  Image Added ClickImage Addedon the left of Composite Array field to expand and see the added row for defining the subfield. Image Added For the subfield, enter the name, data type (String, Number, or Date).  Image Added Perform the above steps (1 through 3) for all the other subfields and continue from step iii through step 10.

         
         

      3. Anchor
         iii iii

         In the Format field, select the date and time format for the Date or Date Array data type (if selected in the previous step). This field is applicable only for Date and Date Array data types.
      4. In the Occurrence field, enter the number of array field values or sets of array field values. This field is applicable only for array data types.

      5. In the Length field, provide a length of the field up to which you want to parse its value.
         

         Note
         You cannot modify the values for Start and End fields. The value for the Start field remains 1 and that for the End field changes based on the value you enter here. For example, if you provide 10 as the value for this field, the values for the Start and End fields are 1 and 10 respectively.

         
         

         Tip
         In case of a Composite Array data type field, you need to define the length for subfields instead of defining it for the parent field.

         
         

      6. Click Save to save the record definition.

         Info
         You can view the Control Total and Table Data/Record Definition in Data View panel by clicking Data

1. 1. 1. View Image Modified button from the toolbar. You can also edit and delete form this panel. If you want to see the layout in XSD format, click XSD View Image Modified button from the toolbar. You can also download the XSD file by clicking Download XSD button.  You can test the layout by clicking Test Layout Image Modified button from the toolbar. Click here to get more details.

         
         

2. Anchor
   10 10

   Click Save Layout to save the layout.