Interfacing valid attribute value ranges to Attribute Matrix (AC/BR)

In the Attribute Matrix application, you must define the attributes for which you are interfacing values.

  1. Prepare a comma-separated value (CSV) file containing the 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 KB2218730 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 attribute 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 (IBMi), 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.