import_export_reports

Allows report definitions, their dependent data (for example, saved query definitions and property set definitions), and their associated style sheets to be exported from one Teamcenter server and imported to another Teamcenter server. Syntax import_export_reports {-import | -export | -execute} [-u=user-id -p=password | -pf=password-file -g=group] -stageDir=directory -reportId=report-identifier -overwrite [-reportFile=xml-output-file] [-f=xml-file] [-h] Arguments -import Specifies the report definitions are to be imported to the Teamcenter server. -export Specifies the report definitions are to be exported from the Teamcenter server. -execute Generates a report in the command line. This argument requires the -f argument. -u Specifies the user ID. This is generally a user with administration privileges. Note If Security Services single sign-on (SSO) is enabled for your server, the -u and -p arguments are authenticated externally through SSO rather than being authenticated against the Teamcenter database. If you do not supply these arguments, the utility attempts to join an existing SSO session. If no session is found, you are prompted to enter a user ID and password. -p Specifies the password. This argument is mutually exclusive with the -pf argument. -pf Specifies the password file. For more information about managing password files, see Manage password files. This argument is mutually exclusive with the -p argument. -g Specifies the group associated with the user. If used without a value, the user's default group is assumed. -stageDir Specifies the fully qualified name of the directory that contains all of the report definitions and its associated data in predefined format. Note If you use -reportId to import a single report, you must place the report definition file and resource file in a folder with the same name as the report ID and place it in the directory and folder specified by the -stageDir argument. -reportId Specifies the ID of the report definition. -overwrite Overwrites the existing report definitions during import. If you want to modify the closure rule, change the transfer mode name and the closure rule name in the respective XML file. Note Use this argument with caution. If you have done any customizations to the commercial-off-the-shelf data (COTS) templates, that data is overwritten by this argument. -reportFile Specifies the name of the XML containing the list of report templates. Note If you provide both -reportId and -reportFile, -reportId is used to import a single report and -reportFile is ignored. -f Specifies the name of an XML file containing report parameters. This argument is used with the -execute arguments. -h Displays help for this utility. Environment As specified in Setting up a Teamcenter command-line environment. Files As specified in Log files produced by Teamcenter. Restrictions None. Examples The following command exports report definitions and associated data (style sheets) to the file system pointed by the -stageDir argument: Copy import_export_reports -export -u= -p= -g= -stageDir= -reportId= The following command imports report definitions from a Teamcenter server: Copy import_export_reports -import -u= -p= -g= -stageDir= -reportId= The following is an example of how to create an input file format and run the -execute command with the -f filename option to generate a report: You can import or export report definitions by using a sample XML file. For more information about sample XML files, see TC_DATA\crf\crf_item_report_offline_execution_sample.xml for an item report and TC_DATA\crf\crf_summary_report_offline_execution_sample.xml for a summary report. Create a sumsap.xml input file format as follows: Summary report example: Copy
Item report example: Copy Revision rule name and variant rule name are optional. If the revision rule name is not specified, the default is Latest Working. To generate the report, execute the input file using the following command: Import_export_reports –u=user_name -p=password -g=dba –execute –f="d:\report builder\sumsap.xml" The system generates the sumrpt.html report in the d:\report builder directory. Note If you do not specify the output_report_file option, the report is generated in the path specified in the TC_TMP_DIR environment variable. If you do not set the TC_TMP_DIR variable, then the system creates the report in the C:\temp directory for Windows or /tmp directory for Linux systems.