[OJS 2.4.6] Script to delete multiple journals from OJS

juancure · October 4, 2019, 6:31pm

Hi everyone, I write this topic because I need to delete multiple journals from an OJS which has about 120 journals, I was using the delete button but when the deleting process takes more of 30 seconds about finish, the browser shows the following page:

504_gateway_time-out

How can I do a PHP script as there are in the tools directory to delete multiple journals? I appreciate some kind of help, thanks a lot.

ctgraham · October 7, 2019, 1:25pm

If you are handy with PHP (or if you know someone who is), you could make a CLI tool for this by taking the code from the delete journal action:

github.com

pkp/ojs/blob/44980e842ec1bcae2fe22eefd6233e7b84b7196c/pages/admin/AdminJournalHandler.inc.php#L115-L128


			$journalId = $args[0];
			if ($journalDao->deleteJournalById($journalId)) {
				// Delete journal file tree
				// FIXME move this somewhere better.
				import('lib.pkp.classes.file.FileManager');
				$fileManager = new FileManager();

				$journalPath = Config::getVar('files', 'files_dir') . '/journals/' . $journalId;
				$fileManager->rmtree($journalPath);

				import('classes.file.PublicFileManager');
				$publicFileManager = new PublicFileManager();
				$publicFileManager->rmtree($publicFileManager->getJournalFilesPath($journalId));
			}

and adding it into a copy of one of the existing CLI tools. An easy target might be:

github.com

pkp/ojs/blob/ojs-dev-2_4/tools/deleteSubmissions.php

<?php

/**
 * @file tools/deleteSubmissions.php
 *
 * Copyright (c) 2013-2019 Simon Fraser University
 * Copyright (c) 2003-2019 John Willinsky
 * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
 *
 * @class deleteSubmissions
 * @ingroup tools
 *
 * @brief CLI tool to delete submissions
 */

require(dirname(__FILE__) . '/bootstrap.inc.php');

import('classes.file.ArticleFileManager');

class SubmissionDeletionTool extends CommandLineTool {

This file has been truncated. show original

Just change out the submission_id for the journal_id in the parameters.

juancure · October 14, 2019, 7:39pm

Hi @ctgraham thanks a lot for your response, I have copied the code from delete journal action above, on a based-script in tools/deleteSubmission.php an I have got to delete multiple journals from CLI terminal.