|
|
Help Needed
Started by TotalBalance at 02-21-2009 14:02. Topic has 4 replies.
  
|
|
Sort Posts:
|
|
|
|
 02-21-2009, 14:02
|
TotalBalance
Joined on 06-01-2007
Posts 8
|
Help integrate Kimai and TimeSnapper.
|
|
|
|
|
Background:
Being a big supporter of Open Source and wanting a local server environment for both personal use and production testing, I've setup a "localhost" server environment configured on my WinXP SP3 laptop using XAMPP for Windows (MySQL, Apache, PHP, Perl). Then I can install/test/use OS server based apps I'm interested in (i.e. blogs, wikis, forums, time tracking, etc).
Related to my personal productivity & time tracking system, I'm presently trying out Kimai for time tracking. While I've always wished TimeSnapper was open source, it's nevertheless one of those great commercial products that has no equal in the open source world, yet. Ergo, I registered quite some time ago. Complimenting/integrating what TimeSnapper offers with Kimai would be killer.
Support Question:
Unfortunately, I'm no MySQL expert and realize I need help setting up and configuring the integration between the two. I've looked at some of the threads that discuss how, but I guess I'm just not getting it.
General database integration threads:
http://forums.timesnapper.com/forums/64/ShowPost.aspx
http://forums.timesnapper.com/forums/691/ShowPost.aspx
MySQL Specific references:
http://forums.timesnapper.com/forums/614/ShowPost.aspx
What info from my Kimai MySQL dB can I provide for instructions how to properly configure the Advanced Integration Settings string. Is there anything else I need to do?
Thanks in advance,
|
|
|
|
|
Report
|
|
|
|
|
02-21-2009, 15:54
|
AtliB
Joined on 05-30-2006
Reykjavik / Iceland
Posts 382
|
Re: Help integrate Kimai and TimeSnapper.
|
|
|
|
|
|
Hi,
their forum is down at the moment so I'm having difficulties installing the software (it doesn't come with an installer(?)).
But you can basically provide TimeSnapper with any data from Kimai that you want.
But this is definitely something that we are interested in helping you out with!
Cheers
Atli
Check out TimeSnapper, the automatic screenshot journal at www.timesnapper.com
It runs in the background of your computer, taking screenshots of your desktop every few seconds all week long.
TimeSnapper lets you play back your week just like a movie. Use it to improve your work habits and become more productive.
|
|
|
|
|
Report
|
|
|
|
|
02-21-2009, 17:16
|
TotalBalance
Joined on 06-01-2007
Posts 8
|
Re: Help integrate Kimai and TimeSnapper.
|
|
|
|
|
|
Hi Atli, thx. for the quick response and attempt to install. Kimai.
Just to make sure we're on the same page, hope I explained things well enough to understand one needs to 1st setup a local Apache, MySQL, PHP server environment. Then you can install/run other server based apps locally (i.e. Wordpress, MediaWiki, Kimai, etc). As mentioned I use XAMPP for Windows to accomplish this. P.S. Updated original post to better describe my local environment.
After setting up your local server environment, download the Kimai zip file and extract/copy contents into your ...\webroot\kimai directory (i.e. ...\xampp\htdocs\kimai\). It contains a "How_To_Install.txt" file with details and the app has a web based install program with step by step online instructions. Just open Kimai in your browser and you'll be taken to the 1st time installation program (i.e. http://kimai.localhost/, http://localhost/kimai/, or however you've configured your Windows Host and Apache's httpd.conf files to handle your localhost web app Urls). Let me know if I need to explain things further.
P.S. The above reflects a localhost installation. If you'd rather set it up on your ISP Linux Web server, no need for XAMPP, just FTP and use your browser as described above to install.
Thx. again,
Lars
|
|
|
|
|
Report
|
|
|
|
|
02-22-2009, 6:31
|
AtliB
Joined on 05-30-2006
Reykjavik / Iceland
Posts 382
|
Re: Help integrate Kimai and TimeSnapper.
|
|
|
|
|
|
Thanks Lars,
I've managed to set this up (both locally and on my ISP), thanks to your setup notes. I have no experience with Apache so I'm kinda thick on how to do things here :) Having gone through this once makes it all look simple and fun in retrospect :)
I installed the 0.7 version of Kimai - is that what you are running? I had heaps of problems installing 0.8 which other seemed to have as well.
I've installed some MySQL OleDB and ODBC drivers but don't seem to be able to get a solid connection to the database. What I found out is that:
1)
MS OleDB doesn't want to connect to the MS OleDB Provider For ODBC Drivers:
================================
Details:
System.ArgumentException: The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc).
at System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid)
at System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String connectionString)
at System.Data.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.OleDb.OleDbConnection.ConnectionString_Set(String value)
at System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)
at System.Data.OleDb.OleDbConnection..ctor(String connectionString)
at al.a(n A_0, Flag A_1)
at x.e(Object A_0, EventArgs A_1)
Query:
select knd_grpID, knd_grpID,knd_grpID ,knd_grpID from kimai_knd where knd_grpID = 1
2)
And using OleDB to connect to MySQL OleDB (same as Patrick Metz did in another thread) gives error if I select more than 1 column (!):
Details:
=====================
System.Data.OleDb.OleDbException: 'MySqlProv.3.9' failed with no error message available, result code: E_FAIL(0x80004005).
at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr)
at System.Data.OleDb.OleDbDataReader.GetRowHandles()
at System.Data.OleDb.OleDbDataReader.ReadRowset()
at System.Data.OleDb.OleDbDataReader.Read()
at System.Data.OleDb.OleDbDataReader.HasRowsRead()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at al.a(n A_0, Flag A_1)
at x.e(Object A_0, EventArgs A_1)
Query:
select knd_grpID, knd_grpID,knd_grpID ,knd_grpID from kimai_knd where knd_grpID = 1
=====================
So I'm quite stuck as you are currently :-s Looks like we have to make some changes to TimeSnapper to make this smoother. Let me know if you come up with anything...
cheers
Atli
Check out TimeSnapper, the automatic screenshot journal at www.timesnapper.com
It runs in the background of your computer, taking screenshots of your desktop every few seconds all week long.
TimeSnapper lets you play back your week just like a movie. Use it to improve your work habits and become more productive.
|
|
|
|
|
Report
|
|
|
|
|
02-22-2009, 8:54
|
TotalBalance
Joined on 06-01-2007
Posts 8
|
Re: Help integrate Kimai and TimeSnapper.
|
|
|
|
|
|
Hi Atli,
So, if I understand correctly, you've got Kimai setup and working both locally and on your ISP. Didn't realize this was new stuff for you but I can certainly relate!! I had similiar issues my first time and then realized it wasn't really hard at all and actually quite rewarding & fun, in retrospect. Thanks for the effort!
As an aside, I found it pretty cool having TimeSnapper running in background the whole time. After everything was firgured out and installed correctly, I just did a replay in TimeSnapper, pausing as necessary, writing down and providing screen captures, as appropriate, resulting in a nice little installation/setup guide for myself and others the next time around. Sort of a poorman's Camtasia!
As for the connection issues, I'm afraid we're in the same boat. Just not something I'm expert at. I wonder if Patrick Metz is still checking this forum, perhaps he's got some additional insights on why things aren't quite working. In the meantime, I'll do some more testing later this afternoon and let you know if I can figure anything more out. Guess I'll need learn more about MySQL as well. As an FYI, XAMPP included PHPMyAdmin to administratively manage all your MySQL database stuff, I'll take a look into that as well to see if I can glean anything.
Cheers,
Lars
|
|
|
|
|
Report
|
|
|
|
|
|