Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

MX160


MX160 - Attribute Valid Value Interface

**Form purpose
Run Attribute Valid Values Interface (AM160) to load attribute values or
ranges of values imported from a non-Lawson file into the Matrix Attribute
application.

**Prerequisites
A non-Lawson file must have been imported into the interface file MXVALREL,
and you should have reviewed and edited the contents of MXVALREL using
Attribute Valid Value Adjustment (MX60.1) before running this program.

**Process at a glance
1.  Create a non-Lawson file of attributes and attribute value ranges in a
format that can be imported into the MXVALREL file such as a comma-separated
value  (CSV) file. The fields in the file must match the fields in the
MXVALREL file.

2.  Transfer the non-Lawson file to the target machine, using a transfer
utility program (such as the winptxfr or ftp command). When you transfer the
non-Lawson file, you may need to rename the file for use in the Lawson system
to abide by the file naming rules of your Lawson environment. For example,
assuming you are transferring a file AttributeValue.csv from your C: drive to
a Lawson UNIX environment, the winptxfr utility could be:
  winptxfr -u attrval c:\\Data\\AttributeValue.csv
  where attrval is the name of your transferred file in the Lawson UNIX
environment.

3.  Load your transferred file into the MXVALREL file, using an import utility
such as importdb.  In the previous example, the syntax would be
    importdb  MXVALREL
    where  is the product line (for example dev8.0) where your
Lawson applications and data are loaded.

4.  Use Attribute Valid Value Adjustment (MX60.1) to review and edit the data
as needed.

5.  Run Attribute Valid Values Interface (MX160) to load the attribute values
into the LAWSON INSIGHT II Matrix Attribute (MX) application.

6. If there are any errors, use MX60.1 to correct them, and run MX160 again.

**Decision/impact
If you leave the Run Group field blank, the load will include all run groups.

If you select an attribute in the Attribute field, only the values for that
attribute will be loaded.

If you select R (Report only) in the Update Option field, the program does not
 update any records and produces an error report.

If you select L (Load) in the Update Option field, the program deletes and
replaces all existing values, and adds new values.

If you select A (Append) in the Update Option field, the program appends new
values to the existing values.

If you Select U (Update) in the Update Option field, the program ignores
existing values that do not overlap, replaces overlapping values, and adds new
values.

If you select Y (Yes) in the Update Type field, the program will load only the
valid records.  MX60.1 will then display only those records that are in
error.

If you select N (No) in the Update Type field, the program will not load any
values until all errors are corrected.  No is the default.

The Update Type field is significant only if you select L (Load), A (Append)
or U (Update) in the Update Option field.

**More help
Run Attribute Valid Value Listing (MX260) to list the attribute values
contained in the Attribute Valid Values Interface file (MXVALREL).

Updated Files

    CKPOINT    -

    MXVALIDATE -

    MXVALREL   -


Referenced Files

    MXCATDEF   -

    MXELEMENT  -

    WFSETUP    -