[Solved] Import tickets for multiple project using map config file

[Nicolas DUPRE]

Hi All,

My company working on an massive migration of tickets that represents 440 projects.

Actually, we have to import project files one by one and we have to specified the project key in "setup step" (External Import).

I saw that step admits the option "Defined in CSV".

We use a map config file.

By Following the documentation, we have to add Project Key and Project Name to automatically import ticket to the right project.

https://confluence.atlassian.com/adminjiracloud/importing-data-from-csv-776636762.html

However, the two columns "Project Name" and "Project Key" are read as field and required to be map in step 3 - fields.

That step also said :

Importing projects

To import project define the column mapping for: Project key and Project name

How can I do in my config file to treats the two columns as expected .

Please find the map config file :

{
 "config.version" : "2.0",
 "config.project.from.csv" : "false",
 "config.encoding" : "UTF-8",
 "config.email.suffix" : "@",
 "config.field.mappings" : {
 "Site" : {
 "existing.custom.field" : "10116"
 },
 "Object_Type" : {
 "existing.custom.field" : "10118"
 },
 "Issue_Key" : {
 "jira.field" : "issuekey"
 },
 "Description" : {
 "jira.field" : "description"
 },
 "Modified" : {
 "jira.field" : "updated"
 },
 "Customer_Request_Type" : {
 "existing.custom.field" : "10001"
 },
 "Complexity" : {
 "existing.custom.field" : "10117"
 },
 "Created" : {
 "jira.field" : "created"
 },
 "Original_Estimate" : {
 "jira.field" : "timeoriginalestimate"
 },
 "Approver" : {
 "existing.custom.field" : "10121"
 },
 "Desired_Delivery_Date" : {
 "existing.custom.field" : "10112"
 },
 "Status" : {
 "jira.field" : "status"
 },
 "Assignee" : {
 "jira.field" : "assignee"
 },
 "Due_Date" : {
 "jira.field" : "duedate"
 },
 "Priority" : {
 "jira.field" : "priority"
 },
 "Reporter" : {
 "jira.field" : "reporter"
 },
 "Issue_Type" : {
 "jira.field" : "issuetype"
 },
 "Summary_Domain" : {
 "existing.custom.field" : "10600"
 },
 "Domaine_VEyes" : {
 "existing.custom.field" : "10109"
 },
 "Customer_Reference_Number" : {
 "existing.custom.field" : "10114"
 },
 "Summary" : {
 "jira.field" : "summary"
 },
 "Other_Reference_Issues" : {
 "existing.custom.field" : "10115"
 },
 "Issue_Id" : {
 "jira.field" : "issue-id"
 },
 "Lead_Viseo" : {
 "existing.custom.field" : "10107"
 }
 },
 "config.value.mappings" : { },
 "config.delimiter" : ";",
 "config.project" : {
 "project.type" : null,
 "project.key" : "",
 "project.description" : null,
 "project.url" : null,
 "project.name" : "",
 "project.lead" : null
 },
 "config.date.format" : "yyyy-MM-dd HH:mm"
}

Please find below a sample of CSV where I tried to use feature :

Issue_Key;Issue_Type;Summary_Domain;Summary;Priority;Assignee;Reporter;Lead_Viseo;Approver;Description;Domain;Status;Desired_Delivery_Date;Due_Date;Site;Complexity;Object_Type;Issue_Id;Customer_Reference_Number;Other_Reference_Issues;Customer_Request_Type;Created;Modified;Original_Estimate;Domaine_VEyes;Project Name;Project Key
"NDU01T-95013";"Support";"Comptabilité" -> "";"Test ne pas tenir compte Transfert de compétences";"Low";"FCH90040";"FCH90040";"";"";"Temps passé en préparation et réunion de transfert";"Comptabilité";"CLOSED";"2016-10-31 00:00";"2016-10-31 00:00";"";"Low";"";"95013";"";"";"Support";"2016-09-19 09:56";"2016-09-19 09:58";"86400";"Z_V-Eyes";"NDU TEST 01";"NDU01T"
"NDU02T-95014";"Support";"Comptabilité" -> "";"Test ne pas tenir compte Transfert de compétences";"Low";"FCH90040";"FCH90040";"";"";"Temps passé en préparation et réunion de transfert";"Comptabilité";"CLOSED";"2016-10-31 00:00";"2016-10-31 00:00";"";"Low";"";"95013";"";"";"Support";"2016-09-19 09:56";"2016-09-19 09:58";"86400";"Z_V-Eyes";"NDU TEST 02";"NDU02T"
"NDU03T-95015";"Support";"Comptabilité" -> "";"Test ne pas tenir compte Transfert de compétences";"Low";"FCH90040";"FCH90040";"";"";"Temps passé en préparation et réunion de transfert";"Comptabilité";"CLOSED";"2016-10-31 00:00";"2016-10-31 00:00";"";"Low";"";"95013";"";"";"Support";"2016-09-19 09:56";"2016-09-19 09:58";"86400";"Z_V-Eyes";"NDU TEST 03";"NDU03T"

I get that response :

If you can help me, we will save sooo many hours .....

Thanks in advance

Best regards,

Nicolas DUPRE.

[Nicolas DUPRE]

Hi All,

I solve the issue by adding the extras lines 

"Project Name": {
"jira.field": "project.name"
},
"Project Key": {
"jira.field": "project.key"
},
"Project Type": {
"jira.field": "project.type"
}

in

config.field.mappings

[Merve Nur Bas]

Hi @Nicolas DUPRE

do you know any way to write some fix or rather pre defined text in the config file? Am I able to write like "This is" (as text) and than add the field "developer" to it, for example. 

The field developer would be variable of course. 

Do you have any idea?

My best,

Merve