Import custom attribute data from excel into RQM.
![](http://jazz.net/_images/myphoto/f20b2a6e322d87123c74b7ecb27e1971.jpg)
I’m using the export tool (v 4.0.1) from excel to RQM (v 4.0.0.1) to upload all our TCs.
In addition to description and pre-condition the old TCs also have supplementary data (i.e. miscellaneous …).
In order to have that I added a custom attribute field in the RQM as text and named it “Supplementary Data”.
What is the communed in the .cfg file that I need to write in order to connect column x to the custom attribute while importing.
Thanks,
Gilad.
One answer
![](http://jazz.net/_images/myphoto/f20b2a6e322d87123c74b7ecb27e1971.jpg)
Gilad,
Take a quick look at the following thread, it may point you in the right direction
https://jazz.net/forum/questions/102815/updating-the-custom-attributes-when-importing-test-cases-from-excel-using-excel-importer-utility
Comments
![](http://jazz.net/_images/myphoto/f20b2a6e322d87123c74b7ecb27e1971.jpg)
I have tried what there is in that thread in several ways - all failed.
![](http://jazz.net/_images/myphoto/f20b2a6e322d87123c74b7ecb27e1971.jpg)
I got the following from Anthony Paul, Thanks Anthony!
![](http://jazz.net/_images/myphoto/f20b2a6e322d87123c74b7ecb27e1971.jpg)
Hi this is the line I used:
testscript.customAttributes identifier="Deadlines".name="Deadlines".type="SMALL_STRING".value=J
I have found that this works with Test Scripts but not with Test Cases using the "Scripts that create testcases" excel template.
![](http://jazz.net/_images/myphoto/f20b2a6e322d87123c74b7ecb27e1971.jpg)
what I use is exactly the "Scripts that create testcases" excel template.
what is the way???
Thanks,
Gilad