Running a Load

When the load is started, the target form that is to receive the first keystroke must be open. DataLoad versions prior to V4.1 also require that the form isn't minimised, whereas V4.1 and beyond will restore any minimised windows for you. If the first command in the spreadsheet is to send data, as opposed to opening a form, for example, the cursor must be in the correct form field.

The name of the window to receive the data and commands must be entered in the Window Name text box. There is a drop down list that can be used to select window names or the name can be manually entered.

G The name to be supplied in the Window Name box should be the text which appears on the top of the window, not the Oracle Applications form name. The whole window name does not have to be entered, rather only sufficient characters to uniquely identify that window are required.

When the data sheet is ready to test you can either process all cells in your data sheet or just a limited selection. This latter option is useful for testing or debugging just a small, complicated part of the load. If you want to process just a few cells make sure they are highlighted before the load is started.

To run the load select 'Send data' from the 'Tools' menu or click on the shortcut icon. The following dialog box will appear:

Select whether all cells should be processed (as shown above) or just the selected cells.

Click 'OK' and the load will proceed. When it is complete DataLoad will return to being the active window and will display how many records were processed and in what time.

It is sometimes necessary to stop the load before it is complete. This can be achieved by pressing the 'ESC' (Escape) key. DataLoad will stop once the current command is complete. For that reason it may not finish immediately, however in this situation it is not necessary to repeatedly press ESC or hold the key down.