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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Emily,
Our Testlink is in version 1.9.3 (Prague).
Thanks,
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Martin,
Our Zephyr for JIRA XML tests utility import is compatible with TestLink versions 1.8 and higher only.
Kind Regards,
Emily
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Kind Regards,
Emily
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What is the status on that importer? I'm looking for this right now.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.