
#Keystrokes meaning windows#
The target application must be running before *CW is used and the window name should be as displayed in the application's icon in the Windows taskbar. For example, the following would activate Excel: The name of the target window must supplied as a parameter to the *CW command. This command is useful where a load must work with more than application or the application has multiple windows. *CW is used to change loading to a different window. Using them repeatedly in the spreadsheets should be avoided because it becomes very time consuming to change the delay when debugging or fine tuning the load.Ī large number of other delays are available in DataLoad and these, along with *SL, are described in the Using delays page. As such they will probably be used in particular one-off situations. *SL is used to include a delay at a specific point in the load and is most useful for situations not covered by the pre-configured DataLoad delays. The number specifying the length of the delay may optionally be enclosed in brackets, e.g. *SL0.5 will result in a half second delay. Decimal numbers can be used for more precise delays, e.g. For example, '*SL5' will cause a pause in the load for 5 seconds. The *SL N command can be added to a spreadsheet cell to cause DataLoad to 'sleep' for a given number of seconds at that point in the load. Delays are used to control the load speed to ensure the load is reliable and no fields are skipped. *SL DataLoad can send data and keystrokes to applications faster than they can be processed. Click the command name for more information about using each command. The built-in commands are listed in the following table. These commands cannot be edited or replaced The following commands are built-in to DataLoad to provide additional functionality beyond sending data and keystrokes to applications. DataLoad provides *A X so that all possible Alt key combinations are available as a DataLoad command. Note 1 In most applications the menus, buttons and other controls can usually be activated by using the Alt key combined with one other key. Sends the Alt + X keystroke where X is a single letter (A-Z). To select the block or tab to which to navigate. Run a query when the form is in query enter mode Of radio buttons and check boxes instead of using the mouse. These are listed below.Ĭlears the form field but does not delete any dataĬlears a record from the form fields but does not delete it While new commands can be added, DataLoad comes with a large number of pre-configured commands. Similarly, to overwrite a load's commands with the defaults the "Load Defaults" button should be pressed. To save those changes such that they become the default and are used for all future loads the "Make Default" button should be pressed. If the Commands or Command Groups are later changed then this only affects that load. When a new Macro load is created the default commands are added to the load. To do this, open the Macro Commands window using the toolbar icon or with the Edit->Commands menu entry. Before running a Macro load the Command Group must be set via the drop list on the DataLoad toolbar.Ĭommands and Command Groups may be created, edited and deleted in DataLoad. A Command Group contains all the definitions for a particular application. Multiple definitions can exist for each command because the keystrokes required for the command can vary between applications, for example the keystroke shortcut to create a new record may be different in Oracle E-Business Suite, SAP and Sage. Also, if the keystroke sequence needs to change then only the command definition needs to be changed and no changes are required in the spreadsheet. Using the command alias makes the spreadsheet easier to read and understand. when *SP is used in a spreadsheet DataLoad will actually send the Save & Proceed keystrokes. Oracle E-Business Suite 11i/R12 the following keystroke combination is required:ĭataLoad includes a standard Save & Proceed command called *SP that is an alias for those keystrokes, i.e. Keystroke AliasesĬommands that are keystroke aliases are used to hide complex keystrokes behind a more userįriendly command name.

Each type of command is documented below. Command names are not case sensitive and may be entered in upper or lower case in the DataLoad spreadsheets. Commands may be built-in to DataLoad to provide additional functionality while others are aliases for commonly used or complex keystrokes. Groups enable multiple definitions of each commandĭataLoad commands are used to give user friendly names to complex or frequently used activities. Commands also exist for special operationsĪllow a single definition for regularly used actions
