We are working with version 8.7. and I am having the following problem. I would need to move items (tasks - milestones - messages - files) from one project to another (newly created) one. Is there any simple way to do that, or to I have to copy - paste and delete each item. I think it will be available in 8.8. but I still have to go through the update process and test 8.8. on our server for stability which will take some time.
Can I change this maybe direct in the database (still I only have very basic SQL knowledge. Thx for any advise.....
Move Content
By bluesky - Posted on November 30th, 2011
Tagged:
If you need to move (not copy) items, it is quite simple. Something like this needs to be executed on the database:
update set project_id = where project_id =
Suppose you want the move all items from project 9 to project 10:
update pp087_project_task_lists set project_id = 10 where project_id = 9
update pp087_project_tasks set project_id = 10 where project_id = 9
update pp087_project_milestones set project_id = 10 where project_id = 9
update pp087_project_messages set project_id = 10 where project_id = 9
update pp087_project_files set project_id = 10 where project_id = 9
update pp087_project_folders set project_id = 10 where project_id = 9
The project_id is visible in the URL when you view the project (&id=...)
Hi ,
this helped me tremendously again today. So a move option for "non sql users" would be great.... but for me this works very good now, thx