Error on exporting test cases from excel using excelimporter sample doc
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
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
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.
| 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