Save Clients, Projects and Tasks

Suggestions

Save Clients, Projects and Tasks

Anonymous 02-21-2008, 21:24
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!

Re: Save Clients, Projects and Tasks

AtliB 02-22-2008, 3:40
>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.

Re: Save Clients, Projects and Tasks

Anonymous 02-22-2008, 4:16
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

Re: Save Clients, Projects and Tasks

AtliB 03-06-2008, 14:41

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

Re: Save Clients, Projects and Tasks

PatrickMetz 04-06-2008, 4:37

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 ;-)

Re: Save Clients, Projects and Tasks

Anonymous 06-10-2008, 3:11
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...

Re: Save Clients, Projects and Tasks

AtliB 06-10-2008, 17:36
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

Re: Save Clients, Projects and Tasks

Anonymous 06-11-2008, 0:38
You posted something on "bookings" .
Isn't that of any use?

I'm a real noob at this...

Re: Save Clients, Projects and Tasks

typovar 06-11-2008, 5:00
<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

Re: Save Clients, Projects and Tasks

AtliB 06-11-2008, 15:21

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 :)