What is jWorkSheet?
jWorkSheet is an open source personal desktop time tracker for your projects, data are presented in a spreadsheet like format. Application offers some completed work sheet reports, however you can create your own user reports by XSL transformations.

System requirements
  • Minimum JRE: 1.6.0


jWorkSheet on an eComStation machine with Open JDK


Installing jWorkSheet
Download jWorkSheetSetup.0.90.zip. Make a directory/map with the name "jworksheet". Unzip the zip file to the directory "jworksheet". That's all! Delete the files "file.jnlp", "JWorkSheet.exe", "JWorkSheet.sh" and "jWorkSheet.vbs", they are for other OS systems.

The used cmd file
jWorkSheet works with Open JDK in OS/2-eCS. I have a "jworksheet.cmd" file with the following contents;
@echo off
set BEGINLIBPATH=[drive: java]\JAVA160ga5\bin
set path=[drive: java]\JAVA160ga5\bin
set CLASSPATH= 
[drive: jworksheet]
cd [drive: jworksheet]\jworksheet
java -Duser.home=[drive: jworksheet]\jworksheet -Xmx180m -Xms32m -jar jWorkSheet.jar 2>jworksheet-bugs.txt 
I use 2 separate folders (directories), one for Java and one for jWorkSheet with the files created by this program. The references used in the cmd file;

  • [drive: java] = drive with Java
  • [drive: jworksheet] = drive with jWorkSheet

should be replaced with real drive letters. Save the file and name it "jworksheet.cmd" or use the file from the distribution. This file is copied to the "jworksheet" folder (directory). Furthermore, different paths?, adjust according to your needs.
Create a new program object. Specify the path and file name: "[drive: jworksheet]\jworksheet\jworksheet.cmd". In the tabpage Session check the boxes "OS/2 window", "Running as an icon" and "Close Window to end program". In the tabpage General you can enter the name "jWorkSheet".

Parameters / options explained
  • The statement "-Duser.home=[drive: jworksheet]\jworksheet" will ensure that jWorkSheet will save all necessary files in own directory instead of saving them in the home directory.
  • The "-Xms32m" specify the initial size of the memory allocation pool. The value comes from the file "JWorkSheet.sh".
  • The specification "-Xmx180m" indicates the maximum limit of the used memory. This value comes also from the file "JWorkSheet.sh".
  • The addition "2>jworksheet-bugs.txt" ensures that errors are saved in the file "jworksheet-bugs.txt". The 2 in "2>" is not a typo!

Download
In the file you can find the above command files (all drive letters are on set to C:) and an OS/2 jWorkSheet icon: jworksheet-ecs.zip.

revision August 20, 2016