KB All Products
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 […]Office Connector 2.02.0017
- Improved compatibility with Timberline 9.5 and above: Non-administrative users can now access data folder paths longer than 68 characters in length.
- Added the ability to suppress and re-enable optimization prompts for workbooks created using Office Connector between versions 2.01.0023 and 2.01.0033.
- Minor updates to the look of various windows.
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 […]What templates are available for Office Connector?
Template LibraryEvent 1 Software is in the process of building a library of add-on templates that provide solutions to common needs. Search For TemplatesUse the following page to search for template solutions in our current library:https://www.event1software.com/templates/index.phpCurrent LibraryThe current library consists of the following templates: AP Vendor Inquiry with Drill-Down AP Vendor […]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 […]How can I combine data from multiple data folders in one query?
Background An ordinary query inserted into a worksheet using Office Connector only queries data from a single Sage 300 Construction and Real Estate data folder. By editing the SQL text of the query afterword, you can include the data from the same tables in other data folders. Solution The solution is […]