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

  • Added MYOX_Timesheets table.
  • Added location field to STANDARD_Sales and STANDARD_Purchases 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.

Related Topics