All Products
Could not convert the Prolog Manager project number to a valid Sage 300 Construction and Real Estate job number
Description The Project Number of the contract does not result in a valid Job Number for Sage 300 Construction and Real Estate. Normally the Timberline Job Number is identical to the Prolog Project Number however an alternate value may be specified using a substitution table in Integrator. Regardless, this message […]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 […]How can I add case-insensitive conditions to a query when using the LIKE operator?
BackgroundThe LIKE operator is useful for identifying rows in a table by matching on a partial value. For example, the following expression would identify vendors with names containing the word “Electric” (referred to as the search-text in this article):[VNAME] LIKE '%Electric%'ProblemComparisons using the LIKE operator are case-sensitive and so you […]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 […]How do I migrate from one SQL Server to another?
Background This article covers the process associated with relocating your Prolog Manager database from one SQL Server Instance to another. This must be accompanied by the relocation of the Integrator database as well as updates to the Integrator connection file(s). Considerations The steps in this article assume the following: Basic […]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 […]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 […]How do I save my workbook as a template?
Background Excel templates have a special file type that designates them as a template. The advantage of using a template is that the default action associated with a template is to create a new workbook based on a template but not open or modify the template itself. The design of […]Newsletter – Volume 1, Issue 1
Event 1 Software Newsletter Volume 1:Issue 1 March 2009 In This Issue Importance of Training TUG Conference Information Illuminate Your Knowledge What are YOU Saying? Featured Template NEW in the Event 1 Software Knowledgebase Just in Time Training The Importance of Training Do you have the training you need to […]