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.