Customising DataLoad using the Options Form

Key parts of DataLoad's activity and appearance can be customised through this form, which is accessible via the Tools menu or from the toolbar icon. This page describes each of the options available.

Generic Options

Automatically size titles When this option is turned on column widths will automatically adjust to fit the column titles. This means the full title is always displayed and is readable. By default this option is not set.

Oracle Apps Export Target If this check box is checked then DatraLoad is the helper application used by the Oracle Applications export functionality. If this box is not checked then setting it will make DataLoad the target helper.

Data Source DataLoad can automatically import data from an Excel spreadsheet. This option controls whether just the selected data or all data in the spreadsheet is imported. The data is pasted into DataLoad at the position of the active cell.

Action After the Excel import DataLoad can automatically start loading into the target application, thus enabling users to easily load data from an Excel spreadsheet into another application. This option controls whether the load starts as soon as the import finishes or not.

Copy & Paste Options

Wait while hourglass When checked, this option will cause DataLoad to suspend sending data and keystrokes to the target application while the cursor is an hourglass. If the cursor is an hourglass this indicates that the application may be still processing the previous data or keystrokes. Delaying processing further cells may prevent DataLoad from sending data that the application is not ready to process. Rather than DataLoad 'spinning' while an hourglass is displayed, which would consume high levels of cpu, it will 'sleep' for a period set in the delays form. When the sleep period is over DataLoad will check the cursor again and will return to sleeping for the preset time if the houglass is still present. By default this option is not set.

Auto insert commands Where a DataLoad column title is a command name that command will be inserted into the column's cells whenever one of the cells is navigated into by the user. This feature is designed to save the user time when setting a spreadsheet up, however unintentional cell commands may result which are undesirable, especially when the spreadsheet is complete. By default this option is set but this functionality can be disabled by unsetting the check box.

Show progress bar During a load DataLoad displays a progress bar indicating how many columns of the current row have been sent and how many rows of the total load have been processed. By unsetting this check box this functionality can be disabled.

Cell Colour The use of colour in a DataLoad spreadsheet not only makes it look more attractive but is very useful in distinguishing between cell types. Default colours can be set for data, command and keystroke cells and cells are painted that colour as soon as DataLoad identifies what the cell contains. By automatically colouring the cells the user does not have to spend time formatting each cell, or changing the formatting when a spreadsheet layout is changed. By default all cells are white, but by clicking on the colour panels a dialog box is displayed and a new colour can be chosen.

Forms Playback Options

Exit Oracle Apps after load If this check box is set then Oracle Applications shuts down once the forms playback is complete.

Username The username to be used to login to Oracle Applications for the forms playback.

Password The password to be used to login to Oracle Applications for the forms playback.

Responsibility The responsibility to be used after logging in to Oracle Applications.