This blog talks about handling keywords while you are using the RQM Excel Importer utility to import test data (testcases, testscript etc..) stored in XLS file into RQM Server.
Read Here: RQMExcelWordImporter
You might notice during import of test data using RQM Excel import utility that 'keywords' included in the RQM excel import excel sheet overwrites existing keywords stored in a RQM Project Area.This happens due to not meeting the required conditions while importing keywords as part of your test data in the XLS sheet.
Read here : Rational Quality Manager Excel/Word Importer-> Keywords_and_special_cases
Here is a sample to begin with using keyword import available along with the RQM Excel Import Utility Installation
Now lets take a look at what you could perform to over come this:
You can note the following points to avoid overwriting existing keywords during your XLS import :
1.The following parameter from the CFG file is critical while you export the 2nd time from the same sheet (with different Test script and Keywords).
This Worksheet name from the XLS has to be different each time. I started with "keyword1" and went on upto "keyword13" for various iterations to confirm this. I am unsure what is the significance of this Worksheet name causing the dependency. Checking with my developer.
2.Secondly the use of the "manual script" column in the keyword worksheet is critical as well ,and each time you have a new set of the Test script and Keywords, please have new set of Identifiers for the same.
The TS Column cause the creation and linking of the scripts to the respective keywords. I notice that re-use of the TS data , will not create the script and tags the existing scripts (created with previous iteration getting tagged with the new keywords.
3.Use of new worksheet name for "keywords" if re-using the same sheet with new data.
Every iteration of import with new test scripts , you need to have different Test script name, different Keyword Worksheet name and the TS ID's in Keyword Worksheet for next iteration.