|Home||Using DataLoad||Macro Loads||Browser Control||Forms Playback||Scripting||Problems|
DataLoad has been developed for over 10 years and today it is the only integrated solution for non-technical users to enter data in to ERP/CRM systems such as Oracle E-Business Suite. Within a single application it enables users to load data via Self Service forms, core/professional forms and directly in to a database.
DataLoad's origins were far more humble. When Oracle E-Business Suite (then known as Oracle Applications) was character based and ran within a Unix Telnet session, users could paste multiple values from Excel in to Oracle's forms. This worked because the pasted data's columns was separated by Tab characters and the rows by Return characters and hence the data was correctly entered in to tabular forms. However, this approach no longer worked when Oracle re-wrote the applications with GUI forms, first with the "Smart Client" forms and later NCA. The simple copy & paste approach was replaced with an Excel macro that entered the data into Oracle forms. Credit for that work must go to Martin Birch, Jeff Glanville and Luther Armstrong who authored and developed those initial macros. Further functionality was added to this macro and another key watershed came when the macro was rewritten in August 1988 to work Oracle's then new Network Computing Architecture (NCA) using the Java forms client.
However, the real breakthrough came when the Excel macro approach was dropped and DataLoad was re-written as a standalone Windows program. This delivered major benefits over the macro approach and the software's functionality was significantly extended in that release. Development since then has been solely on the standalone version because this allows us to take advantage of the improved performance and functionality available in a standalone Windows program. That has subsequently enabled DataLoad to become the integrated multi-technology software that it is today.