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.

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):

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.

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.

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.

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.

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 lots of messages if Office Connector blows up.
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.

Posted 3/26/2010

Installing now takes fewer steps because you can run the setup directly from the self-extractor.
Resolves an issue where the Launch Pad no longer supported the ability to copy the executable file to a new location and have custom reports from that location appear in the report list.
Resolves an issue where specifying a local shared drive for the Event 1 System Folder to would prevent reports from showing up in the Launch Pad.

Posted 2/19/2010

New report templates have been added and all existing report templates have been updated.
The launch pad has been updated and now includes a new tab containing information about Office Connector and links to additional online content.
Increased the evaluation period from three business days to five business days.
Added a new workbook function, OCContext, that indicates if a workbook is operating under the normal context or as a Sage Starter workbook (or other specialized or OEM workbook).
Improved messaging when operating in Viewer mode.
Added the ability to turn off some notification messages.
Added the individual license file names to the System Information report.
Since Office Connector uses a minimum of four license files, any of which may or may not be individually renewed, the license description has been added to messages displayed when the application is upgraded after maintenance has expired.

Testing has verified functionality under 32-bit and 64-bit operating systems.
Changed the file name of the executable that checks the web for software updates so Windows 7 doesn't mistake it for an installer (thus avoiding the prompt for administrator permission).
Now set Windows file permissions on key Event 1 folders to allow full control for all users.
Added "Windows 7" as a recognized operating system in the System Information report.
An internal change was made to correctly handle queries that return no data under Windows 7.

Resolves an issue where TSSum functions would display an error message instead of a zero when the criteria had no matches.
Resolves an issue where named files that contain spaces would prevent the Query Wizard Preview feature from working.
Resolves an issue where a Designer concurrency would be re-acquired after having previously used a Designer feature, followed by closing all open workbooks (but leaving Excel open) and then using features that should only require a Standard concurrency.
Now release concurrencies when the last open workbook in an Excel session is closed, but Excel is still running.
Resolves an issue where "TSCUSTOMCAPTION(" would appear as the default text in the Excel Find/Replace window in non-OC workbooks.
Resolves an issue where new mapped drive letters could appear as a side effect of having a stand-alone license on the local drive.
Now require Query Designer permission to use the SQL Editor.
Resolves an issue for workbooks that use the Save data with report feature where saving the workbook after canceling the login prompt could cause the loss of the saved data (thus requiring a subsequent refresh).

Has it been a while since your last update? Click here to see what else has been added in the release notes for previous versions.

The perfect companion for
Office Connector

Get yours FREE. Click here to see how!

Check out these reports
featuring dynamic drill-down technology!

GL Financial Statements with Drill-Down

AP Vendor Inquiry with Drill-Down