1. Integration Manager
  2. Formatting Information for Export and Import
  3. Validating Field Value Length and Range on Export

Validating Field Value Length and Range on Export

You can add length and range validation for field values exported from OpenAir to a CSV file.

To validate field length and range on export:

  1. On the Field Mapping window, right-click on an OpenAir field, and click Format.

    Note:

    For steps to go to the Field Mapping window, see Mapping OpenAir Fields to CSV Columns.

    The Individual Field Formatting window appears.

    Individual Field Formatting window in Integration Manager.

  2. Length validation — To validate the length of the field value, do the following:

    1. Enter the Total Length (maximum or expected number of characters or digits) for field values.

    2. Select the validation outcome from the dropdown options under Total Length. This determines what happens when the field value length is greater or less than the specified Total Length. The following options are available:

      • Fail with warning if longer — Integration Manager does not export a record and adds a log entry for the error if the field value length is greater than the specified Total Length for that record.

      • Truncate the end if longer — Integration Manager exports all records and shortens the field value to match the specified Total Length by removing digits or characters from the right of the field value.

      • Truncate the beginning if longer — Integration Manager exports all records and shortens the field value to match the specified Total Length by removing digits or characters from the left of the field value.

      • Pad left with spaces — Integration Manager exports all records and lengthens the field value to match the specified Total Length by adding spaces to the left of the field value.

      • Pad right with spaces — Integration Manager exports all records and lengthens the field value to match the specified Total Length by adding spaces to the right of the field value.

      • Pad left with zeros — Integration Manager exports all records and lengthens the field value to match the specified Total Length by adding zeros to the left of the field value.

    3. Enter the Decimal Length (maximum number of digits in the decimal part) for field values.

    4. Select the validation outcome from the dropdown options under Decimal Length. This determines what happens when the field value length is greater or less than the specified Total Length. The following options are available:

      • Fail with warning — Integration Manager does not export a record and adds a log entry for the error if the length of the field value decimal part is greater than the specified Decimal Length for that record.

      • Truncate — Integration Manager exports all records and shortens the decimal part of the field value to match the specified Decimal Length by removing digits from the left of the decimal part.

  3. Range validation — To validate the range of the field value, do the following:

    1. Enter the minimum value under Lowest.

    2. Enter the maximum value under Highest.

    3. Select the validation outcome from the dropdown options. This determines what happens when the field value is outside the range (less than the specified Lowest value, or greater than the specified Highest value). The following options are available:

      • Fail with warning — Integration Manager does not export a record and adds a log entry for the error if the field value is outside the specified range for that record.

      • Set to closest range — Integration Manager exports all records and changes the field value either to the minimum value (Lowest) if less than that value, or to the maximum value (Highest) if greater.

  4. Click OK to return to the Field Mapping window.

  5. Click OK to save the field mapping settings and return to the main Integration Manager window.