31:st of August 2014 new version of Sui available (0.70D)

For more details about downloading the new version see the download page.. You can also download the executable parts of Sui from these two links: Sui.jar and SuiExtras.jar

 

Changes

Query tree

The query tree is added in version 0.70. To enable the query tree you must check Show File tree in the preferences (File->Sui Preferences) and restart Sui.

sui-prefs

The query tree lets you browse the files available on your computer and execute queries in Sui directly from the file tree. You can add favorite folders (shown on top of the file tree). From the file tree you can also launch any file (using the program associated to the file-type). If you, for example, run a query and save the result-set in a CSV-file you can launch the CSV file from the file-tree. The picture below shows a sample view of the query tree (with folders export and queries added as Favorite Folders).

suitree

Excel Interface Changes

  • Changed Excel Export from main window and query report to support XLSX format
  • Import Excel now supports both XLS and XLSX format
  • Added default value for missing Value in Excel
  • Export of XLSX Format uses less memory
  • Direct execution to Excel (not yet export from result set) creates native and formatted excel data types

Sui Packaging changes

  • Starting from 0.70 Sui requires java 1.7 (previous version required 1.5).
  • Sui is now packaged in two separate jar files. One jar for Sui and one jar for additional components used by Sui.
  • Derby database is included in the additional JAR File.
  • The database driver for Derby is automatically loaded at startup

Canned Queries

In Sui 0.70 a new function to save queries (canned Queries) and to list saved queries is added. The queries are saved in a table. This function allows sharing of SQL queries within a group or a department. The canned queries are saved in a table with a specified layout. A sample create statement can be supplied. The function is invoked from the query window (query context menu).

Sui and Excel (XLS / XLSX files)

  • Changed Excel Export from main window and query report to support XLSX format
  • Import Excel now supports both XLS and XLSX format
  • Added default value for missing Value in Excel
  • Export of XLSX Format uses less memory
  • Direct execution to Excel (not yet export from result set) now creates native and formatted excel data types

Miscellaneous changes

  • Function to send a query as a mail added
  • Fixed some memory issues and made the thread management smarter and less resource consuming
  • Close all windows now closes all windows except Sui Main Windows
  • Added a function to save the .pro files every 2:nd minute (120 Seconds)
  • Added a function to backup .pro files at close down and every 30 Minutes (15).
  • Added a function to delete backups (of .pro files) older than 2 days.
  • Fixed the length for Intelligent field length if column name > value
  • Save query and Open query remebers last folder within a session
  • Class path selection remembers last selected folder within a session
  • Max number of sheets changed to 90

 

Leave a Reply