Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Monday, May 14, 2012

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}




2 comments:

Unknown said...

is there any command for Alt 2. Cause the shortcut for Lines in number 2 and the Alt combination option is A-z only.

Unknown said...

WHAT IS THE KEY FOR SHIFT+TAB

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect