Added by Arnold Davis about 1 year ago
I have a task that involves removing hundreds of parent work packages, and I'm wondering how I can achieve this efficiently. The bulk editor user interface allows me to define the work package numbers but doesn't seem to have an option for removing them entirely ("nothing"). Do you have any suggestions on how I can accomplish this without having to do it one by one?
Replies (2)
If your work package management system has an API or scripting capabilities, you could write a script to automate the process. This script could use the API to locate and delete the specified parent work packages based on their numbers.
Some work package management tools allow you to import data in bulk. If your tool supports this, you might be able to prepare a spreadsheet or file that lists the work package numbers you want to remove. Then, use the import functionality to apply the changes.
Depending on the architecture of your work package management system, you might be able to directly manipulate the underlying database. This approach can be risky if not done carefully, as it could lead to data corruption or unexpected issues. It's essential to consult with your system administrators or technical support before attempting this method.
If you have access to developers, you could consider building a custom solution that interfaces with your work package management system. This might involve creating a dedicated tool or script that interacts with the system's API to remove the desired parent work packages.
If your work package management system is provided by a vendor, consider reaching out to their support team. They might have insights or recommendations for handling bulk changes that aren't immediately obvious from the user interface.
Before proceeding with any approach, it's crucial to back up your data and thoroughly test the solution on a non-production environment. This will help you ensure that you don't accidentally delete or modify critical data.
I hope you like my answer , i always try to give my best.
Hello Arnold,
it is possible to bulk delete work packages (-> How-to-Guide). This deletes all sub-work packages too, though. Currently you cannot remove a parent work package from sub work packages via bulk action. There is a open feature-request to add this possibility. Feel free to add your comment and vote here: https://community.openproject.org/wp/33875
So, if you are fine with removing the sub work packages as well, you could do this manually with bulk delete or eventually, as suggested by Wanda, via API.
I recommend you to do a backup before you start deleting that many work packages.
Best
Alexander