It's all about the answers!

Ask a question

Problem deploying an RPE template with Word stylesheet attached in RQM


Dan Ani (131) | asked Apr 10 '20, 6:05 a.m.

Hello everyone,


I'm trying to deploy an RPE template in RQM but I also want to include a WORD stylesheet (.dot or .dotm)

I've followed all the steps from the official IBM page: https://www.ibm.com/support/knowledgecenter/SSYMRC_6.0.2/com.ibm.rational.rrdg.usage.doc/topics/t_rrdg_make_reports_avail.html but with no results. I'm attaching a template (.dta) and in additional files I'm adding the Word stylesheet and the .dsx file but when I'm running the report and export to Word, the stylesheet is not used.

Anyone managed to deploy an RPE template and to include a WORD stylesheet in RQM before? 

Accepted answer


permanent link
Bartosz Chrabski (3.1k12141) | answered May 15 '20, 1:47 p.m.
Dan,

When You create an resource and you add dsx and word files please remove fakepath before a file names. Keep only file names.

You have now:


Should be:

Dan Ani selected this answer as the correct answer

4 other answers



permanent link
Subramanya Prasad Pilar (4.4k14) | answered Apr 10 '20, 8:02 a.m.
edited Apr 10 '20, 8:12 a.m.
In the document specification (.dsx) file, provide only the file name (without any path) for "Stylesheet" property of Word output. You can retain only Html, Word and PDF outputs.In RQM, while creating report resource, first browse and upload the .dta file. While uploading additional files, first add the word stylesheet followed by .dsx file.
The sequence makes the difference. You can also note that adding .dta in the document specification file does not actually use that .dta. It will always use the .dta uploaded while creating report resource.

permanent link
Dan Ani (131) | answered Apr 12 '20, 4:34 a.m.

 Hei Prasad,


Thank you for your help.

Unfortunately I followed exactly the steps provided by you and in the exact order but the result is the same. The stylesheet is not used when running the report in WORD format.

I did further investigations and it seems like when the document is generated (by RPE) the Word stylesheed is not found. Please see the error message from the qm.log file.
--------------------
2020-04-10 21:47:01,982 [            RRDG_624:2193-CORE] ERROR com.ibm.rational.rrdg                               - CRRPE3186E The stylesheet DTP_Template.dotm could not be used.
java.io.FileNotFoundException: file:/C:/Users/danan/AppData/Local/Temp/reports_JFWYYXHaEeqqV9MwnR7uNw/__GrEMHtaEeqcvbgM1VZY-A/DTP_Template.dotm
-------------------

If I'm going to the directory created by RPE for this report (mentioned in the Error message) I can find only the .dsx file and the .dta file that I've uploaded in RQM but no Word stylesheet. For some reason the stylesheet is not copied in the temp directory and the RPE is not able to find it.

Note: I'm using RQM 6.0.6.1

Any thoughts?


permanent link
Subramanya Prasad Pilar (4.4k14) | answered Apr 14 '20, 3:40 a.m.
edited May 15 '20, 9:43 a.m.
Make sure you delete the prefix "C:\fakepath\" from the path after uploading the files:


permanent link
Marcin Blacha (14617) | answered May 18 '20, 4:32 a.m.
edited May 18 '20, 4:33 a.m.

Try to name all files template.xxx (template.dta, template.dsx, template.dot, etc.).  And of course remove all "fakepath" as other recommend.

Your answer


Register or to post your answer.