cqload importintegration

Imports schema modifications to an existing schema from a schema file created with the cqload exportintegration subcommand.

Applicability

Platform: Windows™

Command type: cqload subcommand

Synopsis

cqload importintegration [-dbset dbset ] loginID password schema recordType integrationName integrationVersion schemaFilePath formName

Description

The cqload importintegration subcommand modifies an existing schema by importing a partial schema from a file created by using the cqload exportintegration subcommand. To import an entire schema into the schema repository, use the cqload importschema subcommand.

If a schema contains packages that are not installed in the schema repository, an error occurs for each package that is not found. Before using the cqload importintegration subcommand, right-click a schema repository and select install package to install the missing packages.

Important: If you are using HCL Compass MultiSite, you can only run the cqload importintegration subcommand at the working master site.

Options and arguments

-dbset dbset
Specifies the HCL Compass connection name. Required if there are multiple schema repositories in the system.
loginID
Login name of the HCL Compass user. This user must have Super User privileges.
password
Password for the loginID user. If the user does not have a password, you must enter an empty set of double quotes () if there is no password.
schema
Name of the schema associated with the integration. This is the simple name of a schema that is defined in your schema repository. Note that the schema revision number increases by one after running the cqload importintegration subcommand.
recordType
The record type in the target schema (for example, Defect) to which you want to add an integration. You must enter an empty set of double quotes () to omit this option.
integrationName
Name that you assign to the integration. You can specify any alphanumeric indicator such as a comment that identifies the integration you are loading.
integrationVersion
Version of the integration that you are loading. This is a numeric value that is used as a comment to identify the integration.
Important: The version of the schema that you are integrating is increased by one in the target schema regardless of the number of versions that you import from the source.
schemaFilePath
Path name of a schema integration file that has been created by the cqload exportintegration subcommand. Enclose the path name in double quotes ().
formName
Form to which the new tabs created by the integration are added. If no form updates are required, enter an empty set of double quotes ().

Examples

  • Import the exported schema revisions into the Testing schema, leaving all record types with their original names.

    cqload importintegration -dbset 2013.00.00 admin secret Testing "" Email_Integ 1 "c:\program files\hcl\compass\schema.txt" ""

  • Import the exported schema revisions into the Testing schema, renaming the record type specified in the recordType option of the previously run cqload exportintegration subcommand to Defect.

    cqload importintegration -dbset 2013.01.00 admin secret Testing Defect Email_Integ 1 "c:\tmp\export.txt" ""

Troubleshooting

If you are having problems importing a block of schema revisions, use the cqload exportintegration subcommand to create export files one revision at a time, and then import these one revision at a time.
  • Following is an example of importing your schema revisions by running the cqload importintegration subcommand for each revision.

    cqload importintegration -dbset 2013.01.00 admin secret HCL_SR Service_Request i 8 "c:\compass\schema8.txt" ""

    cqload importintegration -dbset 2013.01.00 admin secret HCL_SR Service_Request i 9 "c:\compass\schema9.txt" ""