Skip to main content
J
JN_108759101-Visitor
1-Visitor
November 21, 2024
Solved

Excel custom export template for Issue tracker

  • November 21, 2024
  • 3 replies
  • 1947 views

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)

    Best answer by 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:

    SC_12857095_0-1740425383153.png

     

     

    3 replies

    Catalina
    CatalinaCommunity Manager
    Community Moderator
    November 27, 2024

    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,

    Catalina | PTC Community Moderator
    E
    EvaBertalan12-Amethyst
    12-Amethyst
    January 24, 2025

    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.

    S
    SC_128570957-BedrockAnswer
    7-Bedrock
    February 24, 2025

    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:

    SC_12857095_0-1740425383153.png

     

     

      Terms & ConditionsCookie settingsAccessibility statement