Installing Excelerator and Prerequisite Components
To install Excelerator, make sure that you have administrator privileges. If not, you can ask your system administrator to install Excelerator into your user account. If multiple users on the system want to use Excelerator, the system administrator must install Excelerator for each user account respectively. Installing once on the system cannot enable all users to use Excelerator.
1 Make sure that the following prerequisites are met before you implement Excelerator on your client machine:
• The operating system on the client machine must be Windows 8, Windows 7, Windows XP, Windows Server 2003, or Windows Server 2008.
• Microsoft Excel 2007, 2010, or 2013 is installed on the client.
• QXtend Inbound and Outbound (version 1.6.3 or later) have already been properly installed and configured to successfully communicate data between source and target QAD applications.
Note: If you use Excelerator 1.3 with a QXtend version earlier than 1.8.4 and use a comma as the decimal separator, contact QAD Customer Support to get a patch.
2 From the installation media, execute setup.exe to install the Excelerator workbook and all prerequisite components. The components include Microsoft .NET Framework 3.5 SP1, Microsoft Office Primary Interop Assemblies, and Microsoft Visual Studio 2010 Tools for Office Runtime. Follow the on-screen instructions to complete the setup.
Important: For Excel 2010, if Microsoft Visual Studio Tools for the Microsoft Office System 3.0 is installed on your client machine, uninstall it before you execute setup.exe and remove the registry key under HKEY_CURRENT_USER\Software\Microsoft\VSTO\SolutionMetadata. Otherwise, you cannot open any Excelerator worksheet.
3 When setup is complete, you can find a QXtendWorkbook.xlsx file in your My Documents\QAD\QAD QXtend Workbook folder. This file serves as a template, so do not directly use this file but rather create new working Excel files from the file for data integration.
A default QXtendWorkbookConfig.xml file is also deployed to the My Documents\QAD\QAD QXtend Workbook folder. The file contains the global Excelerator settings that are set in the QAD QXtend Excelerator Settings window. When the Excelerator is launched, the configuration details (QXtend Location, Update Receiver, QAD Application Settings) are loaded from the QXtendWorkbookConfig.xml file. The tool searches the following locations in order of preference when loading the configuration:
• Local directory where the worksheet was opened from.
• The config subdirectory under the local directory where the worksheet was opened from.
• Your ClickOnce cache directory. The ClickOnce cache is where required DLLs are installed to. The location is a subdirectory under your Local Settings\Apps\2.0 directory.
• The config directory under the ClickOnce cache.
This mechanism allows you to decide whether to bundle the configuration file with the set of worksheets you are working with. If the configuration file is not exposed in the local directory where the worksheets are stored, the settings are stored in your ClickOnce cache. The administrator can then restrict access to the cache directory, which would restrict a user from tampering with the QXtend settings.