Skip to main content
1-Visitor
May 6, 2016
Solved

Export traceability matrix report to excel

  • May 6, 2016
  • 1 reply
  • 2970 views

Hello Everyone! I am trying to create a report in Integrity that could generate customized excel traceability reports but I have no idea where to start from. Does anyone can point me to a direction where I could find a good literature to try and implement that functionality?

Thank you!

Danilo

    Best answer by KaelLizak

    Hello Jason Zand,

    There is an existing HTML report for traceability in the ALM solution.  It's called <ALM_Prefix>Document Matrix, although <ALM_Prefix>Document Traces might actually be a better starting point, depending on what you are intending to do.

    As an early version of it, you could output the results as a .csv file instead of as HTML, which would make it very easy to import into Excel.  That would probably be a reasonable format to get to Excel.  In theory, you could probably export it to .xslx, but that would likely take additional post-processing after exporting from Integrity.  Certainly, I can't think of any easy way to do it.

    If I was forced to hack something to generate a final .xslx, I'd probably use something like this, and modify the script to do the conversion using existing tools, then email the completed report to the requesting user, if I could get the user's email address from the report output.

    Regards,
    Kael

    1 reply

    KaelLizak16-PearlAnswer
    16-Pearl
    May 9, 2016

    Hello Jason Zand,

    There is an existing HTML report for traceability in the ALM solution.  It's called <ALM_Prefix>Document Matrix, although <ALM_Prefix>Document Traces might actually be a better starting point, depending on what you are intending to do.

    As an early version of it, you could output the results as a .csv file instead of as HTML, which would make it very easy to import into Excel.  That would probably be a reasonable format to get to Excel.  In theory, you could probably export it to .xslx, but that would likely take additional post-processing after exporting from Integrity.  Certainly, I can't think of any easy way to do it.

    If I was forced to hack something to generate a final .xslx, I'd probably use something like this, and modify the script to do the conversion using existing tools, then email the completed report to the requesting user, if I could get the user's email address from the report output.

    Regards,
    Kael