Extract System Managers from Frappe

extract_system_managers.py

from webnotes.utils import cstr, validate_email_add, extract_email_id
from email.utils import parseaddr
el = []
for s in webnotes.conn.sql("""select system_managers from `tabSerial No`
        where status in ("Active", "Trial", "Delivered")"""):
    if s and s[0]:
        emails = cstr(s[0]).split("\n")
        for e in emails:
            name, addr = parseaddr(e)
            if addr:
                addr = addr.lower()
                if not validate_email_add(addr):
                    addr = extract_email_id(e).lower()
                
                if addr:
                    el.append(addr)

webnotes.errprint(", ".join(sorted(list(set(el)))))