Manually Exporting/Importing Reports from the UR Repository
Notes:
· This information is up-to-date as of UR version 1.9
· The Jasper Import/Export syntax is detailed in the UR Server Admin Guide, under the Import/Export chapter.
· The migration process was designed specifically for moving from UR 1.7 or lower (where the jasper database tables reside in the NimsoftSLM database) to UR 1.8 and above (where the jasper database is separate from the NimsoftSLM database).
· Before upgrading UR 1.7 or lower to UR 1.8 or higher, drag the wasp_ur_migrate_export package from the archive to the UR Robot, then look at the js-import-export.zip file in the C:\Program Files (x86)\Nimsoft\probes\service\wasp\tmp\jasperserver-pro\js-import-export folder
· In UR 1.9, the folder is “js-import-export”, for 1.8 it was “js-import-export-4.2.1”
· Check metadata.jdbc.url and metadata.jdbc.username and metadata.jdbc.password in the js.jdbc.properties file (wasp_ur_import_export_configurer is the package that configures the js.jdbc.properties file)
Location:
C:\Program Files (x86)\Nimsoft\probes\service\wasp\webapps\jasperserver-pro\js-import-export-4.2.1\config\js.jdbc.properties
Example of the js-jdbc.properties file:
1. To manually run the export, first set the environment variables:
Either uncomment the top 2 lines in the js-env.properties file or set them in the command prompt session:
set NIM_ROOT=C:\Program Files (x86)\Nimsoft
set NIM_JRE_HOME=jre\jre1.6.0_24
Example of the js-env.properties file:
2. Run the js-export.bat file (can use --everything or --uris)
Example for just specific folders:
C:\Program Files (x86)\Nimsoft\probes\service\wasp\webapps\jasperserver-pro\js-import-export-4.2.1>js-export.bat –uris /Bonavista,/LongViewReports,/LVSMonthlyReport,/LVSMonthlyReports,/origin --output-zip c:\users\cshurley\documents\RepositoryExport.zip
3. Example for everything:
C:\Program Files (x86)\Nimsoft\probes\service\wasp\webapps\jasperserver-pro\js-import-export-4.2.1>js-export.bat –everything --output-zip c:\users\cshurley\documents\RepositoryExport.zip
- Examine the zip file:
Example zip with only the 4 Custom Report Top-Level Folders, plus the “origin” input control:
Example zip file with “everything”:
5. To manually import, make sure the environment variables are set and that the js.jdbc.properties file is pointing to the correct database, with username and password.
The syntax for the import is as follows:
js-import --input-zip myExport.zip
Cash Shurley, Nimsoft