Projects / SYMPLiK EXZELLENZ

SYMPLiK EXZELLENZ

SYMPLiK EXZELLENZ is a program to manipulate table data in Oracle database by using a Microsoft Excel file (xls or xlsx format). Unlike Oracle WebADI, More4Apps, or other Excel-driven solutions, this program does not use Office VBA (macros) to process the data. It is a pure Java solution incorporated with Apache POI and the Oracle JDBC driver to download, upload, insert, update, and delete data from Oracle database tables. It is Linux-friendly for Open Office users as long as the spreadsheet is in Excel formats.

Tags
Licenses
Operating Systems
Implementation
Translations

Recent releases

  •  05 May 2010 16:16

    Release Notes: This release adds an Oracle EBS connection mode, an EBS RunAs user mode, delete OPERATION_MODE, the ability to create template and download data from database views, and a parameter SAVE_NEW_FILE so that a new file will be created after a process. It adds a popup menu to select a file instead of drag-n-drop and to set the SAVE_NEW_FILE parameter.

    •  10 Feb 2010 04:06

      Release Notes: Support for the Microsoft Excel 2007 format was added. The Excel Template version was changed to 1.3. POI version was changed to 3.6. Column width is automatically fit in the template and download operations. The active sheet is set in the template and download operations. The ROWID column is hidden in the download operation.

      •  18 Sep 2009 17:33

        Release Notes: This release fixes an error when the date value is empty in DOWNLOAD mode. It fixes an Excel template version/program version conflict bug. It fixes an extra ROWID column added in DOWNLOAD mode. Known limitation: a template cannot be generated if the table has more than 255 columns (e.g. the OE_ORDER_LINES_ALL table has 240 columns).

        •  25 Aug 2009 10:38

          Release Notes: The update operation mode was added. End users can make changes in the data rows downloaded from a database table and then update them back to the database.

          •  19 Aug 2009 16:34

            Release Notes: This release adds a TEMPLATE operation mode to generate an Excel template worksheet for a table. It adds a DOWNLOAD operation mode to download table data of user-selected columns from Oracle to Excel worksheets. It adds UPDATE operation mode: after data is downloaded to Excel worksheet, a selected row of data can be updated back to an Oracle database table. POI has been updated from 3.2 to 3.5 beta 6. The Oracle JDBC driver has been changed to Oracle DB 11.1.0.6.0.

            Screenshot

            Project Spotlight

            OpenStack4j

            A Fluent OpenStack client API for Java.

            Screenshot

            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.