Importing Test cases to Zephyr add-on from Test link.

olid khan June 27, 2013

Is there any way to Import test cases from Testlink, or from a .XML file to Zephyr add-on for JIRA?

14 answers

1 vote
Marius Bob October 19, 2014

Hi there,

I am using a MAC OS computer and I'm trying to import some testcases from an excel document, but I'm getting the following error:

Mon Oct 20 15:44:32 EEST 2014 file:///Users/mbob/Desktop/tobeImported.xls normalization success..! 
Mon Oct 20 15:44:33 EEST 2014 Unable to add testcase ending at rowNumber - 1. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:34 EEST 2014 Unable to add testcase ending at rowNumber - 2. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:35 EEST 2014 Unable to add testcase ending at rowNumber - 3. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:36 EEST 2014 Unable to add testcase ending at rowNumber - 4. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:37 EEST 2014 Unable to add testcase ending at rowNumber - 5. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:39 EEST 2014 Unable to add testcase ending at rowNumber - 6. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:40 EEST 2014 Unable to add testcase ending at rowNumber - 7. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:41 EEST 2014 Unable to add testcase ending at rowNumber - 8. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:42 EEST 2014 Unable to add testcase ending at rowNumber - 9. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:43 EEST 2014 Unable to add testcase ending at rowNumber - 10. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:44 EEST 2014 Unable to add testcase ending at rowNumber - 11. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:45 EEST 2014 Unable to add testcase ending at rowNumber - 12. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:46 EEST 2014 Unable to add testcase ending at rowNumber - 13. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:47 EEST 2014 Unable to add testcase ending at rowNumber - 14. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:48 EEST 2014 Unable to add testcase ending at rowNumber - 15. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:49 EEST 2014 Unable to add testcase ending at rowNumber - 16. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:50 EEST 2014 Unable to add testcase ending at rowNumber - 17. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:51 EEST 2014 Unable to add testcase ending at rowNumber - 18. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:52 EEST 2014 Unable to add testcase ending at rowNumber - 21. Error:Unexpected response code: 405
<html><head><title>Apache Tomcat/7.0.55 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Method Not Allowed</u></p><p><b>description</b> <u>The specified HTTP method is not allowed for the requested resource.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.55</h3></body></html> 
Mon Oct 20 15:44:52 EEST 2014 tobeImported.xls imported successfully..!
 
Does anyone know what the error is trying to say? Thanks
Vic Pekun October 21, 2014

Hi! I have the same issue as Marius, and really need help.

1 vote
Gennadiy Pozdnyakov August 6, 2014

Some notes here:

Steps: remove emty steps from your XLS file.

Labels: 1. Should not have spaces (i.e., "Smoke test" is wrong; "smoke_test" is ok). 2. You may have 2 lables in on cell (i.e., "smoke_test, functional_test").

Components: 1. May have spaces. 2. Should be defined in Jira.

Priority: Should be defined in Jira (I exported from Zephyr app, so I had P1 - P5. Replace with Major, Minor,...).

Epic Link: I was not able to import links (I had Epics in Jira and I was trying with full link, short link, i.e., PRO-22, or name of epic, or subject of epic - nothing works).

Import takes time. In my case it was around 1-2 test cases every sec.

0 votes
Shruti Dubey July 11, 2019

Getting this when click on import button , i have added all these fields still not working

 

Sheet1:Row:2:Version is required.Pillar is required.Priority is required. Sheet1:Row:3:Version is required.Pillar is required.Priority is required. Sheet1:Row:4:Version is required.Pillar is required.Priority is required. Sheet1:Row:5:Version is required.Pillar is required.Priority is required. Sheet1:Row:6:Version is required.Pillar is required.Priority is required. Sheet1:Row:7:Version is required.Pillar is required.Priority is required. Sheet1:Row:8:Version is required.Pillar is required.Priority is required. Sheet1:Row:9:Version is required.Pillar is required.Priority is required. Sheet1:Row:10:Version is required.Pillar is required.Priority is required. Sheet1:Row:11:Version is required.Pillar is required.Priority is required. Sheet1:Row:12:Version is required.Pillar is required.Priority is required. Sheet1:Row:13:Version is required.Pillar is required.Priority is required. Sheet1:Row:14:Version is required.Pillar is required.Priority is required. Sheet1:Row:15:Version is required.Pillar is required.Priority is required. Sheet1:Row:16:Summary must be less than 255 characters.Version is required.Pillar is required.Priority is required. Sheet1:Row:17:Summary must be less than 255 characters.Version is required.Pillar is required.Priority is required. Sheet1:Row:18:Summary must be less than 255 characters.Version is required.Pillar is required.Priority is required. Sheet1:Row:19:Summary must be less than 255 characters.Version is required.Pillar is required.Priority is required. Sheet1:Row:20:Summary must be less than 255 characters.Version is required.Pillar is required.Priority is required. Sheet1:Row:21:Summary must be less than 255 characters.Version is required.Pillar is required.Priority is required. Sheet1:Row:22:Version is required.Pillar is required.Priority is required. Sheet1:Row:23:Version is required.Pillar is required.Priority is required. Sheet1:Row:24:Version is required.Pillar is required.Priority is required. Sheet1:Row:25:Version is required.Pillar is required.Priority is required. Sheet1:Row:26:Version is required.Pillar is required.Priority is required. Sheet1:Row:27:Version is required.Pillar is required.Priority is required. Sheet1:Row:28:Version is required.Pillar is required.Priority is required. Sheet1:Row:29:Version is required.Pillar is required.Priority is required. Sheet1:Row:30:Version is required.Pillar is required.Priority is required. Sheet1:Row:31:Version is required.Pillar is required.Priority is required.

0 votes
Emily Schneider
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 19, 2014

Hi Sri,

It looks like the error is saying what is going on. When you are importing test cases into Zephyr for JIRA, which fields are you importing into? It looks like you have some required fields in JIRA that you need to add in your import. It looks like the following fields are required in your JIRA to create a ticket:

Description is required.",

"duedate":"Due Date is required."

"components":"Component/s is required

"fixVersions":"Fix Version/s is required."

"versions":"Affects Version/s is required."

So you have two options.

1) You can add these fields to your excel sheet and imiport them into Zephyr for JIRA. Since it appears that these fields are manditory in JIRA you will need to also import them in.

2) You can make these fields not be manditory in JIRA while you import in. So temporarily remove the manditory lock on these fields in JIRA, import the test cases in, then put the manditory lock back on the custom fields.

Kind Regards,

Emily

Sri Harish June 22, 2014

Hi Emily,

Thanks for the solution which I required and I've removed the mandatory field check for duedate, fixVersions, Description fields while importing the excel with test cases using Zephyr.

Thanks again Em.

Sri...

0 votes
Sri Harish June 19, 2014

Hi,

For me too, got the response as below:

Fri Jun 20 12:48:28 IST 2014 file:///C:/Users/harish/Desktop/success/Callshop_Ver1.0.0_GUI-Test-cases.xls normalization success..!
Fri Jun 20 12:48:28 IST 2014 Unable to add testcase ending at rowNumber - 1. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:28 IST 2014 Unable to add testcase ending at rowNumber - 2. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:28 IST 2014 Unable to add testcase ending at rowNumber - 3. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:28 IST 2014 Unable to add testcase ending at rowNumber - 4. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:28 IST 2014 Unable to add testcase ending at rowNumber - 5. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:28 IST 2014 Unable to add testcase ending at rowNumber - 6. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:28 IST 2014 Unable to add testcase ending at rowNumber - 7. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:28 IST 2014 Unable to add testcase ending at rowNumber - 8. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:28 IST 2014 Unable to add testcase ending at rowNumber - 9. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:29 IST 2014 Unable to add testcase ending at rowNumber - 10. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:29 IST 2014 Unable to add testcase ending at rowNumber - 11. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:29 IST 2014 Unable to add testcase ending at rowNumber - 12. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:29 IST 2014 Unable to add testcase ending at rowNumber - 13. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:29 IST 2014 Unable to add testcase ending at rowNumber - 14. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:30 IST 2014 Unable to add testcase ending at rowNumber - 15. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:30 IST 2014 Unable to add testcase ending at rowNumber - 16. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:30 IST 2014 Unable to add testcase ending at rowNumber - 17. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:31 IST 2014 Unable to add testcase ending at rowNumber - 29. Error:Unexpected response code: 400
{"errorMessages":[],"errors":{"versions":"Affects Version/s is required.","description":"Description is required.","duedate":"Due Date is required.","components":"Component/s is required.","fixVersions":"Fix Version/s is required."}}
Fri Jun 20 12:48:31 IST 2014 Callshop_Ver1.0.0_GUI-Test-cases.xls imported successfully..!

Cn anyone please help me to resolve this issue...

Thanks in Advance.

Sri...

0 votes
ldroth May 13, 2014

Hi,

we wan't to import XLS-Files into Jira with your importer. We created a XLS-File, connected to Jira, filled out all important column fields, received a successfull message, but nothing was imported. What's the problem? Do you wan't to see the XLS-File, too?

Thanks,

Laurens

0 votes
jo krish November 4, 2013

Hi,

Anyone please let me know why one would move from Testlink to Zephyr? What are the +s and -s?

Thank you

Jo

0 votes
Emily Schneider
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 1, 2013

Hi Martin,

I had another answer for you yesterday but Atlassian was down. I also want to supply you with our documentation. It does appear that you have some non standard TestLink fields in your XML file that will need to be mapped. The link below will take you to our documentation that explains how this works!

http://community.yourzephyr.com/viewtopic.php?f=15&t=1048

Select the XML documentation at the bottom.

Kind Regards,

Emily

0 votes
Marcin Giemza August 1, 2013

Hi Emily,

Our Testlink is in version 1.9.3 (Prague).

Thanks,

Martin

0 votes
Emily Schneider
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 31, 2013

Hi Martin,

Our Zephyr for JIRA XML tests utility import is compatible with TestLink versions 1.8 and higher only.

Kind Regards,

Emily

0 votes
Marcin Giemza July 31, 2013

Hi Emily,

Jira and Zephyr are being inrtoduced into our project. We have thousands of test cases stored in TestLink. I tried to import a few test cases, but Importer (ver. 0.27) returned some errors:

ERROR [pool-2-thread-1] TestLinkImporterManagerImpl.find FldConfigAndPopulateCustomField(213) | No mapping found for customField testcase.externalId, skipping custom field

The same for testcase.preconditions and testcase.execution_type fields.

Finally, there's

FATAL [pool-2-thread-1] TestLinkImporterManagerImpl.processEvents(149) | Error in creating testcase, skipping to nextUnexpected response code: 405

Sample file: http://pastebin.com/vQNwttq1

And screen from Importer: http://imgur.com/VGK24oB

Did I miss some mappings?

Thanks,

Martin

0 votes
Emily Schneider
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 22, 2013

Hi Ed,

Below are instcutions on getting started using the Zephyr for JIRA XML tests utility importer. What you can do is if you have any questions about the importer you can email us screen shots or example XML files to see why you are getting any failed imports. As for our team helping with a larger migration we can direct you towards pofessionaly services. They can assist in a larger migration for an additional charge. If you are interested in this please let us know we can set you up.

A few things to note on the xml importer:

1) There are standard fields that will always import when using the XML importer. Those standard fields are
- name
- summary
- importance
- keywords
- steps

These standard fields are important to note because you do not have to map anything. Just go ahead upload it and then start the import. I have attached an image as well to help you get started called 'XML import.png'.

2) If you have custom fields you will want to use the exact same name as the custom field in the xml file to the right. I have attached an image 'CML importCustField.png'.

3) If you have a standard field of testlink but not standard in JIRA. You will need to map these as well. You will map them to the right column under 'XML Column'. They must follow the format of 'testcase.execution_type' or 'testcase.externalID'. Etc. I have attached an image on this as well labeled 'XML importMapping'.

Images that go with this can not be attached so they can be found in the imgur link below:

http://imgur.com/NHky6n4&QfF7puc#0

http://imgur.com/fysS71h

Kind Regards,

Emily

0 votes
Emily Schneider
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 27, 2013

Hi Olid,

I must have read your question too fast and for some reason had excel on the brain. Anyway, we are currently working on an XML importer that is in beta version right now. Althought it is in Beta you are more than welcome to test it out! If it works for you great, if not then you may need to wait a little bit until it is officially released. Note: It works with Testlink only.

Below is the dropbox link to test it:

https://www.dropbox.com/s/coflaqlc2er903b/zfj-importer%20-assembly-0.27.jar

Feedback is appreciated!

Kind Regrds,

Emily

EdDev_Gilat July 21, 2013

Hi Emily, I was just looking for this one.

I am planning to test it by importing around 1K test cases.

Could you please let me know what kind of problems should I expect to have with it? Would your team be able to support us with such a migration?

Thanks,

Ed.

Justin Bonneau February 8, 2016

What is the status on that importer? I'm looking for this right now.

0 votes
Emily Schneider
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 27, 2013

Hi Olid,

Yes. To do so you need the Zephyr for JIRA tests utility importer. All of the information and the download is available here:

http://community.yourzephyr.com/viewforum.php?f=15

Kind Regards,

Emily

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events