Configuring a Read Schema (Positional)

You can configure a positional read schema using Business Object Editor.

Procedure

  1. Configure attributes in the Reader Positional Business Object.
    For detailed information about these attributes, see Read Schema (Positional) Reference.
  2. Click Add to add some fields.
    The name of the field is generated automatically as field, field1, field2 and so on. You can edit the field names. With the Add, Remove, Up and Down buttons, you can add or remove attributes, move attributes up and down.
  3. Configure the Type, Constant, and Sample Value columns for the added fields.
    • Type

      The data type in the corresponding field in the file is converted to before publication.

      When you use the dateTime type, you must specify the pattern and locale: right-click the field name and select Set locale and pattern, and then select a supported locale and pattern from the list.

      Note: The parser that matches the pattern specified with the actual date and time is not a strict parser. Even if the pattern and the actual date and time do not match, you might not receive an error. To ensure that the pattern used is correct, you have to verify the date and time actually published with the actual date and time in the data file.
    • Start

      The starting position for the field in the record.

    • Length

      The length of the field.

    • Constant

      Available only when you have selected Field Value from the Identify Type field. Enter a constant value for the appropriate field.

    • Sample Value

      The value is set to <unknown> if the Display Wizard panel is not extended. It shows the actual value when the Display Wizard panel is used and the line in the file is highlighted. You can remove or shuffle the fields.

  4. Create fields and the names of the fields using the Display wizard.
    The wizard text box is used to display the contents of the file for the record being created. You can specify the start and length of each field.
    1. Select the encoding of the file content. Before opening the file, you have to select the file content.
    2. Click Browse to navigate to the file.
    3. After identifying the desired file, click Open.
      The file content is displayed in the Display Wizard panel.
    4. Highlight the line where you want to create a file record.
      The file record lines are displayed in the Sample Line box.
    5. Click Add to add a field.
    6. Select the text in the sample line, the start and the length for the fields are calculated automatically.
    7. Repeat Step e and Step f to create other fields.

    After creating all fields for the record, if you have selected Record Length from the Identifier Type list, you can update the length configuration parameter using the Update Length button.