Change email for all Projects using script runner

[Sigursteinn Bjarni]

Hello.


I need to change project email for all of my projects in JIRA.

There are hundreds of them so I would like to know if script runner is capable of this?

I've been struggling with this for some time now.

[Nic Brough -Adaptavist-]

Yes, a one-off script run in the console could use the ProjectManager class to update every project

[Sigursteinn Bjarni]

There are methods of getting the mail, but I cannot see how to set the email for the project.

I've been looking through 
https://docs.atlassian.com/software/jira/docs/api/7.0.11/com/atlassian/jira/project/

and these 2 stand out, but nothing on how to set the email.

https://docs.atlassian.com/software/jira/docs/api/7.0.11/com/atlassian/jira/project/ProjectManager.html

https://docs.atlassian.com/software/jira/docs/api/7.0.11/com/atlassian/jira/project/Project.html

Could you give me some pointers ?

[Nic Brough -Adaptavist-]

Ah, hang on, what exactly do you mean by "project email"?

[Sigursteinn Bjarni]

In the project configuration under notification you can specify the notification scheme and an email.

F.x.
Scheme: Notification Scheme name
Email: xxx@company.xx

I need to change this email on all projects.

[Nic Brough -Adaptavist-]

Ah good, I could have pointed you in completely the wrong direction!

I think you combine ProjectManager with ProjectEmail.setFromAddress(email) - https://docs.atlassian.com/software/jira/docs/api/7.0.11/index.html?com/atlassian/jira/project/ProjectManager.html

[Thanos Batagiannis [Adaptavist]]

Hi Sigursteinn,

What @Nic Brough -Adaptavist- said (a one time script using the script console)

So the script that will change it for one project is 

import com.atlassian.core.ofbiz.util.OFBizPropertyUtils
import com.atlassian.jira.component.ComponentAccessor

def newAddress = "newEmail@example.com"
def project = ComponentAccessor.projectManager.getProjectByCurrentKey("ATG")

def email = OFBizPropertyUtils.getPropertySet(project.getGenericValue())
email.setString("jira.project.email.sender", newAddress)

So for all the projects will be something like 

import com.atlassian.core.ofbiz.util.OFBizPropertyUtils
import com.atlassian.jira.component.ComponentAccessor

def newAddress = "newEmail@example.com"
ComponentAccessor.projectManager.projects.each {
 def email = OFBizPropertyUtils.getPropertySet(it.getGenericValue())
 email.setString("jira.project.email.sender", newAddress)
}

Regards, Thanos

[Sigursteinn Bjarni]

Thank you so much Thanos, that did the trick :)