Data Loader Commands

Introduction:
Data loader is an utility where you can load data into different Form Based systems especially Oracle APPS. This simple utility works by recording keystrokes that are necessary for loading data from frontend.

Software be downloaded free from
http://www.dataload.net/downloads/download.php

Advantages:

·         Easy to learn and use

·         Can save time for repetitive processes

·         Can be copied from Excel

·         Can be an option to data edits and complex interfaces if the data are simple

 List Of Commands:

DataLoad Command	Application Action(s)
TAB	<Tab>
ENT	<Enter>
*UP	<Up Arrow>
*DN	<Down Arrow>
*LT	<Left Arrow>
*RT	<Right Arrow>
*SP	Save & Proceed
*FE	Field Editor
*PB	Previous Block
*NB	Next Block
*PF	Previous Field
*NF	Next Field
*PR	Previous Record
*NR	Next Record
*ER	Erase Record
*DR	Delete Record
*FR	First Record
*LR	Last Record
*SAVE	Save Record
*SB	Send a single space character
*ST	Select entire field text.
*SLN or *SL(N)	Pause for N seconds. Note 1
*BM	Block Menu
*AX	Alt + X where X is a single letter (A-Z). Note 2
*FI	Find +
*FA	Find All +
*QE	Query Enter +
*QR	Query Run +
*CL	Clear Field +
*IR	Insert record +
*CW(window)	Change to window window. +
*ML(coordinates)	Position the mouse at coordinates and press the left button. ++
*MR(coordinates)	Position the mouse at coordinates and press the right button. ++
\^{f4}	Closing a window
*CW(window)	Make window the new target window for DataLoad.
*SLN or *SL(N)	Sleep for N seconds.
*ML(coordinates)	Position the mouse at coordinates and press the left button.
*MR(coordinates)	Position the mouse at coordinates and press the right button.
*DL(coordinates)	Position the mouse at coordinates and double click the left button.
PROMPT(message)	Prompt the user with message and wait for a response
BACKSPACE	{BACKSPACE}
DELETE	{DELETE}
UP ARROW	{UP}
DOWN ARROW	{DOWN}
LEFT ARROW	{LEFT}
RIGHT ARROW	{RIGHT}
END	{END}
ENTER	{ENTER}
TAB	{TAB}
ESC	{ESC}
HOME	{HOME}
PAGE DOWN	{PGDN}
PAGE UP	{PGUP}
INSERT	{INSERT}
Toggle Numlock1	{NUMLOCK}
Prnt Scrn2	{PRNTSCRN}
F1	{F1}
F2	{F2}
F3	{F3}
F4	{F4}
F5	{F5}
F6	{F6}
F7	{F7}
F8	{F8}
F9	{F9}
F10	{F10}
F11	{F11}
F12	{F12}
F13	{F13}
F14	{F14}
F15	{F15}
F16	{F16}