Home | Products | Support | Subscriptions | About | Contact

INSTALLATION GUIDE

It typically takes not more than a minute to perform an install to your system.
 

Personal TimeSheet consists of a simple client install and you are required to setup and configure projects and activities, and maintain drop down lists, templates, reporting settings etc. in a Project database. And only then you would be able to prepare timesheets in Outlook and publish to the project database.

Download link:
https://www.assistmyteam.net/PersonalTimeSheet/download.asp
 

There are two different setup types:
 

For 'Per User Installation' (ideal for standalone single user/workstation)
PersonalTimeSheetSetup_x86.zip (for 32-bit Outlook 2007, 2010, 2013, 2016)
PersonalTimeSheetSetup_x64.zip (for 64-bit Outlook 2010, 2013, 2016)

The downloaded zip file contains one setup file:
PersonalTimeSheetSetup_xXX.exe
where ‘xXX’ can be either x86 (32-bit Outlook) or x64 (64-bit Outlook)


Extract these file contents to a file folder. It is recommended that you place the setup files on a file folder, such as your desktop for quick access to it, and ease the installation and upgrade process.


Before continuing with the installation, don't forget to go through the System Requirements page. For version numbers and changes history, refer to the Version History page.
 

Part I: Files Installation Part II: Database Configuration


Part-I: Files Installation

 

Step 1. Run the PersonalTimeSheetSetup_xXX.exe to start the installation. Click 'Next' to Continue. If Outlook 2007 or later is not installed, the setup wizard will not be able to proceed. Please also ensure Outlook is shutdown (if already running or active in the task manager) as the setup has to install an Outlook add-in.



Step 2. Select the appropriate destination folder where the application files will be installed. If you change the default folder path, please make sure you have appropriate permission. (Note: by default, it will be installed under your application data folder)

 

Step 3. Click 'Next' to continue with the files extraction. It just takes a few minutes to complete the whole copying process

 

Step 4. Click 'Finish’. This ends the files installation process in your system. Now start Microsoft Outlook

 

b) Project Database Configuration

The next step is to choose a database option and configure it to store the project metadata such as project/activity lists, notification options, email templates, members list, reporting settings etc. as well as other global settings that streamline the behavior on you work, track and publish their timesheets in Outlook.

If you have just installed the Personal TimeSheet tool, you will get to see this ‘Project Data Source’ Settings dialog when you start Outlook.

Or you can get to this from Outlook > the backstage File > Personal TimeSheet > Project Data Source button.



You can choose a project database between a Microsoft Access (MDB file) to a Microsoft SQL Server, or Azure SQL Database (cloud db).

i) Using Microsoft Access - If you choose ‘Microsoft Access’, the database file (e.g., PersonalTimeSheet.MDB) will need to be placed on a file folder. When you specify the location where the MDB file is to be created, make sure you choose a valid folder from your computer or from another computer (shared folder). Note that it is recommended to use a UNC path if it is a network path e.g. \\AMTServer\TimeSheets instead of a mapped one because, a mapped drive might only be accessible to you.
 

 

ii) Using Microsoft SQL Server - You can also use a dedicated SQL Server database option..

For SQL server, the server name is mandatory. The Database name is optional. If it is left empty, a new database with the name ‘PersonalTimeSheetDB’ would be created. If your SQL server is configured to use windows authentication (NTLM), then you can check the ‘Use Integrity Security’ option to let Windows manager the credentials to access the resources on the SQL server.
 

Permission for users on the SQL database - You should have both db_datareader and db_datawriter permission on the TimeSheet SQL database.


iii) Using Microsoft Azure SQL – Azure SQL Database is a cloud-based relational database service from Microsoft, which is based on SQL Server database. This option is ideal if you work remotely in different locations but have access to the web.



NOTE: If no database name is mentioned, the manager add-in will create a new database in your Azure SQL server, by the name of 'PersonalTimeSheetDB’.
 

Once you click ‘Save’, the manager tool will automatically create the chosen database (if it does not exist already). And then any project metadata and other settings/drop down lists you defined from TimeSheet add-in in Outlook would be saved in this repository.



NOTE: There are other administrative configurations that you would need to undertake. These options are available in the ‘Personal TimeSheet ’ menu in Outlook. For more references and helps on performing these administrative configurations, refer to the PDF Help Manual, which can be invoke from the Personal TimeSheet > Help Topics.

You can also download the full PDF help manual directly from this link:
https://www.assistmyteam.net/downloads/Manuals/PersonalTimeSheet.pdf

 
 
Copyright © 2018 AssistMyTeam. All rights reserved.
ENTERPRISE LICENSING | SERVICES | KNOWLEDGE BASE | BLOG | FREE LICENSE | ABOUT