dotProject TaskTracker V1.0

[Frank Hönisch]

The first Widget from tyclipso.net (http://www.tyclipso.net/de/Home.htm) revolutionizes the timetracking during the working on tasks of projects. Thereby it creates a better performance, qualified project data and the permanent overview over the status of the own tasks.

The TaskTracker V1.0 can load user-referred projects and tasks from the dotProject and shows the status, final date and the progress in percent.
By clicking on a ‘i’-Symbol on the list the browser will open the according project/task-side of the dotProject.

http://www.tyclipso.net/media/images/widget-window_list.gif

You can click on a project, select a task and start the timetracking. Now you can see two textareas where you can enter notes and a new percentage to the task. On the bottom of the widget you can see how long you still working. When you finished you can stop the task.

The data can be synchronized at any time with your dotProject. For synchronisation the widget uses a PHP-Script. The TaskTracker V1.0 can also work when you have partly no connection to the dotProject. When you are still connected you can synchronize at every time you want by clicking on the ‘Synchronize-Button’. So the Tracking is also possible during a business trips or by local work on the laptop.

In addition you can generate a daily report and save it as HTML-File.

Our partner agency solongo.design (http://www.solongo.de/templates/tyTP_standard.php?topic=www_solongo_de) still working with the TaskTracker V1.0. and they are happy about the easier project management.

If you want to use the TaskTracker V1.0 you need the dotProject V2.0.1. and the Yahoo Widget Engine (http://widget.yahoo.com).

You can download the TaskTracker V1.0 from http://www.tyclipso.net/de/dotProject_TaskTracker.htm

http://www.tyclipso.net/media/images/widget-window.gif

[MacOfTheEast]

Very, very nice Frank! Thank you and your team for the excellent work and contribution.

But... as a Mac OS X user, and since the Yahoo Widget Engine is based on OS X technology, perhaps you'd consider making the widget OS X Tiger compliant. (It would just need a small bit of tweaking: instructions are on the Apple Developer web site.) Now, OS X Tiger does not recognize it as a "standards compliant" widget (whatever that means) :-)

Again, thank you!

MOTE

[Denis Bartelt | tyclipso]

Uuh, okay... we didn't checked that on tiger yet. Thank you for the hint -> we will test and overdo this in a view days. Till this update comes - the Tigers are not able to use TaskTracker as it seems. Sorry guys.

[MacOfTheEast]

Uuh, okay... we didn't checked that on tiger yet. Thank you for the hint -> we will test and overdo this in a view days. Till this update comes - the Tigers are not able to use TaskTracker as it seems. Sorry guys.Sounds good. Thank you again. Yes... you're right. Until some small mods are made, us "Tigers" can not enjoy your fine program.

MOTE

[Maxim.Bolshakov]

Hallo, ich verwende DotProject mit russisce Localisation und TaskTracker zeigt russische Projects und Tasks falsh kodiert!!! und wenn ich neue Tasklog in TaskTracker schreibe dann in DotProject wird es nit ?????? angezeigt!!!

Ich denke, dass TaskTracker hat Problemme mit UTF8?

Kann ich TaskTracker auch auf russisch finden?

[Frank Hönisch]

Danke für den Hinweis,

ich habe bis jetzt nicht mit kyrillischen Zeichen getestet. Es wird sehr wahrscheinlich an der UTF-8 Codierung liegen, dass diese nicht einwandfrei funktioniert. Ich werde dem Problem nachgehen.

Frank Hönisch

[Wendebaum]

A great piece of software. I did hide the server information as not everyone should see the data and get access to the database and I added LDAP-Auth which is used in our company.

Now I have to propose it a bit and see, if it is accepted. :)

I can send you the modified version if you like. It's a dirty hack, though...

Jochen Wendebaum

[Maxim.Bolshakov]

Hallo Frank,
wenn du russische Version machen willst, dann würder ich dir mit Übersetzung gerne helfen :)

[dekamerone]

Hallo Frank,

I'm just installed TaskTracker-Widget - very nice tool for well organised people :-) - thank you.
And to my surprise: it worked well with https-connection: thanks again!

Only two suggestions:
- Why not use server-side database connection parameters, maybe by including ../dotproject/includes/config.php into your server-side PHP-Script? That way your users doesnt have to configure and to know some critical administration data ...

- For not so well organised people (like the Companies Boss for instance ;-) ): the possibility of doing the Working Hours entries "by hand" at a later time (similar to the "progress" value).

The second problem is a Killer criteria for the successful introduction of the tool in many environments I guess ... what do you think about the expenditure of time to make this feature work?

Best greeetings from Leipzig : Michael

[Frank Hönisch]

Hello

Why not use server-side database connection parameters

Yes thats possible. I will change it accordingly.


For not so well organised people (like the Companies Boss for instance ;-) ): the possibility of doing the Working Hours entries "by hand" at a later time (similar to the "progress" value).


If I understood it correctly, you want to select a task and enter in a form the working time. I think for this feature I need a day.

[dekamerone]

Hallo Frank,

think we understand us well :-).

To give a background: I'm just trying to implement a Project Management Workflow with high-level user acceptance as follows:

-> Creation of project timetable in MS Project
-> Import the MS Project data into dotProject
-> Project Controlling with dotProject , TimeTracking with dotProject_TimeTracker

The main goals here are the support of team collaboration and project controlling - that mainly means making public the connections between project tasks and - as second - getting informations about time wholes.

Status:
This time there are a few more issues to solve like "how to work with timetable updates".

... keep you informed about the progress of my investigations :-).

thx4all : Michael

[guyroberts]

Hi, I'm sorry to sound thick, but I can't get the MySQL - Host address correct. I host on an external server - I wondered if anyone would be able to help at all?

Is there any how I can check to details of the link to the MySQL database (host and port etc..)

Thanks
Guy

[Frank Hönisch]

Hello

The best way is that you create a folder in your dotProject-directory named 'widget', copy the PHP-Script in this folder. Now in the Widget-Preferences you must enter the correct URL to the PHP-Script.
Then you can get the server,database, and login data from the config.php from dotProject, which you can find in <dotproject-folder>/includes

[guyroberts]

Cool! Nice one, thanks!

[rajesh_hariparsad]

Hey guys ….

This tool looks really wicked. It makes life a lot easier.

One quick question though. The client needs the DB authentication paramameters … because? Does it connect directly to the MySQL Server?

How difficult would it be to rather have the client connect over http to the index.php on DP? The reason being is that when guys are based at a client site there is no way to go around the firewall … and for some reason web access is terrible.

Thanks for the heads up.

R

[Frank Hönisch]

Hello

We have a new version of the TaskTracker, with some changes an bugfixes.

Now you have to copy the php-script from the zip-file in the root-path of your dotProject. So it is no longer necessary to enter the data for database-access into the widget. The php-script gets this information direct from dotProject.

In the TaskTracker now you can see for every project the company name and you can set the automatic synchronisation (widget preferences -> projects).


You can download the dotProject TaskTracker V1.1 from:
http://www.tyclipso.net/en/dotProject_TaskTracker.htm?newLanguage=en

[Wendebaum]

great, works fine, the installation is easy.

One thing that bothers me is the project state, which are not working fine for me as we customized a lot in dP, having totally different project states. But as I can modify the widget this is not a problem.

Thanks a lot for this great work!

Jochen

[madow]

I am having difficulties in connecting to our web server. I am not sure I am configuring the widget correctly. I have placed the tasktracker_widget.php in a folder call \widget under my \dotproject folder. The Tasktracker Widget is on my desktop. I have entered the URL to our server (http://dotproject.health) into the widget settings and still get a "Cannot connect to web server" error.

Is there something else that needs to be configured, have I missed something?

Any assistance would be appreicated.

Mike

[diskortsev]

hi,

I started tracker the first time, entered necessary data. Trying to start it again but get the message box "Tracker V1.1 war es nicht möglich, sich selbst erfolgreich zu laden."
Is something missing? Script is on the server.
Is it possible to get more information on the problem?

Thank you in advance,
Denis Iskortsev.

[Frank Hönisch]

Hi,

it is important that youcopy the tasktracker_widget.php in the root-folder, (in you case \dotproject) and not in a subfolder of '\dotproject'.
Because the script neets the config.php of the dotProject, which you can find in the 'includes'-folder.

Or another way: you can modify in the tasktracker_widget.php the third line. There you can set the root-folder in the variable '$baseDir'.


To the problem:

"Tracker V1.1 war es nicht möglich, sich selbst erfolgreich zu laden."

Up to now this error message did not arise ever, when I testet the TaskTracker. I think the message comes from the Yahoo Widget Engine.
Which version of Yahoo Widget Engine have you installed?

[madow]

Frank,

Thank you for responding, the version of the Yahoo Widget engine I have is 3.1.1, build 96.

I have moved the tasktracker_widget.php under \dotproject and it will still not connect to the web server.

Any suggestions?

Thanks

Mike

[Frank Hönisch]

Hello,
have you adapted the url of the tasktracker_widget.php.
-> in the widget preferences (right click on the widget) - menu 'Server', textfield PHP-Script.

When the URL of your DotProject is for example "http://mydotproject/" you have to enter in the textfield: "http://mydotproject/tasktracker_widget.php".

You can simply test the url in your browser.

I hope now it will connect.

[madow]

Frank,

Thank you so much for the information. Once I added the taskTracker_widget.php to the URL it worked great. Fantastic tool, thank you for the time and effort you put into this.

Mike

[pjtaylor]

Hi,

This looks pretty impressive but I'm having a problem.

I have just installed 1.1 as per the install instructions but all it says is "No Tasks Available! For project status "All Projects""

In the Projects settings, I've tried both "x|All Projects" and my Project Status Lookup values (comma separated) of "0|Not Defined,1|Proposed,2|In Planning,3|In Progress,4|On Hold,5|Complete,6|Template" but to no avail.

I'm on dp 2.0.2 with a Widget engine of 3.1.1 (build 96).

Any thoughts?

Thanks,
PT

[alexj]

Hello,

what is the difference between big round start button in the top right corner and teh small one at the bottom of the widget?

[alexj]

Is it possible to pause task timing without exiting from the task?

For example, for lunchbreak?

[alexj]

I have some suggestions for daily report which I think are not that hard to implement, but could be useful:
<UL>
<LI>Total of working time per day at the bottom
<LI>Names in the work list could be links - like in task log report in dp 2.0.2
</UL>

Thanks for the great app !!!

[CharredPC]

Having the exact same issue here.
Anyone?

Hi,

This looks pretty impressive but I'm having a problem.

I have just installed 1.1 as per the install instructions but all it says is "No Tasks Available! For project status "All Projects""

In the Projects settings, I've tried both "x|All Projects" and my Project Status Lookup values (comma separated) of "0|Not Defined,1|Proposed,2|In Planning,3|In Progress,4|On Hold,5|Complete,6|Template" but to no avail.

I'm on dp 2.0.2 with a Widget engine of 3.1.1 (build 96).

Any thoughts?

Thanks,
PT

[Frank Hönisch]

Hello,

what is the difference between big round start button in the top right corner and the small one at the bottom of the widget?

Is it possible to pause task timing without exiting from the task?


The small button is just to get the time of tasks, which are not in your project list. In the future this button should be for timetracking of lunch, telephone call etc.

At time, when you want to stop the time for this things, the best way is to make a new "project" with the "tasks" lunch, telephone call ...

[alexj]

I think I found a bug in daily report : a have a job that lasted 45 minutes, in daily report its duration is 0.45(h?).

In DP (2.0.2) everything is OK - 0.75

[Frank Hönisch]

Originally Posted by pjtaylor
Hi,

This looks pretty impressive but I'm having a problem.

I have just installed 1.1 as per the install instructions but all it says is "No Tasks Available! For project status "All Projects""

In the Projects settings, I've tried both "x|All Projects" and my Project Status Lookup values (comma separated) of "0|Not Defined,1|Proposed,2|In Planning,3|In Progress,4|On Hold,5|Complete,6|Template" but to no avail.

I'm on dp 2.0.2 with a Widget engine of 3.1.1 (build 96).

Any thoughts?

Thanks,


Sorry, at present I cannot say what the reason for this problem is.
We have testet the TaskTracker V1.1 with dotProject 2.0.1.

I'll test it the next days with the new dotProject.

[alexj]

DotProject has the analogue of daily report, which can be extracted by the following link (2.0.2):

http://mycompany.com/dotproject/index.php?m=projects&a=reports&project_id=0&report_type=tasklogs&log_start_date=20060503&log_end_date=20060503&log_userfilter=2&log_pdf=on&log_ignore=on&do_report=submit

Things to change dynamically are log_start_date, log_end_date and log_userfilter.

I think that it would be better than reimplement daily report functionality by yourself. The only drawback is that the location of the link may change in the future, as the reports will be moved out to separate module.

[alexj]

Hi.

I have a question: if I by accident i start timetracking of wrong task, is it possible to cancel it so that no time is reported to dp?

[Frank Hönisch]

Hello,

I think I found a bug in daily report : a have a job that lasted 45 minutes, in daily report its duration is 0.45(h?).

In DP (2.0.2) everything is OK - 0.75

In the daily report all times are in the format: "hours.minutes".
So 0.45h means 45 Minutes. 1.30 -> 1hour and 30Minutes.

[CharredPC]

Sorry, at present I cannot say what the reason for this problem is.
We have testet the TaskTracker V1.1 with dotProject 2.0.1.

I'll test it the next days with the new dotProject.

I'll be happy to provide any details needed if testing is required... we have found no way around this problem; this handy widget has never worked for us. We're actually in the middle of evaluating several different Management software applications, and getting this working would likely make us lean toward Dot Project. Feel free to reach me at charredpc at gmail dot com.

[leongoogs]

Thanks for the good work on Task Tracker . I have installed V1.1 on the server. However the the server uses SSL and a self signed certificate.
SSL logs show that the client is sending username and password but i do not get any task data at all . I get a message to confirm use of my Sercurity certificate after I start the widget and No data available . After I sync get No tasks available .
Even though the check box "Use login data for database access from dotproject" is checked. The widget still sends sl[object%20Preference]&ldap=&host=&port=&db=&dbuser=&dbpw=&ps=x&tf=0&sip=0

I get no tasks available for project status 'All Projects'

Permissions for tasktracker_widget.php are 700 for Apache

When trying to access the tasktracker_widget.php direct from a browser I get .
Cannot view XML input using XSL style sheet. Please correct the error.

Only one tope level element is allowed in an XML document . Error Processing
resource "https:// blah blah

Any thoughts please ?

[CharredPC]

It would seem that work on this has slowed... which is a shame, as everyone seems to be runing into the same issue. It would be a very helpful widget.

[Frank Hönisch]

Hello,

sorry that I have not answered your questions the last days.


When trying to access the tasktracker_widget.php direct from a browser I get:
Cannot view XML input using XSL style sheet. Please correct the error.

Only one tope level element is allowed in an XML document . Error Processing


It it true that the generated XML document is not in right XML-Syntax.
But that is not the Problem.

In the following folder should be a file named projects.xml.
Can you please copy the content of this file!

C:\Documents and Settings\<user>\Local Settings\Application Data\ Yahoo\Widget Engine\DotProject TaskTracker V1.1.widget\DotProject TaskTracker V1.1.widget\Contents

In the PHP-Script:

The only reason that you get no task, could be that there is a problem with the query on line 304. I don't know if there is a differnce between the database structure of dotProject 2.0.1 and dotProject 2.0.2.

From line 294 to 296 - there the project status were insert in this query (line 304) to get the project data. Perhaps, when you uncomment this lines it could work.

[leongoogs]

Thanks for the reply Frank and Help

Using Dotproject V 2.0.1 still

The directory Structure is different to what you have written.

C:\Documents and Settings\<user>\My documents\My Widgets\DotProject TaskTrackerV1.1.widget

There is no Content Subdirectory or projects.xml file

Note: that I am running Yahoo widget engine 3.1.2 (build 100)

Have you tried with this widget engine before ?

Do you mean uncomment line 303 in tasktracker_widget.php ?

#$project_running = " AND p.project_status > 0 AND p.project_status < 7 ";

Line 304 is a blank line in the version I have ??

Still learning PHP here . Tnks

[keystrokes]

Thanks for the reply Frank and Help

Using Dotproject V 2.0.1 still

The directory Structure is different to what you have written.

C:\Documents and Settings\<user>\My documents\My Widgets\DotProject TaskTrackerV1.1.widget

There is no Content Subdirectory or projects.xml file

Note: that I am running Yahoo widget engine 3.1.2 (build 100)

Have you tried with this widget engine before ?

Do you mean uncomment line 303 in tasktracker_widget.php ?

#$project_running = " AND p.project_status > 0 AND p.project_status < 7 ";

Line 304 is a blank line in the version I have ??

Still learning PHP here . Tnks

Are you trying to run this app on a PC or apple?

[leongoogs]

Running on XP. The other widgets that came with the widget engine are working OK.

Is not the Projects.xml a copy of the projects from the site?

If no data is being received from the site will the projects.xml file still exist ?

[CharredPC]

Under Windows XP, the correct directory is:
C:\Documents and Settings\<username>\Local Settings\Application Data\Yahoo\Widget Engine\DotProject TaskTracker V1.1.widget\DotProject TaskTracker V1.1.widget\Contents

The suggestions listed so far do not work. The file "projects.xml" remains at 0 bytes, not receiving any data, hence the widget reporting no projects. It isn't able to aquire the information from the website.

[Frank Hönisch]

Hello,

Are you trying to run this app on a PC or apple?
I have tested the widget on Windows-PC but it should also run on Mac with the Yahoo!-Widget Engine.


Is not the Projects.xml a copy of the projects from the site?

If no data is being received from the site will the projects.xml file still exist ?


Th widget saves all project data in the file 'Projects.xml', which it gets from the php-script. So if this file have no content, the widget gets no project data from the script.

In the last minutes I have tested the widget with the new Yahoo!-Widget Engine and dotProject2.0.2 and I get the same problem.
The Widget is not the problem. The reason is that the query in the php-script in line 305 supplies no data from the database.

Good Evening

[keystrokes]

Hello,


I have tested the widget on Windows-PC but it should also run on Mac with the Yahoo!-Widget Engine.



Th widget saves all project data in the file 'Projects.xml', which it gets from the php-script. So if this file have no content, the widget gets no project data from the script.

In the last minutes I have tested the widget with the new Yahoo!-Widget Engine and dotProject2.0.2 and I get the same problem.
The Widget is not the problem. The reason is that the query in the php-script in line 309 supplies no data from the database. In dotProject2.0.1 is no problem with this query. So something have been changed.
Tomorrow evening I will test and change it.

Good Evening

This seemed such a good program, and after finding out is was running on Windows, I downloaded it and it works fine for me.

I am on dp 2.02 and run the latest Widgets engine. I run it local on windows XP connected to my site that is remotely hosted.

Regards

Lloyd

[Frank Hönisch]

After I had some problems with dp 2.0.2 yesterday evening, I have installed it again.
Now everything works fine. I get all projects data for the widget.

So if you get the message "No Tasks available!" in the Widget the query in the php-script on line 305 supplies no data from the database.
You can test this query for example in PhpMyAdmin. The only thing you have to do:

After the query write the following line:
$log .= $query2;

So in lines 385 to 387 the query is written into the file "log_server.txt", which is generated in the "dotproject" folder.

In the same way you can test all preferences for database connection.

$log .= "\nDB-Host: ".$host;
$log .= "\nDB-Port: ".$port;
$log .= "\nDB-Name: ".$db;
$log .= "\nDB-Username: ".$dbuser;
$log .= "\nDB-User-Password: ".$dbpw;

[CharredPC]

So.... are you saying that we should all re-install Dot Project, or was there some instruction in here I didn't understand?

After I had some problems with dp 2.0.2 yesterday evening, I have installed it again.
Now everything works fine. I get all projects data for the widget.

So if you get the message "No Tasks available!" in the Widget the query in the php-script on line 305 supplies no data from the database.
You can test this query for example in PhpMyAdmin. The only thing you have to do:

After the query write the following line:
$log .= $query2;

So in lines 385 to 387 the query is written into the file "log_server.txt", which is generated in the "dotproject" folder.

In the same way you can test all preferences for database connection.

$log .= "\nDB-Host: ".$host;
$log .= "\nDB-Port: ".$port;
$log .= "\nDB-Name: ".$db;
$log .= "\nDB-Username: ".$dbuser;
$log .= "\nDB-User-Password: ".$dbpw;

[Frank Hönisch]

So.... are you saying that we should all re-install Dot Project, or was there some instruction in here I didn't understand?

I don't know why in the first time I get no data from dotProject 2.0.2 and after re-install it would work.
The problem is not in the widget or in the php-script.

In your case, I really don't know what the problem is. So I can't give you any instructions.

[leongoogs]

Hi have done some more investigations . I have installed dp2.02 since the previous email. I recovered the database from the dotproject backup file
from the backup module. This does not include the users.
I added the admin user and tried to syncronise the widget . Then it worked !
I then dropped the dotproject database and restored it from a mysql dump
file of the dotproject database only. Once again no connection to dotproject.
It is something in the database content that is stopping the widget
from receiving data/ the query from running. It may be something in the
user tables and permissions !!

[caseydk]

I would like to congratulate Frank on this module. It is great addition to the community.

I've been using Yahoo Widgets since Konfabulator 2(.0?) and this is a great addition there too.

[leongoogs]

I think I have another clue . Those of us that have migrated from very early versions of dotproject have user tables with 26 fields.
+-----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+----------------+
| user_id | int(11) | | PRI | NULL | auto_increment |
| user_username | varchar(255) | YES | MUL | NULL | |
| user_password | varchar(32) | | MUL | | |
| user_parent | int(11) | | MUL | 0 | |
| user_type | tinyint(3) | | | 0 | |
| user_first_name | varchar(50) | YES | | | |
| user_last_name | varchar(50) | YES | | | |
| user_company | int(11) | YES | | 0 | |
| user_department | int(11) | YES | | 0 | |
| user_email | varchar(255) | YES | | | |
| user_phone | varchar(30) | YES | | | |
| user_home_phone | varchar(30) | YES | | | |
| user_mobile | varchar(30) | YES | | | |
| user_address1 | varchar(30) | YES | | | |
| user_address2 | varchar(30) | YES | | | |
| user_city | varchar(30) | YES | | | |
| user_state | varchar(30) | YES | | | |
| user_zip | varchar(11) | YES | | | |
| user_country | varchar(30) | YES | | | |
| user_icq | varchar(20) | YES | | | |
| user_aol | varchar(20) | YES | | | |
| user_birthday | datetime | YES | | NULL | |
| user_pic | text | YES | | NULL | |
| user_owner | int(11) | | | 0 | |
| user_signature | text | YES | | NULL | |
| user_contact | int(11) | | | 0 | |
+-----------------+--------------+------+-----+---------+----------------+

Current dotproject has only 10 fields
+-----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+----------------+
| user_id | int(11) | | PRI | NULL | auto_increment |
| user_contact | int(11) | | | 0 | |
| user_username | varchar(255) | | MUL | | |
| user_password | varchar(32) | | MUL | | |
| user_parent | int(11) | | MUL | 0 | |
| user_type | tinyint(3) | | | 0 | |
| user_company | int(11) | YES | | 0 | |
| user_department | int(11) | YES | | 0 | |
| user_owner | int(11) | | | 0 | |
| user_signature | text | YES | | NULL | |
+-----------------+--------------+------+-----+---------+----------------+

Do you think the query can handle both table types ??

[Frank Hönisch]

Hello,

I think there is no problem with this table, because only the fields user_username, user_password and user_id are necessary.


$query="SELECT `user_id` FROM `users` WHERE `user_username`='".$user."' AND `user_password`='".$pw."'";

[leongoogs]

I have tried running both queries manually in the database.

SELECT user_id FROM users WHERE user_username='username' AND user_password='Password Hash as received from SLL_Access_Log';

This returned User_ID 7

That is correct for that user .

and

SELECT task_log_name, task_log_hours, task_log_description, task_log_date FROM task_log WHERE task_log_creator ='7' ORDER BY task_log_date;

This returned a task list in MYSQL OK.

From the log file I get .

SELECT p.project_id, p.project_name,p.project_description, p.project_status,p.project_start_date,p.project_en d_date,p.project_actual_end_date,p.project_company ,t.task_id,t.task_name,t.task_description,t.task_p ercent_complete FROM user_tasks AS ut JOIN tasks AS t JOIN projects AS p ON (ut.user_id = 7 AND ut.task_id = t.task_id) AND t.task_project = p.project_id AND p.project_active = 1 ORDER BY p.project_name,t.task_name


Is there a project_actual_end_date field in your database ?

If I leave that out the query runs OK!

Changed line 283 in tasktracker_widget.php to

$select = "p.project_id, p.project_name,p.project_description, p.project_status,p.project_start_date,p.project_en d_date,p.project_company,t.task_id,t.task_name,t.t ask_description,t.task_percent_complete";


Now works :)

[Alex B.]

Don't know if someone mentioned that - use addslashes() on task_log_description when executing $query3 or your task notes with single qoutes will not update. It took me about 2 hours to figure out where the problem was.

[littlecong]

It cann't display chinese properly

[CharredPC]

leongoogs: Thank you for your work on this!
Unfortunately, even after the changes, my widget still won't pick up any project data. Same as always; has never worked here. Will continue to monitor the thread in hopes someone finds the cure.

[Frank Hönisch]

Hello,

Is there a project_actual_end_date field in your database ?

Yes in my database is this field. That is great that you found the problem.

Don't know if someone mentioned that - use addslashes() on task_log_description when executing $query3 or your task notes with single qoutes will not update

Thank you Alex that you informed me about this.

It cann't display chinese properly

I noticed that there are problems with the utf-8 encoding. Because of this, the TaskTracker have problems with displaying special characters like chinese letters.

I work at present on a new version of the TaskTracker-Widget. There I wil fix all these problems.

[leongoogs]

Hi Frank and everyone.
Just a general note my migration path across the different versions of dotproject hasn't been easy sometimes. The database step from 1.X to to 2.X can leave the database structure in an unknown state. It is probably best to go through all your tables in MYSQL and record
SHOW FIELDS from <tablename>;
and compare them against the 2.0 database schema documents to see
it is not missing something else?

Also Frank . I notice that if I syncronise the widget and start the laptop from cold (no network connection) the syncronised data is not there.

No sign of the projects.xml yet ?

[littlecong]

I think it should have a font preference to setup a appropriate font to display some non-english like Chinese.

I have change all "Arial" to "simsun"，so that it can display Chinese.

function utf8_encode in tasktracker_widget.php will not work well in Chinese. I modified it as iconv("gb2312", "utf-8", "some txt") to corretly deal Chinese.
So I think there should be a argument to deal with different charset.

Maybe you should create some file like language_en.js, language_de.js,language_it.js and so on to deal with i18n.

You understand my pool English, do you?:p

[Frank Hönisch]

Also Frank . I notice that if I syncronise the widget and start the laptop from cold (no network connection) the syncronised data is not there.

You have synchronised with network connection and after a restart with no connection you have no project data? That is strange.


So I think there should be a argument to deal with different charset.

Maybe you should create some file like language_en.js, language_de.js,language_it.js and so on to deal with i18n.

You understand my pool English, do you?


That is a good idea. I will try it to insert this language selection.

I'm also not so good in english.

[littlecong]

Perhaps WidgetEngineReference_3.1.1.pdf can give you a reference about Localized Widgets.

Please refer to page 14.

[ATang]

how to add the support for other language?

[madow]

Frank Hönisch

I use the Widget daily and truely think it makes my life easier. I was wondering if you had considered adding the option to use the Cost Code for the Company that the Project was assigned to. If the person tracking thier time could also select the cost code from a dropdown and store it the Task logs would be complete. This would allow for the easily creation of the Invoice from the Invoice Module.

Thank you very much for the TaskTracker, great work.

Mike

[pjtaylor]

FYI, I have found that my version of MySQL (3.23.56) didn't like the JOIN syntax so I had to change line 285 to:

$tables = "user_tasks AS ut , tasks AS t , projects AS p";

Tasks are now brought back and it works a treat.

[thebrandonstore]

Hi, is there a version that works with Tiger yet?
Thanks!~

[Frank Hönisch]

Hello,

the TaskTracker is developed for the Yahoo!Widget-Engine (not for Tigers Dashboard). But the Yahoo!Widget-Engine is also available for Tiger on http://widgets.yahoo.com/

[c4361025]

Hallo Frank,

i think it would be great to have an overall access feature. I am a project manager and I would like to check all tasks on all people sorted by projects or staff.

Would something like that be possible?

thx
HArald

[ghostwriter78]

first of all thank you very much for this helpful tool!

it would be great if you could add any of this points..

Is it possible to include same task filters as on dotproject (task view)?
At least following would be great: My Tasks, My Unfinished Tasks, All Tasks, All Unfinished Tasks.

Since our programmers sometimes forget to start the time counter it would be nice if they could enter the time directly at the logging function.

Could you implement also a switch to show active and inactive tasks?

Display of tasks is very compact and clear. Just the Big play button on the top right position makes our users think they can play some music and they mix it always with the start button for time tracking. Could you replace it with something more clear, like L or LOG for Logging and "save" for sending it to the server?

It seems there is some irregularity at Logging function. When i want to stop logging without entering a note (clicked on play button by mistake) then it asks me two times to enter some text in a note. AND it saves a 0.2min log to dotproject. Could you include a CANCEL button for logging?

When i manually refresh the project status then it collapses (closes) all open projects. Is it possible to stay in same position and just refresh the content without collapsing?

Is there a possibility for automatic project status refresh (every 10min)?

Some further helpful items would be:
Show assigned people, just above or below the task description in mouseover.
Quicklink to project reports (similar to "i" button just jumps to report page on dotproject, "R" button)
Show estimated duration and logged duration next to task progres percentage or at task mouseover next to description.

kind regards
Tibor

ps. sorry for crossposting on several websites but all of them show different people as owner of this widget.

[caseyd1020]

Hey...

So does this version work with tiger's regular dashboard?

-------------

--> Having read the above posts, I retract my post, but would ask that you think about making it a normal widget. (:

Casey

[caseydk]

It's a widget for Yahoo Widget Engine, so no it wouldn't work. YWE is nice though since it works on lots of OS's.

Making one for OSX Tiger might be cool, but I think that requires a completely different skill set. On that note, I'm in the middle of writing a simple REST engine for dotProject, so that should make these efforts a bit easier.

[jordis]

I think I found what was going on with the "No tasks available" problem that we all seem to suffer in dP204

leongoogs' post helped me track it down:
SELECT p.project_id, p.project_name,p.project_description, p.project_status,p.project_start_date,p.project_en d_date,p.project_actual_end_date,p.project_company ,t.task_id,t.task_name,t.task_description,t.task_p ercent_complete FROM user_tasks AS ut JOIN tasks AS t JOIN projects AS p ON (ut.user_id = 7 AND ut.task_id = t.task_id) AND t.task_project = p.project_id AND p.project_active = 1 ORDER BY p.project_name,t.task_name
In my dP204 installation, the above query (after fixing the linewrap) resulted in:Unknown column 'p.project_active'
Volia! I don't have that column in the projects table
Looking for "project_active" string in the dP204 code brings up some entries from the "changelog":
2005-11-07 12:20 (pedroix)
---------------------------------
modules/projects/gantt.php
- On stable_2 branch inactive projects are defined trough project_active field and not trough project_status yet, ...
(...)
2006-07-30 06:54 (cyberhorse)
---------------------------------
modules/tasks/gantt.php
- fixed sql (project_active doesn't exist anymore)

and some others
So this column was deprecated in dP204 and "archived" projects are now identified by project_status=7


Is there a project_actual_end_date field in your database ?
If I leave that out the query runs OK!
Well, I DO have this column in the database, so I didn't leave it out...

To cut things short, in tasktracker_widget.php change line 302:
$project_activ = "AND p.project_active = 1"; //nur aktive Projekte auslesen
to:
$project_activ = "AND p.project_status < 7";
That will hopefully return all projects which are not archived.
Alternatively, if you do not want "template" projects (project_status=6) to show up, you can change it to
$project_activ = "AND p.project_status < 6";

I hope this solves your problems!

I just discovered this little gem and it looks really promising, and it would be great if further features like the ones suggested in earlier posts were implemented... like being able to set the time you spent regardless of the stopwatch.

Playing with it, I just realized that one of my tasks was set to 127% completed!

I also realized it does not handle national characters in task names and descriptions...

But this is really nice work!
Keep it up

[caseydk]

I've poked around in the guts of this one too. It uses raw sql strings as opposed to actual dP objects or even the dbQuery stuff. Expect the problems to continue/increase as dP development goes on if this widget isn't updated...

[dotuser]

Hi there,
i have a question, because my TaskTracker do not work :???:
I have install the newest Version of DotProject (2.1 RC1).

All data in TT is correct, but i can't connect to the server.
Is the new version of DP compatible with TT 1.1?

[MacOfTheEast]

Is the new version of DP compatible with TT 1.1?
Actually, you should be asking the question the other way around :)

It's quite possible that they're not compatible with each other. There have been a few changes regarding security that can interfere with those third-party PROGRAMS that access dP EXTERNALLY however third-party MODULES, that run from WITHIN THE DP ENVIRONMENT should not be negatively effected. Therefore, the author of TaskTracker needs to revisit the methods he used for authentication.

MOTE

[caseydk]

Mac is 100% correct.

There have been a number of changes to dotProject itself. Since the TT widget is using raw sql calls for getting data and string concatenation for creating XML, there are going to be problems as tables change.

I'd love to update this to use dP objects, but changing the one PHP file only handles half the work...

[seiacca]

is this working w DP 2.0.4?

[seiacca]

hi all..
about 2 weeks that i am trying to make tastracker 1.1 work on my dp2.0.4.
no way, obviously i need an help.

i get always no connection to web server.
I have put tasktracker_widget.php under dotproject folder
I have configured php script pointing to http://myserver/dotproject/tasktracker_widget.php
if i put it in browser it gives me back "0001-0 0001-1"

i have confugured dotproject url to point to

http://myserver/dotproject/index.php
tried also
http://myserver/dotproject/

also removed .htaccess

can somebody be of any help?
thanks in advance

[caseydk]

This is an extension module not released by the dotProject team and therefore, we don't know much about its internal workings. In the TaskTracker release, there is contact information on the company/team who created.

I attempted to reverse engineer it and make it work for 2.0.4 and to prepare it to use cleaner code (instead of raw sql, ew). The error codes mean nothing to me either... and I was never able to get it working properly due to assumptions it makes about Project/Task layouts. I have contacted their team a few times without a response.

I wish I could do something for you... but please let me know if you hear from their team!

[seiacca]

well, at least i will not try anymore!.
i was just thinking if there is any other tool (working on dp2.0.4) able to track tasks online/offline/syncronize.

[seiacca]

Already sent an email to tyclipso few days ago, got no answer.
I think this module is dead.
if someone has any idea on making tasktracker work on at least dp204 please share!!!
byebye

[Frank Hönisch]

Hello,
sorry that I did not answered to your questions.
All notification-mails were deleted by my spam filter.

Under http://www.tyclipso.net/en/dotProject_TaskTracker.htm
you can find the newest TaskTracker (Version 1.4) .

I have made changes to the widget and also to the php-Script, which generates the XML-data for the widget. A complete description will follow next week.

The widget works with Yahoo-WidgetEngine (http://widgets.yahoo.com/) in version 3.1.. and version 4.0.1 and dotProject Version 2.0.3 and 2.0.4.

I also tested it with dotProject 2.1.0. It seems to work with 2.0.1,
but I can not guarantee it to 100%.

[seiacca]

well it's working now!
great job!
i tested a lil bit the widget, and the online functionalities seem to be ok.
but when you go offline or close the widget the xml files on widget folder are deleted, so you cannot work offline .
any hint about that?

[Frank Hönisch]

Thank you for your information. I will check it tomorrow evening.

[seiacca]

some other testing info:
1)project status menu doesn't work. if you select an option the result is the same as "all projects"
2)what's the first row of buttons?
3) can you explain online/offline behaviour?

Thanks in advance
S

[Oliver30]

Hi,

I'd installed the new version. My question ist, what are new buttons in the widget (Phone, Mail, 1,2,3,...) ?

One more question : I have a project with different subtasks, to which level down can I see the tasks in the widget ? I have tried it, but I can see only the first level : Project - Subtask1 . I can't see the subtask below of subtask1.

Thanks

Oliver

[seiacca]

Frank,
any news about documentation?
is there a way to let tasktracker save offline logs and then re-open them?
thanks
S

[seiacca]

just had a look back on http://www.tyclipso.net/en/dotProject_TaskTracker.htm
it is specified that tasktracker is able to work offline . so maybe I am doing something wrong.

Frank, what I see on my tasktracker 1.4 is that every time I open it it deletes automatically the XML files on widget folder.
I tried this sequence:
1) syncronize with dot proj (at this point xml are filled with DP data)
2) go offline mode
3) close widget
4) copy xml to another location
5)re-open widget (at this point xml with old tasks are deleted so you start from scratch)
6)copy of old XML into widget folder
7) select "reload data"

at this point I got some entry in tasktracker but without any description! to make it show project and tasks I have to sync again, so it is not usable oflline.
I think there are two different problem:
first on opening widget: tasktracker should not delete XML files already present on widget folder
second:behavior on reload data should be adjusted.

[Frank Hönisch]

Hello seiacca

thank you for your testing-work.
I could fix the two bugs.

Here is the fixed version: http://www.tyclipso.net/media/files/DotProject_TaskTracker_v1.4.1.zip

Now the xml-files where stored in another folder, so that the widget-engine couldn't delete them by loading the tasktracker.
Also the offline mode works now correctly, that you can see all descriptions.
The problem was: In the offline-mode I have to rebuild the xml-content and after this step befor every taskname or description was a linebreak "\n" so that you couldn't see the words.

To the your other questions:
1)project status menu doesn't work. if you select an option the result is the same as "all projects"

I have tested the project status menue but I couldn't found any problem at the moment. When you select another status the SQL-query to get the projects where modified (line 269 in the php-file). The number for every status is defined in the Widget-preferences under the point "Projects".

2)what's the first row of buttons?
These buttons are for tasks like "luch" , "writing a mail" or "telephone".
An example: If you working on a task and your telphone rings you only have to click on the button with the phone-icon, so that the widget stops the current task and switches to the task "telephone".
There is only one contition that this works: At the first time you klick on such a button a popup will opened where you have to enter the id and the name of appropriate task. I know this is not very practically but I did not have the time to improve this.

To olivers question:

One more question : I have a project with different subtasks, to which level down can I see the tasks in the widget ? I have tried it, but I can see only the first level : Project - Subtask1 . I can't see the subtask below of subtask1.

At the time there is no diffent representation of tasks with different levels. Perhaps I could change the images in the background of tasks with a lower level. But at the moment I have not the time to work on it, because i hafe to manage my study and work.

So I hope you could understand my bad englisch :confused:

[seiacca]

Thanks for your reply!
I am going to test the new version.
I'll give you a feedback on it.
Last thing is: as the hot buttons are not really easy to manage, is there a way to disable them (hiding from ttracker window)?
THANKS
s

[seiacca]

OK first feedback.
it is ok now, I was able to have the data after closing widget.
I inserted a tasklog in offline mode (lan disconnected) and after that the sync was successful.
anyway I have a few questions:

1) Can you explain behaviour of online/offline button?
2) can you explain behaviour of auto sync preference?
3) is there a way to display on tasktracker the content of already stored tasklogs in XML files? For istance users of tasktracker may want to re-read what they have traced before sync, or simply want to be sure that every activity has been logged.

Really appreciating your work,
S

[seiacca]

few more notes:
1) when you are offline and afterthat you come back online the sync works but on display you have "no connection to server" even if everything works. if you exit from tasktracker and reopen it everithing is fine. (cosmetic bug)
2)there's no way to exit from the page "insert tasklog" with hours and percentage. if you enter it there's no cancel button, so you are forced to insert a new tasklog even if you do not want.( need to add cancel button)
S

[seiacca]

Ok for previous point 2 (cancel button) I found it: you have to right click on widget to display the menu and you can find "cancel". anyway I think it will be useful to insert it in the tasklog window.

S

[ATang]

I can view the tasks in chinese(UTF-8), but when I update the task log all chinese convert to ???????
Could you fix this bug?
Thank you.

Btw, I will like to do a chinese language translation. Could you give me some help?

[phredbroughton]

I just downloaded 1.4.1 today and am very grateful for the cancel function! This had been an issue for me. I had never gotten the off-line mode to work before and will test it tonight, but after reading previous posts, I have great confidence that the fix is in ;-)
One question/feature request.
I am using tasks as a helpdesk type scenario and typically need to email the task contact the notes when I am updating the task. Has there been any thoughts of adding a check box to trigger the DotProject task notifications to contacts? This would (for me) be a great feature, but I don't know if there is any interest from others.

[ATang]

I can view the tasks in chinese(UTF-8), but when I update the task log all chinese convert to ???????
Could you fix this bug?
Thank you.

Btw, I will like to do a chinese language translation. Could you give me some help?

tasktracker.php
line 84
"VALUES (".$tasks_ids[$j].", '".utf8_decode($tasks[$j])."','".addslashes(utf8_decode($tasks_notes[$j]))."', ".$user_id.", ".trim($tasks_times[$j]).", '".trim($tasks_dates[$j])."')";

remove utf8_decode(), change to:

"VALUES (".$tasks_ids[$j].", '".$tasks[$j]."','".addslashes($tasks_notes[$j])."', ".$user_id.", ".trim($tasks_times[$j]).", '".trim($tasks_dates[$j])."')";

all chinese update ok now.

[phredbroughton]

Well something really screwy has happened since I updated to 1.4.1.
1st. I tried to test the off-line mode and got an error about an invalid XLM format.
"2007-04-20 06:18:26 :Error by parsing of the content of "C:/Documents and Settings/myname/Local Settings/Application Data/Yahoo/Widget Engine/Widget Data/DotProject TaskTracker V1.4/projects.xml". Content is no correct XML."

2nd and this is the killer!
I have just discovered that 1.4.1 is duplicating entries in the database. For example, I logged time to a task with 1.5 hours and a description of the work. Later, when I view it in the web interface, this item appears 3 times! I think it is happening if I press the "Synchronize" button. I do have automatic synchronization on so I guess this is really unnecessary, but I do it at times when I have created a new task and I want the Task Tracker to pick it up. It is as if the XML file for these transactions is not getting cleared and so it is repeating the transaction each time I sync. There are many occurances of this that I have found already after just a week or so of using the new code.
I have had to switch back to 1.1 as I don't want to have to double-check every day to make sure there are no dupes.
Any ideas??? I'll try anything and send any logs or output you need.

[Frank Hönisch]

Hello,

I save all task notes into the taskdata.xml (C:/Documents and Settings/myname/Local Settings/Application Data/Yahoo/Widget Engine/Widget Data/DotProject TaskTracker V1.4/taskdata.xml)
By any synchronisation the widget reads the content of this file, send them by POST to the php-file on the server, which writes the notes to the dotProject-database and sends the new procect-list as xml-file to the widget (projects.xml). After synchronisation the content of taskdata.xml should only:

<?xml version='1.0' encoding='UTF-8' ?>
<content></content>



So can you please check, whether this is the case !?

[AjnabiZ]

Hello

Nice Widget.

Does this widget, send any data to the Author of the Widget ?

[Frank Hönisch]

Of course not. What should I do with you data, i still haven't the time to manage all of my own data on my pc :) I'm not working like Google

[phredbroughton]

Hello,

I save all task notes into the taskdata.xml (C:/Documents and Settings/myname/Local Settings/Application Data/Yahoo/Widget Engine/Widget Data/DotProject TaskTracker V1.4/taskdata.xml)
By any synchronisation the widget reads the content of this file, send them by POST to the php-file on the server, which writes the notes to the dotProject-database and sends the new procect-list as xml-file to the widget (projects.xml). After synchronisation the content of taskdata.xml should only:

<?xml version='1.0' encoding='UTF-8' ?>
<content></content>

So can you please check, whether this is the case !?

I have not been able to spend the time to try and recreate this again, but I am switching back to the new version and will test. After the XML error when I tried to use it off-line, I was also wondering if there may have been some issue with this file being (or getting) corrupt. I deleted the XML files and let the widget recreate them. The first test I tried did empty the file as expected. I'll just have to watch it and see if it happens again.
Either way, you couldn not talk me out if using this product! It has been a great help and has made DotProject an even better product than it already was ;-) I can't thank you enough for sharing this with us!

[phredbroughton]

I have been using the widget with the automatic synchronization disabled and it hasn't missed yet. I would watch the contents of the XML file each time and it was cleared as it should be. I am going to switch back to automatic sync and see if the double entries appear again, but so far so good.
Thanks!

[WhiningKhan]

I confirm that 1.4.1 is creating duplicate task log entries if automatic synchronisation is turned on. Haven't had problems with manual sync.

[phredbroughton]

Same here. Double entries re-appear after setting back to automatic synchronization. Manual works fine.

[seiacca]

Frank, is there any way to make tasktracker work with dp 2.1 rc1/2 ?
I think something has changed into database and it is impossible to retrieve data from dp 2.1rc2

someone made it?

[Frank Hönisch]

Hello,

thank you for testing. At time I have to lern for the examinations of my study.
After this (in 14 days) I will fix the bug and test if the widget works with the new dp version.

[Felix Langfeldt]

Hi Frank

Great work! I love this tool.

I noticed a bug in the latest version of your widget (v1.4.1).

Whenever I try to change the value of the "Project Status" preference it gets reverted to the default value. That makes it impossible to use customized project states.

I tracked the problem back to the "displayLanguage.js" file. At line 14 and 63 you set the value of the preference field to a static value. This happens every time the preference dialog is opened, thus overruling the previously entered value. These lines are not necessary at all, because the "default" value already gets set by the widget XML file. When I comment out these 2 lines it works perfectly.

[seiacca]

got 2 systems with dp2.1rc2

in the first everithing is ok with tasktracker.

in the secondone tasktracker doesn't work.

-checked mysql connection from remote->OK
-set devtest=true on tasktracker.php and it gives:

Notice: Undefined index: ps in /var/www/html/catman/tasktracker.php on line 234

Notice: Undefined index: tf in /var/www/html/catman/tasktracker.php on line 235

Notice: Undefined variable: log in /var/www/html/catman/tasktracker.php on line 247

Notice: Undefined variable: makeReport in /var/www/html/catman/tasktracker.php on line 457

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/catman/tasktracker.php:234) in /var/www/html/catman/tasktracker.php on line 459

Notice: Undefined variable: updated_tasks in /var/www/html/catman/tasktracker.php on line 465

Notice: Undefined variable: data in /var/www/html/catman/tasktracker.php on line 466

Notice: Undefined variable: xml_content in /var/www/html/catman/tasktracker.php on line 461

catman is my dotproject install folder

any help?

[seiacca]

the second one with the taasktracker.php error mentioned works if I install from scratch a new dotproject istance with 2.1rc2.

after importing and updating the old db (coming from 2.04) the situation is the same.
the widget remains in status:all project without uploading any project or task.
xml files are not written at all in widget folder.
so i am start thinking about a problem in the database after importing.
Anyway dotproject works perfectly without any problem.

Frank can you give me some infos about debugging the tasktracker?
is there any switch to generate logs?
thanks
S

[seiacca]

as additional info the script updating the db to 2.1 has the following:

# 20061119
# archived status replaces project (in)active flag:
UPDATE `sysvals` SET `sysval_value` = '0|Not Defined\r\n1|Proposed\r\n2|In Planning\r\n3|In Progress\r\n4|On Hold\r\n5|Complete\r\n6|Template\r\n7|Archived' WHERE `sysval_title` = 'ProjectStatus' LIMIT 1;
UPDATE `projects` SET `project_status` = 7 WHERE `project_active` = 0;
ALTER TABLE `projects` DROP `project_active`;


so maybe this could be the problem. in my db there were both inactive and archived project.
i will try to reproduce the problem on a scratch install of 21rc2

[caseydk]

Those 'Notices' are simply because you have your notification level set a bit high. There are no errors in any of that and are simply because there are uninitilized variables all over the place... the worst you could say about that is that the code is a bit sloppy, not necessarily wrong.

Yes, the upgrade to 2.1* replaces your Project Status list with the base one. It was (unfortunately) required in order to deprecate the old field.

[seiacca]

yes caseydk,
absolutely right!

I was missing a & ~E_NOTICE on php.ini....

disabling notices tasktracker is working!

so i will continue in testing the tasktracker under 21rc2!

thanks
S

[seiacca]

Frank,
Tasktracker does not manage dynamic tasks: they are seen as other normal tasks and so it is possible to directly insert logs on them.
this is not allowed under Dp.
also the percentage calculation is based on tasklogs inserted under the dynamic and does not consider related tasklogs of childs.

waiting for future implementation, I think that the best thing at the moment, could be disabling the possibility to view and manage dynamic tasks.
child tasks will behave as normal and so the tasklogger can insert data as usual.

[Meancode]

Hi,

I have this TaskTracker widget installed on two computers, once at work, and a laptop at home. The install at work is fine. But the one on my laptop at home was not showing me the updates, even when I would select "reload data."

So I have deleted and re-installed the widget on my laptop at home. But now I get an error message:

No local project data.

I checked the settings, and all are correct, exactly the same as the settings I put in when I was at work.

Any help on that error? Thanks.

On nevermind. Killing the plist did the trick.

[seiacca]

when inserted a new project status on preference for example (7|Archived as in dp 21) the widget does not change and at next reload it looses the 7th status on configuration.

[seiacca]

Frank,
Any news on Tasktracker?
when will the fixing be released?

[bens]

does anyone know if there is anyway with tasktracker to quickly add a new task to an existing project? This seems like it would be the ultimate asset to dotproject once that gets put in.

Also, has anyone found where the telephone time gets recorded to.

thanks
ben

dotproject rc1
widget engine 4
tasktracker 1.4.1

[Frank Hönisch]

Hello,

how can I see in the Database if a task is a dynamic tasks?

To Meancode Problem:

I checked the settings, and all are correct, exactly the same as the settings I put in when I was at work.

I think the widget on your Laptop works in the offline-Mode. Otherwise there must be a problem with your connection to the php-Script.

To bens:
The aim of the tasktracker was not to rebuild the hole functionality of dotProject in a widget. We have developed it, that we could track the working time on a easy way.

[phredbroughton]

And it does a GREAT job of that!!!
:-) (just wanted to put in my 2cents worth :-)

[bens]

oh well, too much to hope for.

Most of the people we employ get lost with all the functionality of the full dotproject and really only need to see a task list and a timer which is exactly what your widget is already showing them. The only other thing I would like to have users be able to do is quickly add an additional task to an existing project.

I do not know the complexities involved in making a widget. Is your widget open for others to add to? Are you open to adding additional functionality to your widget or to having others add additional functionality to your widget?

[Frank Hönisch]

I think it would be possible that I add a link to every project in the list and the link target is the page of the project in dotProject, where you can add a new task.

[bens]

Has anyone else had the problem where duplicate logs get logged if "automatically syncronize" is checked?

edit:
just realized this got posted in the wrong place, sorry

-ben

[seiacca]

Hello,

how can I see in the Database if a task is a dynamic tasks?

.

column task_dynamic on table tasks I think.

frank, is tasktracker covered by any kind of license?
can we modify/redistribute it?

[bens]

Upon looking further it seems this is the best place to post that question so I will post it again.

Has anyone else had the problem where duplicate logs get logged if "automatically syncronize" is checked?

[Frank Hönisch]

Hello

to your question seiacca:
The use is free, but the copyrights is by tyclipso.net. So it is not free for modifications. But if you want an modifications or a special features, feel free to post it. There is only one limit - the time - I have not so much time for the development on task tracker.


To bens problem:
Upon looking further it seems this is the best place to post that question so I will post it again.

Has anyone else had the problem where duplicate logs get logged if "automatically syncronize" is checked?

Do you have version 1.4.1 of the task tracker. In an older version we had the same problem but after an bugfix it worked correctly.

[bens]

we are using version TaskTracker 1.4.1 and dotProject v2.1 rc1

thanks

[seiacca]

Hello

to your question seiacca:
The use is free, but the copyrights is by tyclipso.net. So it is not free for modifications. But if you want an modifications or a special features, feel free to post it. There is only one limit - the time - I have not so much time for the development on task tracker.

Frank,
I was thinking about making some mods (maybe configurable) on tasktracker and add some features like following:

1)dynamic tasks (right now you can insert tasklogs via tasktracker, this is not correct)
2)biliing code manageable and default billing code (customized DP)
3)ability to add task if possible for project managers usage offline.
4) custom fields capability

of course without subtracting any kind of copyright to Tyclipso.
My only interest is to make it soon.
Let me know your opinion, and a possible way to proceed.
It would be a good thing if you have time to speak with you directly (by mail or call, tyclipso??? let me know)
thanks
S

[timhog]

I have been using task tracker widget for about a year now and love it. but recently it has stopped working and disappeared all together. The icon still exists on the yahoo menu but it does not launch. Would appreciate hearing from anyone who has had a similar problem

[HerbCSO]

Hi there,

love this widget, but I think as of widget engine 4.5 there is a change whereby files cannot be written outside the data directory? I had to change all file variables in onLoad.js from:

//Datei Variablen
var project_file = "projects.xml";
var taskdata_file = "taskdata.xml";
var errorlog_file = "errorlog.txt";

to:

//Datei Variablen
var project_file = system.widgetDataFolder + "/projects.xml";
var taskdata_file = system.widgetDataFolder + "/taskdata.xml";
var errorlog_file = system.widgetDataFolder + "/errorlog.txt";

Prior to making this change I always got exceptions "Access denied" whenever the widget tried to write to these files.

I've got it working now with the changes above, but any chance you could issue an official fix?

Best regards,

Carsten

[HerbCSO]

Whoops, sorry, didn't realize 1.4.1 already fixed that... Never mind - I was using 1.4! ;]

I do have one other problem though, which is that when I open more than one project, the project tasks start to overlap in the text. Anyone else experiencing this problem?

[bens]

hello

is there an english version of the main page for this widget? I thought there was one here: http://www.tyclipso.net/en/dotProject_TaskTracker.htm but this one is no longer in english.

[bens]

I just updated my widget engine to 4.5 on a PC here and I am getting the same text display issues that HerbCSO mentioned.

I have uploaded a screen shot of it here so you can see what it now looks like:
http://monsterteaparty.com/tasktracker.jpg

[Frank Hönisch]

Hello,

I'm still working on the next Version of the TaskTracker-Widget to fix the known problems. I think it would be available in january.

Frank

[seiacca]

Frank,
I tried to contact you on tyclipso but I didn't get any answer.
is there a way to get in contact with you in private?

[timhog]

Great! I look forward to it. Since my last post I have discovered my widget was hiding of the page. But the problem that still persists is the display of an error message. "Content is no correct XML"

Do you know what this is about or how I could go about fixing it?

Also I have another question. Do you think in the future you will develop the widget to fit in a div, so it can be embedded anywhere, outside of yahoo engine?

[INTEL]

This module is really useless with all the bugs, text is over-lapping, Check Mark and X buttons stay even after window is closed, it doesn't email other users when task is updated? it doesnt log.

too many errors that out balance the benefits...

I think you should provide the source and let other people who have time to complete the script for you since you dont have the time...

[timhog]

i was using this widget for about a year and it was great while it worked.
but since it corrupted I can't use it or get any feedback on the error. so my summary is; great widget, crap forum.

[Karen]

Pardon?

This widget is provided by a third party - unconnected with dotProject. If you have an issue with the third party then take it up with them.

We'd appreciate it greatly if you would refrain from abusing our forums for what is, after all, nothing to do with us.

[ajdonnison]

You might want to take it back to where you got it and not to these forums. The widget has nothing to do with the main dotProject project and bitching about it on these forums is not going to do one iota of good.

[Frank Hönisch]

Hallo,

@ timhog:

1. The URL in the widget preferences - Server - PHP-Script is realy available ?

2. For finding the problem you can edit the php-File (tasktracker.php)
2.1 Before the line 222 set: $devtest = true;
2.2 Lines 230 - 231: enter your the username and password;

3. Now open the URL in your browser and check that you get an correct XML
or alternatively: Reload the widget. Now right click on the widget and select "Open widget folder". In the opened explorer you can find an file called projects.xml . Check if this a correct XML-File.

To your second question:

Also I have another question. Do you think in the future you will develop the widget to fit in a div, so it can be embedded anywhere, outside of yahoo engine?


Do you want the taskTacker for other widget-engines like dashbord or the vista system?

[Frank Hönisch]

To all other who have problems with the taskTracker:

I realy want to fix all bugs, but a week have only 7 days and I have to manage my working time and also my studies. And because that we earn no money with the taskTracker-Widget its priority is not so high like of other projects.

An problem for me is, when the structure of dotProjects database would change, the XML file for the widget couldn't generate correctly and the widget can not work. Is there any documentation how I can get the project and task data without using my own SQL queries?

Now @ INTEL
This module is really useless with all the bugs, text is over-lapping, Check Mark and X buttons stay even after window is closed, it doesn't email other users when task is updated? it doesnt log.

If you want to have special features like logging or mailing, write me an private message. Then I can write you how many money it would cost to develop it.

[timhog]

Hi Frank thanks for your reply I will check this and hopefully get it working again.

In regards to my question about making the widget available outside of the yahoo engine, I was thinking can it be embedded into a website such as a joomla platform. That way it could be accessible remotely and a great tool for mobile business's. Something like this I am sure would have great appeal as a commercial component via the Joomla community. I for one would purchase it.

[HerbCSO]

FYI, it looks like the new Widget engine (4.5.1) fixes all the display issues in the widget (1.4.1), so it seems to have been a problem in the engine, not the widget itself. :D

[Frank Hönisch]

Hello,

yes the new widget engine is the reason for the display problems.
I already had fixed most of them.
At the beginning of the next week the new version would be available.


Frank

[pms]

Ahoi!

Bei mir funktioniert der TaskTracker leider iwie gar nicht.
Habe Ihn sowohl auf unserem WebServer als auch bei einer Testinstallation bei mir auf dem localhost getestet, doch beides brachte das selbe Ergebnis:
es erschienen weder Projekte, noch Aufgaben noch sonstiges ... :(

Kann mir da jemand helfen?

[Nick_lar]

in my experience it would be better to post your question in english and to provide informations regarding your installation (OS, version numbers etc.)

Nur sagen "seh nix" ist nicht wirklich produktiv ;)

a nice overview how to ask the smart way is given here: http://catb.org/~esr/faqs/smart-questions.html

das Ganze gibt es sogar auf deutsch: hier (http://www.tty1.net/smart-questions_de.html)

[pms]

okay ;)

so i installed tasktracker today but never mind my settings it wont work :-|
i tested it with the dotproject installation on our webserver and also at my test installation on my localhost test server.

i thought it can connect to the server, cause when i set up a wrong username or a wrong pass i get an adequate message.

my problem is, that i cant see any projects, task, whatever in the tasktracker.
my localhost is a standart xampp installation. dotproject version is 2.1.1

hope that somebody can help me to fix this ...

[spin]

Hi,

I seem to be having problems connecting to the db. The tasktrackerlog.txt says Database Error: No database selected. I have v1.4 and yahoo widgets 4.5.2. I've looked thru here, and have seen the comments about manually adding the db information. According to the readme file that came with this, it says it should obtain it automatically. I've tried entering it in manually, I get the error no database connection on the project screen.

[Freezo]

Hiya,

I really like the idea of this widget...and it looks good...but i cant get it to work... i looked through all the pages of this thread...and nothing works...

I do not get an errror, it just doesnt show projects nor tasks....

Any ideas?

I tried the error checking thingy set to true but when i view that in a browser i get a headers already send message/error.

I'd really like to use this thingy...

So any help would be appreciated.

I am using the latest version of dotproject.

Gr.
Freezo

[Frank Hönisch]

Hello,

a new Version (1.5.0) of the Widget is available.
You can get it from

http://tyclipso.net/de/Produkte/Yahoo_Widgets/dotProject_TaskTracker.htm (http://tyclipso.net/tycon/file.php?id=1324)

I have fixed some problems with the current Yahoo! Widget Engine (4.5.1).
Only the i-button for each task doesn't work at the moment.

If there will be problems (for example problems with the server connection) the widget creates an error file (errorlog.txt). You can find this file in the widget folder - just right click on the widget an choise "Open widget directory".

[Freezo]

Hey Frank,

Thank you for replying, this works now :) Thank you so much. I still have to test if it syncs. But the widget shows the project.

Excellent widget, amazing work :)

QUESTION:
Is there a way to edit the output file for the report?I'd like to style it a bit more (wouldnt mind sharing that with you either hehe). Let me know if it is possible.

NOTE: Just synced it etc everything works.

[starcraft04]

Hi all,

I don't speak german and I have no idea how to configure this widget. It seems great but I understand nothing.

Anyone can give help and explain what fields are necessary and where do we need to put the necessary files?

I am using version 2.1.2 of dotproject and Yahoo widgets 4.5.2 and TaskTracker 1.5. I see the widget but it is not connecting to my site.

Many thanks for your help,

John.

[Frank Hönisch]

Hello starcraft04,

the widget needs the following information (in the widget preferences - right click on the widget an select preferences):
- Login: user name and password (of your dotProject account)
- Server: PHP-Script (URL of the tasktracker.php)

@Freezo:
The file tasktracker.php generates the report. You can edit the generated HTML from line 176 to 207.

[starcraft04]

Hi Frank,

many thanks for your answer, this is sooo great.

It is working now. Could you please tell me where I can find documentation in english on how to use the different functionality of this tool? There are a lot of buttons and I don't know how to use them. If you want, I can help creating a document explaining everything in english or populate a wiki page if you have one as this tool is very useful.

Many thanks,

John.

[Freezo]

Hehe starc, i too do nto know what all the buttons do :) So if Frank could shed some light on this subject, he would make me a happy person too!

[evrapha]

Hi,

Very nice widget. May I use with dotproject 2.1.2 ? If not, what about to upgrade it ?

[Freezo]

Hi evrapha,

I use 2.1.2 and it works.

Gr.
Friso

[evrapha]

Hi Freezo,

Yes, it really works. I was getting a xml error, but this was because I was using a demo project, and maybe the tasks were not so well defined.

By the way, have tried all the buttons of the widget ? Do you know if is there any guide/manual about the meaning of them ? Or do you know what are all these buttons for ? Could you give me a brief about them ?

Other things, is it possible to resize the widget window ?

Thanks.

[starcraft04]

Hi,

I have used this widget and it is great.

Unfortunately, I am missing one project in the widget that is assigned to me. In dotproject version 2.1.2, I am seeing 9 projects when I filter in my name. But when I go to the widget, I only see 8.

Has anyone seen this problem?

Thanks,

John.

[starcraft04]

Hi all,

is it possible with this tool to see all the projects and filter by company or user? Or is it only the ones where tasks are assigned to you? I am saying this because I would like to add logs on tasks where I am not the owner.

Thanks,

John.