Extracting all emails

Hello,
is there any way to extract all emails from the OJS database? I mean, we would like to email all authors from previous issues special announcement in one email and to do that we need to extract these emails. It would be great if we could choose just some emails from specific journal(s).
Thank you
Petr

What version of OJS are you using?

In 2.4.x, to email all authors by Journal:
User Home → Journal Manager → Authors → Select All → Email.

newest 2x version, this goes only to registered authors, not the authors entered through quick submit function- those are not there

Ah, ok. If you want to find the emails for authors who are not registered users, you will need to write a database query.

This is stored in the authors table, within the email field.

ok, will try to find it, thank you

Hi, I opened the phpmyadmin, and although I clicked email under author, I see no table and I do not know how to use sql, can you please help me out?

Hi @Petr,

the sql statement to get the email and name components would look like:
select distinct email, first_name, middle_name, last_name from authors;
If you like it ordered by last_name
select distinct email, first_name, middle_name, last_name from authors order by last_name, first_name, middle_name;

I’m not using phpmyadmin but here is a tutorial of running sql queries.

Hope this helps

Claudia Jürgen

Hi, great, thank you, is it possible to filter author emails according to specific journals?
Petr

In 2.4.x, the authors table has a field submission_id. This submission_id is the article_id in the articles table. The articles table also has an associated journal_id.

You’ll need to use SQL joins to associate the tables within your query.