start-stop task-log better store in db

[hoehmi]

if i start a task-log and leave the page (e.g. i search a company or look into my calendar) an come back to the task-log then the there is no "running watch" :?

the probleme is the handling via javascript (?!)
nicer solution: new flag in the db (e.g. start_timestamp) per task-log
(possible restriction: only one task-log per time can "run" ...
done by a simple sql-select). so i can use other dotproject pages
during a taks-log is running

<nice2have>
a new "report" running tasks
* per user: only 1 task
* per superadmin: all running tasks displayed
</nice2have>

[udoline]

if i start a task-log and leave the page (e.g. i search a company or look into my calendar) an come back to the task-log then the there is no "running watch" :?

the probleme is the handling via javascript (?!)
nicer solution: new flag in the db (e.g. start_timestamp) per task-log
(possible restriction: only one task-log per time can "run" ...
done by a simple sql-select). so i can use other dotproject pages
during a taks-log is running

<nice2have>
a new "report" running tasks
* per user: only 1 task
* per superadmin: all running tasks displayed
</nice2have>in welche tabelle ?
ein bischen genauer bitte ...

[ajdonnison]

The simple solution is to use a new window or a new tab in your browser so you don't overlay the timer page.

[hoehmi]

The simple solution is to use a new window or a new tab in your browser so you don't overlay the timer page.

that's true. but a browser-window can crash :cry:
if this happend then the all the time-information is lost!

[ajdonnison]

And what makes you think that it isn't lost when you put a timer in the database? What stops the database timer? What happens if you lose the connection for two days before you get back to the system? All these issues and more rear their ugly head once you start trying to do timing in the database from a web application.

[hoehmi]

What happens if you lose the connection for two days before you get back to the system?

i thinkt that is not a big problem. if i lose the connection (e.g. my browser crash) that i relogin into the system and all is fine.

if i lose the connection for two days (e.g. the whole system is down) then the time-tracking via dotproject make no sense :wink:

imagine ... i work e.g. one week on the same task (a big problem), perhaps i only start the task on monday and stop it on friday, or i work the whole day on one task ... then it
is hard to have the browser allways open. i think the serverb should handle the task-time-tracking an not the client.

month ago i had tested php-project and i think the timetrack-input is very good, there you have a list of current tasks (in one view) and you only have to "start" (click) on the task that you want to be started. for our customer-care-division this should be very helpfull to "timetrack" many different customers as quick as possible (stop A, start B ... stop B, start C .... stop C, start A ....) or better only start (with auto-stop-current-task) .... only a idea :) [/b][/quote]

[Gromph]

I just want to second this request. We've been useing dotproject off and on for the last year. I want to make it a more integral part of our day to day work process. Having accurate and reliable time tracking would be awesome. I think storing a users current task in the database would lead to many other useful features.

In addition to having the start time stored in the database I'd like:

A report that shows what tasks employees are currently working on, what they've worked on that day, week, month, etc.

A report too summarize how much of each employees time went to different projects, by day, week, month, etc.

To have an overall day timer per employee, ie when an employee logs in the morning till the time they log out. With a break/lunch pause button. Hopefully good enough to use for payroll purposes. Plus various reports :D

I would also like it if the tasks start and finish times were adjusted by the task logs dates and times. The finish date could be set when the Progress is set to 100% (or add a Task Done button :) )


I can't explain how exstatic I would be if these sorts of time tracking features were added to dotProject!

Thanks!

[Gromph]

I've found the timecard module and am trying to get it to work now, it looks like it will solve some of my problems!