Applying Import Rules to Table Column Transformations

After the preliminary data transfer completes, the grid of the Import Table Column Rule Definition form  is populated with the external application and CloudSuite Industrial values for the table columns that were flagged. The CloudSuite Industrial value is determined in part by the rule that is assigned. You can review and change the data transformations in this form before you rerun the preliminary data transfer and, when that completes successfully, the final data transfer.

  1. Use the Import Table Column Rule Definition form to determine the columns where each import rule is applied. New rules can be automatically generated during the preliminary data transfer. View or specify this information:
    Source Table
    Specify the table name in the external application database. The mapping of this table to the target table must be defined in the Import Steps form.
    Source Column
    Specify the column name of the table in the external application database. 
    Seq
    For new rules, specify the sequence used to generate the rules for the table column. -1 indicates a system-generated rule that cannot be edited.
    Rule
    Specify the rule to apply to this column in order to transform the data. The rule must be defined on the Import Rule Definition form.
    Target Table
    The target table that is mapped to the source table is displayed. The mapping is defined on the Import Steps form.
    Target Column
    The target table column that is mapped to the source column is displayed. The mapping is defined on the Import Steps form.
    Data Type
    The data type of the mapped target column is displayed. If more than one mapped target column is found, the data type of the first one that is found is displayed.
    Precision
    If the target column's data type is numeric, the target column precision is displayed. The precision value is the total number of digits that can be stored. For decimal numbers, this includes the digits both to the left and to the right of the decimal point, for example 1.2345 has a precision of 5.
    Length
    If the target column's data type is non-numeric, such as char or nvarchar, the target column length is displayed.
    Decimals
    If the target column's data type is Decimal, the number of decimal digits that are stored to the right of the decimal point is displayed.
    Nullable
    This field indicates whether the column accepts null values.
    [Detail grid]
    The data values for the rule are displayed and the target values can be edited.
  2. Save your changes and rerun the preliminary data transfer.
Related topics