Downloading the list of keywords

Software Support
1

Dear colleagues,

At the Revista Ibero-Americana de Ciência da Informação (RICI), we are interested in downloading the list of keywords from all published articles in order to conduct an analysis that will help us identify thematic trends in our content.

Our journal uses OJS version 3.3.0.16.

We would appreciate your suggestions on how to carry out this technical process.

Kind regards,

Julio Santillan
Revista Ibero-americana de Ciência da Informação (RICI)
ISSN 1983-5213
https://periodicos.unb.br/index.php/RICI/index

2

Hi @santillan,

I wonder if you could do this using the custom a generate report:
https://docs.pkp.sfu.ca/learning-ojs/3.3/en/statistics#generate-custom-report

That CSV, I suspext, will have a a column containing all keywords for each article (often as a semicolon‑ or comma‑separated list) that you can then analyze in Excel, R, Python/your data analysis tool of choice.

This is usually the easiest method if you do not have direct database access - if you find you’re not able to do this via the custom report, the database route may be a good next thing to try.

-Roger
PKP Team

4

Another option would be to export the articles as native XML and then write an XSLT transformation to extract and group keywords according to a publication date range.

5

Hi @santillan,

Another option occurred to me as we well. One of our team member was experimenting with the use of Metabase for doing some analytics, pulling data from OJS. You can see an overview of the approach here:

I don’t think it’s been used widely, but it did remind me of your use case, and might be something you find useful.

-Roger
PKP Team