Difference between revisions of "Recover iReport template"
From IMSMA Wiki
(Created page with "The user has lost his iReport template file and do not want to start from the beginning. <ol> <li>In Navicat, open the table ''reporttemplate'' and identify which iReport it...") |
|||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | [[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 Navicat, open the table ''reporttemplate'' and identify which iReport | + | <li>In case the report has subreports and those need to be changed, it is important to also locate the subreports.</li> |
| − | <li>Copy the contents of the column ''jrxml'' to a new NotePad++ | + | : The following query checks if the report contains subreports (enter the correct report name in the WHERE clause of this query) |
| − | <li> | + | <pre> |
| − | <li>Open in iReport.</li> | + | 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' | ||
| + | </pre> | ||
| + | [[Image:Recover ireport.png|900px|center]]<br/> | ||
| + | <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>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 20: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. |
| ||||||||||
