Category Archives: Revision History

All reported bugs is closed. The sql extract is now many times faster…

When using SQL, Oracle date will be conversted to Excel date. When using Dataload, Excel date will be converted to Oracle date. When system date format is empty, they will be defaultet.

The 3.6.1 version has some new feature: utility to set the apps initialize progress form also in the sql tool maxline functionality updated Spoolname accepts: $filename, $timestamp, $seqnr Check for duplicate header names

Multiline load error count and error message corrected. Moved first save workbook to after cancel/continue descision. The log file will generate in csv file format. Excel For Oracle Applications

Dataload: Code has been optimized – the performance of the generate mapping section is now performing around 10 times faster. Added comment on heading line: mapping info. The ‘OK’ button on the status form is now defaulted – so you … Continue reading →

If an extracted column value was null the previous column value was replicated. Excel For Oracle Applications

Status form’s text window is now readonly. Status form showing $row_commit and $final_commit. Excel For Oracle Applications

Improved the SQL function: Added sheet versions: Prefix sheetname with “$” – and sheetname will be build by counting the existing sheets with same name. Added delete sheet function: Enter “d” in execute – and data sheet(s) will be deleted. … Continue reading →

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