Configuring Infor Lawson Add-ins for Microsoft Office

Use this procedure to adjust several parameters that affect the processing of transactions started by users of Infor Lawson Add-ins for Microsoft Office. The purpose of these parameters is to mitigate any overloading of the Infor Lawson System Foundation server due to too many and too frequent requests from Infor Lawson Add-ins for Microsoft Office.

System administrators should communicate to the Infor Lawson Add-ins for Microsoft Office users the purpose of these parameters. In general, whenever possible, the users should use existing batch programs rather than Infor Lawson Add-ins for Microsoft Office, and users should not use Infor Lawson Add-ins for Microsoft Office to submit large numbers of transactions (that is, they should submit fewer than 500 at a time). As an administrator, be aware that if you raise the limit for the maximum number of data rows, if you lower the idle time between either different batches of transactions being processed or single data rows being processed, or if you allow multi-threading, you may cause the overall system performance to degrade.

  1. With a text editor, open the iosconfig.xml file in system.
  2. Add and/or edit the following parameters in order to modify the processing of transactions generated by users of Infor Lawson Add-ins for Microsoft Office.
    Parameter Description
    com.lawson.moa.upload.batch.maxrows

    Default value is 500. Allowable range is 500 to 60000.

    The maximum number of data rows that Infor Lawson Add-ins for Microsoft Office can upload at once. If you attempt to upload a larger number, the processing will pause for the number of milliseconds specified for the com.lawson.moa.upload.batch.idletime parameter before processing the next set of rows.

    com.lawson.moa.upload.batch.idletime

    Default value is 1000. Allowable range is 1000 to 60000.

    The length of time in milliseconds that Add-ins is idle before it performs another batch upload.

    com.lawson.moa.transaction.idletime

    Default value is 100. Allowable range is 100 to 60000.

    The length of time in milliseconds that Add-ins is idle in between uploading single data rows.

    com.lawson.moa.multithreading.visible

    Default value is FALSE.

    Defines the visibility setting for the Enabled Multi-Threaded Requests option found in the Upload Wizard.

    If Multi-threading access within the ADDINS attribute set for a user in the Lawson Security Administrator is different from the value set here, then the value in Lawson Security Administrator is used. For more information on the ADDINS attribute see the "Fine Tuning Access to Infor Lawson Add-ins for Microsoft Office" section in the Resources and Security Administration Guide.

  3. Save the changes.