Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Extract Timesheet a...
 
Notifications
Clear all

Extract Timesheet activity

2 Posts
2 Users
0 Reactions
1,718 Views
(@tatatonio)
Posts: 16
Active Member
Topic starter
 
[#6241]

Hi,

I try to collect information about the spent time for an activity, beetween to dates, with the corresponding ressource and comments related to this activity.
Actual reports don't offer me what i specifically need and I didn't find how to export in excel the reports. So I think I have to build a SQL request.

I can find the planed charge but I can't find where are stored every hour entered in the timesheet.
Can you help me please ?

How complex do you think it is to implement this request as an integrated report ?
Thks,


 
Posted : 12 Sep 2019 17H40
(@babynus)
Posts: 14952
Member Admin
 

Actual reports don't offer me what i specifically need and I didn't find how to export in excel the reports. So I think I have to build a SQL request.

On Timesheet, you can Export Data to CSV format

I can find the planed charge but I can't find where are stored every hour entered in the timesheet.

table work

How complex do you think it is to implement this request as an integrated report ?

I don't know, all depends on what you want to get, sums, consolidations, numbe of tables involved, formating, ...


 
Posted : 13 Sep 2019 16H09
Share:

Scroll to Top