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

[Bob Swift · Accepted solution]

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)

[Olivier Orlow]

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.

[Olivier Orlow]

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

[Bob Swift]

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

[Olivier Orlow]

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.

[Bob Swift]

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

[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