BudgetLink v2015.12.2.159

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

Enhancements

Upgrade

Menu

Menu worksheet is now protected to ensure startup performs better and double clicks get ignored.

Manage Data Files

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

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.
Increased the height of one of the licensing caption to ensure it fits the text line in full.

Get Data

Skipping unchanged data files mechanism enhanced to skip more of the process.
Added location field to STANDARD_Sales and STANDARD_Purchases tables.
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.

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

Added AlignRangeDef function to control the alignment of cells programmatically.
Enhanced code that Freeze Panes to handle pivot tables and query tables without FreezePaneDef.
Added EnsureGetData function required for CAPS.
Added RecalculateListWorksheet function required for CAPS.
Added alias for periods required for CAPS import.