It's all about the answers!

Ask a question

Cannot update test case owner and more categories via RQMExcelImporter plugin


Oriya Cohen (111) | asked 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

One answer



permanent link
Don Yang (7.7k21114139) | answered Feb 13 '17, 11:40 p.m.
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.


Comments
Oriya Cohen commented Feb 14 '17, 3:01 a.m. | edited 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 commented 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 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.