MySQL Forums
Forum List  »  Announcements

MySQL for Excel 1.3.2 GA has been released
Posted by: Jocelyn Ramilison
Date: September 23, 2014 02:54AM

Dear MySQL users,

The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.2. This is a GA release for 1.3.x. It can
be used for production environments.

MySQL for Excel is an application plug-in enabling data analysts to very
easily access and manipulate MySQL data within Microsoft Excel. It
enables you to directly work with a MySQL database from within Microsoft
Excel so you can easily do tasks such as:

 * Importing MySQL Data into Excel

 * Exporting Excel data directly into MySQL to a new or existing table

 * Editing MySQL data directly within Excel

As this is a GA version the MySQL for Excel product can be
downloaded at this link
http://dev.mysql.com/downloads/windows/excel/

Changes in MySQL for Excel 1.3.2 (2014-09-22, General Availability)

This section documents all changes and bug fixes applied to MySQL
for Excel since the release of 1.3.1. Several new features were
added the 1.3.x branch, for more information see What Is New In
MySQL for Excel 1.3
(http://dev.mysql.com/doc/mysql-for-excel/en/mysql-for-excel-what-is-new-1-3.html).

Known limitation:

Upgrading from versions MySQL for Excel 1.2.0 and lower is not
possible due to a bug fixed in MySQL for Excel 1.2.1. In that
scenario, the old version (MySQL for Excel 1.2.0 or lower) must be
uninstalled first. Upgrading from version 1.2.1 works correctly.

Functionality Added or Changed

  * Excel tables created from stored procedures can now be
    refreshed. (Bug #19129583, Bug #73151)

  * Several fields next to checkboxes were updated to
    automatically be focused and selected when the corresponding
    checkbox or radio button is checked.

  * A new global option called "Preview MySQL table data before an
    Edit Data session is opened" was added. When checked
    (default), the data of a selected MySQL table to be edited is
    shown in a preview dialog before the Edit Data session is
    opened. If the option is unchecked, no preview takes place and
    the Edit Data session is simply opened.
    A new context menu option called "Preview Data" was also
    added, and it is available when right-clicking a MySQL table
    or view that is listed in the DB Objects selection panel. The
    option opens the Preview Data dialog and shows the first 10
    (by default) rows of the selected table or view.
    In previous versions, the Import Data dialog was always
    displayed when an Edit Data was started, the Preview Data
    dialog replaces it to avoid confusion about the type of
    operation being performed.

  * MySQL for Excel now handles the managed Fabric connection type
    that was introduced in MySQL Workbench 6.2. New icons were
    introduced for SSH and managed Fabric connections. Connections
    that are not of the type native, native_socket, or
    native_sshtun, will not be listed in the connections listing
    under the Welcome Panel.

  * A single PivotTable can now be created for the entire Excel
    data model when importing multiple MySQL tables, which allows
    analyzing the related Excel tables within a single PivotTable.
    The Excel data model contains all Excel tables at the time the
    single PivotTable is created, so if previous imports were
    already performed, the data model may show more tables than
    the imported ones in the last multiple import operation. The
    option to create a PivotTable for each imported table is still
    present, but single PivotTable creation is selected by
    default.

  * The generated summary row added by the Add Summary Fields
    option when importing MySQL data is now bold and includes a
    thick border, as to differentiate from actual data.

  * When importing multiple database objects, the ability to add
    related tables to the directly related tables (i.e. indirectly
    related tables) was added by right-clicking a table in the
    related tables list (at the right side of the dialog) and
    choosing Add Related Tables from the context menu.

  * The Schema Selection panel now includes collation information
    for the listed schemas that can be shown by right-clicking the
    Schemas list and choosing Display Schema Collations from the
    context menu.

  * Changed the way stored procedure result sets are laid out in a
    Excel worksheet when all of them are imported horizontally or
    vertically, and when PivotTables are created for each result
    set. Instead of skipping one row or column, the necessary rows
    and columns are skipped so the created PivotTables for the
    result sets do not collide.

Bugs Fixed

  * Duplicate edit session connection information would be saved
    to the settings.config file, which generated a "Editing not
    possible" error message after using the "Work Offline" option.
    Closing an unsaved workbook now opens an Excel "Save As"
    dialog. (Bug #19347634)

  * The Append Excel Data to Table operation failed when the
    number of columns did not match, even when the data was
    manually mapped. (Bug #19346203, Bug #73453)

  * A pop-up warning message stated that some features could not
    be saved in a macro-free workbook would appear when closing a
    Workbook that was not saved.
    Internationalization formulas used by MySQL for Excel that are
    stored in Workbook Names are now removed before the Workbook
    is saved, and these formulas are added again after the save
    operation. (Bug #19358961, Bug #73467)

  * Two labels were changed: the context menu option "Import
    Selected and Related DB Objects" changed to "Import Selected
    and Related Tables", and "Selected related Tables and Views"
    changed to "Selected related Tables". This is because these
    options only apply to tables. (Bug #19296989, Bug #73398)

  * In the Import Multiple dialog, Excel relationships were
    created on import when the "Create Excel relationships for
    imported tables" was unchecked. (Bug #19299550, Bug #73402)

  * Entries for invalid connections from import sessions were
    saved in the %APPDATA%\Oracle\MySQL for Excel\settings.config
    file even when the workbook was not saved. (Bug #19242130, Bug
    #73319)

  * The table schema initialization procedure was fixed to only
    import the selected columns into Excel, instead of always
    importing all of them. (Bug #19181877, Bug #73247)

  * Sometimes MySQL styles were missing from the data list. (Bug
    #19189185, Bug #73263)

  * The Append Data action incorrectly became unavailable when
    changing database object nodes.
    A workaround was to reselect the Excel data to re-enable
    Append Data. (Bug #19190638, Bug #73267)

  * On Windows 7 (x64) with Excel 2007, MySQL for Excel did not
    save connection information for edit sessions or data imports.
    (Bug #19145707, Bug #73182)

  * Excel relationships were not created for the relationships
    among selected database objects when a multiple import was
    performed. Only relationships among database objects in the
    original selection were successfully created, while those from
    the original selection were not. (Bug #19153946, Bug #73191)

  * Either checking the "Create Pivot Table..." box and/or
    selecting vertical or horizontal import options with stored
    procedures failed with the following error: "An external data
    table can be resized only to include or exclude rows of data.
    The column boundaries cannot be changed." (Bug #19129609, Bug
    #73152)

  * Reconnection information stored in the %APPDATA%\Oracle\MySQL
    for Excel\settings.config configuration file to reconnect
    Excel tables with their corresponding MySQL database objects
    counterparts was being written to disk even when the workbook
    save operation was cancelled. (Bug #19153978, Bug #73192)

  * When importing multiple database objects, related tables and
    views were only detected when the originally selected database
    object (shown at the left side of the dialog) had a MySQL
    Foreign Key explicitly declared, but they were not detected if
    the selected database object was actually the foreign object.
    In other words, only a 1-directional relationship was
    detected. (Bug #19154006, Bug #73193)

  * The Import MySQL Data feature failed to import stored
    procedures. (Bug #19129583, Bug #73151)

  * The "Create an Excel table for the imported MySQL table data"
    advanced option in the Import Data dialog was renamed to
    "Create an Excel table for the imported MySQL data", because
    it also imports non-tables such as views and procedures. (Bug
    #18979352, Bug #73003)

  * The "Add Summary Fields" checkbox in the Import Table dialog
    would be enabled even though the required "Create an Excel
    table for the imported MySQL table data" option was disabled.
    (Bug #18979388, Bug #73004)

  * When creating Excel tables for imported data, MySQL for Excel
    created two Excel Workbook connections instead of one.

  * All "Edit Session" references were renamed to "Edit
    Connection", and all "Import Session" references were renamed
    to "Import Connection".

  * Text for the Restore Saved Edit Sessions and Reconnect Import
    Sessions dialogs was updated to be more descriptive.


Quick links:
You can access the MySQL for Excel documentation at
http://dev.mysql.com/doc/en/mysql-for-excel.html.
You can find our team's blog at http://blogs.oracle.com/MySQLOnWindows.
You can also post questions on our MySQL for Excel forum found at
http://forums.mysql.com/list.php?172.
You can follow our videos on our YouTube channel found at
http://www.youtube.com/user/MySQLChannel.


Enjoy and thanks for the support!

The MySQL on Windows team at Oracle.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL for Excel 1.3.2 GA has been released
2906
September 23, 2014 02:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.