Hi everyone,
I’m currently working with OJS 3.4 and facing an issue related to assigning DOIs to articles in bulk. In OJS 3.3, I used the following SQL query to insert DOI numbers for multiple articles:
INSERT INTO `publication_settings` (`publication_id`, `locale`, `setting_name`, `setting_value`) VALUES
(200, '', 'pub-id::doi', '10.123456/journalx.1'),
(201, '', 'pub-id::doi', '10.123456/journalx.2'),
.
.
.
(1201, '', 'pub-id::doi', '10.123456/journalx.1000');
However, in OJS 3.4, it seems that DOIs are stored in a separate table, and I’m having trouble identifying the article IDs associated with these DOIs.
Given that I have hundreds of DOIs and I know which articles they belong to, how can I perform a bulk DOI assignment in OJS 3.4?
Any guidance or suggestions on how to approach this task would be greatly appreciated!
Thank you!