Exporting Relationship Matrices to Word

[Polymorph]

Has anyone found a way to create a document template that exports a relationship template to Word? I can get EA to print out a JPEG of the matrix easily enough but this is totally useless because it is so tiny as to be completely illegible. Does this require some kind of Ninja SQL skills?

Obviously there's the CSV export option from the Relationship Matrix itself but this has its own problems because it only outputs the names of the elements and none of their detailed attributes such as their notes.

I am performing requirements traceability and am amazed that this functionality seems to be so lacking!

[PeterHeintz]

I assume you need the Ninja SQL skills.

[Nabil]

Try Custom Template with scripting guess that is the only way to acheive what you expect.

Best Regards,
Nabil Saleem

[Geert Bellekens]

It's going to need some kind of Ninja skills, but I think you will probably need a document script template to be able to vary the number of columns in your table.
So you'll need to make a script that outputs raw RTF that contains the table with the contents you need.

Geert

[Polymorph]

Thanks guys

Why on Earth isn't this something EA supports?!? Seriously, who wants a JPEG of a relationship matrix!!

[Geert Bellekens]

Thanks guys

Why on Earth isn't this something EA supports?!? Seriously, who wants a JPEG of a relationship matrix!!

Because someone put it on the backlog and one of the juniors took the ticket and didn't know any better because the requirements were not clear.

Happens all the time in all development teams 

Geert

[pb17]

I´m having the exact same problem. Has anyone found a possible solution to this issue?
I´m trying the RTF template and the custom script approach, but it is getting more complex. I can create an XML structure of the matrix but I'm failing to understand how to export it in a fragment.

Thank you in advance. 

[Geert Bellekens]

The only feasible solution is to export the same data in a fixed column layout using an SQL fragment:

see also https://stackoverflow.com/questions/76359145/how-to-export-a-relationship-matrix-in-a-document

If you really really wanted to, you'd have to somehow craft an RTF string containing the contents of your matrix.
I'm not sure how you'd do that, but RTF is textual format. If you use wordpad to create a table with a few rows and columns, and save it as .rtf, you can open it with notepad and see how it looks in RTF.
then work back from there I guess...

Good luck 

Geert

[Sunshine]

I resorted to post editing a word document by exporting the matrix to CSV, opening in MS Excel then copy and pasting into MS Word.

[Thomas Arnbjerg]

I normally create a javascript script, which generates new 'report friendly' trace elements in the model followed by a report template to create the Word Document..