ODBClink v2015.12.2.159

ODBClink v2015.12.2.159 was released on 22/12/2015. Release specifically targeted for dropbox and get data improvements.

Enhancements

Menu

Menu worksheet is now protected to ensure startup performs better and double clicks get ignored.
Renamed command centre to ""Command Centre"" and not ""Command Center""

Tables

Get Data

Skipping unchanged data files mechanism enhanced to skip more of the process.
Enhanced Get Data process to only populate STANDARD_ tables into the AddonsLink.Cache.mdb or BudgetLink Data.mdb if required by functions or by linked tables.
Enhanced Get Data process to only populate raw tables into the AddonsLink.Cache.mdb or BudgetLink Data.mdb if required by linked tables.
Enhanced get data process to also transfer SYSTEMDATA_MonthlyPeriods and SYSTEMDATA_WeeklyPeriods to data warehouses to support dropbox.
Enhanced get data to create all tables from the addonslink cache as opposed to data file interface.

XERO

Enhanced XERO get data to request report data using standardLayout=true to ensure values can be read correctly.

Manage Data Files

Fixed issue when broswing for an MYOX cloud file the first time.
Fixed validation to warn when entering data file name longer than 50 characters.

Licensing

Transfer Keys will no longer be required.
Upgrade Keys will no longer be required.
All editions will now allow for multiple users.
New trial keys will be generated if the last key generated is over 60 days old.
System tables and hidden tables will be hidden when using the Add Query Table utility.
Increased the height of one of the licensing caption to ensure it fits the text line in full.

Dropbox

Enhanced dropbox integration to only check for READ/WRITE access on FULL GET DATA.
Enhanced get data to not retain archive unless required.
Added option to ""Perform a full get data and retain archive"" which is used to prepare the archive for future use.

Miscellaneous

Enhanced code that Freeze Panes to handle pivot tables and query tables without FreezePaneDef.
Enhanced code that refreshes pivot tables and query tables to handle missing QueryTableDefs by parsing the connection string.
Enhanced code that refreshes pivot tables and query tables to refresh even when not using data warehouses and using external databases.