Helpful Tips
June 2002
Backing Up a Database
Unfortunately disasters happen. The machine on which all your Journyx Timesheet product information is stored could be struck by lightning, contract a virus, or fall victim to a flood at any time. Despite all of your precautions and preparations, this will happen at the most inopportune moment. To minimize your losses, it is important to maintain a backup of your database. Journyx Timesheet has a utility for backing up and restoring your time and expense database.
On Windows, in a DOS shell, run the backupdb command from the jwt\bin directory (usually C:\jtime\jwt\bin\backupdb in versions 4.x and earlier - C:\Program Files\Journyx\jwt\bin\backupdb in versions 5.x). By typing just backupdb you will see the available options and the necessary parameters. When specifying the backup filename, you must enter the full path. So, your command will look something like this:
c:\jtime\jwt\bin>backupdb -v -x c:\jtime\backupfile.out
(which will create a backup file called backupfile.out in your c:\jtime directory)
On a Unix machine, you run the backupdb command in the $WTHOME/pi/bin directory. As with the Windows version, typing backupdb will display the available options and the necessary parameters. When specifying the backup filename, you must enter the full path.
The backup process can take from one minute to a few hours, depending on how much data you have stored in the product. Employees will be unable to login to Timesheet during this period.
What is Cube Reporting and how do I to use this new feature?
Journyx Timesheet Cube Reporting is a dynamic report output format that allows you to sort and view your data on-the-fly. Cube Reporting makes it easy to change the subtotal options of a given report in real time. Further, you can sort your results or hide individual users, dates, tasks and the like. Finally, the Cube Report format also allows you to export the results of a specific report directly to Excel, where you can have complete control over the data to make graphs or drill down more completely.
In order to view reports in Cube format, the computer that you are using to access Journyx Timesheet must have a Windows operating system with Microsoft Office 2000 or later, including the Office Web Components module, installed. Additionally, you must use Internet Explorer 5.0 or greater to view Cube Reports successfully. Finally, Internet Explorer must be configured to access data sources across domains. For help configuring this IE security option, please contact your organization's IT department.
Helpful Hint: When you export a Cube Report formatted report from Timesheet into Excel, the complete selection of raw data covered by that report is also exported - usually to Sheet 2 in the workbook that is created during the export process.
To modify the subtotal option dynamically, click the Field List Button on the report toolbar. The Field List screen will be displayed and you will be able to select additional fields to show in the report. Initially, only the fields that are included in the report are displayed in the report proper; however, by default, all standard fields will be listed in the Field List Screen and are available to add to the active Cube Report. Simply drag the desired field from the Field List screen to the Filter Fields portion of the Cube Report. Timesheet will automatically recalculate the report based on the choices you make.
To export the data displayed by a Cube Report to Excel, click the Export To Excel Button on the report toolbar. You may receive a security warning from IE indicating that the data you are about to transfer is located in another domain. If you do receive this warning, you may safely click "Yes" to continue. Once the data has been exported to Excel, you may work with it freely, independent of Timesheet.
