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 might have a valid value range of 01/01/2004 to 12/31/2004. The system would not allow you to enter a date of 01/01/2001. Use this procedure to replace or add to existing value ranges that are used to validate values you enter for an attribute.

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

  1. Prepare a comma-separated value (CSV) file containing the customer attribute information you want 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. For instructions on using the Import command, 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. This program moves 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 it contains errors:
    1. Correct the records, using MX60.1.
    2. Run MX160 again.
    3. Repeat this step until the report shows no errors.