Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet Reports Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Command-Line Installation of Jet Professional using MSI


Expert

Related Articles...

Overview

For most installation needs, Jet Reports provides the consolidated installer - a self-contained .EXE file that handles the installation of all components of Jet Professional.  Some organizations have specialized needs and utilize their own installation processes.  Jet Reports makes an MSI installer avaialble for these organizations.

Below are the steps (both required and optional) for using the MSI installer to install the Jet Excel add-in.

MSI Installation Considerations

  1. Download

    Your first step in performing a command-line install of Jet Professional is to download the MSI installers.

    A zip file containing both the 32-bit and 64-bit MSI file is available here.

    You will need to extract the files contained in the zip file before they can be used.

  2. System Platform

    Once you have downloaded and extracted the MSI files, your next step is to choose the correct installer for your system(s).  Based upon your edition of Microsoft Excel, you'll need to select either the 32-bit or 64-bit installer.

    Please note that your choice is determined by the bit-level of Excel, not the bit level of your version of Windows.  It is common (and sometimes recommended*) to run 32-bit Excel on 64-bit Windows.
    For our customers using Excel 2010 or higher with Microsoft Dynamics NAV 2009 R2 or earlier, Jet Reports recommends the 32-bit editions of MS Office.

    How do I determine which bit-level of Excel I have?

    The examples below denote the 32-bit installer (Jet.Setup.ExcelAddin_x86.msi).  If you have 64-bit Excel, you'll want to use the 64-bit installer (Jet.Setup.ExcelAddin_x64.msi)

  3. Silent Installation

    Silent installation is a feature that installs the Jet Professional Excel add-in with no user interaction at all. This feature is primarily useful when creating automated installation scripts.

    In order to perform a silent installation of the Jet Professional Excel add-in, you must use the Windows Installer database file Jet.Setup.ExcelAddin_x86.msi with the /qn command-line option:

    C:\> Jet.Setup.ExcelAddin_x86.msi /qn
  4. Language

    The language of the installer is set automatically based on the Operating System language.  This determines the language of the Start Menu shortcuts, but Jet Professional will still be able to support all languages that are currently available.

Command-Line Properties

Properties can be set on the command-line to be passed to the MSI.  These are specified using the following syntax:

C:\> Jet.Setup.ExcelAddin_x86.msi PROPERTYNAME=PropertyValue

The name of the property is case-sensitive and must be in all CAPS.  Below is a list of the supported properties and their functions:

  1. ACTIVATIONCODE

    C:\> Jet.Setup.ExcelAddin_x86.msi ACTIVATIONCODE=ABCDEF01-2345-6789-ABCD-EF0123456789

    The ACTIVATIONCODE property specifies the activation code that will be used to activate the Jet license the first time the Jet Professional Add-In is enabled in Excel.

    NOTE: The activation code is not validated at the time of installation.  If the activation code is invalid for any reason, each individual user will still be prompted to activate.

  2. SERVICEHOST and SERVICEPORT

    The SERVICEHOST property specifies the host name of the Jet Service Tier.

    The SERVICEPORT property specifies the port on which the Jet Service Tier is listening.

    C:\> Jet.Setup.ExcelAddin_x86.msi SERVICEHOST=MyServer SERVICEPORT=7090

    When specified, Jet Professional will attempt to connect to this server/port in order to receive shared data source and license activation information from the Jet Service Tier.

  3. DISABLELOCAL

    The DISABLELOCAL property specifies whether to disable local data source settings, only allowing the user to connect to the Jet Service Tier for data source information.

    C:\> Jet.Setup.ExcelAddin_x86.msi SERVICEHOST=MyServer SERVICEPORT=7090 DISABLELOCAL=1

    The options for this property are 0 (the default) or 1.  A value of 1 indicates that local data source settings will be disabled.

  4. EXCELPLATFORM

    The EXCELPLATFORM property specifies the platform of Microsoft Excel.

    C:\> Jet.Setup.ExcelAddin_x86.msi EXCELPLATFORM=x86

    The Jet Professional MSI will attempt to automatically detect the platform of Excel, and perform a validation check that it matches the platform of the current installation.  In some cases the platform of Excel cannot be detected, in which case specifying this property will override the validation check and allow the installation to continue.

    Note: The use of this property is not recommended unless the Excel platform cannot be detected automatically.

Disclaimer: Please note that Jet Reports Technical Support staff is happy to help you with the installation Jet Professional using the methods described above.  Our analysts are not, however, familiar with all forms of MSI installers or your organization's specific internal processes.

The Jet Professional MSI installers and the information in this article are provided to assist our customers who are already familiar with using MSI installers in their organization.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments