MappyX
19-08-05, 10:04 AM
I'm working on a tool that will update the assignees accross all my projects by assigning the task to the user of a simular task in one of my template projects.
The script works great, however I'm experiencing some strageness now when I update a project - I loose the assignee and a "-" is shown in the column.
First the history. My script update the user_tasks table by using the following SQL:
Update user_tasks set user_id='<correct_User>'
where task_id = '<task_to_be_changed>';
Like I said, this works great, but when I later update a task that was changed in the above method, I loose the assignee all to gether. If I try to edit the task again and add a resouce, it won't add it.
When I look in the user_tasks table, I notice that the record for this task is not there. Where the task_id would be a one to one match to the task_id in the tasks table, now the user_tasks is missing some tasks.
What I don't understand is how dotProject is removing this record from the database.
On a side note, this doesn't happen when I update the task percent complete by entering a task log. It only happens when I click on the pencel and edit the task info directly.
Does anyone have any clues as to why this is happening?
Any help is appreciated.
The script works great, however I'm experiencing some strageness now when I update a project - I loose the assignee and a "-" is shown in the column.
First the history. My script update the user_tasks table by using the following SQL:
Update user_tasks set user_id='<correct_User>'
where task_id = '<task_to_be_changed>';
Like I said, this works great, but when I later update a task that was changed in the above method, I loose the assignee all to gether. If I try to edit the task again and add a resouce, it won't add it.
When I look in the user_tasks table, I notice that the record for this task is not there. Where the task_id would be a one to one match to the task_id in the tasks table, now the user_tasks is missing some tasks.
What I don't understand is how dotProject is removing this record from the database.
On a side note, this doesn't happen when I update the task percent complete by entering a task log. It only happens when I click on the pencel and edit the task info directly.
Does anyone have any clues as to why this is happening?
Any help is appreciated.