What's New in Office Connector 2.02.0060
Posted 9/1/2010
The Short List
The details are all listed below, but here's the bottom line:
- Office Connector Starter - added security and improved user feedback.
- Licensing - more scenarios are supported and the delivery of keys takes fewer clicks.
- Maintenance - updates for newer Excel features and changes in the Windows operating system.
- Technical Support - many enhancements to accelerate our ability to resolve issues for you.
General Enhancements
- Added the ability to control access to Office Connector Starter functionality using the Office Connector Administrator.
- Added support for ListObjects (created when you select Format as Table in Excel):
- Refresh Data
- Edit SQL
- Save As Values
- Save As Values is more robust and efficient.
User Feedback
- Added the ability to turn the progress meter off.
- Modified the "invalid user name or password" message to contain a bullet list that outlines the possible causes for the failure.
- Modified the "permission denied" messages for Office Connector Starter to indicate if the functionality is unsupported or if the action was explicitly denied by Office Connector Administrator.
- Modified the Viewer Mode message to include "access to Timberline" as a possibility instead of simply reporting that Timberline does not appear to be installed.
Licensing Enhancements
- Provides the ability to share a local license file with network users. For example, the license can be stored on the local drive of a Terminal Server, and also shared as a network floating license for other workstations on the LAN.
- License Wizard
- Automatically selects all licenses that have an ID.
- The License Results step now disables the Next button and sets the focus to the Close button because it was confusing to have it wrap around back to the start.
- Adds the ability to copy the Activation Codes from the License grid when delivering license keys via telephone.
- Prevents the License Wizard from being used in Viewer Mode.
- System Information Report
- Now shows the license ID for all of the licenses.
- For the Event 1 System Folder, now displays the logical drive type, Standalone/Shared type and the value as stored in the registry.
- Now suppresses unwanted licensing messages that would otherwise be displayed as a side effect of actions that initialize the licenses but don't require a concurrency.
- Supports the ability to share a local license file that is in a shared subfolder of another share.
- No longer enforces restrictions on permanent licenses when the clock has been rolled back, provided that the system date never exceeded the maintenance expiration date.
Better Technical Support
- Added the Launch Pad activity log and Sage Starter installation log to the Technical Support Email attachments.
- Many enhancements to tracing and error logging combine to accelerate issue analysis.
- The new ability to copy activation codes from the wizard reduces mistakes and accelerates the delivery of manual license keys delivered via WebEx.
Bug Fixes
- The Write GL Budget template no longer writes all periods to period 1.
- Restored the ability to free concurrencies without having to close Excel.
- The Ignore Missing Tables setting has been updated to accommodate a change in the Timberline ODBC driver.
- Resolved a case sensitivity issue that could cause Launch Pad templates to be read from the application folder instead of the Event 1 System Folder when running as a published application under Citrix.
- The Conditions step now generates the correct syntax for Null memo fields.
- It is no longer possible to drag the Criteria toolbar off of the Query / Function Wizard.
- No longer display a duplicate "permission denied" message that used to be shown under a particular circumstance.
- TSWrite functions that write to multiple columns using the CreateOnly action no longer fail.
- Now have top-level error handling to prevent Excel from displaying too many messages in response to a crash.
- No longer generate SQL errors when using the Query Wizard to change the table for an existing query that already has conditions that apply to the original table.
- Fixed a bug that could prevent the workbook from being automatically refreshed on open if Save data with report is on, but there actually isn't any saved data.