Interfacing valid attribute value ranges to Attribute Matrix (BL)

You can interface a non-Lawson file of valid attribute value ranges and attach them to attributes in Attribute Matrix. The valid value ranges are used to verify values you enter for the attribute. For example, an attribute of Last Called may have a valid value range of 01/01/2004 to 12/31/2004. You cannot specify a date of 01/01/2001.

You must have already defined the attributes for which you are interfacing values in the Attribute Matrix application.

  1. Prepare a comma-separated value (CSV) file containing the customer attribute information to interface. The file fields must match the order and data type of the fields in the MXVALREL (Unix/Windows) or DBIFMVR (IBM i) file. This file layout is available in Infor Customer Portal.
  2. Transfer the CSV file to the server where your environment resides.
  3. Use the Import command to load the activity data from the CSV file into the Customer Import file.

    See Lawson Administration: Server Setup and Maintenance.

  4. Run Attribute Valid Value Listing (MX260) to verify the value ranges before interfacing those records.
  5. View and edit the records in MXVALREL(UNIX/Windows) or DBIFMVR (IBM i), using Attribute Valid Value Maintenance (MX60.1). You can add, change, or delete any records.
  6. Run Attribute Valid Value Interface (MX160) to load valid attribute value ranges to Attribute Matrix. You can use this program to move records from the MXVALREL (Unix/Windows) or DBIFMVR (IBM i) file to the MXVALIDATE (Unix/Windows) or DBIFMVL (IBM i) file, unless errors are found.
  7. View the report generated by MX160. If report contains errors, perform these steps:
    1. Correct the records, using MX60.1.
    2. Run MX160 again.
    3. Repeat this step until the errors are no longer displayed on the report.