Import command for reporting assets

You can use the istool export command with the -report parameter to import your reporting assets from a file that contains previously exported assets. These assets can include both report designs and report results.

Purpose

You import reports from an archive file that has the .isx extension.

Reports that are created by InfoSphere Information Governance Dashboard cannot be transferred by using the istool command line. Reports created by InfoSphere Business Glossary cannot be imported by using istool.

Note: You can use a single the istool import command with the -all parameter to import most types of metadata assets from an archive file. See Moving all assets from one metadata repository to another.

Prerequisites

To import a report or report results, you must have the role of Suite Administrator, or have read permissions for the template that the report is based on. After the import, you are the owner of that report and have administration, read, and write permissions.

The preferred way to run this command is in the istool command-line window. If you run this command in your operating system command-line window or in scripts, you must add istool to the command name.

Command syntax

Optional parameters and values in the syntax are enclosed in brackets, [ ].

import 
authentication
[generic parameters]
[-abortAfter number_of_errors]
-archive file_name_and_path
[-preview] | -replace
[-responseFile "file_name_and_path"]
-report

Parameters

authentication parameters: Required. All asset interchange commands use authentication parameters to connect to a specific installation of InfoSphere Information Server.
generic parameters: The generic parameters are available to all asset interchange commands. Use the generic parameters to request help on command syntax, to specify silent or verbose operation, and to use a script to run commands.
-abortAfter | -abort number_of_errors: Specifies that the import stops if more than the specified number of errors occur.
-report: Required Specifies that report assets are imported.
-archive | -ar file_name_and_path: Required. Specifies the .isx file to import assets from.
-preview | -pre: Previews the import. The preview lists the assets that will be imported when the import runs. The assets are not imported when you run a command with the -preview parameter.
-replace: Required. Merges imported assets with existing assets if they have the same identity. The -replace parameter must be specified for all reporting imports, regardless of whether there are existing assets in the metadata repository.
-responseFile | -rf "file_name_and_path": Specifies the name and path of a response file that contains assets that failed to import during a run of a previous istool import -report command. Not supported with the -preview parameter. For more information, see Using a response file with istool export and istool import commands.

Example

The following command previews reporting assets that were previously exported to the archive c:\MDBds_001.isx:

import -domain qakserv:9443 -username user1 -password pass1 
-report -archive "c:\MDBds_001.isx" -preview

The following command imports reporting assets that were previously exported to the archive c:\MDBds_001.isx:

import -domain qakserv:9443 -username user1 -password pass1 
-report -archive "c:\MDBds_001.isx" -replace

Importing multiple types of assets

If the archive file to be imported includes multiple types of assets, you must specify each type of included metadata on the command line when you import the archive file, otherwise only reporting assets are imported. For example, if the archive includes InfoSphere Information Analyzer assets and common metadata assets, you must specify the -ia and -cm options in addition to the -rep options when you import the archive. Use separate import commands for each type of asset for best performance.

Archive files can contain assets from multiple exports of multiple tools. For best performance, when you import from an archive file, or when you migrate assets of varying types in multiple archive files, run separate commands to import the following types of assets in the following order:

Users and groups
Common metadata
InfoSphere DataStage® and QualityStage® assets.
Reports.
InfoSphere Information Analyzer assets.
InfoSphere FastTrack assets.
InfoSphere Information Governance Catalog extended data sources.
InfoSphere Information Governance Catalog extension mapping documents.
InfoSphere Information Governance Catalog business glossary assets. In versions earlier than 11.3, these assets are created in InfoSphere Business Glossary.
Custom attributes for InfoSphere Information Governance Catalog extended data sources and extension mappings. In versions earlier than 11.3, these assets are created in InfoSphere Metadata Workbench.

Asset types not listed can be imported in any order.

Using the -replace option

Note: You must use the -replace option when you import report assets from an archive. If you do not want to use the -replace option for the other types of assets in the archive, you must use a separate command to import the reports. If you import assets without the -replace option and import their related reports with the -replace option, some of the reports might not be accurate for the unreplaced assets in the target environment. Check the reports and run them again in the new environment if necessary.

In the following example, the first command imports InfoSphere Information Analyzer assets and common metadata assets from the file ia_archive1.isx without using the -replace option. The second command imports reporting assets from the same archive file while using the required -replace option.

import> -u admin -p admin100 -dom EVEREST -ar ia_archive1.isx
-ia '' -cm ''

import> -u admin -p admin100 -dom EVEREST -ar ia_archive1.isx 
-replace -rep

Exit status

A return value of 0 indicates successful completion; any other value indicates failure.