Copy of Advanced Positional Layout

You can use an Advanced Positional file to define the structure of your Source or Destination layout. 

Follow the steps below to create a positional layout using the default option:

1. Click Configure > LAYOUTS > Advanced Positional.
2. Click Create Advanced Positional Layout.
   
3. On the Create Layout screen, select the Default option from the Select Layout UI Type field.
4. Click Next. 
5. On the Create Layout screen,
   
   
   
   
   1. In the Name and Description fields, type the name and description of the new advanced positional layout.
      
      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. In the Definition Mode field, select the definition mode for the Advanced Positional Layout. You can define the layout in the following three ways: 
      • Import Definition file
      • Use Data Dictionary
      • Enter the Fields Sequentially
   3. In the Field Separator field, select either Field Length or Start & End Positions option.
      
      • Select the Field Length option if the field length is used to set the field positions.
      • Select the Start or End Positions option if start or end positions are used to set field positions.
   4. If you select Import Definition File option, follow the steps below:

      1. In the Definition File field, select the definition type (XSD or Field).

      2. Click Choose File, navigate to and select the required file (XSD or Field), and then click Open to upload.

   5. If you select Use Data Dictionary option, follow the steps below:
      1. In the Data Dictionary field, select the data dictionary. 
      2. Click Select Record. 
         A new screen displays the name of the data dictionary and the list of all records that are in the dictionary.
      3. On the Select Records screen, select the check box against the record that you want to display in the Advanced Positional layout.
      4. Select Select All check box to display all records.
      5. Click Ok.
         This closes the Select Records window and displays the selected records under the Record Definition. You can view or delete a record from this screen by clicking the appropriate button (View or Delete) for that record.

   6. If you select Enter the Fields Sequentially option, follow the steps below:

      If you select Enter the Fields Sequentially option, the Definition File and Data Dictionary fields will be inactive.
      1. Type the name of any field in the Field Definition for Record Identifier and the value of the field in the Value. Record Identifier is used to identify the records that will be parsed through this definition. You can also use the regular expression as a value by clicking Is Regex.
         
      2. In the Field Name and Description fields, type the name and description of each field.

      3. Select the type of data from the Type drop-down list. The supported data types 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.

      4. If the data type is Date, select the format of date and time in the Date Format and Time Format fields respectively.

      5. If you have selected Field Length as a field separator then type the length of the field in the Length.

      6. If you have selected Start & End Positions as a field separator then type the start and end positions in the Start and End.
         The starting position of a row in a positional file is 1. In a positional file, the schema counts a tab as one position and not eight positions. By default, the schema creates these field positions in a sequence. You can also create a schema with fields that are not in a sequence. For more details, click here.

      7. Select the alignment of the field from the Align. Select L for left aligned and R for right aligned.

      8. 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 unrequired 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.
         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.
          
         While editing an existing schema, the field file that you will download, Adeptia Connect will represent the skipped fields by 'T' and unskipped fields by 'F'. This depiction will remain same while viewing the Print-Friendly Page.

      9. Click Add Record to define another set of data and repeat the steps.
   7. After defining records, you need to define their hierarchy. This is mandatory for creating an Advance Positional schema.
   8. Once you finish adding the records, defining the Record Identifiers and their values, click Refresh under Hierarchy Definition. This populates the Record Identifiers of the defined records in the Record ID field under Hierarchy Definition.

   9. Select a record from the Record ID.

   10. Select Y or N from the Required list box to indicate if a record will appear in the source file.
   11. In the minoccur, type the minimum number of occurrences that you want a record to appear in the source file. If the value of the Required field is 'Y' then the minoccur must have at least minimum 1 occurrence in the source file. If the value of the Required field is 'N' then the minoccur field must be 0.
   12. In the maxoccur, type the maximum number of occurrences that you want a record to appear in the source file. The maximum allowable value that you can enter in the maxoccur field is 2147483647.