Support
Installing Timesheet 5.5.2: Windows

 

Journyx Timesheet 5.5.2 has been designed to be simple to install. This document is divided into two sections: Pre-Install Considerations, which discusses concepts and concerns that should be addressed prior to installing Timesheet 5.5.2; and The Installation Process, which outlines the installation process from start to finish.

Pre-Install Considerations
This section of the Timesheet Installation documentation addresses certain concepts and concerns that must be taken into account before installing Timesheet 5.5.2 on a Windows server. Each topic discussed below should be considered, and if need be, addressed, before you continue with the installation process.

Special Note For Professional Services Tools Users
If your organization already has a version of Timesheet installed and you are using custom or standard PS Tools from Journyx, please contact the Journyx Support Team before migrating to Timesheet 5.5.2.

Timesheet Migration Hygiene
If your organization already has a version of Timesheet installed and you are migrating to the latest version of Timesheet, please remember to:

  • Make a backup of your existing Timesheet database, using the standard Journyx backupdb command line tool, and store that information in a safe location, such as on a network server. Additional copies of your backup file, burned to CD and stored in various safehouses and vaults around the world, couldn't hurt, either.
  • Install Timesheet on a test server and migrate your data into that installation for testing purposes before upgrading your production server.

From The Windows Readme File

  • When reporting problems installing the product, you may be asked to send in certain log files so that we can analyze the problem. The InstallShield log file can be found in this location: %TEMP%\JournyxTimesheetSetupLog.txt. This file is needed by Journyx Support if the product installation fails for any reason.
  • A separate logfile is produced by the 'Setup Web Server and Database' program that runs after you reboot. This logfile will be needed by Support if there is a problem configuring your web server or database. The file can be found in this location: %WTHOME%\IntegrationLog.txt. %WTHOME% is the location where you installed the product, such as "C:\Program Files\Journyx". If you simply type %WTHOME% into the address bar of a Windows Explorer window then it will take you to the correct location.
  • PLEASE NOTE: If are you are currently running an earlier version of Journyx Timesheet and plan to migrate your existing data then it is absolutely critical that you follow the proper migration steps to preserve your existing data and assure a smooth transition to the new Timesheet version. Please read this file before continuing: Timesheet Migration Help. If you do not follow the migration instructions, your critical Time and Expense data may become unavailable or lost!
  • To avoid interruptions in service, Journyx strongly recommends that you install the new version of Timesheet on a separate machine. This will leave your production site available online while you test the new site.

    Databases
  • Journyx Timesheet requires a relational database to store your Time and Expense information. You may either use the provided "Internal" database, or you may supply your own external database server.
  • Journyx provides an "Internal Database" for Windows. The feature is selected by default. If you wish to use an external database, you must do a "Custom Setup" and de-select the "Microsoft Database Engine (MSDE)" feature.
  • Journyx also distributes a version of the Timesheet installer that is smaller in size and does not include the MSDE feature, but requires that you use an external database to store your Timesheet data.
  • Anyone who wishes to use an external database, such as Oracle, SQL Server, or IBM DB2 must follow the instructions on the web page below before installing. This page will tell you how to configure your external database: Timesheet 5.5.2 and External Databases.
  • Using SQL Server 7 as an external database will fail unless it was installed with the correct case-sensitive "collation name." It is the same collation that was used for Timesheet 5.0. For instructions on setting up a SQL 7 Server with the correct collation please see the Timesheet 5.5.2 external database instructions listed above.

    System Requirements: Hardware
  • These are the minimum supported system requirements for Journyx Timesheet with Internal Database installed. The requirements are decreased if an external database on a different machine is used.
    • Pentium III class processor or better
    • 256 mb of RAM (system memory) or more is required.
    • Journyx recommends at least 512 mb of RAM for best performance.
    • At least 500 mb of free hard disk space
    • At least 2 gigabytes of disk space are recommended for sites with more than 30 users and the Internal Database.
    • If the machine will be hosting other websites or applications besides Journyx Timesheet then the system resources will need to be increased appropriately.
    • If you have any questions please email support@journyx.com.

    System Requirements: Operating System
  • Journyx Timesheet can be installed on any of these unix platforms:
    • Solaris v2.5.1, 2.6, 7, 8
    • Linux Redhat 6 / Kernel 2.2.x / GNU Libc 2.1.x
    • Linux Redhat 9 / Kernel 2.4.x / GNU Libc 2.3.x (aka libc 6)
    • FreeBSD v2.1.7, 3.2
    • AIX v4.3.3
  • Journyx Timesheet CANNOT be installed on any version of Windows 95, Windows 98, or Windows ME (Millennium Edition.) A Windows Server system is required to host the application. All versions of Windows may be used to access the software through a web browser.
  • Journyx Timesheet requires one of these Windows server platforms:
    • Windows NT 4.0 - Service Pack 6a is required
    • Windows 2000 (any edition)
    • Windows XP
    • Windows Server 2003 (any server edition)

    Other Windows Installation Requirements
  • You must have "Administrator" rights on the system to install Journyx Timesheet. (Your user must be a member of the local Administrators group.)
  • Timesheet installations that will be used for more than demo purposes require Internet Information Server (IIS) and the Active Server Pages (ASP) feature. These are Windows system components, and they may be found on your Windows installation media, or the Option Pack CD for Windows NT 4.0.
  • You may install IIS by going to the Control Panel, then Add / Remove Programs, then 'Add / Remove Windows Components.' The exact location of the IIS feature may vary depending on your operating system. If you have any doubt, please contact your system administrator or support@journyx.com.
  • Please note that the Active Server Pages feature is not installed by default on Windows Server 2003.
  • Please note that when installed under IIS Journyx Timesheet will only install to an existing Web Site. If you wish to make your Journyx Timesheet site show up on a specific IP address or port number then that site must already be configured in IIS. See 'Configuring the Web Site' below.
  • Journyx strongly recommends temporarily disabling all virus scanners and performance monitors while installing Timesheet, especially if you are installing the Internal Database feature. It is fine to run virus scanners after installing. However, if your virus scanner is not properly configured, it may seriously degrade the performance of Journyx Timesheet.
  • The Timesheet installer will detect most virus scanners and prompt you to stop their NT Service. In most cases, these will be restarted automatically after you reboot. (A reboot is required before Journyx Timesheet setup completes.)

    Windows Installation
  • Journyx strongly recommends rebooting your machine before installing Journyx Timesheet. This may help to avoid problems with previous installations of other products that never completed.
  • If you have uninstalled an older version of Timesheet (4.6 and earlier), it may leave behind a registry key, and therefore you will get a warning when running the Timesheet 5.5.2 installer that a version of Timesheet may be installed. You can ignore this warning; click OK to continue. However, do not continue if the older version actually is currently installed; you must remove this version before installing Timesheet 5.5.2. Before doing that, be sure to read the migration instructions.
  • The Internal Database (MSDE) feature will co-exist with a different installation of MSDE 2000 or SQL Server 2000 on the same computer, but it will not co-exist with a different SQL Server 7 installation on the same computer. You must either a) remove SQL Server 7 and use the MSDE Internal Database or b) use the SQL Server 7 external database without installing MSDE. However, if you wish to use SQL Server 7, you must make sure it was installed with the correct collation name, or else you must re-install that product. (See the databases note above.)
  • The Journyx Timesheet installer includes a 'Quality Feedback' feature. This feature sends installation "milestone" information to the Journyx website as a simple web page request to help Journyx evaluate installer quality and to identify areas of technical concern. No private or personal information is collected or transmitted by the Quality Feedback feature. The feature may be disabled by un-checking the box on the first screen on the Installer.
  • The installer may appear to pause at the "Configuring Windows Installer" action. This is normal; please be patient as Setup must unpack a large number of files from the archive. The installer may also seem to pause at 90% to 100% of the progress bar as it "configures services." This is normal.
  • After the installer is complete, you will be required to reboot your computer. You have the option of rebooting later, but you cannot use Journyx Timesheet until you reboot. When you reboot and log in, the installer will run a final setup action that initializes Timesheet. This action will run only once, and you must complete it before you can use Timesheet. Your computer may appear to be "frozen" or "thinking" temporarily when the InstallShield dialog appears after rebooting.
  • This setup action will launch a script (text) window to configure your system, web server and database for Journyx Timesheet. This "Integration script" can be run at any time by clicking "Setup Web Server and Database" from the Journyx Timesheet menu under Start -> Programs.

    Configuring the Website
  • Journyx Timesheet is a web application and installations that will be used for other than demo purposes require the Internet Information Server (IIS) and Active Server Pages (ASP) feature on Windows. IIS can serve multiple separate web sites, possibly on different addresses. Journyx Timesheet will only install on an existing website. If you want Timesheet to be served from a particular port number, you MUST configure a website with that port. Journyx Timesheet is not capable of creating a new IIS web site for you; it can only install to an existing site.
  • If you are installing on Windows 2003 then please see this special note about IIS 6 on Windows 2003.
  • Note that only certain editions of Windows allow you to create multiple web sites. If you only have one web site available, the Timesheet Integration will NOT prompt you for a website. It will automatically select the only available site. If multiple sites exist, you will be prompted to select the site for Timesheet.
  • Timesheet will create two new virtual directories on your chosen website: /jtime and /icons.
  • You may remove Timesheet from a web site at any time by simply deleting these virtual directories in the IIS Administration tool. You can then re-run the Integration script (see above) and select a new website where Timesheet will live.

    Configuring the Database
  • If the Internal Database feature is selected, there will be nothing to configure here. Otherwise, you will be asked for connection information for your external database.
  • Please note that Journyx Timesheet uses ODBC to connect to the database. The Data Source Name (DSN) entry for your external database must already exist as a System DSN. If you need to create a new DSN, you must cancel the Integration script, create a System DSN, and then re-run the Integration. (See above.)
  • If you are not sure about how to create a System DSN or connect to your external database, please talk to your local database administrator or email support@journyx.com. Be sure to read the information on the Timesheet 5.5.2 and External Databases page before installing to an external database.

    Configuring Your Timesheet Data
  • After your website and database are configured, the Integration script will ask you if you want to set up a new 'clean' Timesheet site with the default initial configuration, or if you wish to restore a site from an existing backup file. You can also click Cancel at this point, and nothing will be done. (It will not modify the database at all, but your Timesheet site will not work correctly in most cases. This option should only be used when following instructions from Journyx Support.)
  • When the Web Server and Database Setup completes, you will be taken to the Timesheet Configuration Quickstart screen. However, you must first log in to the product. If you did a 'clean' install, your Timesheet administrator account login name and password will be the same as your Windows username. If you restored a database, your username and password will be the same as in your previous site.
Performing The Installation
  1. Log on to the Windows machine that will serve as the Timesheet host machine as the Windows account defined above in the prerequisites.
  2. Double-click on the install image downloaded from the Journyx website.
  3. Once the installer is started, you will be prompted for installation information:
    • On Windows 2000 Server, Windows Advanced Server and Windows Server 2003, you will be asked to enter a port number if you have more than one website configured (see Configuring the Website above). This number will be part of the Web address you use to access Journyx Timesheet. The default is 80, which is the default website for IIS.
    • On 2000 Professional, Windows XP and Windows NT Workstation, you cannot choose a port number, so Journyx Timesheet is installed on the port 80, which is the default.
    Please Note: The selected port and the 8 subsequent port numbers must not be used by any networking services other than Journyx Timesheet and IIS. Therefore, if you choose to install Journyx Timesheet on port 90, ports 91 through 98 must also be available.
  4. On all platforms, Timesheet will ask you to specify the install location (the default is C:\Program Files\Journyx).
  5. Upon completion of setup, you will be required to reboot the Timesheet host machine. When it is fully rebooted, the Database Setup will automatically run.
  6. Timesheet will display the database setup screen in your default browser. You may also run this manually by clicking on "Setup Web Server and Database" from the Journyx Timesheet menu under Start -> Programs. This screen allows you to specify which database you would like to use with Timesheet.

    Congratulations! Once you have completed the Database setup, you have successfully installed Timesheet 5.5.2. If this is your first time using Timesheet, please refer to the Configuration Quickstart on the main Admin page of Journyx Timesheet to get up and running.

    If you are migrating to Timesheet 5.5.2 from a previous version, see the migration documentation.