We’ve developed some resources to help you work effectively from home during COVID-19 Click to learn more

Upgrade Windows Client

In this article

    How to upgrade SuperOffice 7 Windows Clients / SuperOffice 8 Windows App

    1. Check the System requirements for the client SuperOffice8 Windows App
    2. Install correct ODBC driver if needed
    3. Run SuperOffice8.exe to start the installation

     

    1. Check the System requirements for the SuperOffice 8 Windows App

    NOTE! In SuperOffice 8 the user needs a "Windows App" license to be able to log in to the Windows client. Read more in the Help-file.

    NOTE! The "Maintenance and settings" is only accessible from the Admin client web.
    Some settngs for Travel / Remote Travel (Replication), Windows client scripting is configured from the Admin client windows. Here you also find a section called "Options" where you can set automatic update of SuperOffice client. Check this option if you want the SuperOffice client to be updated automatically when a new version becomes available. Read more in the Help-file.

    Make sure the system requriements for the computer is met, read more informatin about this below and in the section "System requirements" under "Preparations"

    Prerequisites are installed during the upgrade of the client. Read more in Prerequisites 

     

    2. Install correct ODBC driver if needed

    Oracle ODBC driver, Microsoft Native Client or Microsoft SQL Server driver

    Oracle

    Note: If you want to use Oracles 11g, you need to install the Oracle client drivers on each client first. Oracle 10g may run on the Microsoft version of the Oracle driver. 

    Microsoft Native Client

    Note: Since we're now using the MSI installer - you may not run one client with SQL Server driver and another one with Native client. You need to install the Native client on the client if it's not installed already.

    Microsoft SQL Server driver

    Most current Windows operating systems have SQL Server driver pre-installed and is ready to use.

     

     

    3. Run SuperOffice8.exe to start the installation

    To install the client - run the MSI Installer "SuperOffice8.exe" found in the Server\Client folder.
    Read more about running the installer and installing the client under "Install Windows client".

     How to find "Server\Client folder" on server

    Since you are upgradeing the client on a computer, there is information you can use to find the location for the installer program - by navigating through the current files you already have.
    (if this is changed by your admoinstartor or IT - you need to ask them where to fin it).
    Here is how you can find this info:
    1. Open SuperOffice.ini - to find centralpath (where the server installatin is) 
    2. Open the file path to where the server installatin is - in file explorer
    3. Find the folder "Client" on server and run "SuperOffice8.exe"
     
    1) Open SuperOffice.ini - to find centralpath (where the server installatin is) 

    How to find SUPEROFFICE.INI

    a) To find the configuraton file for SuperOffice (SuperOffice.ini), right-click the SuperOffice icon on the desktop / in the start-menu, and choose "Properties"

    b) In the window the opens up - click on [Open File Location]

    Open_File_Location

    An file explorer window will open - and you will se the SuperOffice program files.

    c) Find the file "SuperOffice.ini", and open this file

    SuperOffice_ini

     

    How to find the centralpath

    d) Find the central path / installation path for the server
    - You will find the address for the central SuperOffice installation (server installation) in the configuration file as CentralPath. Copy the address after "Centralpath="

    superoffice-ini_centralpath

     

    2) Open the file path to where the server installatin is - in a 'file explorer'

    a) Open the Run dialog (open it either from the Windows start-menu, choose "Run" or click Windows-key + R chortcut on the keyboard.)

    b) Paste or write the address for CentralPath and click [OK].

    run_centralpath

     

     3) Find and open the folder "Client" on server and run "SuperOffice8.exe"

    Read more about running the installer and installing the client under "Install Windows client"

     

     

     You may now start SuperOffice by clicking [START] -> All Programs -> SuperOffice 

     

    The following must be prepared for computers running the win client

    SuperOffice Windows client is available only for SuperOffice 8 and older.

    For Microsoft SQL Server: Make sure the ODBC driver you want to use is installed on the client.

    For Oracle: Make sure the the 32 bit version of Oracle Client is installed. Note - we require the Runtime installation. You also need to set up the Local Net Service Name from the Oracle Net Configuration Assistant.

    The client installer will install all prerequisites, the .Net framework is a web download so the client needs access to the internet when installed.

     

    ODBC and ADO.NET connections

    Most parts of SuperOffice product family use ADO.NET connection. There are some exceptions which for historical reasons use ODBC connection.

    Win client

    Win client uses a mix of ODBC and ADO.NET connections. The new parts (e.g. selections, quote, bulk update, guide, archives) use ADO.NET, some parts like e.g. Diary are ODBC based.

    Win Admin client uses a mix of ODBC and ADO.NET connections. E.g. Prototype generation uses ADO.NET, Import use ODBC. 

    Import in Win Admin is the only place which can benefit from SQL Native client driver with bulk copy capabilities. In other parts using ODBC the difference in performance between SQL Native Client and Microsoft ODBC Driver is insignificant.
    On SQL Server we are using the .NET version of the bulk copy functionality which is just as fast as the ODBC.
    SORT.exe, SORTS.exe, SoTrvGate.exe, Reporter Studio - these use ODBC.

     

    DBSetup

    DBSetup uses a mix of ODBC and ADO.NET connections. ODBC in DBsetup is mainly for historical reasons and is not actually used for database setup, upgrade, export and import; those have all been rewritten to C# and use ADO.net.

     

    Web client / Netserver

    Netserver use ADO.NET connection only. Web client doesn't have its own database connection and uses Netserver to connect to a database and so_arc. The only part of a Web client which has its own connection is Web Reporter and it uses ODBC connection.

     

    Service

    Service uses both ODBC and Netserver connection.

     

    Migration Tool

    Migration Tool uses ADO.NET to connect to the database. It also uses Win client to read some information from SuperOffice database. If Win client is not installed a user will get the following dialog and will have to type in the answers manually.

    Migration Tool

    These are our current tested operating systems for win client

    Currently tested client operating systems if running SuperOffice Onsite (for our Mac users this means only the web client).

    Want to know if a newly released OS is compatible? Check your compatibility reports.

    For SuperOffice 9 and later the Win client is not available.

    WIN Operating system 8.0 8.1 8.2 8.3 R01 - R03 8.3 R04 8.4 8.5 9.1
    Windows 10*
    Windows 8.1
    Windows 8
    Windows 7 x64 (SP2)**
    Windows 7 x86 (SP2)**

    * Windows 10 is supported from Windows 10 Anniversary Update (version 1607)

    ** Windows 7 SP1 and SP2 has reached end of support 14th January 2020

     

    MAC Operating system* 8.0 /
    SR1 / SR2
    8.0 SR3 - SR6 8.1 8.2 8.3 8.4 8.5 9.1
    MacOS Big Sur
    MacOS Catalina
    MacOS Mojave
    MacOS High Sierra
    MacOS Sierra 
    MacOS X El Capitan
    MacOS X Yosemite
    MacOS X Mavericks

    * Mac users - the biggest source of incompatibility is our Web Tools, so for the Mac OS versions not part of our tested configurations this is the most likely part of the product that will not work.

    These are our current tested browsers for win client (web panels)

    Tested browsers to run both Win and Web applications.

     Want to know if a newly released browser is compatible? Check your compatibility reports.

    Browsers 8.0 8.1 8.2 8.3 8.4 8.5 9.1
    Edge
    Internet Explorer 11
    Internet Explorer 10
    Chrome Win
    FireFox Win
    Chrome Mac
    FireFox Mac
    Safari Mac

     

    Be especially aware of the different versions of the ODBC drivers.

    SuperOffice CRM has officially been tested on MS SQL Server 2012, 2014, 2016, 2017 and 2019. 

    SQL Server 2019

    Name Version
    SQL Server 2019 15.0.2000.5

    ODBC drivers

    Name Version
    ODBC Driver 17 for SQL Server  17.4.2.1

     

    SQL Server 2017

    Name Version
    SQL Server 2017 14.0.1000.169

    ODBC drivers

    Name Version
    ODBC Driver 17 for SQL Server 2017.171.00.01

     

    SQL Server 2014, 2016

    Name Version
    SQL Server 2016 13.0.1601.5
    SQL Server 2014 12.0.2000.8

    ODBC drivers

    Name Version
    ODBC Driver 13 for SQL Server 2015.131.811.168

     

    SQL Server 2012 (Enterprise or Standard edition*)

    Name Version
    SQL Server 2012 11.0.2100.60

    ODBC drivers

    Name Version File
    SQL Native Client 11.0 2011.110.1750.32 SQLNCLI11.DLL

     * Our compability tests have been performed on both Enterprise and Standard edition of SQL server 2012. When looking at the specification for the different version, the other versions of SQL Server 2012 should also work. The only funcitonallity we "may" use (not required), is "Full-text and semantic search". So when choosing your SQL Server 2012 version, make sure it covers your needs. Be especially aware of the different versions of the ODBC drivers. This has turned out to be greatest source of incompatibility.

    Be especially aware of the different versions of the ODBC drivers.

    SuperOffice CRM has been officially tested on Oracle 11g, 12c and 18c.

    Oracle 18c*

    Server

    Name Version
    Oracle 18c  18.3.0.0.0

     

    Client

    Name Version
    Oracle 18c Client 18.3.0.0.0

     * See below Oracle 18c compatibility info

     

    Oracle 12c

    Server

    Name Version
    Oracle 12c  12.1.0.1.0

     

    Client

    Name Version
    Oracle 12c Client 12.1.0.1.0

     

    ODBC drivers

    Name Version File
    Oracle in OraClient 12home 12.01.00.01 SQORA32.DLL

     

    Oracle 11g

    Server

    Name Version
    Oracle 11g Release 2 11.2.0.1.0
    Oracle 11g Release 1 11.1.0.7.0
    Oracle 11g Release 1 11.1.0.6.0

     

    Client

    Name Version
    Oracle 11g Client 11.2.0.1.0
    Oracle 11g Client 11.1.0.7.0
    Oracle 11g Client 11.1.0.6.0

     

    ODBC drivers

    Name Version File
    Oracle in Orahome11 11.2.0.3.0 SQORA32.DLL
    Oracle in Orahome11 11.2.0.1.0 SQORA32.DLL
    Oracle in Orahome11 11.1.0.7.0 SQORA32.DLL
    Oracle in Orahome11 11.1.0.6.0 SQORA32.DLL