nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Update custom field from CSV field

Olivier Orlow

I have an issue to which - as a non-developer - I could not find a solution:

I have a csv file with two columns: JIRA-issue id and a second value (numeric)

I would like to update a custom field ("MGMT_SPS" numeric) for each issues with the numeric value on the same line in the csv file.

Could anyone tell me which tools and which syntax I have to use to achieve this goal? (Again I am not a developer)

Thanks a lot

Olivier

Accepted answers

Bob Swift

How to use runFromCsv describes how to make this type of change using JIRA Command Line Interface

All comments

Teck-En

Hi Olivier, you can do it via the CSV import in JIRA. In the process, select your project, map the custom field and issue key then proceed with the import. To avoid any wrong changes, I would suggest perform a backup before you run the csv import.

You can follow the documentation for detail instruction:

JIRA 6: https://confluence.atlassian.com/display/JIRA060/Importing+Data+from+CSV

JIRA 5.2.x or below: https://confluence.atlassian.com/display/JIRA052/Importing+Data+from+CSV

Bob Swift

How to use runFromCsv describes how to make this type of change using JIRA Command Line Interface

Olivier Orlow

Here is the debug message:

User parameters (non-blank):
Java arguments . . . . . . . : []
Used memory (MB) . . . . . . : 1
Free memory (MB) . . . . . . : 13
Total memory (MB) . . . . . . : 15
Max memory (MB) . . . . . . . : 247
clientInfo . . . . . . . . . : Client version: 3.4.0, Java: Java HotSpot(TM) Cl
ient VM 1.7.0_21, OS: Windows Server 2008 R2 6.1
action . . . . . . . . . . . : setFieldValue
debug . . . . . . . . . . . . : true
server . . . . . . . . . . . : http://jivsw026:8088
user . . . . . . . . . . . . : jiraadmin
password . . . . . . . . . . : ***
issue . . . . . . . . . . . . : RISA-2883
field . . . . . . . . . . . . : Amt
values . . . . . . . . . . . : Amt Test Import
Default parameters (non-blank):
verbose . . . . . . . . . . . : false
quiet . . . . . . . . . . . . : false
outputFormat . . . . . . . . : 1
host . . . . . . . . . . . . : localhost
continue . . . . . . . . . . : false
simulate . . . . . . . . . . : false
service . . . . . . . . . . . : /rpc/soap/jirasoapservice-v2
loginFromStandardInput . . . : false
requestType . . . . . . . . . : GET
count . . . . . . . . . . . . : 2147483647
limit . . . . . . . . . . . . : 2147483647
api . . . . . . . . . . . . . : latest
autoGroup . . . . . . . . . . : false

Olivier Orlow

Ctd:

permissionScheme . . . . . . : Default Permission Scheme
autoVersion . . . . . . . . . : false
autoComponent . . . . . . . . : false
autoAdjust . . . . . . . . . : false
asVersion . . . . . . . . . . : false
asComponent . . . . . . . . . : false
asCascadeSelect . . . . . . . : false
append . . . . . . . . . . . : false
appendText . . . . . . . . . : false
copyLinks . . . . . . . . . . : false
copyAttachments . . . . . . . : false
copyComments . . . . . . . . : false
copyWatchers . . . . . . . . : false
copySubtasks . . . . . . . . : false
copySubtaskEstimates . . . . : false
useParentVersions . . . . . . : false
cloneIssues . . . . . . . . . : false
copyVersions . . . . . . . . : false
copyComponents . . . . . . . : false
copyRoleActors . . . . . . . : false
replace . . . . . . . . . . . : false
activate . . . . . . . . . . : false
deactivate . . . . . . . . . : false
help . . . . . . . . . . . . : false
Server address: http://jivsw026:8088/rpc/soap/jirasoapservice-v2
Successful login to: http://jivsw026:8088/rpc/soap/jirasoapservice-v2 by user: jiraadmin.

Olivier Orlow

Ctd 2:

Remote error: java.lang.NullPointerException
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: java.lang.NullPointerException
faultActor:
faultNode:
faultDetail:
{}faultData:null
{http://xml.apache.org/axis/}hostname:JIVSW026

java.lang.NullPointerException
at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder
.java:222)
at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.
java:129)
at org.apache.axis.encoding.DeserializationContext.endElement(Deserializ
ationContext.java:1087)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endEleme
nt(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanEndElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(U
nknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next
(Unknown Source)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration