Excel custom export template for Issue tracker

[JN_10875910]

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)

[Catalina]

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,

[EvaBertalan]

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.

[SC_12857095]

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: