Data Loader is the number one choice of Oracle Applications Professional for entering large data into Oracle EBS / ERP Application Forms from Excel or delimited text files.
It is used to automate bulk data entry. Even though it has special features for Oracle EBS applications, it can be used to automate bulk data entry into any Windows application forms.
Highlights of Data Loader
Needs zero special technical know-how, can be utilized by non-technical end users because data is filled up in forms.
Helps you to save time and effort. Create load at one time and reproduce the load several times as you may need.
Entirely transparent to the application form. Application form responds as information is typed by a user.
Precise. Almost all validations define in the application form forms are carried out.
Data Loader loads the data using the following methods
Macro Loading
Forms Record and Playback Feature
Macro Loading
Forms Data Loader fills data in Forms by simulating keystrokes as if type by a user. It includes a spreadsheet interface where one can enter the data and keystrokes to send to the forms. Setting up Load is quite effortless, you will learn setting up data loads by just spending few minutes. We give a series of demos which demonstrates how the loads are developed and how FDL operates. Even though it is particularly targeted to load data into Oracle ERP Applications, it may be utilized to load data in almost any sort of application form whether it be SAP or HTML or any other application
Start your target application form in which you would like to automate loading of data and move the cursor on the 1st field.
Start Forms Data Loader by clicking on its desktop icon.
Click Create New by Macro Recording button and a dialog will be displayed.
Click Start Recording button in the dialog
Change to your target application form window
At this point enter a sample record in your target application form.
After entering the record click Stop Recording in the dialog
Click Create Load button.
Now you will see a Excel like sheet in Forms Data Loader with all fields which you have entered in the form.
You can now populate this sheet by copying and pasting data from Excel or any CSV or delimited file.
Once you have populated the sheet click Load button
In Data Loader you can send keystrokes to the target application by entering the "\" as the starting letter. FDL recognizes a cell as keystroke if the cell contains as back slash "\" in the first position. For Example to send ALT and F keystroke enter \%F to send "ALT-FV" enter \%FV.
To specify that any combination of SHIFT, CTRL, and ALT should be held down while several other keys are pressed, enclose the code for those keys in parentheses. For example, to specify to hold down SHIFT while E and C are pressed, use "\+(EC)".
To specify to hold down SHIFT while E is pressed, followed by C without SHIFT, use "\+EC".
To specify repeating keys, use the form {key number}. You must put a space between key and number. for example, \{LEFT 42} means press the LEFT ARROW key 42 times; \{h 10} means press H 10 times
In addition to Keystrokes, Data Loader also comes with built in shortcuts for most common Oracle form functions. Below is the list of some of the shortcuts. It also lets you define your own shortcuts for commonly used keystrokes.
It is used to automate bulk data entry. Even though it has special features for Oracle EBS applications, it can be used to automate bulk data entry into any Windows application forms.
Highlights of Data Loader
Needs zero special technical know-how, can be utilized by non-technical end users because data is filled up in forms.
Helps you to save time and effort. Create load at one time and reproduce the load several times as you may need.
Entirely transparent to the application form. Application form responds as information is typed by a user.
Precise. Almost all validations define in the application form forms are carried out.
Data Loader loads the data using the following methods
Macro Loading
Forms Record and Playback Feature
Macro Loading
Forms Data Loader fills data in Forms by simulating keystrokes as if type by a user. It includes a spreadsheet interface where one can enter the data and keystrokes to send to the forms. Setting up Load is quite effortless, you will learn setting up data loads by just spending few minutes. We give a series of demos which demonstrates how the loads are developed and how FDL operates. Even though it is particularly targeted to load data into Oracle ERP Applications, it may be utilized to load data in almost any sort of application form whether it be SAP or HTML or any other application
Start your target application form in which you would like to automate loading of data and move the cursor on the 1st field.
Start Forms Data Loader by clicking on its desktop icon.
Click Create New by Macro Recording button and a dialog will be displayed.
Click Start Recording button in the dialog
Change to your target application form window
At this point enter a sample record in your target application form.
After entering the record click Stop Recording in the dialog
Click Create Load button.
Now you will see a Excel like sheet in Forms Data Loader with all fields which you have entered in the form.
You can now populate this sheet by copying and pasting data from Excel or any CSV or delimited file.
Once you have populated the sheet click Load button
In Data Loader you can send keystrokes to the target application by entering the "\" as the starting letter. FDL recognizes a cell as keystroke if the cell contains as back slash "\" in the first position. For Example to send ALT and F keystroke enter \%F to send "ALT-FV" enter \%FV.
To specify that any combination of SHIFT, CTRL, and ALT should be held down while several other keys are pressed, enclose the code for those keys in parentheses. For example, to specify to hold down SHIFT while E and C are pressed, use "\+(EC)".
To specify to hold down SHIFT while E is pressed, followed by C without SHIFT, use "\+EC".
To specify repeating keys, use the form {key number}. You must put a space between key and number. for example, \{LEFT 42} means press the LEFT ARROW key 42 times; \{h 10} means press H 10 times
In addition to Keystrokes, Data Loader also comes with built in shortcuts for most common Oracle form functions. Below is the list of some of the shortcuts. It also lets you define your own shortcuts for commonly used keystrokes.
Source...