How to import null fields in a record in Rational ClearQuest Import Tool
How do you import null fields in a record in IBM Rational ClearQuest Import Tool?
What happens if null fields are imported into a user database with the Rational ClearQuest Import Tool when updating existing records? Will the fields be overwritten with no value, or will the import leave the fields as they are?
The Import Tool will only update records with actual data. The data in existing fields would not be overwritten with null values.
You can use the word "BLANK" in the applicable data column(s) and row(s). This will clear out the field in whatever records are updated by the Import Tool. This "BLANK" feature was introduced in ClearQuest version 18.104.22.168.
|DATE_TIME||ignore||invalid value||clear value|
|INT||ignore||invalid value||clear value|
|MULTILINE_STRING||ignore||insert one space *2||clear value|
|REFERENCE||ignore||ignore||clear value *3|
(clear value *4*5)
|SHORT_STRING||ignore||clear value||clear value|
|STATE||ignore||invalid value||invalid value|
Note *1: There is no way to clear values in the ATTACHMENT_LIST field type.
Note *2: It inserts one space as it is, not null value.
Note *3: APAR PK73991 was fixed starting in versions 22.214.171.124 and 126.96.36.199.
Note *4: APAR PK71388 was fixed starting in versions 188.8.131.52 and 184.108.40.206
Note *5: APAR PM44971 was fixed starting in versions 220.127.116.11.
How to clear values in the REFERENCE_LIST field type :
For version 7.0 :
Set the following behavior flag in order to use "" to clear value in the Reference list.
This solution contains information about modifying the system registry. Before making any modifications to the Microsoft Registry Editor, it is strongly recommended that you make a backup of the existing registry. For more information describing how to back up the registry, refer to Microsoft Knowledge Base article 256986
- Click Start > Run type regedit and click OK
- Find HKEY_CURRENT_USER\Software\Rational Software\ClearQuest
- Create a new key and name it Diagnostic
- Right click on the Diagnostic key and select New > String Value
- Name the string Behavior
- Double click the Behavior string value and insert for the Value data: REPLACE_REF_LIST=TRUE
For version 7.1 :
The "Replace value" option in Import Tool preference has been added in Rational ClearQuest Eclipse RCP client version 7.1, however, "" does not clear value in reference_list field.
For version 8.0 :
The "Replace value" option in Import Tool preference works as expected in Rational ClearQuest Eclipse RCP client version 18.104.22.168 or later.
More support for:
Software version: 7.0, 7.0.1, 7.1, 7.1.1, 7.1.2, 8.0
Operating system(s): Windows
Reference #: 1121020
Modified date: 13 July 2009