On this page:
Summary: As described in Instructions for configuring your standalone Health Dashboard , CAST is able to export to Excel/CSV file a allow export of a detailed breakdown of the Enhanced and Automated Function Point data provided "out of the box". However, to do so, a configuration change must be made to the Health Dashboard. This page explains how to configure the Health Dashboard to allow the export of Enhance and Automated Function Point (AFP) data to a Microsoft Excel/CSV file.AEP/EFP function point data to Excel/CSV. Note that this configuration change is ONLY applicable when using the standalone CAST-Health war file (see Health Dashboard deployment) - when using the combined CAST-Health-Engineering war file, the export to Microsoft Excel/CSV icons are visible out of the box.
The export to Microsoft Excel/CSV icons (as shown below) are NOT active (they are greyed out) by default in an "out of the box" Health Dashboard setup when using the standalone CAST-Health war file (see Health Health Dashboard deployment). This is because the information resides in the Dashboard schema (central) :
and not the Measure schema used by the Health Dashboard. In a combined Health and Engineering Dashboard, the dashboard schema is referenced in the context.xml file for the dashboard, so the Health Dashboard already knows where the information is located. To enable these export icons in a standalone CAST-Health war file, a configuration change must be made to the Health Dashboard to inform the dashboard where the information is located. This page explains how to make this change.
Options greyed out:
Activating the export icons
To enable the icons when using the standalone CAST-Health war file (see Health Dashboard deployment), a CAST Administrator needs to make a configuration change as follows:
Determine the Dashboard schema name
First determine which Dashboard
schema the snapshot containing the relevant Application has been generated in. You can do so by
first looking at the Application and Snapshot name in the Health Dashboard:
Open AIP Console and browse to the Admin Center (a user with the ADMIN role is required). Ensure you have selected the Applications tab, find your Application in the list and then click the hamburger options menu:
Choose the View Details option
Expand the Database Schemas section and note the name of the "central base":
This information is also located in CAST Management Studio in the Execution tab of the Application editor - the Dashboard Service is highlighted below:
When you have
the name of the Dashboard schema that stores the required information, open the following file with a text editor:
You now need to add an additional resource which points to the Dashboard
schema you identified above. The following example shows the resource pointing to the Measurement
schema (as defined as part of the initial configuration of the Health Dashboard - see Health Dashboard deployment) and a second resource pointing to the Dashboard
<Resource name="jdbc/domains/AAD" url="jdbc:postgresql://nefyn192.168.200.104:2282/postgres" initConnectionSqls="SET search_path TO V832general_1536_MEASUREmeasure;" username="operator" password="CastAIP" auth="Container" type="javax.sql.DataSource" driverClassName="org.postgresql.Driver" validationQuery="select 1" initialSize="5" maxActive="20" maxIdle="10" maxWait="-1"/> <Resource name="jdbc/domains/V832_1536_CENTRALuuid_55800ce6_03f7_49d0_971c_eb6f18ff2c94_central" url="jdbc:postgresql://nefyn192.168.200.104:2282/postgres" initConnectionSqls="SET search_path TO V832_1536_CENTRALuuid_55800ce6_03f7_49d0_971c_eb6f18ff2c94_central;" username="operator" password="CastAIP" auth="Container" type="javax.sql.DataSource" driverClassName="org.postgresql.Driver" validationQuery="select 1" initialSize="5" maxActive="20" maxIdle="10" maxWait="-1"/>
Please ensure that you:
- Define a unique "name" (unique within the file). In the above example, we have used
uuid_55800ce6_03f7_49d0_971c_eb6f18ff2c94_central- this is different to the default "name" provided by CAST:
jdbc/domains/AADand reuses the name of the CAST AIP schema used for the Dashboard Service (Dashboard schema (note that you can use any name you like but please retain the
- Define a "
url" that points to the RDBMS or CAST Storage Service/PostgreSQL instance on which the Dashboard Service schema is installed. In the majority of most situations, this will be identical to the "url" used for the Measurement Service schema
- Define a "initConnectionSqls
initConnectionSqls" that references the name of the CAST AIP schema used for the Dashboard Service: V832_1536_CENTRAL in
initConnectionSqls="SET search_path TO uuid_55800ce6_03f7_49d0_971c_eb6f18ff2c94_central;"in the example above.
- Check that the "
username" and "
password" entries are correct.
- Following any changes you make, save the context.xml file and then restart your application server so that the changes are taken into account.
- Now when you access the Automatic Function Point pagerelevant pages, the export icon will be visible.
Configuring export to Microsoft Excel or CSV file
By default, the export file format is set to Microsoft Excel (.xlsx). However, it is possible to change this to .csv if you prefer. To do so, open the following file with a text editor:
Locate the following line in the file:
Change the line as follows:
- icons will be visible.