Perhaps the easiest way to manipulate data, using the grouping arrangement you
note above, is to extract the relevant data from allocPSA, using the raw
Reports functionality, and then massage that data in a spreadsheet:
To extract the data, click on the Tools menu in allocPSA, then click on the
Reports tool, under Miscellaneous.
in the Reports tool, select the Time Sheets database and click on the Show
Fields button.
You can then experiment with using simple Query by Example settings in the
data fields to provide you with a raw dump of those timesheets which you need.
Do this by placing values in the fields you want to filter on, as per the
instructions in the allocPSA Help file.
Once done, get that data exported as a file by checking the 'Generate File:'
check-box.
Once you have that data file, you can import it as a CSV or TAB delimited file
in your spreadsheet or end-user database application. If you don't have one of
these, you can download one for free from:
Hi,
I would like to get reports for timesheets in a form of:
Prj1
Task1
User1 Hours
User2 Hours
Task2
User2 Hours
User3 Hours
Prj2
Task1
User1 Hours
User4 Hours
grouped by projects and tasks,
or grouped by people, I mean how much hours employee spent on a different
projects.
How can I achieve that?
Hello geshkin
Perhaps the easiest way to manipulate data, using the grouping arrangement you
note above, is to extract the relevant data from allocPSA, using the raw
Reports functionality, and then massage that data in a spreadsheet:
To extract the data, click on the Tools menu in allocPSA, then click on the
Reports tool, under Miscellaneous.
in the Reports tool, select the Time Sheets database and click on the Show
Fields button.
You can then experiment with using simple Query by Example settings in the
data fields to provide you with a raw dump of those timesheets which you need.
Do this by placing values in the fields you want to filter on, as per the
instructions in the allocPSA Help file.
Once done, get that data exported as a file by checking the 'Generate File:'
check-box.
Once you have that data file, you can import it as a CSV or TAB delimited file
in your spreadsheet or end-user database application. If you don't have one of
these, you can download one for free from:
http://www.libreoffice.org/download
Once you've got the data in there, you can massage it in whatever way you feel
is needed.
Best of luck
-- Con