ProjeQtOr free project management software - Extract Timesheet activity - ProjeQtOr
 

Extract Timesheet activity

More
12 Sep 2019 15:40 #1 by Tatatonio
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,

Please Connexion or Create an account to join the conversation.

More
13 Sep 2019 14:09 #2 by babynus
Replied by babynus on topic Extract Timesheet 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.

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, ...

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.044 seconds