CSV import rejects configuration file

[Ralph Broeker]

Hello,

I am trying to import the issues from our old problem tracking system to JIRA using the csv file format. Works fine so far but as I have to import many projects (and also during test) I tried to use the import configuration file. But using the configuration file for the next import even with the same csv file gives an error and stopps processing. JIRA asks for a mapping for the header line and gives the following error message:

Some field mappings are defined in your existing configuration file, however they do not correspond to any of the columns in your CSV file. These mappings will be ignored. Show more

Checking the mapping with "Show more" looks pretty good.

I cannot find a description of a similar problem. Any hints?

BTW: We are using JIRA 6.2.2

Thanks for your help,

Ralph

Config file:

{
"field.IssueKey" : "issuekey",
"field.Components" : "components",
"field.Resolutiondate" : "resolutiondate",
"field.Priority" : "priority",
"value.Status.suspended" : "10012",
"field.Summary" : "summary",
"value.Issue Type.Change Request" : "10400",
"date.import.format" : "dd/MMM/yyyy",
"field.Reporter" : "reporter",
"value.Status.closed" : "6",
"value.Status.open" : "1",
"field.GNATS Audit Trail" : "customfield_11300",
"field.Resolution" : "resolution",
"field.How-to-repeat" : "customfield_10502",
"value.Issue Type.Software Bug" : "1",
"value.Issue Type.Task" : "3",
"value.Status.analyzed" : "10009",
"field.Issue Type" : "issuetype",
"user.email.suffix" : "@xxx.yyyy",
"field.Status" : "status",
"field.Implementation Details" : "customfield_10001",
"field.Assignee" : "assignee",
"field.Description" : "description",
"date.fields" : "Created",
"field.Submitter" : "customfield_11302",
"field.Created" : "created",
"value.Status.implemented" : "10008",
"mapfromcsv" : "true",
"field.External Issue" : "customfield_10400",
"field.Release Notes Comments" : "customfield_10700",
"field.Project.Name" : "project.name",
"field.Project.Key" : "project.key",
"field.Environment" : "environment",
"field.fixversion" : "fixVersions"
}

[Ralph Broeker · Accepted solution]

Hi All,

The solution was quite easy. My csv file uses the semicolon as separator but the default used by the importer is a comma. I assumed that was stored in the configuration file as well but I was wrong. Using the correct separator the import works as expected.

Cheers,

Ralph

[Rob Peterson]

Was not following the solution; can you post an example of the configuration file that did work... thanks! (the file itself)

[Ralph Broeker]

Hi Pietro,

I raised a ticket with JSP-199113

I hope you can find the cause.

Cheers,

Ralph

[pschaff01]

Hi Ralph,

This is a really odd behaviour indeed, as this message should only appear if there is a problem with the column mapping in the CSV.

Could you raise a support ticket in support.atlassian.comand attach the log files from <<JIRA_HOME>>/log, the configuration file and the CSV file so we can try to reproduce the same problem locally?

Cheers,

Pietro Schaff