Update custom field from CSV field

Olivier Orlow June 16, 2013

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

0 votes
Answer accepted
Bob Swift OSS (Bob Swift Atlassian Apps)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 16, 2013

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

Olivier Orlow June 17, 2013

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 June 17, 2013

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 June 17, 2013

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 June 17, 2013

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 June 17, 2013

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 OSS (Bob Swift Atlassian Apps)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 17, 2013

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

Olivier Orlow June 17, 2013

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 OSS (Bob Swift Atlassian Apps)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 17, 2013

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

0 votes
Teck-En
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 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