Jira Importer failing.

[lance_lyons]

We are having a hard time making the Jira CSV importer work. We have Axosoft Ontime and i have narrowed down our csv to a few select columns and it still doesnt work. The csv looks good and comes into Excel in good clean columns including our description field that I am having issues with below.

The problem we are having is our description in Axosoft may have dates in the description even though it is surrounded by double quotes. Something like

" PROJECT DETAILS:

Format/Delivery Method – online, direct mail, on-site, etc: onsite and online

Production Schedule:

Draft by date: ;2/29/2012 ; ; Approval by date: ;3/2/2012 Final delivery date: 3/9/2012 Mail/email Drop date:
. "

even though I have told Jira to move the entire description to the comments body, it is failing on parsing the dates.


2012-01-31 10:42:23,136 INFO - Import started by admin using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean
2012-01-31 10:42:23,183 INFO - ------------------------------
2012-01-31 10:42:23,183 INFO - Importing: Users
2012-01-31 10:42:23,183 INFO - ------------------------------
2012-01-31 10:42:23,183 INFO - Only new items will be imported
2012-01-31 10:42:23,449 WARN - Exception occurred parsing comment. Some values may not be set
java.text.ParseException: Unparseable date: "PROJECT DETAILS:
Format/Delivery Method ? online, direct mail, on-site, etc: onsite and online
Production Schedule:
Draft by date:"
at java.text.DateFormat.parse(DateFormat.java:337)
at com.atlassian.jira.plugins.importer.imports.csv.CsvConfigBean.parseDate(CsvConfigBean.java:978)
at com.atlassian.jira.plugins.importer.imports.csv.mappers.SimpleCommentMapper.parseComment(SimpleCommentMapper.java:59)
at com.atlassian.jira.plugins.importer.imports.csv.mappers.SimpleCommentMapper.buildFromMultiMap(SimpleCommentMapper.java:40)
at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.populateCache(CsvDataBean.java:220)
at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.refreshCache(CsvDataBean.java:158)
at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.getAllProjects(CsvDataBean.java:146)
at com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean.getSelectedProjects(CsvDataBean.java:152)
at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.getSelectedProjects(DefaultJiraDataImporter.java:1277)
at com.atlassian.jira.plugins.importer.web.ImporterLogsPage.getFormTitle(ImporterLogsPage.java:121)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:98)
at org.apache.velocity.util.introspection.UberspectImpl$VelGetterImpl.invoke(UberspectImpl.java:264)
at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:153)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327)
at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:51)
at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:95)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at org.apache.velocity.Template.merge(Template.java:256)
at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:422)
at com.atlassian.velocity.DefaultVelocityManager.getEncodedBody(DefaultVelocityManager.java:77)
at com.atlassian.jira.plugin.webwork.JiraPluginWebworkVelocityServlet.service(JiraPluginWebworkVelocityServlet.java:55)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25)

[Wojciech Seliga]

Hi,

Could you raise a bug for that at https://studio.atlassian.com/browse/JIM and attach there a minimum CSV file and importer configuration file which exposes this problem. Then we should be able to fix it quickly.

Thanks!

Wojtek