Interfacing valid attribute value ranges to Attribute Matrix

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 Opening Date might have a valid value range of 01/01/2005 to 12/31/2006. The application would not allow you to enter a date of 01/01/2003. 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.

To interface valid attribute values

  1. Prepare a comma-separated value (CSV) file containing the vendor 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 (IBMi) file. This file layout is available in Infor Customer Portal.
  2. Transfer the CSV file to the server where your Infor Lawson System Foundation is installed.
  3. Use the Import command to load the item data from the CSV file into the Attribute 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, DBIFMVR, 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 (IBMi) file to the MXVALIDATE (Unix/Windows) or DBIFMVL (IBMi) 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.