Version History of SaveToDB

Version History of SaveToDB

Version 7.7, May 31, 2017

Licensing Changes

  • Removed limit of loading multiple webpages in SaveToDB Express.
  • Removed limit of updatable cursor fields in SaveToDB Express.

New Features:

  • New parameters of XML and JSON parsers:
    CollapsedNodes, SkippedNodes, IgnoredTags, NoSourceHeaders, AsIs, and RowValues

Improvements:

  • Updated set of suggested URLs for loading stock quotes, historical and intraday stock prices, option chains and futures from Yahoo Finance, Google Finance, and MSN Money.
  • Special processing of datetime values of historical prices from MSM Money.
  • Special processing of datetime values of option chains from Yahoo Finance.
  • HTML parser supports multiple tables in the /RootPath option.
  • Possibility to activate the add-in using the activation files in virtual environment.
  • Removed option 'Single Line SQL for SQL Server.' The add-in always generates standard SQL commands.
  • Suppressed error messages when DisplayAlerts = False.
  • Improved documentation.
  • Improved error diagnostics.

Bug Fixes:

  • Missed URLs in the Query Parameters dialog box title.

Version 7.6.2, May 15, 2017

Bug Fixes:

  • Wrong calls of event change handlers on changing headers and deleting rows over the tables (version 7.6 only).

Version 7.6, May 11, 2017

Improvements:

  • Support of ODBC Driver 13 for SQL Server
  • Improved documentation
  • Improved error diagnostics

Bug Fixes:

  • Installer issues with updating previous versions.
  • Lost of ribbon values of context parameters from the Edit Parameters form.
  • Missing calls of cell change event handlers on deleting the last rows.

Version 7.5, May 5, 2017

New Features:

  • Spanish translation

Improvements:

  • Redesigned msi installer.
  • New context parameters of cell change event handlers: @ChangedCellAction and @changed_cell_action.
    The parameters get values: CellChange, RowInsert, and RowDelete.

Bug Fixes:

  • Wrong detection of user-defined types in Microsoft SQL Server.
  • Publish wizard issues for tables without connections.
  • Web connection issues.
  • Incorrect behavior of setting the IsRibbonField property from VBA.
  • Missing calls of cell change event handlers on adding and deleting rows.

Version 7.4, April 5, 2017

Improvements:

  • Improved parsing JSON data.
    The parser supports * as a property name in the rootPath parameters.
    For example, try to load futures data from the Yahoo Finance website using the URL:
    https://query1.finance.yahoo.com/v10/finance/quoteSummary/CK18.CBT?modules=futuresChain;rootpath=quoteSummary.result.futuresChain.futuresChainDetails.*
  • HTML parser converts string values with % to numbers and "n.a." values to empty values.

Bug Fixes:

  • Lost of authorization data of HTTP requests.
  • Lost of rootPath parameter values of HTTP requests.

Version 7.3.2, March 31, 2017

Bug Fixes:

  • Updating non-string ribbon parameters with NULL on changes of parameter named cells.

Version 7.3.1, March 28, 2017

Bug Fixes:

  • Lost of the SaveToDB tab in new installations.
  • Lost of Encrypt and TrustServerSertificate options in the SQL Server .NET provider.

Version 7.3, March 27, 2017

New Features:

  • The add-in supports multiple values in ribbon parameters for tables and views.
    To select multiple values, click on the Query Parameters group button and click on the "..." button to launch a new editor of multiple values.
    Multiple values are translated to the WHERE <field> IN (<value>, ..., <value>) clause.
  • The add-in supports multiple values for string parameters of stored procedures.
    The add-in passed multiples values as (<value>, ..., <value>).
    For example, a select stored procedure has a currency string parameter and a view that populates the parameter values like (1, 'USD'), (2, 'EUR'), (3, 'GBP').
    If a user selects USD only, the add-in calls the procedure with '1'. If the user selects [USD,EUR], the add-in calls the procedure with the '(1,2)' value.
    Be careful with SQL injection using this technique. The best way is to accept integer and date multiple values only, and check the input values like this:
    IF LEFT(@param, 1) = '(' AND RIGHT(@param, 1) = ')' SET @param = SUBSTRING(@param, 2, LEN(@param) - 2)
    IF @param IS NOT NULL AND @param LIKE '%[^-0-9.,'' ]%' SET @param = NULL

Improvements:

  • Improved error diagnostics.

Bug Fixes:

  • Lost of add-in metadata on deleting multiple worksheets with VBA at once.
  • Showing the SaveToDB Enterprise edition as SaveToDB Express in the About Product dialog box.

Version 7.2, March 20, 2017

The trial version requires registration. The trial period remains the same, 30 days.

New Features:

  • The SQL Server Management application to manage logins, users, roles, and permissions in SQL Server and SQL Azure databases.
    You may launch the application from the query list in the Data Connection Wizard.
    The application can be used by database administrators and business users.
  •  Developer Guide 7.2 in the Workbook Templates and Examples menu.
    The guide shows new features for VBA developers.
  • Configuration tables may contain pseudo-SQL codes like
    [+|-][@]<Field>[,...]]
    All fields are used in SELECT.
    Fields with @ are used in WHERE.
    Fields with + or - are used in ORDER BY.
    For example, the code: +Date,+Sum,@Company,Item
    generates the SQL code:
    SELECT Data, Sum, Company, Item FROM <table> WHERE Company = @Company ORDER BY Date, Sum
    This feature simplifies creating drill-down queries for business users.
  • New column event handlers: ConvertFormulas and DoNotConvertFormulas
    For columns with ConvertFormulas, the add-in tries to convert text formulas from a database to Excel formulas.
    This allows having values and configured formulas in the same column.
    For columns with DoNotConvertFormulas, the add-in disables auto-detecting formulas and do not convert them.
  • New methods for using with VBA. Here are groups of new methods:
    - ribbon control;
    - executing queries to databases, web data sources and text files;
    - working with connection strings;
    - protecting usernames and passwords;
    - working with cursors and form fields;
    - working with table views;
    - add-in options.
  • You may choose stored procedure parameters to place to the ribbon.
    It is useful for procedures with more than six parameters.
  • You may specify WHERE field values without placing the fields to the ribbon.
  • The add-in may automatically remove the named cells with error ranges.
    You may disable this option if use macros that fix such errors.

Improvements:

  • Values of the fields that have Formula or FormulaValue handlers are used in the generated SQL even the fields are not selected.
    The best case is using the =UserName() and =NOW() formulas to update the LastUserName and LastModified columns.
    Now such fields have the correct values even the fields are not selected in Excel.
  • Event handlers may use new context parameters, CellDateValue and CellNumberValue.
    The parameters contain datetime and number values if possible or NULL.
  • Form fields can be created on any worksheet. The form fields on other sheets must have a workbook scope.
    Such fields update the underlying table. So, you may use the fields to create edit forms easily.
  • Improved detection of formula columns.
    For such columns, the add-in converts text formulas from a database to Excel formulas.
    You may change the automatic detection using the ConvertFormulas and DoNotConvertFormulas handlers.
  • Improved performance of scrolling on tables with form fields and cursors.
  • Improved Pivot Data Connection Wizard.
    The wizard allows creating multiple pivot tables on a sheet connected to a single data source.
  • Improved messages of the Register Product wizard.

Bug Fixes:

  • SQL execution errors of Change handlers that contain DECLARE statements.
  • Loss of parameter values in the Parameter Editor form.
  • Generating UPDATE commands in the merge mode for a table without fields for UPDATE.
  • Loss of sort orders after refreshing tables with ValidationList handlers.
  • Loss of ribbon fields after connection string change using VBA.
  • Loss of date validations that starts at 1/1/1900.
  • Absent English in the Data Language list if the English keyboard layout is not installed on Windows.
  • Detecting tables with INSTEAD OF triggers like as TRIGGERED VIEWs.
  • Detecting CSV data with one column as text.
  • Detecting JSON data with two-dimensional arrays as text.

Version 7.1.1, February 9, 2017

Bug Fixes:

  • Fixed issues with Data Merge Wizard.
  • Fixed issues with cursor fields.

Version 7.1, February 3, 2017

New Features:

  • Ribbon parameters may get values from Excel ranges.
    Set the RANGE type in the SELECT_TYPE field and a range name or address in the SELECT_CODE field.
  • Ribbon parameters may get values specified in the SELECT_CODE field directly.
    Set the VALUES type in the SELECT_TYPE field.
  • You may specify field names used to select ribbon parameter values from tables and views in the SELECT_CODE column.
    This feature allows getting values without SQL code use.
  • ValidationList and SelectionList may get values from Excel ranges.
    Set the RANGE type in the HANDLER_TYPE field and a range name or address in the HANDLER_CODE field.
  • ValidationList and SelectionList may get values specified in the HANDLER_CODE field directly.
    Set the VALUES type in the HANDLER_TYPE field.
  • You may specify field names used to select ValidationList and SelectionList values from tables and views in the HANDLER_CODE column.
    This feature allows getting values without SQL code use.
  • The Wizards, Workbook Templates and Examples menu and SaveToDB SDK include Developer Guide 7.1.
    The new guide shows how to create Excel application using new SaveToDB 7.1 features, without SQL or VBA use. Try it.

Improvements:

  • The add-in uses ribbon parameter and named cell values for new row cells protected by DoNotChange handlers.
    Such cells had NULL values before.
  • The Copy and Insert Rows button copies values protected by DoNotChange handlers.
  • You may disable DoNotChange handlers in macros. Set Application.DisplayAlerts = True.

Bug Fixes:

  • Fixed inserting rows instead of updating in SQL Server in some cases. The bug was added in SaveToDB 7.0.
  • Fixed error messages on selecting the entire worksheet with the active List Editor.
  • Fixed bad values calculated by the =UserName() and =DomainUserName() functions.

Version 7.0.3, January 25, 2017

Bug Fixes:

  • Fixed issues with creating SQLite databases.
  • Fixed issues with List Editor.
  • Fixed issues with saving table formats to SQL Server.

Version 7.0.2, January 20, 2017

Bug Fixes:

  • Fixed issues with PowerQuery compatibility.
  • Fixed issues with Query Lists.

Version 7.0.1, January 17, 2017

Bug Fixes:

  • Fixed issues with MySQL ODBC drivers.

Version 7.0, January 17, 2017

Licensing Changes

  • The free SaveToDB Express edition is available again.
    However, the new Express edition has other limits than previous versions. See Edition Comparison.
  • Starting SaveToDB 7, major upgrades are not free.
    You may purchase and renew Upgrade Warranty of free upgrading to the latest major versions.
  • As a special case, customers, who bought SaveToDB 6.x versions, may upgrade to SaveToDB 7 for free, using the same product codes.
    Customers, who bought SaveToDB 1.x-5.x versions, may purchase an upgrade license.
  • The SaveToDB add-in is available as a subscription.
    During the subscription period, you may upgrade to the latest versions for free.
  • The SaveToDB Personal edition allows saving OData data.
    So it has the same features as the SaveToDB Enterprise edition.

Upgrade Notes

  • Previous versions are converted to a new trial version with a 30-day period.
  • Customers, who bought SaveToDB 6.x versions, may register SaveToDB 7 for free, using the SaveToDB 6.x product codes.
  • Customers, who bought SaveToDB 1.x-5.x versions, may purchase an upgrade license and register SaveToDB 7, or uninstall SaveToDB 7.0 and install the previous version.
    In the last case, you may continue to use the previous registered version without additional actions.
  • Customers, who use free SaveToDB Express 1.x-5.x versions, may purchase a full license or subscription and register SaveToDB 7, or uninstall SaveToDB 7.0 and install the previous version.
    In the last case, you may continue to use the previous registered version without additional actions.
  • SaveToDB 7.0 supports all previous versions of server-side configurations.
    So, you do not need to change your databases before the upgrade.
  • You may upgrade previous versions of SaveToDB Framework to the newest SaveToDB Framework 7.0.
    SaveToDB SDK contains upgrade SQL codes for all database platforms.

Download Package Changes

  • The SaveToDB 7 setup package does not include gConnectionManager, gsqlcmd, and gwebcmd.
    You may install these products using separate setup packages.

New features:

  • SaveToDB supports working with SQLite databases.
    SQLite is the best database platform for creating personal Microsoft Excel applications using the SaveToDB add-in.
    SQLite database files can be located in workbook folders, and data can be loaded to multiple workbooks and worksheets in different views.
    The free SaveToDB Express edition has no limits and delays for both SQLite and Microsoft SQL Server Compact databases.
    However, SQLite supports views, and Microsoft Excel supports connecting to SQLite via ODBC drivers.
  • The SaveToDB add-in may read server-side configurations from tables like from views.
    This feature allows creating database applications in a single schema, with data and configuration tables, without using SaveToDB Framework.
    You may create required configuration tables and views using SaveToDB Framework source codes just replacing schemas.

Improvements:

  • The latest SaveToDB Framework 6.9 and 6.10 are renamed to SaveToDB Framework 7.0.
    SaveToDB Framework 7.0 includes updated batch files.
    SaveToDB Framework Installer allows installing the latest SaveToDB Framework 7.0 only.
  • SaveToDB SDK 7.0 includes new examples for SQLite and updated examples for other database platforms.
  • The updated SaveToDB installer creates menus in Windows 8 and Windows 10 styles.
  • Significantly improved performance of executing MySQL commands.
  • The SQL Debug mode has been removed.