The attached .zip file contains a step-by-step guide and an example on how to integrate TimeSnapper with your Timesheet software. We don't enforce TimeSnapper users to use any specific Timesheet software so we support a configurable way for integration. Hopefully in the future - we will have some preconfigured integration methods against some de-facto standard timesheet software (if such exists).
For people who have access to SQL Server, setting up this example integration should not take more then 10 minutes.
I've included the contents of the Readme.txt file for searching purposes:
============================================================================ A step by step guide for testing the integration feature of TimeSnapper= to a timesheet / booking system.= = NB: The Timesheet dialog is an experimental dialog which will be further= more enhanced and changed based on customer feedback. Those= changes might break the current integration solution which means= changes (by you) will be necessary.==========================================================================
1. Run the "Sample Database 2 SQLServer Timesheet Integration.sql" file on a SQLServer => a new database called TimeSheetTest has been created along with tables and stored procedures that can be customized.
2. Drop the BookingDefinitions.xml file into TimeSnapper's installation directory (no need to restart TimeSnapper - it notices all changes to this file)
3. Change the connection string in the BookingDefinitions.xml so it points to the correct database server and uses the correct authentication: <connectionString>Provider=sqloledb;data source=***SERVER***;Initial catalog=TimeSheetTest;integrated security=sspi</connectionString> 4. Open the "Tools -> Timesheet" dialog in TimeSnapper and select a date that contains some entries. 5. Test the integration: Click the "Book" button: => No error message nor dialog will be shown if all is ok => You can verify that the data has been entered into the database by executing this SQL code: select * from ts_tbl_timesheet Click the "Book" button again: => Error message will appear which is correct due to how the procedure is implemented (your implementation can work differently):
A problem occurred while saving a booking. You have already booked for this date, this implementation cannot override that 6. Read through the BookingDefinitions.xml file for a understanding of the functionality. That file contains documentation on most parameters that can be used.
=====================================TimeSnapper v. 2.1December 2006Atli Björgvin Oddsson & Leon Bambrickhttp://www.timesnapper.com