SaveToDB 9 Change History

SaveToDB 9 Change History

Version 9.12, July 5, 2022

Changes in End-User License Agreement:

SaveToDB includes an updated End-User License Agreement.

The most important change:

"Consent to Be Included in the Client List: By purchasing the software on behalf of your company, you implicitly consent to the listing of your company name as our customer. You can revoke this consent at any time by submitting a request."

SaveToDB Personal edition is available only under the active upgrade warranty. New purchases of SaveToDB Personal are not available.

Breaking changes:

  • The add-in adds null values to parameter value lists prepared by stored procedures or SQL queries.
    This feature allows you not to use the rows like SELECT NULL AS id, NULL AS name UNION ALL in your SQL code to get such values.
    Also, this allows getting lists of parameter and cell values using the same procedures.
    After an update, you may need to add the _NotNull value to the TARGET_WORKSHEET field for ParameterValues handlers.
    See the Developer Guide for details.
  • We changed formats of connection strings and authorization data for connecting to web data and text files.
    This change relates to new opportunities for working with the REST API and authorization using OAuth1 and OAuth2 for any provider.
    Also, the new version allows using the connection and authorization settings from databases.
    After updating the add-in, you should update the data and configuration for such requests.
    New connection and authorization data do not work in versions before 7.31, 8.26, and 9.12.
    Therefore, after testing the update, we recommend updating to the newest version for all users.
    We put a lot of effort into testing all the features. SaveToDB 9.12 is the most tested version.

New features:

  • The add-in supports language codes up to 10 characters.
    For example, you can use zh-cn, zh-hans, and zh-hans-cn. zh-hans and zh-hant are preferrable in Chinese.
  • The add-in includes the AutoUpdate tool to check and install SaveToDB updates.
    Use Help, Check Updates to launch the wizard manually.
    The check request does not contain personal data. However, we can identify the license owner in internal systems.
    We use this information to count the current licenses more accurately and can provide this information to the owner upon request.
    This feature is useful for companies with a large number of users and frequent replacement of computers.
    You can turn off the checking updates in the utility dialog box if you do not agree with this statement.
  • The Application Installer wizard includes SaveToDB Framework 10.
    SaveToDB Framework 10 has new views to select configuration settings checking actual user permissions on schema objects.
    SaveToDB Framework 10 has a new view, xls.users, to allow business users to manage roles, users, and permissions from the Excel context menu.
    SaveToDB 9 does not support some new handler types introduced in SaveToDB 10.
  • The add-in allows naming worksheets with translated names of inserted objects.
    Use _UseTranslatedName in the TARGET_WORKSHEET columns of the handler configurations and UseTranslatedName in the DEFINITION columns of the workbook configurations.
  • The Online Samples menu includes new samples for MySQL, PostgreSQL, SQLite, and OData.

Improvements:

  • The add-in includes completely new documentation.
    It includes a separate Developer Guide, common for the product family, including DBEdit, DBGate, and ODataDB.
    Also, the documentation is common for SaveToDB versions 7-10.
  • The reload performance is significantly improved.
    The add-in keeps connections opened for the entire refresh cycle, caches loaded data and does not use the transaction mode.
  • The performance of saving changes to databases using JSON parameters is significantly improved.
    The add-in does not add columns with empty values.
  • The add-in does not use quotes in CREATE|ALTER|DROP ROLE|USER and GRANT|REVOKE|DENY command variables.
    This feature allows using SQL code handlers to manage roles, users, and permissions from the Excel context menu.
    SaveToDB Framework 10 has the xls.users view that utilizes this feature.
  • The SQL code parser is improved.
  • The Data Merge Wizard shows tables that have common fields only.
  • Dialog boxes have new, improved Office-style icons.
  • The workbook information dialog box has the log tab that shows critical errors.
  • The HTML task pane is improved. The task pane supports the markdown format.
  • The add-in launches the dialog box to change the login and password on opening a workbook with the user credentials that cannot be decrypted.
    Developers can force this feature by setting the AskPass placeholder in the password field of the connection strings.
  • The add-in quotes numbers with more than 15 digits loaded by .NET providers, including internal file and web data source providers.
  • The add-in shows file names and URL file names in the ribbon QueryList.
  • The URL ContextMenu shows expanded values.
  • The add-in sets the Referrer header to finance-services.msn.com automatically when required.
  • The add-in does not add TOP/LIMIT conditions to queries of validation list values.
  • The add-in allows empty names for SQL code handlers.
  • The add-in does not load Snowflake metadata for procedures and functions if the metadata was not loaded for the first time.
  • The add-in calls procedures with JSON parameters in batches limiting single commands to 10MB.
    You can change the limit in the Windows Registry:
    [HKEY_CURRENT_USER\SOFTWARE\Gartle\SaveToDB\9.0]
    "JsonUpdatePackageMaxLength"=dword:00000000

Bug fixes:

  • The add-in does not update the CurrentDirectory value on saving a workbook to a new folder.
  • The add-in does not update the translation of dynamic validation lists on Reload Data and Configuration.
  • The add-in does not read values from SQLite with an empty SQLite version in a connection string.
  • The add-in detects CSV with HTML values as HTML.
  • The add-in uses a comma as a list separator in validation lists instead of a semicolon.
  • The add-in loses table formats loaded from views.
  • The add-in does not create dynamic validation list formulas when a table starts in row 1.
  • The add-in executes ROLLBACK when reading the Snowflake metadata.