It's all about the answers!

Ask a question

Error on exporting test cases from excel using excelimporter sample doc


Brijraj Beriwal (1311417) | asked Sep 06 '12, 6:42 a.m.

On exporting a sample file from samples folder on excelimporter named "Scripts that create testcases with comments" it gave me the following error

 "

Error sending to server Parent_TC001_TS034_To_check_for_Family__type of type testcase

The remote server returned an error: (403) Forbidden.

"

Could anyone please help in resolving the following error?

5 answers



permanent link
Sonali Lekurwale (111) | answered Sep 06 '12, 6:57 a.m.
It seems like there's an issue in your config file where you map attributes. Sounds like a mismatch.
Or there could be some syntax difference for that particular row in your excel sheet.
Could you pls paste a sample row, along with its headings?
Also give the config file part that maps excel columns with test case attributes.


permanent link
Brijraj Beriwal (1311417) | answered Sep 06 '12, 7:42 a.m.

Path Test Case Name Subject Step No. Action Expected Priority Comments/Queries
  Parent TC001_TS034_To check for "Family " type Objective:
To check Relationship details for "Family " type

Preconditions:
The Parent is created in the system and has been selected.

Post-condition:
user should be able to see the Relationship details for "Family" type.

Business rule Covered:
None

Test Data Req:
Refer the test data Requirement

Back-end/Third party systems involved:
None.

Notes:
None.
Step 1 Login into the System with User ID and Password.

Test data ID:- 
User successfully logged in to the system.   I’m just a lowly comment so there is no worth talking to me.
  Parent TC001_TS034_To check for "Family " type   Step 2 Go to the toolbar select the "Maintain Relationships". The system brings up the ‘Maintain Relationships’ area layout with a list of types    I’m just a lowly comment so there is no worth talking to me.

Config file

// This configuration file creates a test case with each test script and links them.
// The linking is accomplished by self referential data


// Start looking for scripts after row 2
testscript.XLSStartRow=2

// use the data in the first row of a found script's column B
testscript.XLSArtifactID=B
testscript.dc:title=B
testscript.dc:description=C

// the literal "execution" will be put into the step type tag, so all steps will be of type execution
testscript.steps.type="execution"
testscript.steps.description=E
testscript.steps.title=D
testscript.steps.name=D
testscript.steps.expectedResult=F
testscript.steps.property name="comment"=H

// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n
 
// we want to use the data we got for each test script to create a test case
testcase.ID=testscript.XLSArtifactID

// by refering to the testscript's field instead of the column that data comes from
// the tool will also create links to each of the test scripts.
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description


permanent link
Hao Wan (1.5k35) | answered Sep 06 '12, 8:08 a.m.
JAZZ DEVELOPER
as the error message is "(403) Forbidden."
is the user executing the export to repository function assigned the role to save test case and test script
the role can be set in RQM admin page -> Project area -> permission -> project configuration.

permanent link
Sonali Lekurwale (111) | answered Sep 06 '12, 8:13 a.m.
Hi, I implemented export action using above samples. I was able to export successfully.
Here are few suggestions:
1. Make sure the User that use in excel to export should have 'Data base Administrator' role assigned in RQM project area
2.  To use Excel Importer in RQM:

1.            Data Administrator Role should be assigned to the User

2.            To assign this role:

 Edit Project Area -> Overview -> Members -> <user> -> Process Roles -> Data Migration Administrator


permanent link
Albert Yao (5411322) | answered Mar 13 '15, 1:45 a.m.
Hi, Sonali Lekurwale,
why should assign the "Data Migration Administrator" role to the user?
My process has been customized and there is no the "Data Migration Administrator" role.

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.