KB All Products

slide

Office Connector Import 1.00.0009

  • Online licensing provides a greatly streamlined process to automatically request and enter multiple sets of license keys in a single step.
  • Resolves formatting issue in several columns of the "Data" sheet of the GL Transaction Import File Creator.xlt example template.
  • Now uses the Event 1 System Folder paradigm to share common files, store licenses and file formats.
slide

Why aren't Subcontract COs transfering and I get an 'Error 0' message?

SymptomAfter running the Perform Modifications task in Integrator, you find that one or more Subcontract COs that were expected to transfer do not appear in Sage Timberline Job Cost.  A review of the Perform Modifications recap report reveals the message "Error 0" at the end of the Subcontract COs section.  A […]
slide

Why does my software report that the license file location has changed?

Symptom When starting your Event 1 Software application, or when the application needs to acquire a license, the following message is displayed: It appears that the location of the license file has changed. Since the license file is associated with a particular machine, you must request updated license keys from […]
slide

Do I need to enter license keys for each workstation?

The license information for all Event 1 Software products that integrate with Sage 300 Construction and Real Estate is stored in a central location.  When license keys are entered from any workstation, the shared license information is updated and all workstations will begin using the new information.  This means that […]
slide

Why do my TSLookup and TSFind functions return zero after optimizing my workbook?

Symptom After upgrading to Office Connector version 2.01.0041 the following message is displayed when opening a workbook that was saved using a prior version of Office Connector: This workbook was saved using a prior version of Office Connector. This workbook needs to be optimized to run faster under the new […]
slide

How do I unload and load the Office Connector add-in?

Background This is a general-purpose article that provides steps for manually unloading and loading the Office Connector add-in. The resolution for certain technical issues require the add-in to be manually unloaded or loaded, and this action may also be prescribed by technical support staff. The Office Connector product suite consists […]
slide

Why do I receive a message indicating that the cache could not be saved?

Symptom When running a macro that includes a step to save the workbook, the following message may be displayed: The cache cannot be saved.  Please contact technical support for assistance. Would you like to email this information to the support department at Event 1 Software? <Yes> <No>   When caching […]
slide

Why am I prompted about optimizing my workbook that doesn’t use Office Connector functions?

Symptom Upon opening an Excel workbook that does not use Office Connector functions or queries, you receive the following prompt: "This workbook was saved using a prior version of Office Connector. This workbook needs to be optimized to run faster under the new version. If you do not optimize this workbook, it […]
slide

Office Connector Import 1.00.0003

This is the initial public release.
slide

When Should I Use Filter vs Where?

Excel queries only support the Where technology, so this discussion only applies to the Office Connector workbook functions (TSLookup, TSFind, TSSum, TSCount).  By default, Office Connector workbook functions use Microsoft’s Filter technology to apply criteria.  First, all of the data is loaded, and then the filter is applied.  Once you […]