read csv fle form issue attachment using scriptrunner

Question

Hii,,

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

DPKJ · Answer

It worked for me when I last tried.

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

Tom Lister_97sldx · Answer

Hi @DPKJ

Did you get as far as reading an attachment?

Best

Tom

DPKJ · Answer

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.