| # Import (ttstpssiimp ) Use this session to specify the settings for import of data from Excel. Related topics "MS Excel integration" in the Infor Workspace-LN Plug-in - User Guide (U9647 US) "MS Excel integration" in the Infor ES Web UI online help Import File The folder on the client PC where the import file is stored. Action to be taken after an error occurs This field specifies the behavior of the import process if an error is detected. Allowed values
Stop | Stop further processing.
Continue | Mark the current imported row as ‘ERROR’ and continue with the next row.
Prompt | Ask the user what action should be taken.
Overwrite existing records allowed This field specifies the behavior of the import process when inserting a record which is already present. If this check box is selected, the current record is overwritten with new values. If this check box is cleared, the current record is skipped. Add new records allowed This check box indicates whether the import is allowed to add new records. If this check box is selected, inserting records is allowed. If this check box is cleared, inserting records is not allowed. Only updates of records are possible. Open after import This field indicates whether the import file is opened after the import finishes. An additional column, containing the import results, is added in the import file. Allowed values
Yes | After the import, the import file is opened in Excel.
No | After the import, the import file will not be opened in Excel.
Prompt | After the import, a question is asked whether the import file should be opened in Excel.
Replace or append Text This field indicates whether existing text in a row is replaced by, or extended with, text from the corresponding row in the import file. Allowed values
Replace | If the existing row contains text, this text is replaced by the text in the corresponding row in the import file.
Append | If the existing row contains text, the text from the corresponding row in the import file is added directly after the existing text.
The above only applies if the Overwrite existing records check box is selected. Import Starts the import. Browse Starts a dialog where you can select the folder on the client PC where the import file is stored. |