OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Getting rid of duplicate submissions en masse

Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael, vgabler, John

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

Getting rid of duplicate submissions en masse

Postby Flying_Monkey » Thu Jul 15, 2010 8:21 am

Dear all,

Is there any way of removing duplicate submissions (and I mean all reference to them, not just the document) en masse?

I ask because we are currently migrating our journal to a new server in another country at the same time as importing XML versions of issues from the older pre-OJS version of the journal. During this process there have been many unsuccessful attempts which left half-issues and duplicates in the system.

The properly migrated issues have all their articles in the archives as one would expect, but all the unsuccessful duplicates etc. are listed as 'unassigned' submissions.

Now I know I can open each one and archive then delete them, but there are 145 of them, and this would therefore take me about 2 tedious hours, given our server speed - is there a simpler way to remove all of these incorrectly listed articles en masse? This would make sense... and if there isn't, can I suggest this might be something to add into the next major release of OJS.

David.
Flying_Monkey
 
Posts: 13
Joined: Thu Oct 23, 2008 8:54 am

Re: Getting rid of duplicate submissions en masse

Postby jmacgreg » Mon Jul 19, 2010 12:16 pm

Hi David,

There has been a "Delete Articles" cli tool added to recent versions of OJS -- see http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=4759. You can see usage instructions by running php tools/deleteSubmissions.php.

Cheers,
James
jmacgreg
 
Posts: 4191
Joined: Tue Feb 14, 2006 10:50 am

Re: Getting rid of duplicate submissions en masse

Postby Flying_Monkey » Thu Jul 22, 2010 9:49 am

Thanks, but is this purely a server function - i.e. there is nothing that would appear to me as Editor? Or do these instructions result in a new function appearing to me as Editor? It makes a big difference because I don't have direct server access...

David.
Flying_Monkey
 
Posts: 13
Joined: Thu Oct 23, 2008 8:54 am


Return to OJS Editorial Support and Discussion

Who is online

Users browsing this forum: No registered users and 2 guests