Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Delete Multiple Pro...
 
Notifications
Clear all

Delete Multiple Projects (Mass Delete)

3 Posts
2 Users
0 Reactions
5,058 Views
Mark Docken
(@mdocken)
Posts: 18
Active Member
Topic starter
 
[#1562]

I imported a few hundred Projects from CSV file and I want to delete them all. Is there any way to do this other than clicking on them in the Projects View and deleting them one by one?


 
Posted : 10 Jan 2014 22H02
(@babynus)
Posts: 14952
Member Admin
 

Well, no : no other way.
Have to do it one by one. 🙁

Sorry 😳

But maybe it will be easier to simply "close" them.
This can be done through multiple update functionality.

And if you only created projects, and no other item referencing these project, you can try deleting directly from database : just think to also delete planningelement with refType='Project' and refId=id of project.

Or simply try to write your own php code that will do it...
Something like (sorry not tested) :

include_once("../tool/projeqtor.php"); // change this depenging on location of your script, here is may be in /test folder
$startId=10; // change with your onw start id to delete
$endId = 100; // change with your onw end id to delete 
for ($id=$startId; $iddelete();
}

Simple, no ?


 
Posted : 10 Jan 2014 22H13
Mark Docken
(@mdocken)
Posts: 18
Active Member
Topic starter
 

Easy as pie! Sample code above worked like a charm.


 
Posted : 15 Jan 2014 15H25
Share:

Scroll to Top