System data request for all public bodies with no email addresses

[sallytay]

Would it be possible to get a list of all public bodies that currently have no email address.

Helen has offered to have a look through these for us, and it's something that we could use in the future for giving new volunteers projects to work on

It would be useful for it to include the public body name and a link to their admin page.

[RichardTaylor]

Related:

• Add a way for users to find missing authority email addresses alaveteli#3477
• Add an admin page for bodies with missing email alaveteli#6424
• Enable and encourage users to help find missing contact details for bodies alaveteli#6831

[RichardTaylor]

This could be achieved via a new field on the CSV download.

A request_address_held field could show TRUE if one is held and FALSE if not.

[garethrees]

Generated an export today with the following:

csv_string = CSV.generate do |csv|
  csv << %w[
    public_url
    admin_url
    body_name
    home_page
    tags
  ]

  PublicBody.without_request_email.each do |body|
    csv << [
      "https://www.whatdotheyknow.com/body/#{body.url_name}",
      "https://www.whatdotheyknow.com/admin/bodies/#{body.id}",
      body.name,
      body.calculated_home_page,
      body.tag_string
    ]
  end

  csv
end

File.write("tmp/#{Date.today.iso8601}-missing-body-emails.csv", csv_string)