All Products

slide

Message 60002 – Project [Number] does not have a cost period for the date [Date]

Background In order for Integrator to create a General Invoice or Contract Invoice, the invoice must be assigned to a valid Cost Period that is setup in Prolog Manager.  Each project contains its own list of Cost Periods.  An individual Cost Period in the list is identified by a unique identifier and […]
slide

Message 20004 – Job was not found in the Sage 300 Construction and Real Estate job list

Description The Sage 300 Construction and Real Estate Job Number identified by the Contract in Prolog Manager could not be found in the list of jobs in Sage 300 Construction and Real Estate.   Resolution                                             It may be possible that the job has not yet been created in Sage 300 […]
slide

Message 20003 – There are no Schedule-Of-Value items for this contract

Description In order to send a Contract from Prolog Manager to Sage 300 Construction and Real Estate, the contract must have at least one item in its schedule of values.  This message occurs when a contract is encountered that does not have any items.   Resolution ·         Option 1 - Open […]
slide

Message 20002 – Sage 300 Construction and Real Estate commitment ID is too long. The maximum size allowed by Sage 300 Construction and Real Estate is n characters

Description The Commitment ID for Sage 300 Construction and Real Estate has a maximum size which is 12 characters by default.  This can be smaller depending on your implementation of Sage 300 Construction and Real Estate.  This message occurs if the contract in Prolog Manager would use a Commitment ID that is […]
slide

Message 20001 – Could not convert the Prolog Manager project number to a valid Sage 300 Construction and Real Estate job number

Description This message is reported when the Project Number of the contract does not result in a valid Job Number for Sage 300 Construction and Real Estate.  In many implementations of Integrator, the Sage 300 Construction and Real Estate Job Number is identical to the Prolog Project Number however an alternate […]
slide

Why do my TSSum or TSCount functions return the wrong value after optimizing my workbook?

Symptom After upgrading to Office Connector version 2.01.0041 or higher, some workbook formulas return the wrong amounts. Cause There are two approaches that Office Connector can use to filter Timberline data. The first approach queries Timberline data in bulk, and then uses Microsoft technology to filter the results on the […]
slide

Are Office Connector conditions case-sensitive?

BackgroundIn some cases conditions are case-sensitive.  This is dependent the specific Office Connector feature you are using to query data and how it is being used.The following list identifies when case-sensitive comparisons would occur: Query Table The conditions of the query include the LIKE operator, or the conditions involve a […]
slide

How do I create a template from an existing workbook?

Background Once you have created a workbook containing Office Connector queries and functions, you may wish to deploy it to other people or companies.  This article covers the recommended steps and things to consider that will create a smooth experience for the recipient who will create workbooks based on your […]
slide

Why does my error log report that the file KeyLib32.dll is not found?

SymptomWhen starting your Event 1 software application or attempting to perform various tasks, the following message is displayed:An unexpected situation was encountered.  Would you like to email this information to the support department?<Yes> <No>Upon examination of the error log, the following entry is found in numerous locations:48 File not found: KeyLib32.dllUpon […]
slide

Software Notice 09A – Office Connector Upgrade Message

 March 9, 2009 Upgrade Notification Messages If you downloaded Office Connector version 2.2.x prior to 2/17/2009, the installation package you recieved may have been missing the file responsible for automatically checking for updates.  If you upgraded from version 2.1.x or earlier, the old file is still on your system.  Since version 2.2.x […]