JIRA issues import - Problem with comment date parseing

Justin Leader6

Hello! I'm using CSV import to import issues with comments. Here is an example of the comment format I'm using:

11/27/2012 01:01:01; user_name; Screen shot showing <init> elements in generated HTML

And it adds the comment under my name and current date, not the set date and user. The log shows this error. Please help!

2013-08-22 14:16:24,582 WARN - Exception occurred parsing comment. Some values may not be set
java.text.ParseException: Unparseable date: "11/27/2012 01:01:01"
	at java.text.DateFormat.parse(Unknown Source)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvConfigBean.parseDate(CsvConfigBean.java:161)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvConfigBean.parseDate(CsvConfigBean.java:934)
	at com.atlassian.jira.plugins.importer.imports.csv.mappers.SimpleCommentMapper.parseComment(SimpleCommentMapper.java:67)
	at com.atlassian.jira.plugins.importer.imports.csv.mappers.SimpleCommentMapper.buildFromMultiMap(SimpleCommentMapper.java:48)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.populateCache(CsvDataBean.java:252)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.refreshCache(CsvDataBean.java:177)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.getAllProjects(CsvDataBean.java:165)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.getSelectedProjects(CsvDataBean.java:171)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.preImport(DefaultJiraDataImporter.java:548)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:319)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:26)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:15)
	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:365)
	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249)
	at java.lang.Thread.run(Unknown Source)
2013-08-22 14:16:24,582 WARN - Exception occurred parsing comment. Some values may not be set
java.text.ParseException: Unparseable date: "11/27/2012 01:01:01"
	at java.text.DateFormat.parse(Unknown Source)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvConfigBean.parseDate(CsvConfigBean.java:161)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvConfigBean.parseDate(CsvConfigBean.java:934)
	at com.atlassian.jira.plugins.importer.imports.csv.mappers.SimpleCommentMapper.parseComment(SimpleCommentMapper.java:67)
	at com.atlassian.jira.plugins.importer.imports.csv.mappers.SimpleCommentMapper.buildFromMultiMap(SimpleCommentMapper.java:48)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.populateCache(CsvDataBean.java:252)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.refreshCache(CsvDataBean.java:177)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.getAllProjects(CsvDataBean.java:165)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.getSelectedProjects(CsvDataBean.java:171)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.preImport(DefaultJiraDataImporter.java:548)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:319)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:26)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:15)
	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:365)
	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249)
	at java.lang.Thread.run(Unknown Source)

Shun Hirayanagi

Hi.

You asked the duplicated question. I answered another one.

https://answers.atlassian.com/questions/203935/jira-csv-import-issue-with-comment-import