Bulk fix publication dates for archives

#1

Hi,

we have a large amount of archives with incorrect submission publication dates. The publication dates are either missing or showing the date of upload onto the web.

The archives were produced partly with XML import in OJS2 and partly with the QuickSubmit plugin in OJS2. Now we have a running OJS3.1.1.1 install.

What I wish is to populate and overwrite the publication dates of the submissions for all published articles with the issue publication dates (the latter are correct for the whole archives). I have access to the database via phpmyadmin but do not know SQL to write a script like that.

Thank you for any suggestions.

#2

Although this is a very old issue, I would like to share my SQL code that saved me a lot of time.

UPDATE published_submissions
INNER JOIN issues ON
published_submissions.issue_id = issues.issue_id
SET
published_submissions.date_published = issues.date_published;

I strongly recommaned to make a database backup before and perhaps test it in an isolated database. This SQL was tested with OJS 3.1.0.1 .

Cheers,

Adrian

1 Like