KB All Products

slide

Function values are zero or blank when workbook is re-opened

Symptom When a workbook that contains Office Connector functions is saved and later the workbook is re-opened, the cells containing Office Connector functions show zeros or blanks. Cause Each Office Connector function represents a link to your Sage 300 Construction and Real Estate database. When Excel evaluates an Office Connector […]
slide

Invalid User Name/Password When Trying to Login

Symptom The following pop-up message is displayed after providing Sage 300 Construction and Real Estate login information using Office Connector: The user name or password you entered is incorrect. Please enter a valid user name and password. Cause Assuming you are entering a valid Sage 300 Construction and Real Estate […]
slide

Unable to open the license file

Symptom When opening Excel, the following message is reported in a pop-up message:   Unable to open the license file!  Please call technical support.    Cause This error is caused when Office Connector is unable to open either the Query license file or the Write license file due to one […]
slide

Why is the Office Connector toolbar disabled?

Symptom The Office Connector toolbar is present but all of the buttons are grayed-out (disabled). Cause 1 - No Active Workbook In order for add-ins to be accessible in Excel, at least one workbook must be open. The Office Connector toolbar will therefore be grayed-out when no workbooks are open. […]
slide

Why do some tables appear more than once and end with "(1)" or "(2)"?

ScenarioWhen a list of table names is displayed in an Office Connector wizard, some tables may appear more than once and end with "(1)" and "(2)".ExplanationOffice Connector uses certain Microsoft database technologies that do not support the use of tables that have more than 255 columns.  Since there some tables […]
slide

Which Sage 300 Construction and Real Estate applications can be used with Office Connector?

Any Sage 300 Construction and Real Estate application that allows access to its data via the Timberline Data ODBC driver can be used with Event 1 Office Connector.  The following table identifes the applications that presently meet this requirement: Application Yes No  Accounts Payable  x    Accounts Receivable  x   […]
slide

Why can't I use certain Sage 300 Construction and Real Estate accounting applications with Office Connector?

A small number of accounting applications in the Sage 300 Construction and Real Estate suite were not originally developed by Timberline Software.  As such, these applications do not share the same architecture as those originally built by Timberline.  Although these applications may utilize the Pervasive database engine to store their […]
slide

Why doesn't my Workbook or Template open via Windows Explorer or Office Connector Launch Pad?

BackgroundMicrosoft Excel contains a setting that prevents external applications from communicating with Excel via DDE.  DDE stands for Dynamic Data Exchange and is used by some applications to exchange data back and forth.  Windows Explorer uses DDE to open XLS and XLT files.  Therefore if this feature is enabled, a workbook cannot […]
slide

Cannot open connection after moving Prolog Manager database to a new server

Background:Before moving a Prolog Manager database to a new SQL Server, you must first remove the SDKUser account from the database.  Failing to do so will result in orphaned security records and prevent the normal operation of Event 1 Integrator.This article addresses how to resolve the problem by eliminating the orphaned […]
slide

My Office Connector formula does not return the correct results when the ID field has a space in it.

This can be caused if you forget to enclose the ID in single quotes (this applies to text IDs).  For example: “(TPAYID = ‘01’) AND (TEMPID = “ & A2 & “)” Should be “(TPAYID = ‘01’) AND (TEMPID = ‘“ & A2 & “’)”