Category Archives: Revision History
Fixed a date issue. When moving from excel datevalues to oracle date values, excel is using 01-jan-1900 and oracle somehing like 4096 bc, and the conversion needed and update. This release has been tested on XP / office 2010 and … Continue reading
Fixed issue with error 13 when using some dateformat settings.
Added new feature to refresh a sql sheet. The refresh will use the comment in the A1 cell to generate a new extract. When you press the xls4Oracle/sql button and the cursor is in a cell with an xls4Oracle comment … Continue reading
This release has passed all test senarios. Dataload: Date handling has been streamlined. The dateformat is not nessesary anymore. A new algoritm based on julian date is being used. All excel dates is based on the 01-jan-1900 date and all oracle … Continue reading
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