View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Timesheet - Cannot find source of huge number of hours - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

5 juin 2025 (16h-17h30)

19 juin 2025 (16h-17h30)

9 septembre 2025 (10h30-12h)

  
 

Planifiez avec ProjeQtOr

18 et 19 juin 2025 (9h-12h30)

17 et 18 septembre 2025 (9h-12h30)

  
 

Administrez avec ProjeQtOr

25 et 26 juin 2025 (9h-12h30)

24 et 25 septembre 2025 (9h-12h30)

  

 

 

Timesheet - Cannot find source of huge number of hours

More
06 Mai 2025 14:22 - 06 Mai 2025 15:07 #1 by fxandrei
Timesheet - Cannot find source of huge number of hours was created by fxandrei
So i have some activities defined, and some users.
One activity shows 3700 hours, real work, for one user associated to it, but cannot find where exactly it is set.
So i go to the activity, select Progress, then on Assigment, i see the user, and it has real h 3700 .

How can i find from where it is comming from ?
Maybe in the tables ?

EDIT:
Seems it has something to do with initial planned and real start and end date. They are very big, and it seems that it take the hours per day and calculates that big hour value.
But i see i cannot change those fields.
Hmmm... i think i need to check the manual :))
Last edit: 06 Mai 2025 15:07 by fxandrei.

Please Connexion or Create an account to join the conversation.

More
14 Mai 2025 09:18 #2 by Arkhanje
Replied by Arkhanje on topic Timesheet - Cannot find source of huge number of hours
Indeed. The planned and real  dates are automatically populated by the application. The planned date is based on the workload you have assigned to the resource and their availability, and the real date is manually populated via timesheet by the resource.

The real date indicates the date of the first assigment. This gives you the correct assignment week to check.
Right-clicking on a bar showing real work will give you details of the resource's work.
Validating allocations can also be a good way to check data as well as certain reports on actual work.

You can't modify them directly, but you can use the control levers to adjust the planned dates and delete or modify timeheet for the real work.

Hmmm... I think I need to check the manual :))

Very good idea! 
File Attachment:

Please Connexion or Create an account to join the conversation.

More
14 Mai 2025 09:56 #3 by fxandrei
Replied by fxandrei on topic Timesheet - Cannot find source of huge number of hours
So ive been looking around for quite some time and i just cannot figure out where those values are coming from.
I can see the value in the timesheet for this resource, on the "real" column, at the front, and also on the revised column.. But i dont know from what its actually calculated.

Please Connexion or Create an account to join the conversation.

More
16 Mai 2025 16:16 #4 by babynus
Replied by babynus on topic Timesheet - Cannot find source of huge number of hours
If you can check the DB:
SELECT * FROM work WHERE idResource=[id of the resource] and refType='Activity' and refId=[id of the activity]
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.034 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form