Difference between revisions of "Recover iReport template"
From IMSMA Wiki
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | [[Image:IReport list.png| | + | [[Image:IReport list.png|600px|center]] |
| − | + | This page describes how to solve the scenario: | |
| + | # the iReport template '''file''' has been lost | ||
| + | # the template has been published inside {{IMSMANG}} so it is stored in the database. | ||
| + | Follow the steps below to recover the iReport template. | ||
<ol> | <ol> | ||
| − | <li>In | + | <li>In case the report has subreports and those need to be changed, it is important to also locate the subreports.</li> |
| − | : The following query checks if the report contains subreports | + | : The following query checks if the report contains subreports (enter the correct report name in the WHERE clause of this query) |
<pre> | <pre> | ||
SELECT | SELECT | ||
"Parent"."name" AS "Parent name", | "Parent"."name" AS "Parent name", | ||
"Parent".filename AS "Parent file", | "Parent".filename AS "Parent file", | ||
| + | "Parent".jrxml AS "Parent JRXML", | ||
"Child"."name" AS "Child name", | "Child"."name" AS "Child name", | ||
| − | "Child".filename AS "Child file" | + | "Child".filename AS "Child file", |
| + | "Child".jrxml AS "Child JRXML" | ||
FROM | FROM | ||
"public".reporttemplate AS "Parent" | "public".reporttemplate AS "Parent" | ||
| Line 17: | Line 22: | ||
"Parent"."name" = 'Statistics - Land with Ordnance Details' | "Parent"."name" = 'Statistics - Land with Ordnance Details' | ||
</pre> | </pre> | ||
| − | <li>Copy the contents of the column ''jrxml'' to a new NotePad++ | + | [[Image:Recover ireport.png|900px|center]]<br/> |
| − | <li> | + | <li>In Navicat or pgAdmin3, open the table ''reporttemplate'' and identify which iReport is the one for which the file is missing. Reports can be identified by their name.</li> |
| − | <li>Open in iReport and make the changes.</li> | + | <li>Copy the contents of the column ''jrxml'' of the '''parent''' and/or '''child/subreport''' report to a new text file using e.g. NotePad++.</li> |
| + | <li>'''Delete''' the '''double''' quotes at the very beginning '''and''' end of the file.</li> | ||
| + | <li>Save it as a '''.jrxml''' file | ||
| + | : Click '''Save as'''. | ||
| + | : Enter the old file name with the extension .jrxml | ||
| + | : Select '''All types (*.*)''' in the Save as type field). | ||
| + | : Save the file in the folder ''C:\IMSMAng\iReport\Templates''.</li> | ||
| + | <li>Repeat step 3 - 5 for each iReport that needs to be recovered. | ||
| + | <li>Open the saved file(s) in iReport and make the required changes.</li> | ||
| + | |||
| + | {{Note | If there are subreports, the report will not run inside iReport, as it will not find the subreports(s) - unless all the subreports are also saved as .jrxml files and the references from the main to the subreports are updated. Contact your [[Information Management Team | GICHD IM advisor]]in case of questions on this.}} | ||
| + | |||
| + | <li>'''[[Manage Report Templates in IMSMA | Re-import]]''' the changed iReport template into {{IMSMANG}}.</li> | ||
</ol> | </ol> | ||
| − | {{NavBox | + | {{NavBox HowTo Standardizing Data Analysis and Information Reporting}} |
| − | |||
| − | |||
[[Category:NAA]] | [[Category:NAA]] | ||
Latest revision as of 21:26, 20 February 2020
This page describes how to solve the scenario:
- the iReport template file has been lost
- the template has been published inside IMSMANG so it is stored in the database.
Follow the steps below to recover the iReport template.
- In case the report has subreports and those need to be changed, it is important to also locate the subreports.
- The following query checks if the report contains subreports (enter the correct report name in the WHERE clause of this query)
- In Navicat or pgAdmin3, open the table reporttemplate and identify which iReport is the one for which the file is missing. Reports can be identified by their name.
- Copy the contents of the column jrxml of the parent and/or child/subreport report to a new text file using e.g. NotePad++.
- Delete the double quotes at the very beginning and end of the file.
- Save it as a .jrxml file
- Click Save as.
- Enter the old file name with the extension .jrxml
- Select All types (*.*) in the Save as type field).
- Save the file in the folder C:\IMSMAng\iReport\Templates.
- Repeat step 3 - 5 for each iReport that needs to be recovered.
- Open the saved file(s) in iReport and make the required changes.
- Re-import the changed iReport template into IMSMANG.
SELECT "Parent"."name" AS "Parent name", "Parent".filename AS "Parent file", "Parent".jrxml AS "Parent JRXML", "Child"."name" AS "Child name", "Child".filename AS "Child file", "Child".jrxml AS "Child JRXML" FROM "public".reporttemplate AS "Parent" INNER JOIN "public".reporttemplate AS "Child" ON "Parent".guid = "Child".parent_guid WHERE "Parent"."name" = 'Statistics - Land with Ordnance Details'
 |
If there are subreports, the report will not run inside iReport, as it will not find the subreports(s) - unless all the subreports are also saved as .jrxml files and the references from the main to the subreports are updated. Contact your GICHD IM advisorin case of questions on this. |
| ||||||||||
