Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Cannot update test case owner and more categories via RQMExcelImporter plugin

Questions
Tags
Users
Badges
Oriya Cohen
(11●1) Feb 10 '17, 7:19 a.m.

  Hi,


I try to upload tests cases list from excle via the RQMExcelImporter plugin.
I try to update the test owner and more categories without success.

This is the configuration file :
testcase.XLSWorksheetID="Test Case"
testcase.XLSStartRow=2
testcase.dc:title=C
testcase.jzalm:owner=D
testcase.XLSDelimeter=\n
testcase.priority=B
testcase.category:term="Supported Environments".value=D
testcase.category:term="Supported Projects".value=E
testcase.category:term="Package".value=F 

I succeed to update just the name of the test case: testcase.dc:title=C
The another configuration failed with 400 bad request or ignored. 

Excel data:
ID Priority Name Owner Category Package Supported Environments
648 Medium Test1 User1 C1 pck1 Env1
1117 High Test2 User2 C2 pck2 Env2
1113 Low Test3 User3 C3 pck3 Env3
1037 Unassigned Test4 User4 C4 pck4 Env4
731 High Test5 User5 C5 pck5 Env5

Any idea about this issues?

Regards,
Oriya Cohen

0 votes

1 answer
4,866 views
0 votes

One answer

Permanent link
Don Yang
(7.7k●21●114●139) edited
Feb 13 '17, 11:41 p.m.

Hi, Oriya

testcase owner setting uses: testcase.alm:owner=D and category is something like:
testcase.category term="Function".value=H
Syntax in your cfg file is wrong for owner and category hence 400 bad request.

0 votes

Comments
Oriya Cohen
Feb 14 '17, 3:58 a.m.
 Hi, First, thanks for your answer. Second, I change the owner settings to : testcase.alm:owner=D as you wrote but still not updated. also, I change the category to: testcase.category term="Function".value=H (without ":") and didn't updated but didn't fail. so now I still stuck. Do you think it is related to permissions?

Don Yang
Feb 14 '17, 4:01 a.m.
. In "testcase.alm:owner=D", how does D column define the owner? this should be user id not the user name. . Regarding testcase.category term="Function".value=H (without ":") In guess in your case, it should be testcase.category term="Supported Projects".value=E suppose Supported Projects is the existing category I don't think this is related to permission as if it is permission related, it should throw 403 error. if the user has Data Migration role, it should be fine.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 223

Question asked: Feb 10 '17, 7:19 a.m.

Question was seen: 4,866 times

Last updated: Feb 14 '17, 4:01 a.m.

Confirmation Cancel Confirm