Re: [Tsheetx-developers] Re-using tasks for different projects

[David T. <tom...@us...>]

Good to see an overview after not having seen one for a long time.
The most striking thing I saw from that, is that the project id is recorded with the times as well as the task id.
Scott, are you proposing tasks with the same id on different projects, or just duplicated task names?
Dave
 


Date: Wed, 23 Mar 2011 10:25:28 +1100
From: pal...@gm...
To: tom...@us...
CC: tsh...@li...
Subject: Re: [Tsheetx-developers] Re-using tasks for different projects


Standard tasks is available to be used and has been implemented in the txsheet-2.0-demo branch. But I think it won't be useful for the question Scott raises. 

Scott, are you referring to duplications in the task table?  What duplications do you want to remove? There are a few tables all involved in tasks: assignments, task_assignments, task, times, std_tasks.

I've attached a table diagram produced by mysql-workbench.
Peter

On 23/03/11 03:46, David Thompson wrote: 


Peter was working on a table containing "standard" tasks that could be dropped into a new projects, but in another branch. No idea what the state is, but worth checking before you write lots of new code. 
Dave



Date: Tue, 22 Mar 2011 15:38:33 +0000
From: sco...@gm...
To: tsh...@li...
Subject: [Tsheetx-developers] Re-using tasks for different projects

There is nothing I know about deep in the code that is keeping us from being able to "reuse" tasks in different projects.  Personally, I hate having to create many of the same tasks for every project; so  I'm planning to create a new table that would indicate which tasks were "members" of which projects that would allow this to be done.

-Scott