IBM Support

Exporting and importing stateless records with back references

Question & Answer


Question

How do you export and import stateless records with back references in IBM® Rational® ClearQuest®?

Answer


Prerequisites:

  • For more information on exporting and import records, refer to technote 1234126. It includes links to multimedia materials that explain how to use both tools.

  • The unique key of the stateless record that contains the back reference must be one of the fields that is available to select in Step 3 of the Import Tool, with the exception of the dbid field. This field has a special meaning within the context of ClearQuest. Using it as the unique key in this instance will cause the process to fail.

Note: If for example the dbid field is defined as a unique key, a new temporary field could be defined in the stateless record type and the dbid could be copied to this field by an API call. After successful import this temporary field can be removed.

How to export and import:

  1. Export the stateless records, excluding the back reference list.
  2. Export all fields of the parent record including the reference list.
  3. Import the stateless record making sure to select the unique key during step 3.
  4. Import the parent records. During step 4, make sure that the id from the Source field label is mapped with old_id in the Destination field label.

The import of the parent records will automatically upgrade the back references in the stateless records.

[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Import tool","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2003.06.00;2003.06.12;2003.06.13;2003.06.14;2003.06.15;2003.06.16;7.0;7.0.0.1;7.0.0.2;7.0.0.3;7.0.0.4;7.0.0.5;7.0.0.6;7.0.1;7.0.1.1;7.0.1.2;7.0.1.3;7.0.1.4;7.0.1.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Export tool","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Historical Number

26051

Document Information

Modified date:
29 September 2018

UID

swg21126345