xls4oracle – new release with new feature

16 January 2010
By

Latest release: 3.6.7.218

  • Download: xls4oracle – posted 07-01-2010
  • Download: User Manual – posted 12-01-2010

     

    Release 367218
    11-jan-2010 / Thomas Lundqvist

    – fixed license key bug – new license key needed
    – more rows & columns in excel 2007
    – dataload form added
    – encrypted passwords
    – easy entering of license key on the about form
    – when non apps connection (preprod/prod) and script load – need for ability to generate apps_initialize…
    – $filename – must handle ext. diff from len=3
    – must handle trace > 4 (dies when trace=99)
    – optimized the sql part
    – trace enabled on sql
    – progress info in the sql functions

    =============================================================

    – fixed license key bug – new license key needed

    The license key bug was making it impossible for licenced users to register. New encryption developed, that requires a new license key. All regisrered users will receive new license key, when this release is fully tested. Pls. continue to use the trial license key found on xxls4oracle.com.

    – more rows & columns in excel 2007

    16000 columns and 1 million rows in excel 2007

    – dataload form added

    userfriendly database connection, application logon and responsibility selection.
    New dataload type: online or script load. trace and spoolfilenames. No need to enter values on the system tab.
    Radio buttons to control the commit levels.
    Remember password: if database password is to be remembered, the dataload sheet will be protected, preventing any change in the plqsl program.

    – encrypted passwords

    The database password and appl passwords is stored encrypted.

    – easy entering of license key on the about form

    The license key can now be entered on the about form.

    – when non apps connection (preprod/prod) and script load – need for ability to generate apps_initialize…

    is now checking for apps connection. when connection username is not APPS –  only script load is allowed. this enables resp. selection when loading to prod env.

    – $filename – must handle ext. diff from len=3

    $filename is now without extension and handles the new 2007 extensions: xlsb, xlsm…

    – must handle trace > 4 (dies when trace=99)

    fixed…

    – optimized the sql part

    The count number of records function is costing – so its gone. For queries with many records, the count is using aprox. the same time for getting the count as doing the fetch. The drawback is that the progress bar also must go. The only feedback is the count of fetched records, and it is now set to update for every 100 records.

    – trace enabled on sql

    Will use system sheets “trace” value. This will enable improved support for the sql function.

Leave a Reply

Tags