read csv fle form issue attachment using scriptrunner

[sgole]

Hii,,

can anybody plz help me with this , i want to read csv file from attachment using script runner . 

[DPKJ]

Here is a simplest version that I can share,

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.util.AttachmentUtils

def issueManager = ComponentAccessor.getIssueManager()
def attachmentManager = ComponentAccessor.getAttachmentManager()

def issue = issueManager.getIssueObject("<DESIRED_ISSUE_KEY"); // e.g. SP-1

def attachments = attachmentManager.getAttachments(issue)

attachments.each{ attachment ->
  def fileName = attachment.fileName
  
  
  def filePath = AttachmentUtils.getAttachmentFile(attachment)
  def attachmentFile = new File(filePath)
  

}

Important portion here are, fetching attachment object and getting it's file path using AttachmentUtils helper class (this is because attachments are stored in file system using special directory structure)

Once you have attachment file you can use it as you wish.

[Tom Lister]

Hi @DPKJ 

Did you get as far as reading an attachment?

Best

Tom

[DPKJ]

It worked for me when I last tried.

I will give it another trial once I get some time.