Recover iReport template - Revision history

Alnaucler at 19:26, 20 February 2020

2020-02-20T19:26:44Z

← Older revision		Revision as of 21:26, 20 February 2020
Line 40:		Line 40:

	{{NavBox HowTo Standardizing Data Analysis and Information Reporting}}		{{NavBox HowTo Standardizing Data Analysis and Information Reporting}}
	[[Category:~~VIE~~]]		[[Category:NAA]]

Alnaucler at 19:19, 19 June 2017

2017-06-19T19:19:18Z

← Older revision		Revision as of 21:19, 19 June 2017
Line 25:		Line 25:
	<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>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>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>'''~~Remove~~''' the '''double''' quotes at the very beginning '''and''' end of the file.</li>		<li>'''Delete''' the '''double''' quotes at the very beginning '''and''' end of the file.</li>
	<li>Save it as a '''.jrxml''' file		<li>Save it as a '''.jrxml''' file
	: Click '''Save as'''.		: Click '''Save as'''.

Alnaucler at 18:26, 20 August 2016

2016-08-20T18:26:21Z

← Older revision		Revision as of 20:26, 20 August 2016
Line 1:		Line 1:
	[[Image:IReport list.png\|~~500px~~\|center]]		[[Image:IReport list.png\|600px\|center]]
	~~The user has lost an~~ iReport template '''file'''~~, but still~~ has the ~~imported~~ template inside ~~IMSMA. The user wants to make changes to the template~~ in ~~iReport and therefore needs to recover~~ the ~~file~~. ~~The steps to do that are the following:~~		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 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>In case the report has subreports and those need to be changed, it is important to also locate the subreports.</li>		<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 (enter the correct report name in the WHERE clause of this query)		: The following query checks if the report contains subreports (enter the correct report name in the WHERE clause of this query)
Line 20:		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'' (of the parent and/or child report~~, as required)~~ to a new NotePad++ ~~file~~.</li>		[[Image:Recover ireport.png\|900px\|center]]<br/>
	<li>'''Remove the double ~~quotes~~''' at the very beginning and end of the file.</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>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>'''Remove''' the '''double''' quotes at the very beginning '''and''' end of the file.</li>
	<li>Save it as a '''.jrxml''' file		<li>Save it as a '''.jrxml''' file
	: Click '''Save as'''.		: Click '''Save as'''.
	: Enter a file name with the extension .jrxml		: Enter the old file name with the extension .jrxml
	: Select '''All types (.)''' in the Save as type field).</li>		: Select '''All types (.)''' in the Save as type field).
	<li>Open the saved file in iReport and make the required changes.</li>		: 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 ~~VIE~~ in case of questions on this.}}		{{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>~~As required, re~~-import the changed iReport template into {{IMSMANG}}.</li>		<li>'''[[Manage Report Templates in IMSMA \| Re-import]]''' the changed iReport template into {{IMSMANG}}.</li>
	</ol>		</ol>

	{{NavBox ~~Hub~~}}		{{NavBox HowTo Standardizing Data Analysis and Information Reporting}}
			[[Category:VIE]]
	~~[[Category:NoPublic]]~~
	[[Category:~~NAA~~]]

Alnaucler at 10:48, 19 March 2015

2015-03-19T10:48:45Z

← Older revision		Revision as of 12:48, 19 March 2015
Line 20:		Line 20:
	"Parent"."name" = 'Statistics - Land with Ordnance Details'		"Parent"."name" = 'Statistics - Land with Ordnance Details'
	</pre>		</pre>
	<li>Copy the contents of the column ''jrxml'' (of the parent and/or child report, as required) to a new NotePad++ file, '''~~remove~~ the double quotes''' at the very beginning and end of the file~~, and save~~ it as a '''.jrxml''' file ~~(click~~ '''Save as'''~~, enter~~ a file name with the extension .jrxml~~, and select~~ '''All types (.)''' in the ~~save~~ as type field).</li>		<li>Copy the contents of the column ''jrxml'' (of the parent and/or child report, as required) to a new NotePad++ file.</li>
	<li>Open the saved file in iReport and make the required changes. ~~Please note that if~~ there are subreports, the report will not run inside iReport, as it will not find the subreports(s) - unless all the subreports are ~~alos~~ saved as .jrxml files and the references from the main to the subreports are updated. Contact VIE in case of questions on this.~~</li>~~		<li>'''Remove the double quotes''' at the very beginning and end of the file.</li>
	<li>As required, re-import the changed iReport template into ~~IMSMA~~.</li>		<li>Save it as a '''.jrxml''' file
			: Click '''Save as'''.
			: Enter a file name with the extension .jrxml
			: Select '''All types (.)''' in the Save as type field).</li>
			<li>Open the saved file 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 VIE in case of questions on this.}}

			<li>As required, re-import the changed iReport template into {{IMSMANG}}.</li>
	</ol>		</ol>

Evinek at 10:33, 19 March 2015

2015-03-19T10:33:02Z

← Older revision		Revision as of 12:33, 19 March 2015
Line 1:		Line 1:
	[[Image:IReport list.png\|500px\|center]]		[[Image:IReport list.png\|500px\|center]]
	The user has lost ~~his~~ iReport template file and ~~do not want~~ to ~~start from~~ the ~~beginning~~.		The user has lost an iReport template '''file''', but still has the imported template inside IMSMA. The user wants to make changes to the template in iReport and therefore needs to recover the file. The steps to do that are the following:

	<ol>		<ol>
	<li>In Navicat, open the table ''reporttemplate'' and identify which iReport it is.</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>
	: The following query checks if the report contains subreports		<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 (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 20:
	"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++ file and save as '''~~txt~~'''~~.</li>~~		<li>Copy the contents of the column ''jrxml'' (of the parent and/or child report, as required) to a new NotePad++ file, '''remove the double quotes''' at the very beginning and end of the file, and save it as a '''.jrxml''' file (click '''Save as''', enter a file name with the extension .jrxml, and select '''All types (.)''' in the save as type field).</li>
	~~<li>Change the~~ file ~~type in Windows Explorer to~~ '''jrxml'''.</li>		<li>Open the saved file in iReport and make the required changes. Please note that if there are subreports, the report will not run inside iReport, as it will not find the subreports(s) - unless all the subreports are alos saved as .jrxml files and the references from the main to the subreports are updated. Contact VIE in case of questions on this.</li>
	<li>Open in iReport and make the changes.</li>		<li>As required, re-import the changed iReport template into IMSMA.</li>
	</ol>		</ol>

Alnaucler at 20:34, 18 March 2015

2015-03-18T20:34:20Z

← Older revision		Revision as of 22:34, 18 March 2015
Line 1:		Line 1:
			[[Image:IReport list.png\|500px\|center]]
	The user has lost his iReport template file and do not want to start from the beginning.		The user has lost his iReport template file and do not want to start from the beginning.

	<ol>		<ol>
	<li>In Navicat, open the table ''reporttemplate'' and identify which iReport it is.</li>		<li>In Navicat, open the table ''reporttemplate'' and identify which iReport it is.</li>
			: The following query checks if the report contains subreports
			<pre>
			SELECT
			"Parent"."name" AS "Parent name",
			"Parent".filename AS "Parent file",
			"Child"."name" AS "Child name",
			"Child".filename AS "Child file"
			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>
	<li>Copy the contents of the column ''jrxml'' to a new NotePad++ file and save as '''txt'''.</li>		<li>Copy the contents of the column ''jrxml'' to a new NotePad++ file and save as '''txt'''.</li>
	<li>Change the file type in Windows Explorer to '''jrxml'''.</li>		<li>Change the file type in Windows Explorer to '''jrxml'''.</li>
	<li>Open in iReport.</li>		<li>Open in iReport and make the changes.</li>
	</ol>		</ol>

Alnaucler: Created page with "The user has lost his iReport template file and do not want to start from the beginning.

In Navicat, open the table ''reporttemplate'' and identify which iReport it..."

2015-03-18T20:21:50Z

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..."

New page

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 is.</li>
<li>Copy the contents of the column ''jrxml'' to a new NotePad++ file and save as '''txt'''.</li>
<li>Change the file type in Windows Explorer to '''jrxml'''.</li>
<li>Open in iReport.</li>
</ol>

{{NavBox Hub}}

[[Category:NoPublic]]
[[Category:NAA]]