Exporting users in OJS 2.4.X

Software Support
1

I have not been able to find this.

Is there a way to export users for a journals in a CSV format? I run a multi installation of OJS 2.4.X and I need to export users for one journal. All option I see are for XML.

Thanks

2

Hi @newone,

No, the XML export is all that I’m currently aware of. You could get the information you need from phpMyAdmin in CSV format, if you join users with roles. You’ll need a small amount of SQL experience.

Regards,
Alec Smecher
Public Knowledge Project Team

3

@asmecher

phpMyAdmin gives me all users for all the journal. I just want to get all registered users for 1 journal.

I am wondering is there a way to get only users from a certain journal in phpMyAdmin using the journal ID?

4

Hi @newone,

Yes, as above – you’ll need to join users against roles.

Regards,
Alec Smecher
Public Knowledge Project Team

5

Ooops. :smiley:

How do I do this?

6

Hi @newone,

Have a look e.g. at MySQL Database Tutorial - 22 - How to Join Tables - YouTube.

Regards,
Alec Smecher
Public Knowledge Project Team

7

Thanks for the info. I have been able to export users.