Remove a workspace item

[Alexander Vielhauer]

Dear list,

what is your recommended workflow for deleting abandoned workspace items?

We have a rather large dataset stuck in submission since the author
started a new submission (which is now archived) instead of resuming his
old submission.

I cannot find a way though to delete workspace items via a command line
operation or an admin feature in the UI. I'd rather not manipulate the
database directly to allow the cleanup utility to take care of deleting
the bitstreams.

If anyone keeps track of this in their repo: How do you scan for "stuck"
submissions and what are your thresholds and deadlines for notifying the
authors and deleting the submission?

Thank you and kind regards
Alexander

--
Alexander Vielhauer
Philipps-Universität Marburg | UB
Digitale Dienste | Deutschhausstraße 9 | D226
Tel. +49 06421 28-25290

[Hrafn Malmquist]

Hello Alexander

To the best of my knowledge, there is currently no supported way of doing this using DSpace UI.

There are two PRs to DSpace 6 (assuming that's the version you're using) intended to support such functionality:

https://github.com/DSpace/DSpace/pull/2200

and

https://github.com/DSpace/DSpace/pull/2076

I've mostly looked at the latter one. It applies only to the XML Configurable Workflow which I could not try out as our production servers only use the basic workflow setup.

Unfortunately I can't help you more.

Good luck, Hrafn

--
All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/2b00b729-5b64-8f95-91b5-b3a6c9cb4b10%40staff.uni-marburg.de.

[Alexander Vielhauer]

Dear Hrafn,

Thank you very much! From the PR I learned that DSpace7 has a handy admin feature for browsing and deleting workflow items - another reason to push for the upgrade! :)

Best,
Alexander

[Alexander Vielhauer]

After testing and rereading the PRs, I can say that the workflow administration (in DSpace7) is limited to workflow items which have been submitted. Sorry for the confusion.

To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/ae874de6-b24e-5a97-68e7-d4ff3ba96383%40staff.uni-marburg.de.

[Alan Orth]

Hi all,

I've looked at both of these PRs and unfortunately they are for the configurable workflow (aka XML workflow). We are using the basic workflow so these won't work for us. That's a real shame because I have thousands of abandoned submissions from hundreds of editors over the past twelve years and I'd love to find a way to get rid of them. We are on DSpace 6.3.

Regards,

To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/9ea7ca9d-501b-29fd-8927-ca1c68fab4f8%40staff.uni-marburg.de.

--

Alan Orth
alan...@gmail.com
https://picturingjordan.com
https://englishbulgaria.net
https://mjanja.ch

[Alan Orth]

Asking again here. Is there any way to delete "abandoned" submissions from the database? Our editors sometimes accept submissions at the "Accept/Reject/Edit" step that end up being duplicates or mistakenly accepted for other reasons. Once they've accepted them there is no way to reject them, only send them back to the task pool. We have thousands of these as our repository is over ten years old!

Appreciate any help or stories from the SQL trenches...