DataLoad V4 - Classic & Professional
"If you have hundreds of records, then DataLoad Classic is a good way of loading the records that you need; if you have thousands of records then DataLoad Professional is the tool to use.
Good thing is that this tool is made by oracle and Flexibiulity of AX being windows platform is such that this tool works on it as well.
And it’s FREE
Implementing or supporting any application requires significant effort to configure and load master and transaction data, for example from legacy systems, an expensive and time-consuming activity.
DataLoad reduces the time and costs associated with data migration. Its easy-to-use interface means that it can be used by non-technical employees, giving end-users an active role in the implementation and support of any system.
With 8,000 downloads a month and customers in over 30 countries, DataLoad is the world's most popular data entry tool for end users, consultants and developers.
Why Use DataLoad?
· Non-technical users can easily configure and load data into any system
· Recommended by Oracle, DataLoad contains specific additional features to load large volumes of data in Oracle E-Business Suite
· DataLoad is sponsored by leading UK systems integrator Edenbrook, which has committed to support and improve the tool
· DataLoad is available in Classic and Professional editions, catering to all types of application implementation from the simple to the vastly complex
· DataLoad Classic is available to download free of charge and is not a time limited trial version
· DataLoad has a proven track record with over 10 years of production use and is still actively developed to meet today's needs
DataLoad Functionality
A summary of DataLoad functionality is provided below,
DataLoad provides a spreadsheet style interface and the data contained within that spreadsheet can be loaded into any system using a Macro load, or into Oracle Applications using Forms Playback. Either way, data or setup is loaded through the application's forms and that provides many advantages. Users have a choice between the free DataLoad Classic or more feature rich DataLoad Professional,
Macro Loads
All versions of DataLoad provide the Macro load functionality and this is the load technology of choice in DataLoad Classic, the freeware version.
The easiest way to load data into a form is using a keyboard and mouse and this is what DataLoad does with Macro loads. You configure the data, keystrokes and mouse clicks in DataLoad that you want loaded into your form(s). When you run the load DataLoad presses the keys and clicks the mouse as you specified. Any keys on your keyboard can be used by DataLoad, in any combination, and the left and right mouse buttons can also be used. And because DataLoad calls the same low-level Windows code that is called when you actually press a key or use your mouse, the application you are loading data into cannot tell the difference between data entered by you at the keyboard or DataLoad.
To build a DataLoad load write down what keys and mouse clicks you use to enter one record in your application. Now enter that into a DataLoad row and copy the instructions down into as many rows as the number of records you are going to load. Finally, paste your data into cells in DataLoad that correspond to the fields in your form. Your load is now built!
To load data as quickly as possible DataLoad uses Windows copy & paste to copy data into form fields. Where the actual keystrokes should be sent instead the data just needs to be preceded with a backslash, '\'. To send mouse clicks use the *ML or *MR commands to send left or right mouse click respectively. Please read the User Guide for more information about keystrokes, DataLoad commands and mouse clicks.
Controlling the Load
DataLoad can send data, key strokes and mouse clicks far faster than applications can handle them. To slow down DataLoad there is a comprehensive set of Delay options, using both the Delays form and the *SL (Sleep) command which cause DataLoad to wait at key points.
For the fastest, most reliable copy & paste loads use the Load Control functionality in DataLoad Professional. Load Control enables DataLoad to monitor a log file written by the application you are loading data into. Having configured DataLoad to use the log file your load will not run faster than the application is processing the data. No delays are required and DataLoad will run as fast as possible without overloading the target application. Another great benefit of Load Control is that if an error occurs in the application DataLoad will stop sending data. Therefore loads can be run unsupervised.
To download visit http://www.dataload.net
No comments:
Post a Comment