DataLoad命令集

DataLoad命令集  

Sending Keystrokes

By default, DataLoad Macros use copy and paste to enter datainto the target application, and on most occasions this is the bestapproach. Occasionally, however, it is desirable to be able to sendkeystrokes to the application. DataLoad allows you to send theentire keyboard's printing and most non-printing (E.g. the functionkeys) characters to the active window as if they were typed at thekeyboard. To specify that a cell should result in key presses thetext should be preceded with a backslash. For example, thefollowing would result in each of the specified keys, except for'\', to be sent as simulated key presses.

\Send this as keystrokes

To send a cell which must start with a backslash using copyand paste, precede the cell text with a second backslash. Forexample, the following will cause "\Send this as keystrokes" to bepasted into the target application:

\\Send this as keystrokes

One or more characters represent each key. To specify a singlekeyboard character, use the character itself. For example, to sendthe letter A, use \A. To send multiple characters, append eachadditional character to the one preceding it. To send the lettersA, B, and C, use \ABC. When DataLoad presses a specified key itautomatically takes account of any other key which may need to bepressed to send the exact character which was specified. Forinstance, if a form. field is populated by using the command \A an'A' will appear in the field, that is the character's case ispreserved. In the example of uppercase characters the shift key isautomatically depressed with the character key to send an uppercaseletter.

To use any combination of the Shift, Control, Alt and rightAlt keys one of the following codes should beused: 

Key Code

SHIFT +

CTRL  ^

ALT %

Right Alt &

Each of these codes toggles the key in question. Each of thesekeys is initially in the "up" position and when one of those codesare used the desired key is depressed. When the code is used againthe key is lifted, and so on. If any keys are left depressed whenthe DataLoad cell has been processed the key is lifted. Thefollowing are examples: 

Cell Contents Effect in Active Window

\%F% Alt-F

\%F Same as above

If you want to send the +, ^, % or & keys these charactersmust be enclosed in braces {}. For example, to send '2 +2=4' thefollowing should be entered in the DataLoad cell:

\{2+2=4}

To send a key or a number of keys multiple times, use thefollowing syntax:

\{key(s) number}

You must put a space between the key(s) and number. Forexample, {d 10} means press d 10 times, while {Data 5} sends thekeys 'Data' 5 times. The non-printing characters described belowcan also be sent multiple times in this way.

To specify characters that aren't displayed when you press akey, such as ENTER or TAB, and keys that represent actions ratherthan characters, use the codes shown below. Note that these codesare also enclosed in braces.

Key Code

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}

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}

 

DATALOAD的基本操作命令：
TAB：按键盘上tab键一下；
\{TAB 2}：按tab键两下，如此类推；
*DN：按向下箭头；
ENT：按ENTER键一下；
\^：代表CTRL键，如要按组合键如CTRL+S：\^S，CTRL+F4：\^{F4}（其他如此类推）；
\%：代表ALT键，如要;按组合键如ALT+F：\%F（其他如此类推）；
\{}：代表按下键盘上功能键，要什么功能键就在{}中写，如要按F1键：\{F1}，向下的箭头键：\{DOWN}（其他如此类推）；
*ML(684,120)：代表按下鼠标左键，括号中的数字代表鼠标在屏幕上的坐标；

（如：在ERP窗口把鼠标定位在需要点的位置，然后通过键盘上ALT+TAB键切换到DATALOAD的窗口输入“*ML”就会自动带出当前鼠标坐标。）

定位光标位置：

在DATALOAD程序的DATA位置，在Mainload单元格中输入：*ml(  后，就会提示

意思：自动记录点击确定按键后的第一次点击鼠标的光标位置。

 

*SL2：代表停留，后面的数字是停下的秒数；（在适当的位置停下一定的时间，可以使DATALOAD更加流畅，而且不容易出错。）
*SB：代表按下空格键；
这里只是将比较常用的命令列出来，大家可以举一反三，并在使用中不断熟悉。
在写DATALOAD的过程中，要注意根据窗口切换时的时间，插入一些时间的停留命令，使其有适当的停顿将会避免出错。
对于以下的设置，对时间的控制也是非常重要的：

使用导入工具，一定要熟悉ORACLEERP的操作，特别是快捷键的操作（每个界面按扭文字说明后一般都会有带一个字母，就是快捷键，如登记销售订单，快捷键就是ALT+B，在Dataload工具里就是\%B）。在不是必要的情况下不要用鼠标操作，容易定位错位置，且不同的电脑上定位可能不同。
其实：在很多情况下，程序自身的帮助文件提供了详细的操作说明，包括各种按键、命令的应用。