Import Report Definitions

This sequence of test scripts exercises the ability to import report definitions into OSP Reports. Each of the various roles that may design and/or use reports is involved in this sequence.

System Administrator, Program Administrator, CIG Coordinator, Portfolio Owner

List dependencies

1

Download the report_definitions.zip to your computer.

2

Unzip the files. You should have three files: reportDefinition.xml, passthrough.xsl, default.xsl.

3

Upload the passthrough.xsl and default.xsl to the Resources area of the CIG.

4

In the Resources area, right-click on default.xsl, and select Copy link location from the context menu.

e.g. http://localhost:8080/access/content/group/611f97cf-476d-43f7-00fe-1a9256bbdd16/default.xsl

5

Take the part after content and paste in the xlsLink for the file (make sure it starts with a forward slash '/' into reportDefinition.xml. Also, repeat this process with the passthrough.xsl file in Resources.
<property name="defaultXsl">
<bean class="org.theospi.portfolio.reports.model.ReportXsl">
<property name="xslLink"><value>/group/611f97cf-476d-43f7-00fe-1a9256bbdd16/default.xsl</value></property>
<property name="isExport"><value>false</value></property>
<property name="title"><value>Passthrough</value></property>
</bean>
</property>
...
<bean class="org.theospi.portfolio.reports.model.ReportXsl">
<property name="xslLink"><value>/group/99123ecd-a10b-4b79-00dd-27ae0d7c8df3/default.xsl</value></property>
<property name="isExport"><value>false</value></property>
<property name="title"><value>Passthrough</value></property>
</bean>
<bean class="org.theospi.portfolio.reports.model.ReportXsl">
<property name="xslLink"><value>/group/99123ecd-a10b-4b79-00dd-27ae0d7c8df3/passthrough.xsl</value></property>
<property name="isExport"><value>false</value></property>
<property name="title"><value>Passthrough 2</value></property>
</bean>
NOTE: The bold areas are where the links for default.xsl and passthrough.xsl are copied into.

6

Save the reportDefinition.xml file.

7

Go to Reports

8

Click Import Report Definition

The Import Report Definition File page is displayed.

9

Next to 'XML File' click Select file.

The 'Add Attachment' area in Resources is displayed.

10

Click Add and then Upload Files from the context menu.

11

Browse for the reportDefinition.xml file located on your computer.

12

Click Import Definition.

The Reports list page should re-appear with the new template.