topic Excel custom export template for Issue tracker in Codebeamer

Excel custom export template for Issue tracker

JN_10875910 — Thu, 21 Nov 2024 11:46:06 GMT

Hi,

I'm trying to customize an Excel template to export the different fields of my Issue tracker (see issue_tracker_fields.png for the fields).

The "basic" template from codeBeamer does what I would like to do for the exported data but I would like to customize its style, for both single and multi row options (enabled through the GUI).

Exported Issue tracker using default codeBeamer template with multi-rows enabled: export_issue_tracker_default_template_multirows.xlsx
Exported Issue tracker using default codeBeamer template without multi-rows enabled: export_issue_tracker_default_template_singlerow.xlsx

My custom template: issue_tracker_custom_template.xlsx
Actual export results: export_issue_tracker_custom_template.xlsx

Note that the multi choice fields are only: "Owner(s) and "codeBeamer item(s)"

Could you please help me to correct my template to achieve similar results?

If you have access to the default codeBeamer export template file, that could also help!

Thanks a lot in advance,

Jonathan
(codeBeamer 21.09-SP5)

Re: Excel custom export template for Issue tracker

Catalina — Wed, 27 Nov 2024 12:58:41 GMT

Hi @JN_10875910

Thank you for your question.

Your post appears well documented but has not yet received any response. I am replying to raise awareness. Hopefully, another community member will be able to help.

Also, feel free to add any additional information you think might be relevant. It sometimes helps to have screenshots to better understand what you are trying to do.

Best regards,

Re: Excel custom export template for Issue tracker

EvaBertalan — Fri, 24 Jan 2025 15:46:43 GMT

Hi @JN_10875910,

The default Excel export is generated in Java, so we don't have any default template.

This is the reason why we cannot create a custom template that creates exactly the same result as the default export.

If you have a specific question regarding the custom template, support can help you.

Otherwise you can ask help from your CSM, developing custom templates belong to other departments.

Re: Excel custom export template for Issue tracker

SC_12857095 — Mon, 24 Feb 2025 19:33:09 GMT

I found https://codebeamer.com/cb/wiki/1563473 which talks about getting each comment listed as its own line by using an additional forEach loop. With that information I started from your template and updated the "Owner(s)" column to have:

<jt:if test="${item.supervisors != null}"><jt:forEach items="${item.supervisors}" var="supervisor">${supervisor.name}</jt:forEach></jt:if>

And the "codeBeamer Item(s)" column to have:

<jt:if test="${fields.getByLabel(item,'codeBeamer item(s)') != null}"><jt:forEach items="${fields.getByLabel(item,'codeBeamer item(s)')}" var="cb">${cb.name}</jt:forEach></jt:if>

That gave me an export looking like: