Quick Links

Self-Hosted Help

Top Self-Hosted Items

Installation Guide

This document provides information on installing or upgrading the self-hosted version of Web TimeSheet. It includes step-by-step installation and upgrade procedures, as well as details of the system requirements and optional system configuration.

If you are using a pre-8.14 version of Web TimeSheet, refer to the documentation archive for system requirements specific to your version.

Download in PDF format

Was this helpful?

Back to Top

Quick Start Guide: Importing Data into Self-Hosted Implementations

This document offers a short overview of how to use Web TimeSheet’s data import utility. Self-hosted users can use this tool to add, modify, or delete large amounts of Web TimeSheet data. If you are a SaaS (Replicon-hosted) user, contact Replicon Support for information on performing bulk imports.

Download in Word format

Download in PDF format

Was this helpful?

Back to Top

Web TimeSheet Data Import Utility User Guide

This guide provides detailed information on using the import utility. This utility is for use with self-hosted versions of Web TimeSheet only. For information on carrying out bulk imports in SaaS implementations, refer to the Web TimeSheet online help, or contact Replicon Support.

If you are using a pre-8.14 version of Web TimeSheet, refer to the documentation archive for system requirements specific to your version.

Download in PDF format

Was this helpful?

Back to Top

How do I install Microsoft Message Queuing (MSMQ) on our Web TimeSheet server?

Microsoft Message Queuing (MSMQ) is required on servers running Web TimeSheet version 8.22 and higher. This component is easy to install; refer to Installing Microsoft Message Queuing in the Web TimeSheet Installation Guide for the steps involved.

Was this helpful?

Back to Top

Application Note: Ensuring Support of Unicode Characters in Web TimeSheet Report PDFs

In some cases, Unicode characters display incorrectly in Web TimeSheet report PDFs; the expected Unicode characters may fail to display, or may be replaced by “junk” characters. This issue occurs if the font set that supports these Unicode characters is not installed on the Web TimeSheet server.

If you encounter this issue, you can fix it by installing the necessary fonts. There are two options:

Option 1: Obtain and install the default fonts

The default fonts that Web TimeSheet is configured to use are typically installed along with the Microsoft Office suite. To install these fonts on the server:

  1. From a machine that has Office installed, copy and paste the Windows Fonts folder (typically located at C:\WINDOWS\Fonts) to a new location.
  2. From the new folder, copy the fonts that have the following filenames:
    • ARIALUNI.TTF
    • ARIALUNI.TTF
    • ARIALI.TTF
    • ARIALBI.TTF
  3. Paste the font files into the Fonts folder on the Web TimeSheet server.

Option 2: Obtain and install an equivalent font set

Deja Fonts is an example of an equivalent font set. To install and configure these fonts:

  1. Download the font set from: http://prdownloads.sourceforge.net/dejavu/dejavu-ttf-2.16.zip?download.
  2. Unzip the font set, and copy the fonts with the following file names:
    • DejaVuSans.TTF
    • DejaVuSans-Bold.TTF
    • DejaVuSans-Oblique.TTF
    • DejaVUSans-BoldOblique.TTF
  3. Paste the font files into the Fonts folder on the Web TimeSheet server.
  4. Stop the Web TimeSheet service.
  5. Open Web TimeSheet’s ApplicationSettings.config file (typically located at C:\Program Files\Replicon Inc\Web TimeSheet\APP), and find the code:
    • <appSettings>
      • <add key="UseCustomFonts" value="true" />
      • <add key="NormalFont" value="ARIALUNI.TTF" />
      • <add key="BoldFont" value="ARIALBD.TTF" />
      • <add key="ItalicFont" value="ARIALI.TTF" />
      • <add key="ItalicBoldFont" value="ARIALBI.TTF" />
  6. Change the code to read:
    • <appSettings>
      • <add key="UseCustomFonts" value="true"/>
      • <add key="NormalFont" value="DejaVuSans.TTF"/>
      • <add key="BoldFont" value="DejaVuSans-Bold.TTF"/>
      • <add key="ItalicFont" value="DejaVuSans-Oblique.TTF "/>
      • <add key="ItalicBoldFont" value="DejaVUSans-BoldOblique.TTF"/>
  7. Restart the Web TimeSheet service.

Was this helpful?

Back to Top

Application Note: Exporting Extended Characters from Non-Latin Character Sets to Excel

Excel and the CSV formats sometimes display incorrect extended characters for non-Latin character sets (such as Cyrillic and Arabic). For example, when Web TimeSheet report data is exported to Excel, characters such as ł and ź are typically converted to the closest Latin character.

If you need to export non-Latin extended characters to Excel, follow the procedure below. It involves making a simple change in your database, and then saving Excel reports and importing them from within Excel. Note that the database change will alter how Excel reports are generated for all Web TimeSheet users.

To export non-Latin extended characters to Excel:

  1. In the SYSTEMPREFERENCES table of your Web TimeSheet database, change the PREFERENCEVALUE setting for the CSV.Unicode variable to “1”.

Once this option has been enabled in the database, exported files must be saved and then opened from within Excel. Files can no longer be opened in Excel directly.

To export data and view it in Excel:

  1. Generate the report in Web TimeSheet, and select the Excel button.
  2. Save the file to a known location.

    To prevent users from attempting to open the file directly in Excel, you can save it with a different extension (such as .tsr, for timesheet report).

  3. Within Excel, select File > Open… from the menu.
  4. In the Open dialog box, select All Files (*.*) in the Files of type field.
  5. Locate the file you saved in step 3 and select Open. The Text Import Wizard dialog box displays.
  6. In the File origin drop-down list box, select 65001: Unicode (UTF-8).

  7. Select Next.
  8. In the Delimiters section, clear the Tab check box and enable the Comma check box.

  9. Click Finish.

Was this helpful?

Back to Top

Application Note: Limiting the Occurrence of Low Memory States when Creating PDF Reports

If you are using version 7.5 Service Release 1 or higher of Web TimeSheet and your database contains large amounts of data, Web TimeSheet may enter a low memory state when users create PDF reports.

You can reduce the chances of Web TimeSheet entering a low memory state by carrying out the following procedure:

  1. Open ApplicationSettings.config using a text editor (for example, Notepad).

    The ApplicationSettings.config file is typically located at C:\Program Files\Replicon Inc\Web TimeSheet\APP.

  2. Change:

    <add key=”PDFOutofProcess” value=”false”/>

    to:

    <add key=”PDFOutofProcess” value=”true”/>

  3. Restart the Web TimeSheet service.

Note that this change may negatively impact performance and cannot be carried out for individual SaaS clients.

Currently, changes to settings in the ApplicationSettings.config file are not retained upon upgrade or migration of Web TimeSheet, therefore you will have to carry out this procedure again after upgrading.

Was this helpful?

Back to Top

Application Note: Preventing Errors that Occur when FIPS Validation is Enabled in Windows

Federal Information Processing Standards (FIPS) are United States federal government standards used by government agencies and contractors. If the FIPS-validated cryptographic algorithms setting is enabled in Windows XP or later, an error occurs when the user accesses .aspx pages in Web TimeSheet version 7.1 or higher.

The error would look something like this:

[InvalidOperationException: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms.]

System.Security.Cryptography.RijndaelManaged..ctor() +1494665

System.Web.Configuration.MachineKeySection.ConfigureEncryptionObject() +337

System.Web.Configuration.MachineKeySection.EnsureConfig() +200

System.Web.Configuration.MachineKeySection.HashData(Byte[] buf, Byte[]

System.Web.Security.CookieProtectionHelper.Encode(CookieProtection cookieProtection, Byte[] buf, Int32 count) +35

System.Web.Security.AnonymousIdentificationModule.GetEncodedValue(AnonymousIdData data) +208

System.Web.Security.AnonymousIdentificationModule.OnEnter(Object source, EventArgs eventArgs) +1606

System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +138

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +65

Note that when the user generates PDF reports, Web TimeSheet automatically catches the FIPS error and allows PDFs to be generated. However, the PDFs will be shown as unlicensed, with a watermark and message at the top of each page.

Preventing this Error in Web TimeSheet’s main .aspx pages

To prevent this error from occurring in Web TimeSheet’s main .aspx pages, the user can carry out one of the following options:

Option 1: Disable the FIPS validation setting on the Web TimeSheet server

  1. In Windows’ Control Panel, select Administrative Tools > Local Security Policy. The Security Settings window displays.
  2. From the side menu, select Security Options.
  3. Double-click the System cryptography: Use FIPS compliant algorithms for encryption, hashing, and signing option.

  4. Select the Disabled button.

  5. Select OK.

Option 2: Make a small addition to Web TimeSheet’s Web.config file

  1. In a text editor such as Notepad, open Web TimeSheet’s Web.config file (typically located at C:\Program Files\Replicon Inc\Web TimeSheet\APP).
  2. Add the following text to a new line beneath the <system.web> tag:

    <machineKey validationKey="AutoGenerate,IsolateApps" decryptionKey="AutoGenerate,IsolateApps" validation="3DES" decryption="3DES"/>

  3. Save the Web.config file.
  4. Restart the Web TimeSheet service.

Was this helpful?

Back to Top

I’m using an older version of Web TimeSheet. Where can I find documents for my version?

If you are a self-hosted customer using a pre-8.14 version of Web TimeSheet, you can find documents specific to your version in the Documentation Archive.

Or, you may refer to the current version’s documents located on Replicon’s main Support pages, since many issues facing pre-8.14 users are addressed in the current documents.

Was this helpful?

Back to Top

How do I migrate Web TimeSheet from one machine to another?

You can move Web TimeSheet from one server to another and retain existing data by following the steps below.

On the original (source) server:

  1. Ensure that you have Administrator access to the Web TimeSheet server and access to the database.
  2. Find your Web TimeSheet installation executable file.

    3. You can find the executable for the latest version at: http://www.replicon.com/support/updates/employee-time-tracking-software.aspx.

    If you want to use an older version but no longer have its executable file, contact Replicon Support to obtain a copy.

  3. If you are upgrading to the latest version, carry out the upgrade on the source server.
  4. Stop the Web TimeSheet service.
  5. Backup your database (or, if you are using Oracle, export your Oracle user schema).

Then, on the new server:

  1. Transfer the backup copy of the database to the new machine.
  2. Restore the database on a SQL Server instance (Or, import the user schema you created to a newly created user schema).
  3. If using SQL Server, create a new SQL Server authentication login, with a dbo permission set, mapped to the new Web TimeSheet database.

    4. This step is not required if you are using Windows Authentication or Oracle.

  4. Install Web TimeSheet on the new machine.

    5. During the installation:

    • Choose the ‘Upgrade’ option
    • Use the restored database as your source database. You will have to enter the database server name and database name. If you're using SQL Server authentication, you will also have to enter the uid and password.
  5. Restart the Web Timesheet service.

Finally, on the source server:

  1. Once the installation is completed successfully, uninstall Web TimeSheet from the old server or disable its service to prevent users from entering data against the old instance.

For help installing the application, refer to the appropriate version of the Web TimeSheet Installation Guide, or, if you are using a pre-8.x version, the Web TimeSheet User Guide. Archival versions of these documents are available in Web TimeSheet’s Documentation Archive.

If you have any questions about this procedure, contact Replicon Support.

Was this helpful?

Back to Top

How can I change the Windows authentication account?

If you are using a SQL database with Windows authentication, follow the steps listed below if you want to change the Windows authentication account.

  1. Open Windows' Services control panel.
  2. Right-click on the Web TimeSheet service and select Properties.
  3. Select the Log On tab.
  4. Specify the correct account by selecting either:
    • The Local System account option, or
    • The This account option and browsing to the account location.

Was this helpful?

Back to Top

How do I change Web TimeSheet from SQL authentication to Windows authentication, or vice versa?

Authentication type is typically selected during installation. To change the authentication type after installation:

  1. Open the web.config file using a text editor (such as Notepad). This file is typically located at C:\Program Files\Replicon Inc\Web TimeSheet\APP.
  2. Find the code: <repliconConnectionStrings>
  3. In the line immediately following <repliconConnectionStrings>:
    • If you want to use Windows authentication, set the value of the Trusted_Connection field to true
    • If you want to use SQL authentication, do not include a value in the Trusted_Connection field
  4. Restart the Web TimeSheet service.

Was this helpful?

Back to Top

How do I enable Active Directory or Windows NT authentication in Web TimeSheet?

To enable Active Directory or Windows NT authentication for a user:

  1. Select Administration from the top menu, and then select System > System Preferences from the side menu.
  2. Check the Enable Windows NT/Active Directory login verification check box.
  3. Select Save.
  4. Open the user’s Edit User page.
  5. From the Authentication Type drop-down on the Login section, select Windows NT/Active Directory Domain.
  6. Enter the domain name in the Domain field.
  7. Change the user's login name to match their Windows NT or Active Directory login name.

Was this helpful?

Back to Top

How do I set up virtual directories for IIS?

If you choose to use an Internet Information Services (IIS) server, you will need to install and configure Internet Information Services (IIS) on your computer. Instructions on creating the IIS website and setting up virtual directories are available in the Web TimeSheet Installation Guide.

Was this helpful?

Back to Top


Could not find what you were looking for?

Our Support Team is here to answer any questions you may have 24/7.
Email: support@replicon.com

Call Toll Free:

North America: 1-877-862-2519
Outside North America: +800 8622 5192
Online: Request Help >>