Update custom field from CSV field

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

2 answers

1 accepted

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

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

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.

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)

Ctd3:

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(U
nknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(U
nknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown So
urce)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Un
known Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.p
arse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(Unknown S
ource)
at org.apache.axis.encoding.DeserializationContext.parse(Deserialization
Context.java:227)
at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnders
tandChecker.java:62)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at org.swift.common.soap.jira.JirasoapserviceV2SoapBindingStub.updateIss
ue(JirasoapserviceV2SoapBindingStub.java:4287)
at org.swift.jira.cli.JiraClient.updateIssue(JiraClient.java:2168)
at org.swift.jira.cli.JiraClient.setFieldValue(JiraClient.java:5167)
at org.swift.jira.cli.JiraClient.handleRequest(JiraClient.java:652)
at org.swift.common.cli.AbstractRemoteClient.process(AbstractRemoteClien
t.java:122)
at org.swift.common.cli.CliClient.doWork(CliClient.java:327)
at org.swift.jira.cli.JiraClient.main(JiraClient.java:177)
931520bcb4007982191f93e455cb98261f6820b0 logged out.

Thanks for your input.

I am running the following command:

jira --action setFieldValue --issue "RISA-2883" --field "Amt" --values "Amt Test Import" --debug

Then I get an error message: Remote error: java.lang.NullPointerException

I am using:

JIRA(v5.2.4#845-sha1:c9f4cc4)

CLI 3.4.0

JRE 7-0

WINDOWS 7

Could you help me?

Thanks a lot

Olivier

Appears to a server issue. I created JCLI-397 to track. Please follow up there.

Hi Bob

Thanks for your quick answer.

I can update the JCLI-397 case and add my comments.

Could you please authorize me?

I have followed the steps you suggested.

You need a site id to make comments. Select Log In and then Create an account

0 vote
Yew Teck En Atlassian Team Jun 16, 2013

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

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

100 views 0 1
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you