3305 Main Street Ste 019 Vancouver, WA 98663

KB Office Connector

slide

Lease Adjustment Templates

Background The following Office Connector templates were developed in response to customer-communicated needs relative to the impact of the COVID-19 outbreak. In response to economic hardships of tenants, some property management customers have elected to either eliminate late charges temporarily, or decrease rent amounts temporarily. Performing these changes within the […]
slide

How Do I Migrate My Office Connector Software To A New Server?

The following steps can be used to successfully move your Event 1 System Folder (E1SF) associated with your Office Connectorsoftware to a new server when it is required by a server migration. Before beginning the steps listed below, it will be important to identify the location of your current E1SF […]
slide

How to Automate the Office Connector Import Process via TSIWriteImportFiles2

It may be desirable to automate the process of creating an import file for Sage 300 CRE via an Office Connector Import workbook. This task can be completed with a macro built into Office Connector Import. This macro can be called via a custom macro using the Microsoft Visual Basic […]
slide

Office Connector Functions Return #TABLE? Error

Background In an effort to reduce refresh time(s), Office Connector will optimize the data functions. It does this by creating a SQL statement based on the table name and only the fields referenced by the Office Connector function(s) contained within a workbook. It will then use this SQL statement for […]
slide

How do concurrent license uses work?

Licenses for many of the products developed by Event 1 Software work based on a number of concurrent uses assigned to each license type. This allows each customer to have multiple staff utilizing the same license type simultaneously if desired. The following products are included in this behavior: Liberty Reports […]
slide

Making Sure Your Business Management Software Upgrade Goes Smoothly

While Event 1 Software strives to be aware of every possible contingency that could arise due to upgrading your Business Management Software, it is impossible to account for every type of implementation. Because of this, it is highly recommended that a test environment be created prior to upgrading a production […]
slide

An Unexpected Situation Has Occurred When Using The Office Connector Toolbar In Excel

Symptom(s) After installing Office Connector on a new PC or where Microsoft Office was recently installed/activated and attempting to select any of the buttons on the Office Connector toolbar, you receive a message that starts, "An Unexpected Situation..." After installing Office Connector on a new PC or where Microsoft Office […]
slide

How to send data from Excel to Sage 300 CRE

Overview The Office Connector license that you use (Write or Import) to send data from Excel into Sage 300 CRE depends on the type of data and whether Sage allows that type of data to be sent directly into the database or whether the data must be processed and validated […]
slide

Which Office Connector module should I use to send data from Excel to Sage 300 CRE?

Click an application title below (e.g., "Accounts Payable") to view a list of the tables that you can send data to from Excel via Office Connector. Click on a specific table (e.g., "AP Invoice") to see which Office Connector modules can be used to create and/or update records. Refer to […]
slide

I’ve Licensed My Office Connector or Liberty Reports Designer License, But I’m Still Getting a Prompt About The Evaluation License Expiration

Cause When Office Connector Query & Write or Liberty Reports is first installed, both the Designer and Standard features are activated with a 10 day evaluation period. These features are activated without entering a valid License ID. If you only purchased a Designer license, once you have completed licensing your […]