Monthly Archives: September 2008

Improved the SQL function: Added a Comment cell(1,1) on SQL with connect, timestamp and the executed sql statement Added call to connect form when connect info is incomplete (like missing password) Changed the behavior when maxlines reached: Yes = Cont. to end, … Continue reading →

No more need for entering registration key into every load sheet. Excel For Oracle Applications

The “Excel for Oracle Applications” tool is now able to run on installations with the regional language setting different from “English (United States)” / “en-US”. Also install vstor.exe before installing . Excel For Oracle Applications

Added “date format oracle” – for handling oracle date format. “date format” is now only used for excel date format. Added trace functionality. Two new system values: “Trace level” and “Trace dir”. Trace level = 0 – no trace. Trace … Continue reading →

Added system variable “connect”. Will enable dataload without database connect. When connect = “Y”, database connection will be establised and dataload will be executed against database. When connect = “N”, Dataload will generate spoolfile to be executed elsewhere. Excel For … Continue reading →

Added function call in default value: Enter $<function_name> – the dollar sign will add a mapping line assigning the function to the value. Needed functionality to handle the reset of record structures for the  OE_ORDER_PUB.PROCESS_ORDER API.

A load status window has been added. The load status window will show progress information about the load, including a progress bar and a estimated time to complete. When dataload is invoked, the number of rows to process, in all … Continue reading →

In order to handle multiple dataloads in one workbook, the plsql sheet has been rename to “dataload” and one new column and two rows has been added.  The “plsql” sheet is renamed to “dataload”. The “dataload” sheet is added a new … Continue reading →