Version: 8.6.117.0
Release Date: 25th May 2022

Changes in build 8.6.112.0:

• ADDED: Support for Outlook 2019.
• FIXED: If you had enabled ‘ReportBy’ field of the TimeSheet database to be populated with the username of the shared mailbox, rather than the current user, the ‘Last Published’ info in timesheet form in the already published appointment item shows the current user rather than the username of the shared mailbox.
• FIXED: The following errors have been fixed:

  Team TimeSheet Common Library: 8.6.110.0 
  In Outlook version: 16 (x64) 
  At Line: 160 
  In Function: Actions.AssignDateToItem 
  Source: 
  Exception Description: The object does not support this method. 
  Exception Number: -2147352567 
  OS:10.0.17134.0 (Win32NT) 
  Outlook Version: 16 
  Additional Info: Team TimeSheet Common Library: 8.6.110.0 
  
  
  In Outlook version: 16 (x64) 
  At Line: 400 
  In Function: MyProjects.cmdNewTask_Click
  Source: 
  Exception Description: An item with the same key has already been added.
  Exception Number: 5
  OS:6.2.9200.0 (Win32NT)
  Outlook Version: 16
  Additional Info:

  FIXED: If you get the following error, refer for a possible workarounds as stated in this KB article #490:

  Team TimeSheet Common Library: 8.6.110.0 
  In Outlook version: 16 (x64) 
  At Line: 130 
  In Function: DB.Initialize
  Source: Microsoft Office Access Database Engine Message :The database has been placed in a state by user 'Admin' on machine 'ZZZZ' that prevents it from being opened or locked.
  Outlook Version: 16
  Additional Info: strConn=Provider=Microsoft.ACE.OLEDB.12.0;Data
  Source=\\ZZZ\TeamTimeSheet.mdb

Changes in build 8.6.111.0:

• FIXED: If you click the ‘All Fields’ button on the timesheet form in Outlook, the custom fields section is empty (even though you have defined one or more custom fields)

Changes in build 8.1.5.109:

• FIXED: Because of a recent update of Microsoft Office, your timesheet form in Calendar/Task folder in Outlook might display as blank and there might be a separate popup panel where the timesheet fields (project, activity etc) are shown. The fields withint the popup panel might not be usable too. We have applied a quick fix to this issue with this update.

Changes in build 8.0.4.108:

• Reports and Search now show sub-total of Rate, Duration, TotalCost, BillableHours columns.
• FIXED: If a timesheet record in the database contains a single quote eg., O’Michael, the reports or search return with the following error:

  Team TimeSheet Common Library: 8.0.4.107 
  In Outlook version: 15 (x86) 
  At Line: 130 In Function: DB.GetRecordset
  Source:
  Exception Description: Incorrect syntax near 'xxxxxx'.
  Unclosed quotation mark after the character string ')'.
  Exception Number: 5
  OS:6.1.7601.65536 (Win32NT)
  Outlook Version: 15

Changes in build 8.0.4.104:

• Fixed the error when trying to publish an Outlook task item to timesheet database.

  Team TimeSheet Common Library: 8.0.4.103 
  In Outlook version: 14 (x86) 
  At Line: 640 
  In Function: TaskData.ReadDataFromRDOItem 
  Exception Description: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Outlook.UserProperties'. 
  This operation failed because the QueryInterface call on the COM component for the interface with IID '{0006303D-0000-0000-C000-000000000046}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). OS:6.1.7601.65536 (Win32NT) 
  Additional Info:

• Fixed the error when searching published timesheets in database from the add-in.

  Team TimeSheet Common Library: 8.0.4.103 
  In Outlook version: 14 (x86) 
  At Line: 130 
  In Function: DB.GetRecordset
  Source:
  Exception Description: Syntax error (missing operator) in query expression 'Samples Cost'.
  Exception Number: 5
  OS:6.1.7601.65536 (Win32NT)
  Outlook Version: 14
  Additional Info: Source Table=SELECT ID,Subject,Approved,ApprovedBy,StartDate,ProjectValue,ActivityValue,TotalCost,DueDate,TotalWork..

• Fixed the error the following error:

  Team TimeSheet Common Library: 8.0.4.103 
  In Outlook version: 15 (x86) 
  At Line: 40 
  In Function: DataStructure.IsJustCreated 
  Source: 
  Exception Description: Object variable or With block variable not set. 
  Exception Number: 91 
  OS:6.1.7601.65536 (Win32NT) 
  Outlook Version: 15 
  Additional Info:

Changes in build 8.0.4.100:

• Fixed the issue whereby you were unable to publish appointments from Outlook to database.

Changes in build 8.0.4.95:

• Auto Fill or Auto Complete feature – Added feature to type in the first few characters of your project or activity in the drop down boxes so that the drop down field pulls up all the matching items from which you can choose one to auto-complete. This feature might come very handy if you have hundred of projects/activities to choose from the drop down list (so finding one can be time consuming (relatively speaking.) My specialty app programmer has created a way to enter 4-5 characters in a field, press enter, and it pulls up the first 10 matching items.

  

  To enable auto-fill/auto-complete feature, the administrator needs to enable the option ‘Allow members to type in into Project/Activity drop down boxes for auto complete‘ under Team TimeSheet Manager > Form Options.

  
  

Changes in build 8.0.4.93:

• New comprehensive help manuals for timesheet Administrators (TeamTimeSheetManager.pdf) and Client Users (TeamTimeSheetClient.pdf) included in the setups.

  To invoke or show the PDF manual on Admin add-in, go to Outlook > Team TimeSheet Manager tab > Help Topics.
  To invoke or show the PDF manual on Client User add-in, go to Outlook > Calendar or Task folder > Team TimeSheet toolbar > My Settings menu > Help Topics.

  or you can also download the PDF manuals from below
  Administrator Help Manual
  Client User Help Manual

• Fixed the issue where timesheets from other users show up in the search/report in Team TimeSheet client add-in.

Changes in build 8.0.4.92:

• New revamped ‘Search TimeSheets’ tool. A variety of search parameters are predefined to help you find your published timesheets easily and quickly. You can also limit the search to your published timesheets only by choosing ‘My TimeSheets’ scope.

  

  Time Period: Choose a time period from the followings under which the search will be confined:
  Any
  Today
  Yesterday
  Tomorrow
  This week
  Last Week
  Next Week
  This Month
  Last Month
  Next Month
  This Year
  Last Year
  Date Range…
  On

  Report Type: Choose a report type from the predefined ones below:
  Any
  TimeSheets Starting
  TimeSheets Ending
  TimeSheets Reported
  TimeSheets Ongoing
  TimeSheets Approved
  TimeSheets Declined
  TimeSheets Pending Approval
  TimeSheets Completed
  TimeSheets with Empty Project
  TimeSheets with Empty Activity

  Search By: Further refine the search by filtering through keywords or using one of the following timesheet fields: Project/Activity, Reported By, Duration, Billable Hours, Importance, Custom Lists.

  Group By: You can choose to group the timesheets either with:
  Project, Activity, Reported By, Importance, Categories.

  Each timesheet in the search result is color coded to reflect the current state of the timesheet such as if it approved, decline or approval pending. Now, you can easily recognize which timesheets require the attention or review, and plan actions accordingly.

  With this version, you are free to choose which particular timesheet fields/columns show up in the search result and report. Just click the ‘Fields’ button, and choose the wanted columns to include.

  

  You can re-arrange the columns by drag-and-drop to get the kind of view you want. And the display order of the columns will be retained in subsequent sessions.

  You can export cases to files in the following document types:
  Adobe PDF, XPS, Word 97-2003 DOC, Word 2007-2016, DOCX, RTF, ODT or HTML.

  

  You can control what timesheet data are included in the exported files by customizing the ‘Print‘ template under Team TimeSheet Manager > Templates Manager.

• New Summary Reports tool allows for Four modes of views or editing. List, HTML, HTML Editable and Grid. It uses the same sets of search filters discussed above.

  For example, here is what the HTML report view look like:
  

  And here is what the Grid (Excel) report view looks like:
  

  For finer control over the output of report, you can choose which fields (including custom fields) are to be included in the report. You can sort the timesheets by clicking at the column headers, as well as also re-arrange the columns in the list view according to certain sequence of your choice, and even set the width of the columns. These formatting from the List view panel will be inherited on other tabs – HTML, editable HTML and Grids. In short, the List tab acts like a template to the other three tabs.
  

  Once you get the look and feel of your report, you can then export the report to one of the many popular document formats supported such as Microsoft Excel sheets, Word documents, Adobe PDF, Rich Text or web page etc.

  

• The Audit Manager tool has also been revamped for quicker administrative actions on the published timesheets. In fact, the interface and control sets remained the same with the new search/report tool (described above). The only additional features in Audit Manager tool being able to edit, delete, approve or decline timesheets published by your users. You can review the timesheets and make necessary changes and amendments before accepting the timesheets for further processing (say, for payroll).
  

  1. Detail Info – Click this to view finer detail information of the selected timesheet (as available in the project database) in a new window.
  

  2. Edit – Click this to edit the published timesheet. Depending on the permissions as set by the administrator under Team TimeSheet Manager > Audit Options panel, you can edit or make amendment to the published timesheets stored in the project database directly.

  3. Print – Click this to print the selected timesheets using the ‘Print’ template (as defined under Team TimeSheet Manager > Templates Manager). if you select a single timesheet to print, it will show you the print dialog option, where you can customize the layout, paper size etc. However, if you choose multiple timesheets, it will print directly using the default settings without displaying any Print options.

  4. Delete – Click this to permanently remove the selected timesheets from the project database.

  5. Approve – Click this to approve the published timesheets from users. Approved timesheets appear with a green back color for easy recognition. Based on the choice, the add-in may send an alert to the owner (user) of the timesheet informing about the approval.

  6. Decline – Click this to decline the published timesheets from users. Based on the choice, the add-in may send an alert to the owner (user) of the timesheet informing about the decline.

  7. Export to PDF – Click this to export the selected timesheets to PDF document files. You can also export to Word Documents, HTML, plain text etc.

• ADDED: Added two buttons to place the timesheet form left or right side of the inspector window of the opened appointment or task item.
  
• ADDED: Added the ‘Search My TimeSheets in DB’ menu option under Outlook > TimeSheet toolbar > My Settings drop down menu.
• With version 8 release, the duration, billable hours etc. of the published timesheets in the database will always be stored in Minutes format. However, you can change it to show in Hours in Search, Reports and OLAP tool. You can set this preference from Team TimeSheet Manager > Advanced Options >  Show Duration/Billable Hours in database in.
• REMOVED: Removed the explicit impersonation option in TimeSheet Client menu > Local Settings, whereby a user can choose who he/she is from the list of users (defined by the administrator) and accordingly the timesheet client add-in use it when publishing any timesheets to the central database.
• FIXED: If a user has configured multiple Exchange accounts including shared ones, in Outlook, the timesheet add-in may have difficulty picking the primary/correct mailbox user.

Changes in build 7.0.4.86:

• Requires .NET Framework 4.5 or above.
• Supports using of Microsoft Azure SQL database for storing projects as well as timesheets from Outlook: Azure SQL Database is a cloud-based relational database service from Microsoft, which is based on SQL Server database. This option is ideal for team that have users scattered or working remotely in different locations but have access to the web.

  

• Optimize for SQL server database.
• Added a new button ‘Create Copy‘ in the timesheet form in Outlook. Clicking this will create a clone of the current selected or opened appointment/task item along with the project/activity data that might have been tagged previously.
• FIXED: Even if default values are defined under Team TimeSheet Client > My Reporting Options panel, TimeSheet Client add-in does not assign default project/activity or custom fields to new appointment or task items in Outlook
• FIXED: TimeSheet Client add-in throws an error about inadequate permission when you click an appointment from a Shared Calendar in your Outlook.
• FIXED: When SQL server database is offline due to Network issues, TimeSheet Client add-in throws error during Outlook startup.
• Team TimeSheet Client menu in Outlook backstage > File tab is removed in version 7. You can access the Client menu items in TimeSheet toolbar/ribbon in the Calendar or Task folder in Outlook.

Changes as of 2^nd August 2016

• Fixed the issue where newly added projects from the manager addin is not saved to the SQL database (when you had configured SQL database with Team TimeSheet).
• Optimized for Outlook 2016

Changes as of 28^th December 2015

• Supports both 32 bit and 64 bit Outlook 2016 and 365.

28^th August2014 (Version 6.1.2.70)

• Added option to avoid using ‘Billable Hours’ workflow in Team TimeSheet altogether i.e., the add-in will always compute the total cost based on the pre-defined Outlook duration field of the appointment item. For this, we have added a new option under Team TimeSheet Manager > Advanced Options > Total Cost tab, where the admin can choose which field (‘Duration’ or ‘Billable Hours’) is to be used for computing ‘Total Cost’. Optional the admin can also hide the ‘Billable Hours’ field from the timesheet form in Outlook (so as to not confuse the user).
  For more, refer to this KB article – http://assistmyteam.net/KB/index.php?option=com_content&view=article&id=369
• Added the variables ‘Project Manager‘, ‘Activity Coordinator‘ and ‘Rate‘ in Summary Reports and OLAP tool. These 3 new fields are also added to the ‘tReportedAppointments‘ and ‘tReportedTasks‘ tables of the timesheet database.
• Fixed the bug where you are unable to tag or save any project/activity or billable hours or custom fields data to the appointment items (when you have multiple calendars arranged to be viewed in single Outlook explorer window). Only when you view the calendar in Outlook explorer one at a time, it worked. This issue has been fixed in this update.

12^th April 2014 (Version 6.0.2.61)

• Added a side bar form in the Outlook calendar/task folder explorer and inspector window to show the project/activity, billable hours and all the custom fields defined by the manager.

  

  With this form, you can have quick access to the Project/Activity and other custom fields and any changes/editing on the fields are instantly saved to the appointment/task item. You don’t even need to open the appointment item in its inspector window. However, if you use the inspector window to open the appointment/task item, the same form is available.

• Redesigned Auditing feature (Team TimeSheet Manager > Audit Manager). Now, managers can use the ‘Audit Manager’ to approve or decline timesheets submitted by other members in bulk (by checking multiple timesheets and pressing ‘Approve’ or ‘Decline’ button located on the top left portion).

  

• Multiple items tagging (batch tagging) – if you select 2 or more appointment/task items, you could make use of the ‘Group Tagging’ button (available in the Team TimeSheet ribbon toolbar) to tag the same project or activity or billable hours or custom field value to all the selected appointment/task items in one go.
  

  And from the project fields, you can then set the common value for all the selected appointment/task items.
  

• We know, in the previous versions, how difficult and cumbersome it was to change the logo used in the case form. So, we have simplified the steps and now, all you need to do is to specify your logo image file from a network folder or from web. For more, refer to Team TimeSheet Manager > Form Options > Substitute the logo with your own.

  
  

Bug Fixes (build 6.0.2.61):

• When normal user (Team TimeSheet Client addin, but with admin access) tries to insert their own new project or activity (from Team TimeSheet Client > My Projects/Activities panel, the following error is shown:
  
• When managers decline or approve timesheets from Audit Manager panel (and the corresponding auto-alerts to members are enabled), the addin does not send the alert emails to members.
• When you add new custom list field under Team TimeSheet Manager > Custom fields panel, you get an error everytime.
• When saving report to Excel or PDF in Summary Reports tool, you get an error (and the file created is not usable, corrupted.)

29^th October 2013 (Version 5.0.1.42)

• Added support for Outlook 2013.
• Added support for both 32 bit and 64 bit Outlook.
• New excel like grid with support for sorting and newer data types.
• Added the option for the user to choose the user identity to use explicitly under “Outlook > Team TimeSheet Client menu > My Local Settings tab > I am”.
• You can now define new activities without associating to a particular project explicitly under Team TimeSheet Manager > Activities List. Just leave the project empty for that particular activity if you want that activity to be available to all projects.
• You can choose the placement of the Team TimeSheet ribbon toolbars under Team TimeSheet Client menu > My Local Settings > User Interface tab.
• Added support for unlimited Custom fields with varied data types (Team TimeSheet Manager > Custom Fields)
• Newly redesigned ‘All Fields’ form in the Team TimeSheet ribbon toolbar.
• Ability to tag multiple appointments/tasks items. Simply select multiple items from the calendar/task folder, and click ‘All Fields’. And then set the value for the particular field (including custom fields) and that will affect all the selected items.
• Ability to publish multiple items to database by selecting multiple items and clicking ‘Publish’
• New drop down button ‘Group Publish’. Allows for showing all non-reported (non-published) appointments/items of the current calendar/task folder based on specified timer period. Supports a filter search option. And then publish items in batch.
• New button ‘Review Published’. Allows for showing all published appointments/tasks of the current calendar/task folder. User can withdraw, unlink, delete or update published appointment/task items in batch. Supports a search filter.
• New ‘Summary Reports’. All custom fields should now show up in the available fields. Option to group reports by project/member.
• OLAP tool – custom fields show up. And custom fields with numeric or currency data types should show up in the Measures portion too.

Enhancements:

• Setup.exe now checks for the bitness of installed Office/Outlook. For instance, if 32 bit Outlook is installed, and if you run 64 bit setup.exe, it would complain and setup will exit.
• Better handling of Recurrence Appointments.

Related material:

• Building solutions that work on both 32 bit and 64 bit native Office version

Detail information on upgrading your old installation of Team TimeSheet for Outlook with new version and update.

Upgrade Steps to Team TimeSheet Version 8 (from version 5.X, 6.X, 7.X)

• Download the latest setups from above to your system.

• Extract the contents of the zip file to a file folder in your system. The downloaded zip file

• Shutdown Outlook.

• Run ‘TeamTimeSheetManagerSetup.exe’ (x64 or x86) to install version 8 of Team TimeSheet Manager tool. (no need to uninstall the earlier version 5.x, 6.x, 7.x)

• Run ‘TeamTimeSheetClientSetup.exe’ (x64 or x86) to install version 8 of Team TimeSheet Client tool. (no need to uninstall the earlier version 5.x, 6.x, 7.x)

• Start Outlook.

Upgrade Steps to Team TimeSheet Version 8.0 (from version 2, 3, 4)

Step 1 – Uninstall previous Team TimeSheet Manager/Client tool from all systems

Step 2 – Install Team TimeSheet Manager setup on pilot/admin system

Step 3 – Upgrade existing timesheet database

Step 4 – Install the new Team TimeSheet Client tool on member’s systems.

STEP 1: Uninstall previous Team TimeSheet Manager/Client tool from all systems

• This is very important step and must be done on all users systems that have the previous Team TimeSheet Manager/Client installed. Because the new Team TimeSheet version is developed using .NET framework, the files are no longer compatible to earlier versions.

• To uninstall, first shutdown Outlook. And go to Control Panel > Programs and Features ( for Windows Vista, Windows 7 and 8, 10), or Control Panel >Add/Remove Programs (for Windows XP) and uninstall ‘Team TimeSheet Manager’ and ‘Team TimeSheet Client’ of previous versions.

STEP 2:Install new Team TimeSheet Manager setup on pilot/admin system

• Download the latest setups to the pilot/admin system. There are two different setups for 32-bit Outlook and 64-bit Outlook

  TeamTimeSheetSetups_x86.zip (for 32-bit Outlook 2007, 2010, 2013, 2016, 2019)
  TeamTimeSheetSetups_x64.zip (for 64-bit Outlook 2010, 2013, 2016, 2019)

  Make sure each system has .NET framework 4.5 or above installed.

  You should download the correct setup type according to your Outlook bit-ness. And then extract the contents of the zip file to a file folder in your system. The downloaded zip file contains the setup.exe for Team TimeSheet Manager and Client tool.

• Shutdown Outlook.

• Run ‘TeamTimeSheetManagerSetup_xXX.msi’ (where ‘xXX’ can be either x86 or x64) to install the new Team TimeSheet Manager on the admin system.

STEP 3: Upgrade existing TimeSheet/Project database

• Your existing timesheet database of previous timesheet version needs to be upgraded to conform with the schema used in the new version database. Fortunately, the process of database upgrade is automated in the new Team TimeSheet. You just need to make sure, you have adequate permissions to create new tables and alter existing ones in your database.

  1. For SQL Server database, db_creator or higher rights on the timesheet database ‘TeamTimeSheetDB’.

  2. For MS Access database, you should have full write permission on the TeamTimeSheet.MDB file

  kindly take note of the above rights and permissions before proceeding.

• Start Outlook.

• The new Team TimeSheet Manager add-in will probe your existing database and would automatically offer to perform the necessary upgrades. It won’t proceed further without performing the upgrades.

• Click ‘OK’ to dialog prompt. If the database upgrade had succeeded, the add-in would continue to load the existing projects/activities and other metadata settings from the database.
  

STEP 4: Install Team TimeSheet Client tool on individual user’s system.

In the new version, the Client setup exists in two different types – one each for 32-bit Outlook and 64-bit Outlook:

TeamTimeSheetClientSetup_x86.exe (for 32-bit Outlook 2007, 2010, 2013, 2016, 2019)
TeamTimeSheetClientSetup_x64.exe (for 64-bit Outlook 2010, 2013, 2016. 2019)

• Shutdown Outlook.

• Uninstall any previous version of Team TimeSheet Client add-in. To uninstall, first shutdown Outlook. And go to Control Panel > Programs and Features ( for Windows Vista, Windows 7 and 8, 10), or Control Panel >Add/Remove Programs (for Windows XP) and uninstall ‘Team TimeSheet Client’ of previous versions.

• Run TeamTimeSheetClientSetup_xXX.esxe to start the installation of the new version Client tool. The installation involves a few clicks and should be over in matter of seconds.

• Start Outlook.

• Congratulations! Now, you can start using the new Team TimeSheet version.
  

NOTE: Very Important!

You should download the correct setup corresponding to the bit-ness of your Outlook. For instance, if you have 32-bit Outlook, download TeamTimeSheetSetups_x86.zip. If you have 64-bit Outlook 2010 or 2013 or 2016, then download TeamTimeSheetSetups_x64.zip)

For 32-bit Outlook 2010/2013/2016/2019, use TeamTimeSheetSetups_x86.zip
For 64-bit Outlook 2010/2013/2016/2019, use TeamTimeSheetSetups_x64.zip

Your Windows OS bit is not taken account. So, ignore if you have 32-bit or 64-bit Windows. Concentrate on the bit-ness of Microsoft Office and download and install the matching setups.