Data Upload Options
After you map the worksheet columns to the appropriate Infor Lawson form fields, use the Upload tab to transfer the worksheet data into Infor Lawson.
There are three options for uploading the data:
Upload Options panel
| Option | Description |
|---|---|
| Try to add, then try to change | The Upload Wizard attempts to add the data to the mapped field. If it can't add data, it attempts to change existing data. |
| Add only | The Upload Wizard attempts to add the data. |
| Change only | The Upload Wizard attempts to change the data. |
| Delete only | The Upload Wizard attempts to delete all data associated with the record. |
Threading Options panel
| Option | Description |
|---|---|
| Enabled Multi-Threaded Requests |
The Upload Wizard can simultaneously send data in the server and maximize the upload capability. This optional feature must be enabled before you start the upload. Note: Clear the warning check box if your data must be uploaded in the exact sequence as it appears in the excel sheet.
|
Other Options panel
| Option | Description |
|---|---|
| Ignore Pre-Inquire Status |
This option ignores a pre-emptive inquiry on the form. In general, if EVT=CHG parameter is present in a servlet call, it signals IOS to perform a pre-emptive inquiry on the form. Note: The application might throw an error such as "No More Records For Given Key". To avoid the pre-emptive inquiry, you can select Ignore Pre-Inquire Status. Underneath, the EVT=CHG parameter, _IGNREQD=true is inserted in the Upload queries to make IOS ignore the error in the pre-emptive inquiry.
|
| Initialize Detail Lines |
This option initializes the detail fields after a pre-emptive inquiry. If the Initialize Detail Lines is selected, the _INITDTL=TRUE parameter is included in the Upload query, which initializes the detail fields after a pre-emptive inquiry caused by EVT=CHG parameter. To know more, see Doc for Developers: IOS Application Program Interfaces - Windows |
| Do Not Initialize Detail Lines |
This option removes the _INITDTL=TRUE parameter in the Upload query. |
| Let Add-ins Decide | This option adds the _INITDTL=TRUE parameter in the Upload query if a LINE-FC="A" is present. |
In order to make these options accessible to users, your system administrator must configure the ADDINS attribute with Allow and Deny options. See the "Adding Values to the ADDINS Attribute" section in the Resources and Security Administration Guide.