Bulk email address change for JIRA 5.1.2

Kathleen Buckley

We have tried using the following script to update (in bulk) the domain names of our email addresses, but it's not working. Anyone know what is wrong with our script? We are running JIRA 5.1.2 and out database is Oracle 11g.

UPDATE CWD_USER
SET email_address = user_name || '@noemail.com',
lower_email_address = lower(user_name) || '@noemail.com',
updated_date = sysdate
WHERE email_address not like '%@currentdomainname.com'

Matt98

It is a dumb method, but worked for me.

Have you tried to dump everything to xml backup file, and then using email regex like this:

="^([0-9a-zA-Z]([-\.\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\w]*[0-9a-zA-Z]\.)+[a-zA-Z]{2,9})$"

or simple: ="(.*?)@(.*).[a-zA-Z]{2,4}"