Excel import error for Excel row line change

김태영 December 18, 2014

Please help me!!!

When trying importing test cased in excel, error happened with below message

Contains a newline character and so a title is not valid - is this related with Excel format for row change? or???

2014-12-19 12:06:10,437 ERROR [pool-7-thread-1] TestcaseImportManagerImpl.saveTestCase(862) | dispatch.StatusCode: Unexpected response code: 400 {"errorMessages":[],"errors":{"summary":"줄바꿈 문자가 포함되어 있어 제목이 유효하지 않습니다."}}  at dispatch.HttpExecutor$$anonfun$1.apply(executor.scala:53)  at dispatch.HttpExecutor$$anonfun$1.apply(executor.scala:50)  at dispatch.HttpExecutor$$anonfun$x$2.apply(executor.scala:41)  at dispatch.HttpExecutor$$anonfun$x$2.apply(executor.scala:36)  at dispatch.BlockingHttp$$anonfun$execute$1.apply(Http.scala:54)  at dispatch.Http.pack(Http.scala:25)  at dispatch.BlockingHttp$class.execute(Http.scala:53)  at dispatch.Http.execute(Http.scala:21)  at dispatch.HttpExecutor$class.x(executor.scala:36)  at dispatch.Http.x(Http.scala:21)  at dispatch.HttpExecutor$class.when(executor.scala:50)  at dispatch.Http.when(Http.scala:21)  at dispatch.HttpExecutor$class.apply(executor.scala:60)  at dispatch.Http.apply(Http.scala:21)  at com.thed.zfj.rest.JiraService$.saveTestcase(JIRAServiceImpl.scala:172)  at com.thed.zfj.rest.JiraService$.saveTestcase(JIRAServiceImpl.scala:157)  at com.thed.zfj.rest.JiraService.saveTestcase(JIRAServiceImpl.scala)  at com.thed.service.impl.zie.TestcaseImportManagerImpl.saveTestCase(TestcaseImportManagerImpl.java:856)  at com.thed.service.impl.zie.TestcaseImportManagerImpl.importFileByChange(TestcaseImportManagerImpl.java:483)  at com.thed.service.impl.zie.TestcaseImportManagerImpl.importFileForByName(TestcaseImportManagerImpl.java:399)  at com.thed.service.impl.zie.AbstractImportManager.importSingleFiles(AbstractImportManager.java:161)  at com.thed.service.impl.zie.AbstractImportManager.importAllFiles(AbstractImportManager.java:81)  at com.thed.zfj.rest.JiraService$.startImport(JIRAServiceImpl.scala:104)  at com.thed.zfj.ui.BaseImporter$$anonfun$2$$anon$22.call(ImportSwingApp.scala:263)  at com.thed.zfj.ui.BaseImporter$$anonfun$2$$anon$22.call(ImportSwingApp.scala:260)  at scala.actors.threadpool.FutureTask.run(Unknown Source)  at scala.actors.threadpool.ThreadPoolExecutor.runWorker(Unknown Source)  at scala.actors.threadpool.ThreadPoolExecutor$Worker.run(Unknown Source)  at java.lang.Thread.run(Unknown Source)

1 answer

0 votes
Swapna Kumar Vemula [Zephyr]
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.
December 28, 2014

Hi,

The error above states that the summary description is throwing an  error. So, Please check if the title has any special characters and remove them to import successfully. As we are making a REST call to JIRA for creating a test issue special characters will not be supported.

Regards,

Swapna Kumar Vemula

Muniraja SREERAM March 28, 2019

Dear Swapna,

 

We are also facing same issue. What are unsupported special characters? 

Swapna Kumar Vemula [Zephyr]
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.
March 29, 2019

Hi Muniraja,

The post above was very old and we have released many updated versions after that.

I suggest you to submit a case with detailed issue description and screenshots by logging to our Support help desk https://support.getzephyr.com/hc/en-us

Regards,

Zephyr Support

Suggest an answer

Log in or Sign up to answer