Forms Loading
DL Professional
Macro Loads
Load Control
Browser Control
Forms Playback
Database Loads
Loading Data
Replicate Setup
Macro Loads
Load data into any application
Control any application
Simulate keystrokes & mouse clicks
Use delays to control load speed

Macro Loads

All versions of DataLoad include Macro loads and this is the load technology of choice in DataLoad Classic, the freeware version. Macro loads enable non-technical users to load data in to any application, thus saving time and costs.

The easiest way to load data into a form is using a keyboard and mouse and this is what DataLoad does with Macro loads. You configure in DataLoad the data, keystrokes and mouse clicks that you want loaded into your application form(s). When you run the load DataLoad sends the data, presses the keys and clicks the mouse as you specified. All keyboard keys can be used by DataLoad in any combination and the left and right mouse buttons can also be used. DataLoad calls the same low-level Windows code that is used when users press keys or use the mouse, so the application you are loading data into cannot differentiate between data entered by you and data entered by DataLoad.

To build a DataLoad Macro load write down the keystrokes and mouse clicks you use to enter one record in your application. Now enter that into a DataLoad row and copy the instructions down into as many rows as the number of records you are going to load. Finally, paste your data into the DataLoad cells that correspond to the fields in your form. Your load is now built!

Please consult the Macro section of the User Guide for more information about sending data, keystrokes, DataLoad commands and mouse clicks.

Controlling the Load

DataLoad can send data, key strokes and mouse clicks far faster than some applications can handle them. To slow down DataLoad there is a comprehensive set of Delay options, using both the built-in delays and the *SL (Sleep) command which cause DataLoad to wait at key points.

For the fastest, most reliable Macro loads in to browser forms, e.g. Oracle Self Service forms, use the Browser Control functionality in DataLoad Professional. Browser Control integrates with your browser to ensure DataLoad does not send data faster than it may be processed by the browser. Furthermore, Browser Control can be setup so the DataLoad spreadsheet is fully integrated with the browser and each DataLoad column is tied to a browser form field. During the load DataLoad will inject the data directly in to the linked field. This not only ensures the data is sent to the correct fields but also means navigation commands are not required in the load and the load can run in the background while the user works in other applications.