Forms Data Loader

Forms Data Loader facilitates an interface for importing data from Microsoft Excel or CSV files into Oracle Apps 11i/R12 via frontend forms. It's designed for loading text and legacy data into Oracle EBS tools.

The utility is accompanied by HTML Forms Data Loader, a separate tool that can load data into Web Forms and Oracle Applications Self Service Forms.

Wrapped in a clean and familiar-looking GUI, Forms Data Loader has a sample file that can be imported into the main window to demonstrate how it works. You can populate the database with any number of rows and columns, insert time delays or blank cells, or paste skipping key columns.

New loads can also be created by recording macros. This can be done by selecting a target application to capture activity from. Mouse clicks can be either included or excluded from the macros.

In addition to CSV, information can be imported from tab delimited (TAB) and plain text (TXT) files. All you have to do is set the name of the delimited file you want to load data from and specify the separator (comma, tab, semicolon, or other). You can also mention if the first row has column names as well as pick the text qualifier (single or double quotes, or none).

The selected columns can be sorted in ascending or descending order. You can also wrap text, enable autofit, merge and unmerge cells, lock the selected ones, edit headings, get the screen coordinates for mouse clicks, and get macro templates. The modified database can be saved as CSV.

As far as general options are concerned, it's possible to customize colors for the data, keystroke and shortcut cell, set the grid's number of rows and columns, establish the default time delay (in milliseconds), and so on.

The software application worked smoothly in our tests. Taking into account its straightforward interface and options Forms Data Loader should come in handy to most users interested in a simple solution for loading data from Excel or CSV files to Oracle Apps 11i/R12.