- change the work packages view to display the maximum number of work package by page (this settings is configurable in the OpenProject administration in System settings > General)
- now, the tricky part : we can’t select all work packages and copy them because of some script and/or css managing the selection of work packages so we have to disable the script and/or the css with NoScript or something like that or by saving the HTML page to your computer and edit the
tag to remove all the scripts.
- Then, you can select all the work packages and copy and past them to an XLS or ODS and all the work packages should be sorted in the same order as your initial export (in the first step)
- just add the cost column to your first XLS/ODS…
Sorry for my poor English and poor explanations
You can export backlogs (not in a nice row/coumn fashion but you can) but I believe that we can’t configure an export card to export the costs. But you could try (it uses the YAML language).
exporting cost reports as Excel documents (which could then be saved as PDF documents) is on our roadmap / in our product backlog: .
As a workaround you could deactivate the cost report module in your project, make sure that the “Time tracking” module is activated and select the “Time entries” entry from the project menu on the left side.
This has fewer filtering options but includes a CSV export. You could then save the exported CSV file as a PDF document.
To the both of you, thanks for answering, but that is not what I’m searching for.
I’m primarily using OpenProject for a repair tracker. So when a customer has their computer in for a repair, I print out the work package as a PDF.
On that PDF it could be nice to have the specified cost’s on the given repair.
As it is now, the costs doesn’t appear on the work package PDF.
I made a workaround which involves the following:
- I keep track on which spareparts and work hours used with “register cost”.
- The total is then copied to a custom field manually.
- Another custom field is handling the track on what has been fixed and replaced.
As a whole, it would be pretty great to get a means to edit the PDF’s looks and what should be exported.
I know I’m probably pretty alone with this request, but it would be nice with some customization to the PDF export module.
thanks for the response.
It’s actually a bug that costs are not shown on the PDF export (#26562).
You can however use the browser print-function (Ctrl/Cmd + p) to print the work package. Change to the fullscreen mode before.
With OP 7.4 the browser-print will look a lot better: .
I do hope though, that the costs can be specified on the PDF print in the near future. So that there’s a table specifying the cost type, the quantity and the total cost for that cost.
Example:
Part
Quantity
Amount
Total
Fan
2
10€
20€
Work hours
1
50€
50€
Total
70€
I know that this might be a dream never happening. But here’s to hoping :D.
Replies (5)
The only way I’m aware off:
- export your work packages to XLS
- change the work packages view to display the maximum number of work package by page (this settings is configurable in the OpenProject administration in System settings > General)
- now, the tricky part : we can’t select all work packages and copy them because of some script and/or css managing the selection of work packages so we have to disable the script and/or the css with NoScript or something like that or by saving the HTML page to your computer and edit the
tag to remove all the scripts.
- Then, you can select all the work packages and copy and past them to an XLS or ODS and all the work packages should be sorted in the same order as your initial export (in the first step)
- just add the cost column to your first XLS/ODS…
Sorry for my poor English and poor explanations
You can export backlogs (not in a nice row/coumn fashion but you can) but I believe that we can’t configure an export card to export the costs. But you could try (it uses the YAML language).
Hello Stephan,
exporting cost reports as Excel documents (which could then be saved as PDF documents) is on our roadmap / in our product backlog:
As a workaround you could deactivate the cost report module in your project, make sure that the “Time tracking” module is activated and select the “Time entries” entry from the project menu on the left side.
This has fewer filtering options but includes a CSV export. You could then save the exported CSV file as a PDF document.
Best regards,
Robin
To the both of you, thanks for answering, but that is not what I’m searching for.
I’m primarily using OpenProject for a repair tracker. So when a customer has their computer in for a repair, I print out the work package as a PDF.
On that PDF it could be nice to have the specified cost’s on the given repair.
As it is now, the costs doesn’t appear on the work package PDF.
I made a workaround which involves the following:
- I keep track on which spareparts and work hours used with “register cost”.
- The total is then copied to a custom field manually.
- Another custom field is handling the track on what has been fixed and replaced.
As a whole, it would be pretty great to get a means to edit the PDF’s looks and what should be exported.
I know I’m probably pretty alone with this request, but it would be nice with some customization to the PDF export module.
Hi Stephan,
thanks for the response.
It’s actually a bug that costs are not shown on the PDF export (#26562).
You can however use the browser print-function (Ctrl/Cmd + p) to print the work package. Change to the fullscreen mode before.
With OP 7.4 the browser-print will look a lot better:
Best regards,
Robin
I will look forward to the 7.4 then :).
I do hope though, that the costs can be specified on the PDF print in the near future. So that there’s a table specifying the cost type, the quantity and the total cost for that cost.
Example:
I know that this might be a dream never happening. But here’s to hoping :D.