MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Hery Ramilison Date:May 24 2017 5:04pm
Subject:MySQL for Excel 1.3.7 has been released
View as plain text  
Dear MySQL users,

The MySQL Windows Experience Team is proud to announce the
release of MySQL for Excel version 1.3.7. This is a maintenance
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


MySQL for Excel is installed using the MySQL Installer for Windows.

The MySQL Installer comes in 2 versions

- Full which includes a complete set of MySQL products with
   their binaries included in the download.

- Web (network install) which will just pull the MySQL for
   Excel over the web and install it when run.

You can download MySQL Installer from our official Downloads page at
http://dev.mysql.com/downloads/installer/

The MySQL for Excel product can also be downloaded by using the product
standalone installer found at this link
http://dev.mysql.com/downloads/windows/excel/

Changes in MySQL for Excel 1.3.7 (2017-05-24)


    Functionality Added or Changed

      * The way MySQL for Excel shares data-editing sessions
        among users and between computers was improved. (Bug
        #25509085, Bug #73314)

      * The Append Excel Data to Table operation was updated with
        new advanced options to manage the behavior of rows
        containing unique key values that are duplicates of those
        in the database. (Bug #25479653, Bug #83801)

      * Added a new global option that specifies how to format
        spatial data as text: Well-Known Text, Keyhole Markup
        Language, Geography Markup Language, or GeoJSON. (Bug
        #22081263)

      * Enhanced the logic that migrates stored MySQL connections
        to the MySQL Workbench connections.xml file. In previous
        versions, the migration was offered and if not done at
        that moment, the dialog to migrate was shown every time
        MySQL for Excel was launched. There was no way to choose
        to continue storing MySQL connections in the MySQL for
        Excel configuration folder, instead of merging them with
        MySQL Workbench.
        Now, the Connections Migration dialog offers a way to
        postpone the migration by one hour, one day, one week,
        one month, or indefinitely. If the migration is
        postponed, the dialog is shown again after that time
        elapses. If the migration is postponed indefinitely, then
        an option is added to the Options dialog that permits the
        migration of connections to be done manually, as long as
        MySQL Workbench is installed.

      * Support for MySQL Fabric was removed.

    Bugs Fixed

      * SSL connections when created with MySQL Workbench should
        be inactive within MySQL for Excel, which does not
        support SSL connections. (Bug #25962564)

      * Selecting a schema containing at least one stored
        procedure for a MySQL 8.0 or 8.1 connection emitted an
        error. (Bug #25962347)

      * Empty string values within Excel column data that were
        used in an export or append-data operation caused the
        generated SQL queries to have no value, instead of an
        empty value corresponding to the data type of the target
        column (for example: 0 for Integer; false for Bool if the
        column does not allow NULL values, or NULL otherwise).
        (Bug #25509312, Bug #84851)

      * MySQL data could not be refreshed or edited directly in
        an Excel worksheet by different users or from different
        computers, which reduced the ability to share
        data-editing sessions among users or between computers.
        This fix alters the way connection information is stored
        by migrating the connection details for related import
        and edit-data operations from the user settings file to
        the XML parts of a workbook when the workbook is opened,
        and if the workbook supports XML parts and the connection
        information related to that workbook is found in the user
        settings file. (Bug #25509085, Bug #73314)

      * User-selected data types that replaced the detected
        values of a column were lost when the First Row Contains
        Column Names check box was selected or deselected in
        preparation for an export-data operation. This fix
        retains the selected value when the data type is set
        manually to override the automatically detected type and
        the check box is selected or deselected. It further adds
        a new action to reset the column back to automatic
        detection. (Bug #25492772, Bug #84802)

      * A portion of the preview area that should be displayed
        during import, export, and append data operations was
        concealed by other fields. (Bug #25325457)

      * Attempting to refresh MySQL data in an Excel worksheet
        while the MySQL for Excel task pane was closed generated
        an error. (Bug #25301136)

      * Edit-data operations in which the SQL query used
        optimistic updates, and the data contained empty strings,
        produced errors during the commit to MySQL. Enhanced
        mapping of character sets and clearer error-message text
        were added to identify the use of client character sets
        that are unsupported in MySQL. (Bug #25236221, Bug
        #76287)

      * A mismatch between the current schema and the current
        connection caused the refresh action to fail when a
        worksheet with imported data was created as an Excel
        table, saved, closed, and then reopened. (Bug #25233309)

      * Inactive connections and unsaved passwords caused the
        refresh action to generate errors for worksheets with
        imported MySQL data in Excel tables. (Bug #25227226)

      * Excel worksheets that had currency values with comma
        separators produced errors when the data was exported to
        a MySQL table. (Bug #25214984, Bug #84049)

      * MySQL connection passwords were not saved to the secure
        password vault and produced a password request every time
        an existing connection was opened. (Bug #25108196)

      * Excel cells containing empty strings, which are not
        actually blank, generated errors with export, append, or
        edit data operations. With this fix, an empty string is
        now equivalent to a blank cell. (Bug #24431935, Bug
        #82497)

      * Although the Refresh All action in the Data ribbon
        refreshed all MySQL connections, it did not refresh the
        other connections associated with a workbook when the
        MySQL for Excel add-in was enabled. (Bug #23605635, Bug
        #81901)

      * Clearing numeric parameter values within a stored
        procedure, or setting any of the initial values to NULL,
        during an Import MySQL Data operation emitted an error.
        (Bug #23281495, Bug #81417)

      * Type TinyInt was mapped as type Bool when data was
        imported to Excel from MySQL. (Bug #23022665, Bug #80880)

      * MySQL columns of type DATE and DATETIME produced errors
        during import-data operations. This fix improves the way
        MySQL for Excel handles these types for all operations:
        import data, export data, append data, and edit data.
        (Bug #22627266, Bug #80139)

      * Excel data of type Date could not be exported to a MySQL
        table. (Bug #22585674, Bug #80079)

      * Tables and views imported to Excel without the Include
        Column Names as Headers option first being selected
        omitted the expected default column names (Column1,
        Column2, and so on). (Bug #22373140)

      * Creating a new schema with the binary - binary collation
        produced an error. (Bug #22371690)

      * Saved edit-data sessions could not be restored after a
        workbook was closed and then reopened. (Bug #22138958)

      * Connection sharing between MySQL for Excel and MySQL
        Workbench resulted in some incorrect connection
        information being passed to the MySQL Server Connection
        dialog. (Bug #22079779)

      * The default schema of the current MySQL connection
        changed unexpectedly when a table in a different schema
        was edited. (Bug #22074426)

      * With a cursor positioned at the bottom of a worksheet and
        with the Add Summary Fields check box selected, the
        import-data operation failed despite having enough space
        to fill the cells. (Bug #19652840)

Quick links:
MySQL for Excel documentation: 
http://dev.mysql.com/doc/en/mysql-for-excel.html.
Inside MySQL blog (NEW blog home): http://insidemysql.com/
MySQL on Windows blog (OLD blog home): 
http://blogs.oracle.com/MySQLOnWindows.
MySQL for Excel forum: http://forums.mysql.com/list.php?172.
MySQL YouTube channel: http://www.youtube.com/user/MySQLChannel.

Enjoy and thanks for the support!
The MySQL on Windows team at Oracle.
Thread
MySQL for Excel 1.3.7 has been releasedHery Ramilison24 May