KB All Products

slide

How Do I Migrate My Forecast Manager Software To A New Server?

The following steps can be used to successfully move your Event 1 System Folder (E1SF) associated with your Forecast Managersoftware 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 Do I Migrate My Liberty Reports Software To A New Server?

The following steps can be used to successfully move your Event 1 System Folder (E1SF) associated with your Liberty Reportssoftware 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 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 Identify Your Event 1 System Folder

The Event 1 System Folder (E1SF) is used to store common files that are used by all installations of your Event 1 Software products. These files typically include the following items: License Files Connection Settings Shared Report Templates Custom Configuration Settings Custom Security Settings The E1SF is chosen during the […]
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

Custom Liberty Reports Workbook Prompting For Custom Connection After Upgrade

Background After upgrading from Liberty Reports version 1.x to Liberty Reports version 2.x, you may receive an error message when opening a custom report designed with Liberty Reports version 1.x. Error Message A connection called "ConnectionName" is needed in order for the query "QueryName" to be refreshed.Liberty Reports can automatically […]
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

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

2019 Aug 15 – Recent Microsoft Updates Causing Program Exceptions & Errors

Update Microsoft has announced that they have resolved the issues caused by recent Microsoft updates, which were affecting both our software and other software which use the same Microsoft technologies. Microsoft's fixes are available as OPTIONAL Windows updates. While we have confirmed that Microsoft's fixes resolve the symptoms in our […]
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 […]