DataLoad Window
Menu Functions
Using Spreadsheets
DataLoad Options
Importing Data
Data Validation
Sorting Data
Protecting Loads

User Guide Home
DataLoad Home

DataLoad User Guide
Use the Options form to configure how DataLoad works

Customising DataLoad using the Options Window

DataLoad's activity and appearance can be customised in the Options window, which is accessible via the Tools menu or from the toolbar icon. This page describes each of the options available.

When any options are changed the "OK" button must be clicked for the changes to take effect; "Cancel" may be used to revert to the options set before any changes were made.

The "Make Default" button can be used to save the current configuration as the default for all future load sheets. To revert to the default configuration click "Load Defaults".

Display Options

Font This changes the font used in the DataLoad spreadsheets.

Font Size This changes the font size in the DataLoad spreadsheets.

Show toolbar & news messages DataLoad has a message area in the toolbar and will also occasionally show pop-up messages when first started. These are used to provide relevant messages to DataLoad users. These messages can be turned off in DataLoad Professional by un-checking this option. It is not possible to turn off these messages in DataLoad Classic.

Automatically fit columns to title widths 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.

Use date picker in date cells Data validation can be used to specify that a column must contain dates. If this option is enabled then a date picker is displayed when a user edits any cell in a date column. This helps the user to pick a date and also ensures a valid date is entered.

Show DataLoad flash screen at startup The DataLoad startup screen is shown if this checkbox is ticked, otherwise DataLoad starts without showing this.

Macro Loads

Enable Macro Loads Controls whether DataLoad processes the load file as a Macro load when the load is started. This can be disabled for loads where the Macro should not run and instead a PHP script will deliver all load functions.

Automatically tab between fields Most Macro loads involve data being entered in a series of fields and the Tab key is used to navigate between each field. If this option is enabled then DataLoad will automatically press the Tab key after each field is populated, thus avoiding the need to add columns to the spreadsheets to send the Tab key. When this option is enabled DataLoad can be forced not to send a Tab key after processing a cell by prefixing that cell's data with a &.

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. Pausing the load can prevent DataLoad from sending data that the application is not ready to process. DataLoad queries the state of the cursor for the application window under the cursor. Thus, the mouse pointer must be kept over the Macro's target application for DataLoad to know if that application is displaying an hourglass. Moving the cursor outside of the target window may mean DataLoad responds to the cursor state in another window. When the cursor is no longer an hourglass DataLoad will continue with the load after a further optional pause, the duration of which can be set in the Delays window. If the progress bar is activated its title bar is used to tell the user whether the load is currently waiting because the cursor is an hourglass.

Automatically insert commands Where a DataLoad column's title is a command name that command will be inserted into the column's cells whenever the user navigates in to one of the cells. This feature is designed to save the time when setting up a spreadsheet, 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.

Legacy DataLoad keystroke mode The methods used to send keystrokes to target applications changed significantly in DataLoad V5.1. The new methods are fully backwards compatible but added support for many more languages. By default the new methods are always used, however DataLoad will revert to the original methods if this checkbox is checked.

Show progress bar During a load DataLoad displays a progress window 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 window will not be displayed during the load.

Paste Keys By default DataLoad pastes data into target applications using Ctrl-V. This can be changed to Shift-Insert using this option if required.

Cell Colour The use of colour in a DataLoad Macro spreadsheet 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

Exit Oracle E-Business Suite after load If this check box is set then Oracle E-Business Suite shuts down when the forms playback load is complete. By default Oracle stays open at the end of a load.

Unicode (UTF8) File Format for FLD Files If files should be read or written in Unicode UTF-8 then select this option. This option affects all DataLoad files but is only significant for forms playback files. Forms playback files must be in a character set that is compatible with the database character set. By default DataLoad reads and writes files using the default PC character set. That is almost always compatible with the character set in the Oracle database, but if the latter uses UTF-8 then certain characters may not be compatible. To prevent this causing problems this option should be enabled for UTF-8 databases. More…

The following three fields are only relevant for Oracle E-Business Suite versions prior to 11i or where users login to 11i/R12 forms directly and not through the Self Service, "Personal Home Page", browser login. This latter option is not recommended and thus these fields are not used with the majority of forms playback loads.

Username The username to be used to login to Oracle E-Business Suite for the forms playback.

Password The password to be used to login to Oracle E-Business Suite for the forms playback.

Responsibility The responsibility to be used after logging in to Oracle E-Business Suite.


DataLoad is Oracle E-Business Suite Export Target If this check box is checked then DataLoad will be the helper application used by the Oracle E-Business Suite export functionality. That means that DataLoad will be opened and populated with data when the user runs an export.

DataLoad can automatically import data from an Excel spreadsheet and the following two options control the import process. Note that Excel must be running for Excel Import to work and DataLoad will then import from the currently active Excel worksheet.

Excel Data Source 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.

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