Question & Answer
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 220.127.116.11.
|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 18.104.22.168 and 22.214.171.124.
Note *4: APAR PK71388 was fixed starting in versions 126.96.36.199 and 188.8.131.52
Note *5: APAR PM44971 was fixed starting in versions 184.108.40.206.
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 220.127.116.11 or later.
Was this topic helpful?
16 June 2018