Create a Load
Sending Data
Timing & Delays
Running a Load
Step Mode Loads
Load Control
Auto Start
Macro Recorder

User Guide Home
DataLoad Home

Creating a Macro Load

Creating a Macro load is straightforward and the following steps should be followed to create and run a load:

Set the Window Name - This is the name of the window that DataLoad is to control, i.e. typically where DataLoad will load data. Use the drop list on the DataLoad toolbar to select the name of that window. The application must be running for the name to appear in this list.

Set the Command Group - DataLoad Commands may have different definitions for different target applications, e.g., Oracle E-Business Suite, SAP, Sage, etc, and the Command Group is used to select the correct command definitions. Select the most appropriate application from the Command Group drop list in the DataLoad toolbar. If none of the application names is relevant then choose "Other".

Populate the Spreadsheets - Add data, keystrokes and commands to the Header, Main and Footer spreadsheets. Most configuration is normally done in the Main spreadsheet and the Header and Footer spreadsheets may not be used at all. The spreadsheets must be populated such that the correct data, keystrokes and mouse clicks are sent to the target application in the correct order, remembering that DataLoad processes the cells from left to right in each row and one row at a time working from top to bottom.

Check the Delays - Delays are vital to ensure DataLoad works as fast as possible but not too fast for the target application. The default delays are often sufficient but these must be changed if DataLoad runs too quickly.

Start the Load - Start the load by clicking on the start load toolbar icon or selecting Start Load from the Tools menu. Select the rows to be loaded in the Run Load window and change the Window and/or Command Group names if required. Click OK to start the load.