Error CSV Import on jira

Milap Jani

Hi

While doing CSV import on jira, i am getting this error.

Can you please help?

Pls find the error log below.

2014-01-10 14:37:03,540 WARN - Exception occurred parsing comment. Some values may not be set java.text.ParseException: Unparseable date: "Analysis Comment :- 07/02/2009 19:01:31 G?rard De Mdfdfitte (gdedfdfdi) 
In lightddsfdux.c, around line 10355-13060,

replace :

s_lightdemuxSendMessage( (TLightdemuxFunction)filterdata->xReceivedSectionCallback, (u_int32)filterdata->pxBuffer, (errfound==0) ? EPGLIB_SECTION_BODY_SUCCESS : EPGLIB_SECTION_BODY_FAILED, 0, 0 )"
	at java.text.DateFormat.parse(DateFormat.java:337)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvConfigBean.parseDate(CsvConfigBean.java:964)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvConfigBean.parseDate(CsvConfigBean.java:959)
	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:207)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.refreshCache(CsvDataBean.java:133)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.getAllProjects(CsvDataBean.java:121)
	at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.getSelectedProjects(CsvDataBean.java:127)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.preImport(DefaultJiraDataImporter.java:485)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:262)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:27)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:16)
	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:366)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
	at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61)
	at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160)
	at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249)
	at java.lang.Thread.run(Thread.java:662)
2014-01-10 14:37:03,603 WARN - Exception occurred parsing comment. Some values may not be set

&(*&)#)_*#@@(*)(@*)(*@

hello,

Exception occurred parsing comment. Some values may not be set java.text.ParseException: Unparseable date: "Analysis Comment :- 07/02/2009 19:01:31 G?rard De Mdfdfitte (gdedfdfdi)

you need to correct the encoding of you csv file and/or fix the missing separator

"Gérard" is incorrectly encoded and or present in the wrong column.

07/02/2009 19:01:31 G?rard De Mdfdfitte (gdedfdfdi)

best regards,