Welcome to TimeSnapper Forums Sign in | Join | Faq

Suggestions

Started by Anonymous at 02-21-2008 21:24. Topic has 9 replies.

Print Search
Sort Posts:    
   02-21-2008, 21:24
Anonymous
Save Clients, Projects and Tasks
Reply Quote
It took me a while, but I've finally started using the Task functionality, which is really helpful.

I noticed you can integrate a database via odbc, which is very cool - but I don't have a client database (well, not a local one).  It seems something that would work nicely and fit the simplicity of this program would be a minimalistic internal database.  Nothing heavy, just something that remembers recent entries for clients, projects and tasks.

Something like a combo box with a search mechanism - while typing, or something that works like firefox's auto-complete on input fields.

It seems to me that this local cache might even be helpful for people who do have an external client database since the query doesn't have to be run for previously entered data.

Otherwise, I'm a huge fan.

Thanks!

    
   02-22-2008, 3:40
AtliB is not online. Last active: 6/14/2008 7:53:46 AM AtliB

Top 10 Posts
Joined on 05-30-2006
Reykjavik / Iceland
Posts 259
Re: Save Clients, Projects and Tasks
Reply Quote
>I noticed you can integrate a database via odbc, which is very cool - but I don't have a client database (well, not a local one).  It seems something that would work nicely and fit the simplicity of this program would be a minimalistic internal database.  Nothing heavy, just something that remembers recent entries for clients, projects and tasks.

Absolutely and we actually kinda have it, when we store the flags.

we're in the process of moving to the .NET framework 2.0 (currently using 1.1).  Once we're there, it'll be a lot easier to add the auto-complete feature to the combobox (since it's built into .NET 2.0).

We've had this request before and I myself would like to have it - so there is a good chance it'll get into the program! :)

Actually, I've created an Access database which can be used as a poor man's task/issue tracking database.  It contains basic data tables like: customer, project, task etc.  If you'd be interested in trying that out I can send it to you (drop us a line at support@timesnapper.com).   That contains some "basic" autocomplete, although not inline in the combobox, but rather via the lookup.  So, e.g. you type "Micr", press enter and it will show you a list of all companies starting with "Micr"

Thanks
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-2008, 4:16
Anonymous
Re: Save Clients, Projects and Tasks
Reply Quote
Very cool, 

I'll likely come up with something in mysql using mysql's odbc connector for the time being.  Autocomplete would definitely be very cool, though.

Thanks Atli!!

Mark

    
   03-06-2008, 14:41
AtliB is not online. Last active: 6/14/2008 7:53:46 AM AtliB

Top 10 Posts
Joined on 05-30-2006
Reykjavik / Iceland
Posts 259
Re: Save Clients, Projects and Tasks

Attachment: TaskTrackingIntegrationWithTimeSnapper.zip
Reply Quote
 AtliB wrote:
>Actually, I've created an Access database which can be used as a poor man's task/issue tracking database.  It contains basic data tables like: customer, project, task etc.  If you'd be interested in trying that out I can send it to you (drop us a line at support@timesnapper.com).   That contains some "basic" autocomplete, although not inline in the combobox, but rather via the lookup.  So, e.g. you type "Micr", press enter and it will show you a list of all companies starting with "Micr"


I've decided to attach this example here for those who would like to try it out.

Steps to test:
•    Be sure you are using the latest version
•    Expand .zip to your TimeSnapper folder (NB: this will overwrite your current LookupDefinition file)
•    Go to: Tools -> Options -> Integration and import the LookupDefinition.xml file (with the lower import button, need to enable "Task Lookup Integration" checkbox)
•    Create a new flag and try out the integration!
You can open the Access database directly and add new customers / projects and tasks.

NB: this is by no means a production strength task tracking application and is only intended as an example :)

Let me know how it goes (I'm thinking about setting up a special Task tracking / TimeSheet samples page for users to download things like this)

Cheers
Atli
ps. try typing partial text in the "Search tasks:" textbox in the flag dialog to see how it can be used to search through the tasks





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 
   04-06-2008, 4:37
PatrickMetz is not online. Last active: 4/6/2008 2:18:33 AM PatrickMetz

Top 10 Posts
Joined on 04-05-2008
Posts 10
Re: Save Clients, Projects and Tasks
Reply Quote
 Anonymous wrote:
It took me a while, but I've finally started using the Task functionality, which is really helpful.

I noticed you can integrate a database via odbc, which is very cool - but I don't have a client database (well, not a local one).  It seems something that would work nicely and fit the simplicity of this program would be a minimalistic internal database.  Nothing heavy, just something that remembers recent entries for clients, projects and tasks.

Something like a combo box with a search mechanism - while typing, or something that works like firefox's auto-complete on input fields.

It seems to me that this local cache might even be helpful for people who do have an external client database since the query doesn't have to be run for previously entered data.

Otherwise, I'm a huge fan.

Thanks!


*signed*

A lightweight internal database for customers/projects/tasks sounds great. I mean I just love  that TimeSnapper asks me what I'm doing (about ;-) ) every 30 minutes and lets me quickly specify customer, project and task. It made my worklife so much easier. But that's only possible because I know how to setup the datatables, enter the neccessary data and specifiy the SQL-commands for TimeSnapper to retrieve the data. People who do not possess this knowledge will miss a great aspect of your software. I suggest: integrate that feature for everyone and you'd be able to advertise this as nice mainfeature that would attract a few more customers ;-)

   Report 
   06-10-2008, 3:11
Anonymous
Re: Save Clients, Projects and Tasks
Reply Quote
It works for me. Thank you very much.

However, I discovered that when I create a 'new flag' and I fill it with new data, this data isn't stored in the database.
Is there a solution for this as well?

I tried 'enable timesheet intergratation'
But no results yet...
    
   06-10-2008, 17:36
AtliB is not online. Last active: 6/14/2008 7:53:46 AM AtliB

Top 10 Posts
Joined on 05-30-2006
Reykjavik / Iceland
Posts 259
Re: Save Clients, Projects and Tasks
Reply Quote
The current implementation in the attached database doesn't implement that (persisting the flags back to the access database), but it's pretty easy to do.  We just haven't gotten around to it yet (since we want to do something usable by many, supportable by us - it takes some time to do!)

But you can always get the flags from the Reports dialog (in either HTML, XML or Export to Excel) and process it from there.


Thanks
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 
   06-11-2008, 0:38
Anonymous
Huh? [:^)] Re: Save Clients, Projects and Tasks
Reply Quote
You posted something on "bookings" .
Isn't that of any use?

I'm a real noob at this...


    
   06-11-2008, 5:00
typovar is not online. Last active: 6/11/2008 7:53:12 PM typovar

Top 50 Posts
Joined on 06-11-2008
Posts 1
Re: Save Clients, Projects and Tasks
Reply Quote
<blockquote>It works for me. Thank you very much. However, I discovered that when I create a 'new flag' and I fill it with new data, this data isn't stored in the database.
Is there a solution for this as well?
I tried 'enable timesheet intergratation'
But no results yet...</blockquote>

I just registrated, so I'll quote myself...

There is a Sample file on this forum about intergrating with 3rd party software. Could this example be of any use in the process of storing data back into the database?

link: http://forums.timesnapper.com/forums/64/ShowPost.aspx
   Report 
   06-11-2008, 15:21
AtliB is not online. Last active: 6/14/2008 7:53:46 AM AtliB

Top 10 Posts
Joined on 05-30-2006
Reykjavik / Iceland
Posts 259
Re: Save Clients, Projects and Tasks
Reply Quote
 typovar wrote:
Could this example be of any use in the process of storing data back into the database? link: http://forums.timesnapper.com/forums/64/ShowPost.aspx


Absolutely - at least if you have an instance of SQL Server somewhere accessible :)




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 
TimeSnapper For... » TimeSnapper » Suggestions » Re: Save Clients, Projects and Tasks

Powered by Community Server, by Telligent Systems