Absent Member.
Absent Member.
806 views

Exporting reports (as PDF and/or xls) via web services?

Jump to solution

Hello all,

I have the following requirement: after the execution of the automated tests is finished, a certain report (most likely a BIRT report template inside the project) is generated and uploaded to a certain location.

From the subscription options SILK offers two things are missing : the linkage between the "end of execution" and the generation (the trigger is rather time-dependent - at certain time of the day) and the location (we can either get it as an attachment inside an email or as an url for the dashboard).

The other option I've found is the reportData interface , but this allows only 2 formats - xml and csv , while I need the PDF/HTML..

Is there an option to achieve the requirements?

Thank you in advance.

 

BR,

Boris,

 

0 Likes
1 Solution

Accepted Solutions
Micro Focus Expert
Micro Focus Expert

Hi Boris,

Silk Central does not provide an automatic upload of the report output to a certain location. It is possible to either get a HTML version of a BIRT report at a certain link location or to send a PDF of this report per Email. See below:

Use the access link from the report subscription dialog to embed the output in an external system, use it in iframe or use it directly in a link. Here is a description how to use and to embed it in an external page:

http://documentation.microfocus.com/help/topic/com.microfocus.sctm.doc/GUID-3541BA8E-E520-4986-B162-F14090B8012A.html?cp=10_0_2_5_3_1_1_3_0

Alternatively, configure "Send as Email" to get a XLSX or PDF version sent to any Email address.

 

Since Silk Central 18.0 you have, besides the schedule based option to trigger a report subscription, the option to generate the report at the end of an execution plan run. It can be configured in the Execution Plan properties page, section "Notifications and Reports". It is documented here:

http://documentation.microfocus.com/help/topic/com.microfocus.sctm.doc/SCTM-09E703C7-EXECUTIONPROPERTIESPAGE-REF.html?cp=10_0_2_4_3_2

 

If you combine the above you can have either

- a stable link to the latest version of a report which is updated every time the execution plan finishes or

- a PDF version of your report sent to one or more Email recipients.

 

Regards,

Hubert

View solution in original post

0 Likes
4 Replies
Micro Focus Expert
Micro Focus Expert

Hi Boris,

Silk Central does not provide an automatic upload of the report output to a certain location. It is possible to either get a HTML version of a BIRT report at a certain link location or to send a PDF of this report per Email. See below:

Use the access link from the report subscription dialog to embed the output in an external system, use it in iframe or use it directly in a link. Here is a description how to use and to embed it in an external page:

http://documentation.microfocus.com/help/topic/com.microfocus.sctm.doc/GUID-3541BA8E-E520-4986-B162-F14090B8012A.html?cp=10_0_2_5_3_1_1_3_0

Alternatively, configure "Send as Email" to get a XLSX or PDF version sent to any Email address.

 

Since Silk Central 18.0 you have, besides the schedule based option to trigger a report subscription, the option to generate the report at the end of an execution plan run. It can be configured in the Execution Plan properties page, section "Notifications and Reports". It is documented here:

http://documentation.microfocus.com/help/topic/com.microfocus.sctm.doc/SCTM-09E703C7-EXECUTIONPROPERTIESPAGE-REF.html?cp=10_0_2_4_3_2

 

If you combine the above you can have either

- a stable link to the latest version of a report which is updated every time the execution plan finishes or

- a PDF version of your report sent to one or more Email recipients.

 

Regards,

Hubert

View solution in original post

0 Likes
Absent Member.
Absent Member.
Thanks Hubert, this answers my question.
0 Likes
Absent Member.
Absent Member.
Hi again Hubert,

Both proposals work as expected ,thanks.


However there is another issue (or request 🙂 ) - most of the reports we have in our projects are "execution plan" related - we do generate them on each and every new execution of the execution planning. Both proposals are rather static - whichever ExecDefRunID is set - that's what we get report for...

Can we create a subscription for an execution planning that takes the latest ExecDefRunID ? Similar to how the schedule is implemented (no schedule = trigger at the end of the execution => no param = take the one from the current execution).

Am I missing something ? Do you see some workaround?

Thank you in advance.
Boris,
0 Likes
Micro Focus Expert
Micro Focus Expert

Hi Boris,


To get the latest run of an execution plan add this SQL to your query:

SELECT MAX(ExecDefRunID_pk_fk)

FROM TM_ExecDefinitionRuns

WHERE ExecDefID_fk = <YOUR_EXEC_PLAN_ID>

 

Regards,
Hubert

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.