KB All Products

slide

Why do some tables appear more than once and end with "(1)" or "(2)"?

ScenarioWhen a list of table names is displayed in an Office Connector wizard, some tables may appear more than once and end with "(1)" and "(2)".ExplanationOffice Connector uses certain Microsoft database technologies that do not support the use of tables that have more than 255 columns.  Since there some tables […]
slide

Why doesn't my Workbook or Template open via Windows Explorer or Office Connector Launch Pad?

BackgroundMicrosoft Excel contains a setting that prevents external applications from communicating with Excel via DDE.  DDE stands for Dynamic Data Exchange and is used by some applications to exchange data back and forth.  Windows Explorer uses DDE to open XLS and XLT files.  Therefore if this feature is enabled, a workbook cannot […]
slide

Cannot open connection after moving Prolog Manager database to a new server

Background:Before moving a Prolog Manager database to a new SQL Server, you must first remove the SDKUser account from the database.  Failing to do so will result in orphaned security records and prevent the normal operation of Event 1 Integrator.This article addresses how to resolve the problem by eliminating the orphaned […]
slide

My Office Connector formula does not return the correct results when the ID field has a space in it.

This can be caused if you forget to enclose the ID in single quotes (this applies to text IDs).  For example: “(TPAYID = ‘01’) AND (TEMPID = “ & A2 & “)” Should be “(TPAYID = ‘01’) AND (TEMPID = ‘“ & A2 & “’)”
slide

I use Property Management and I need to find the current total square footage of a unit.

The trick here is to use a combination of TSCount and TSFind to locate the last square footage change.  The TSFind function has an optional parameter for the "offset", which is a number of records to skip over.  Zero is the default, and it means "don't skip over any records".  […]
slide

How do I reference a cell from an Office Connector workbook function?

The quick answer is “Replace the existing value with a cell reference using the following syntax “ & <cell address> & “  Following is a more detailed explanation:  Start by creating the workbook function and using a hard-coded value for the filter (see the screen shot for JC transaction example […]
slide

How Do I turn Office Connector off for a particular user under Citrix?

The following procedure will prevent the Office Connector toolbar from showing up for a particular user. Click Start->Run, type regedit and click OK: Navigate to “HKEY_CURRENT_USER\Software\Microsoft\Office\%Excel Version Number%\Excel\Options”. Right click “Open” and pick Modify from the popup menu. Delete the value that contains the path to your OfficeConnector.xla file.
slide

How do I verify that the Sage 300 Construction and Real Estate ODBC driver is installed?

To verify your ODBC status: Go into TS-Main and select "Tools / Change registration name or uses". Select "Number of uses" and click Next to display a list of all applications and their activation codes (the same one you see when you install the software). ODBC is listed in the […]
slide

When I try to run the self extractor file that I downloaded from your web site, I get a message saying that it is not a valid Win32 or WinNT image.

This symptom indicates a corrupted download.  Download the image again; when prompted, be sure to click Save, not Open.  Pick a new location and try opening the file from there.Re-downloading might not resolve the issue if the corrupted file is in your Internet cache.  You can tell if this is […]
slide

I installed Office Connector. It shows up in Add/Remove Programs, but it does not show up in Excel. What happened and how do I fix it?

You must close Excel during the installation in order for the setup program to automatically insert the Add-In.  There are two ways to fix this: Close Excel and re-run setup. Follow the steps in the following KB article:How do I unload and load the Office Connector add-in?