Any way for non-admin users to use issue key during CSV import?

[tueda]

In my environment, non-admin users are required to import issues to their projects.

However, as they use Import Issues from CSV function menu, they can't use issue key.

Is there any way to allow them to use issue key during import?

(Actually, I have project key requirement, too. But saw another article for that. So raise this question separately.)

Thanks,
Teru

[John Funk · Accepted solution]

Hi Teruhisa,

You might try this article for help. 

https://bobswift.atlassian.net/wiki/spaces/JCLI/pages/17563670/How+to+import+JIRA+issues+using+CSV+or+SQL

[tueda]

Thanks John !

I tried but it seems CLI doesn't support issue key?

Please look into it, "the client" is the one I'm using issue key for import.

Regards,

--- CLI result ---

C:\Users\tueda\Documents\Methodology\JIRA POC\Jira Install\CLI\atlassian-cli-8.4.0>test-cli

C:\Users\tueda\Documents\Methodology\JIRA POC\Jira Install\CLI\atlassian-cli-8.4.0>atlassian jira --action runFromCsv --file 4-Feature.csv --propertyFile import.properties.txt --continue -v
URL requested: http://localhost:8080/rest/api/latest/field
Request type: GET
Content type: application/json; charset=utf-8
Response code: 200, message: null, url: http://localhost:8080/rest/api/latest/field
Omit column: project.type. It is not a valid parameter for this client.
Omit column: Project Key. It contains blanks.
Omit column: Project Name. It contains blanks.
Omit column: issuekey. It is not a valid parameter for this client.
Omit column: Notes. It is not a valid parameter for this client.
Omit column: State. It is not a valid parameter for this client.
Omit column: PlannedStartDate. It is not a valid parameter for this client.
Omit column: PlannedEndDate. It is not a valid parameter for this client.
Omit column: PreliminaryEstimate. It is not a valid parameter for this client.
Omit column: DisplayColor. It is not a valid parameter for this client.
Omit column: InvestmentCategory. It is not a valid parameter for this client.
Omit column: Owner. It is not a valid parameter for this client.
Omit column: Ready. It is not a valid parameter for this client.
Omit column: RiskScore. It is not a valid parameter for this client.

Run: --action "createIssue" --jql "project=R1CCD2" --issueType "Epic" --fixVersions "" --summary "R1_CC_CC Work for ContactManager_Special Services_DEV" --project "R1CCD2" --description "" --custom "'Parent Link:R1SUD2-11','Epic Name:R1_CC_CC Work for ContactManager_Special Services_DEV','Portfolio Item:R1_CC_CC Work for ContactManager_DEV'"
URL requested: http://localhost:8080/rest/api/latest/project/R1CCD2
Request type: GET
Content type: application/json; charset=utf-8
Response code: 200, message: null, url: http://localhost:8080/rest/api/latest/project/R1CCD2
URL requested: http://localhost:8080/rest/api/latest/issue/createmeta/?expand=projects.issuetypes.fields&projectKeys=R1CCD2&issuetypeIds=10001
Request type: GET
Content type: application/json; charset=utf-8
Response code: 200, message: null, url: http://localhost:8080/rest/api/latest/issue/createmeta/?expand=projects.issuetypes.fields&projectKeys=R1CCD2&issuetypeIds=10001

Id . . . . . . . . . . . . . : customfield_10008
Name . . . . . . . . . . . . : Parent Link
Description . . . . . . . . . :
Required . . . . . . . . . . : No
Has default . . . . . . . . . : No
Has allowed values . . . . . : No
Type . . . . . . . . . . . . : any
Item type . . . . . . . . . . :
Custom . . . . . . . . . . . : Yes
Custom type . . . . . . . . . : com.atlassian.jpo:jpo-custom-field-parent
Custom id . . . . . . . . . . : 10008

Id . . . . . . . . . . . . . : customfield_10003
Name . . . . . . . . . . . . : Epic Name
Description . . . . . . . . . :
Required . . . . . . . . . . : Yes
Has default . . . . . . . . . : No
Has allowed values . . . . . : No
Type . . . . . . . . . . . . : string
Item type . . . . . . . . . . :
Custom . . . . . . . . . . . : Yes
Custom type . . . . . . . . . : com.pyxis.greenhopper.jira:gh-epic-label
Custom id . . . . . . . . . . : 10003

Id . . . . . . . . . . . . . : customfield_10500
Name . . . . . . . . . . . . : Portfolio Item
Description . . . . . . . . . :
Required . . . . . . . . . . : No
Has default . . . . . . . . . : No
Has allowed values . . . . . : No
Type . . . . . . . . . . . . : string
Item type . . . . . . . . . . :
Custom . . . . . . . . . . . : Yes
Custom type . . . . . . . . . : com.atlassian.jira.plugin.system.customfieldtypes:textarea
Custom id . . . . . . . . . . : 10500

URL requested: http://localhost:8080/rest/api/latest/issue
Request type: POST
Content type: application/json; charset=utf-8
Content length: 342
Post data:
{"fields":{"summary":"R1_CC_CC Work for ContactManager_Special Services_DEV","customfield_10500":"R1_CC_CC Work for ContactManager_DEV","issuetype":{"id":"10001"},"customfield_10008":"R1SUD2-11","project":{"id":"10700","key":null},"description":"","fixVersions":[],"customfield_10003":"R1_CC_CC Work for ContactManager_Special Services_DEV"}}
Response code: 201, message: null, url: http://localhost:8080/rest/api/latest/issue
json: {"self":"http:\/\/localhost:8080\/rest\/api\/latest\/issue\/25810","id":"25810","key":"R1CCD2-2157"}
Issue R1CCD2-2157 created with id 25810.

Run completed successfully. 1 actions were successful from file: C:\Users\tueda\Documents\Methodology\JIRA POC\Jira Install\CLI\atlassian-cli-8.4.0\4-Feature.csv

C:\Users\tueda\Documents\Methodology\JIRA POC\Jira Install\CLI\atlassian-cli-8.4.0>

--- Jira import configuration ---

{
"config.version" : "2.0",
"config.project.from.csv" : "true",
"config.encoding" : "UTF-8",
"config.email.suffix" : "@",
"config.field.mappings" : {
"Description" : {
"jira.field" : "description"
},
"Issue Key" : {
"jira.field" : "issuekey"
},
"Project Type" : {
"jira.field" : "project.type"
},
"Portfolio Item" : {
"existing.custom.field" : "10500"
},
"Name" : {
"jira.field" : "summary"
},
"Project Name" : {
"jira.field" : "project.name"
},
"Project" : {
"jira.field" : "project.name"
},
"Parent Link" : {
"existing.custom.field" : "10008"
},
"Issue Type" : {
"jira.field" : "issuetype"
},
"Project Key" : {
"jira.field" : "project.key"
},
"Portfolio Initiative" : {
"existing.custom.field" : "10215"
},
"Epic Name" : {
"existing.custom.field" : "10003"
},
"Release" : {
"jira.field" : "fixVersions"
}
},
"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" : "dd/MMM/yyyy"
}

[tueda]

forgot to attach this :

[John Funk]

You should probably open a support ticket directly with Bob Swift then.  :-)

[tueda]

Sure, doing.

Thanks

[John Funk]

Can you mark this one as Answer Accepted so the question doesn't stay open? Thanks!

[tueda]

Thanks for the follow up.

But would keep it open because I don't figure out if CLI works for it or not.

Working on it !

[John Funk]

Very good. :-)

[tueda]

I confirmed I can update parent links using CLI.

(Still struggling how to bulk update them, though.)

Thank you, we can close the incident.