Reassigning tasks to different projects / clients

Discussion forum about Anuko Time Tracker
Post Reply
5circles
Posts: 7
Joined: Fri Jan 25, 2013 10:54 pm

Reassigning tasks to different projects / clients

Post by 5circles » Fri Jan 19, 2018 12:52 am

What's the best way to reassign tasks to a different project or client? Can this be done with PHPMyAdmin (easily) or is some other way better?

It looks as though I can export with PHPMyAdmin to get the same output as mySQLdump (which I don't think I can access on my server), and then edit the tt_log section to change the client_id and then import. Or, probably better - just export the relevant rows of the tt_log table, edit them, and reimport. Does this make sense?

It's about time for me to update Time Tracker anyway. I don't that should make a difference as I'll want to make a copy of the database for safety in any case.

Thanks
Mike

wrc
Posts: 238
Joined: Tue May 25, 2010 8:30 pm

Re: Reassigning tasks to different projects / clients

Post by wrc » Sun Jan 21, 2018 12:42 am

See mysql.sql. Tasks are mapped to projects in this table.

Code: Select all

#
# Structure for table tt_project_task_binds. This table maps projects to assigned tasks.
#
CREATE TABLE `tt_project_task_binds` (
  `project_id` int(11) NOT NULL, # project id
  `task_id` int(11) NOT NULL     # task id
);
Projects are mapped to clients in this table.

Code: Select all

#
# Structure for table tt_client_project_binds. This table maps clients to assigned projects.
#
CREATE TABLE `tt_client_project_binds` (
  `client_id` int(11) NOT NULL, # client id
  `project_id` int(11) NOT NULL # project id
);
But based on your question context, you may be actually looking to reassign existing tt_log records to a different client. If this is the case, see if you can export the team data to a file, edit it, and then re-import.

5circles
Posts: 7
Joined: Fri Jan 25, 2013 10:54 pm

Re: Reassigning tasks to different projects / clients

Post by 5circles » Sun Jan 21, 2018 9:58 pm

Thanks. That confirms some things that I was beginning to understand.

Post Reply