NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
=== Get the JRXML files of the iReport templates ===__NOEDITSECTION__
The templates that shall be upgraded need to be opened with iReport. To be able to do so, the related .jrxml files need to be extracted from the database. The following steps are required:
* Use pgAdmin3 or Navicat to connect to the imsma database
* Open the table called '''reporttemplate''' or issue the following query:
<pre>
SELECT * FROM reporttemplate ORDER BY name
</pre>
* Navigate to the right row (corresponding to the report template name you are looking for) and copy the content of the column called '''jrxml'''. The content of this column starts with <?xml version=1.0
* Paste the text into e.g. Notepad++ and ensure that there are no double quotes (") at the very beginning and end of the text (this happens when you copy-paste from pgAdmin3 - in this case delete the double quotes)
* Save the document as <name>.jrxml (not .txt, the extension needs to be .jrxml)
* Open iReport
* Open the file saved before (<name>.jrxml) in iReport
=== Adapt the iReport templates ===__NOEDITSECTION__