Common Dataload commands
Dataload command |
Description |
Tab or \ {tab} |
Keyboard Tab key, Next Unit |
* UP or \ {UP} |
Keyboard |
* DN or \ {DOWN} |
Keyboard |
* LT or \ {LEFT} |
Keyboard left |
* RT or \ {RIGHT} |
Right keyboard |
* SAVE or \ ^ S |
Save |
* SB or \ |
Space |
* SL1 |
One second delay |
\ {F6} |
Function key, F6 can be replaced with other |
* PB or \ + {PGUP} |
Shift + pageup, returns the previous block (interface) |
* NB or \ + {PGDN} |
Shift + pagedown, next block (interface) |
Connector |
Description |
\ |
The start of the operation command. Not starting with "\" is the data to be input. |
+ |
Shift key combination, followed by letter world input, plus other key input {} and command character, such as \ + A \ + {DOWN} |
^ |
Ctrl key combination, same as above. For example \ ^ A \ ^ {DOWN} |
% |
ALT combination key, same as above. For example \ % A \ % {DOWN} |
Note:
1. Modify all data in the Excel template to the text format. Switch to the English input when entering the command and connector, and note the upper case.
2. If an error occurs during the import process, press ESC to stop and check for the error and re-import it. (Dataload imports data only from the first cell in the first row)
3. Navigate to the options window of the tools menu of Dataload. Select the "waitwhile hourglass" option. When the associated program is running in the background, dataload suspends data transmission. When the background processing is complete, Dataload continues to send data.
4. Input format of multiple identical commands: \ {Keys number} for example, press 6 tab Keys \ {TAB 6}
Ctrl |
Alt function key |
F1 and other function keys |
Create other keyboards |
Effect |
Format |
Effect |
Format |
Effect |
Format |
Effect |
Format |
Command |
Ctrl |
\ ^ |
Alt |
\ % |
F1 |
\ {F1} |
Upper |
\ {UP} |
* UP |
Ctrl B |
\ ^ B |
Alt B |
\ % B |
F2 |
\ {F2} |
Lower |
\ {DOWN} |
* DN |
Ctrl C |
\ ^ C |
Alt C |
\ % C |
F3 |
\ {F3} |
Left |
\ {LEFT} |
* LT |
Ctrl D |
\ ^ D |
Alt D |
\ % D |
F4 |
\ {F4} |
Right |
\ {RIGHT} |
* RT |
Ctrl E |
\ ^ E |
Alt E |
\ % E |
F5 |
\ {F5} |
Return |
\ {BACKSPACE} |
|
Ctrl F |
\ ^ F |
Alt F |
\ % F |
F6 |
\ {F6} |
Enter |
\ {ENTER} |
ENT |
Ctrl G |
\ ^ G |
Alt G |
\ % G |
F7 |
\ {F7} |
Skip |
\ {TAB} |
TAB |
Ctrl H |
\ ^ H |
Alt H |
\ % H |
F8 |
\ {F8} |
Space |
\ {SPACEBAR} |
* SB |
Ctrl I |
\ ^ I |
Alt I |
\ % I |
F9 |
\ {F9} |
Delete |
\ {DELETE 10} |
DELETELE |
Ctrl J |
\ ^ J |
Alt J |
\ % J |
F10 |
\ {F10} |
Ctrl K |
\ ^ K |
Alt K |
\ % K |
F11 |
\ {F11} |
Ctrl L |
\ ^ L |
Alt L |
\ % L |
F12 |
\ {F12} |
Ctrl M |
\ ^ M |
Alt M |
\ % M |
Mouse operation |
Ctrl N |
\ ^ N |
Alt N |
\ % N |
Ctrl O |
\ ^ O |
Alt O |
\ % O |
Effect |
Format |
Command |
Ctrl P |
\ ^ P |
Alt P |
\ % P |
Left Click |
* ML (coordinates) |
* ML () |
Ctrl Q |
\ ^ Q |
Alt Q |
\ % Q |
Double-click |
* MR (coordinates) |
* MR () |
Ctrl R |
\ ^ R |
Alt R |
\ % R |
Right-click |
* DL (coordinates) |
* DL () |
Ctrl S |
\ ^ S |
Alt S |
\ % S |
Double-click |
* DR (coordinates) |
* DR () |
Ctrl T |
\ ^ T |
Alt T |
\ % T |
Ctrl U |
\ ^ U |
Alt U |
\ % U |
Ctrl V |
\ ^ V |
Alt V |
\ % V |
Ctrl W |
\ ^ W |
Alt W |
\ % W |
Other operations |
Ctrl X |
\ ^ X |
Alt X |
\ % X |
Ctrl Y |
\ ^ Y |
Alt Y |
\ % Y |
Stay N seconds |
* SL (n) |
* SL |
Ctrl Z |
\ ^ Z |
Alt Z |
\ % Z |
Command |
|
Command Group |
Command Group |
Command Group |
Function description |
Command |
Feedback |
11i |
NCA |
10SC |
Description |
* SP |
MENU CUSTOM FILE ACCEPT |
\ % F % V |
\ % A % {DOWN 4} {ENTER} |
\ % |
Save & Proceed |
* SAVE |
Key Commit_form |
\ ^ S |
\ ^ S |
\ {F10} |
Save |
* NB |
Key Next_block |
\ + {PGDN} |
\ + {PGDN} |
\ ^ {PGDN} |
Next Block |
* PB |
Key Previous_block |
\ + {PGUP} |
\ + {PGUP} |
\ ^ {PGUP} |
Previous Block |
* NF |
Key Next_item |
\ {TAB} |
\ % G % {DOWN} {ENTER} |
\ {TAB} |
Next Field |
* PF |
Key Previous_item |
\ + {TAB} |
\ % G % {DOWN 2} {ENTER} |
\ + {TAB} |
Previous Field |
* NR |
Key Down |
\ {DOWN} |
\ % G % {DOWN 3} {ENTER} |
\ + {DOWN} |
Next record |
* PR |
Key Up |
\ {UP} |
\ % G % {DOWN 4} {ENTER} |
\ + {UP} |
Previous record |
* FR |
MENU CUSTOM RECORD FIRST |
\ % V % DF |
\ % G % {DOWN 5} {ENTER} |
\ % G % F |
First record |
* LR |
MENU CUSTOM RECORD LAST |
\ % V % DL |
\ % G % {DOWN 6} {ENTER} |
\ % G % L |
Last record |
* ER |
Key Clear_record |
\ {F6} |
\ {F6} |
\ + {F4} |
Erase record |
* DR |
Key Delete_record |
\ ^ {UP} |
\ ^ {UP} |
\ + {F6} |
Delete record |
* ST |
[None] |
\ {HOME} + {END} |
\ {HOME} + {END} |
\ {HOME} + {END} |
Select field text |
* BM |
Key Block_menu |
\ ^ B |
\ ^ B |
\ {F5} |
Block menu |
* QE |
Key Enter_query |
\ {F11} |
\ {F11} |
\ {F7} |
Query enter |
* QR |
Key Execute_query |
\ ^ {F11} |
\ ^ {F11} |
\ {F8} |
Query run |
* FI |
MENU CUSTOM VIEW FIND |
\ % V % F |
\ % Q % {DOWN} {ENTER} |
|
Find |
* FA |
Menu custom view FIND_ALL |
\ % V % I |
\ % Q % {DOWN 2} {ENTER} |
|
Find all |
* IR |
Key Create_record |
\ ^ {DOWN} |
\ ^ {DOWN} |
\ {F6} |
Insert record |
* CL |
Key Clear_item |
\ {F5} |
\ {F5} |
\ ^ U |
Clear field |
* FE |
Key Edit |
\ ^ E |
\ ^ E |
\ ^ E |
Field edit |
DataLoad command