Menu

#96 Project templating and dynamic tasks

Stable
open
General (114)
7
2004-01-19
2003-11-25
Handco
No

Add-on features :
Dynamic tasks :
--------------------------------------------------
When the end of a task is modified, all dependant tasks
marked as dynamic are moved accordig to the difference
beetween the end dates.

I hope that function help all users to update projects.....

Project Templating :
--------------------------------------------------
When you create a new project, or edit an existing
without task, a new list appear in the project edit form
to import tasks from another project.

Tasks are imported with parent property and
dependencies
are duplicated according the original tasks.

An offset is applied on the start and end date, it's equal
to the difference beetween the projects start dates.

-----------------
:c) Hn'Co

Discussion

  • Handco

    Handco - 2003-11-25

    Hn'co Patch

     
  • Handco

    Handco - 2003-11-25
    • priority: 5 --> 7
     
  • Dylan Cuthbert

    Dylan Cuthbert - 2003-11-26

    Logged In: YES
    user_id=500015

    In order to get this to work I had to change your sql line in
    tasks.class.php: dependantTasks() into:

    $sql = "
    SELECT dependencies_task_id
    FROM task_dependencies AS td, tasks AS t
    WHERE td.dependencies_req_task_id=$taskId
    AND td.dependencies_task_id=t.task_id
    AND t.task_dynamic=1
    ";

    Is the syntax you were using MySQL 4? A lot of systems still
    use MySQL 3 (redhat 8 for example)

    I also added one line to shiftDependantTasks() to prevent
    unnecessary sql requests:
    (after the call to dependantTasks() )

    if ( count( $csDepts ) == 0 ) return;

     
  • Dylan Cuthbert

    Dylan Cuthbert - 2003-11-26

    Logged In: YES
    user_id=500015

    ignore the "if ( count" line, I mistakenly thought it was an
    array being returned, but obviously it isn't. (should add check
    for empty string though)

     
  • Handco

    Handco - 2003-11-26

    Corrected patch

     
  • Handco

    Handco - 2003-11-26

    Logged In: YES
    user_id=513326

    Little correction to work with older version of mysql...

    :c)
    Hn'co

     
  • Peter

    Peter - 2004-01-08

    Logged In: YES
    user_id=861395

    Hi, I am trying to import tasks, after applying this patch, but
    nothing is being imported. The dropdown list in the add/edit
    screen is there, and I can select another project to import
    tasks from, but they aren't being imported. Can you help
    please? thanks.

    Peter Collins
    Vancouver

     
  • Dylan Cuthbert

    Dylan Cuthbert - 2004-01-19
    • assigned_to: nobody --> dylan_cuthbert
     
  • Dylan Cuthbert

    Dylan Cuthbert - 2004-01-19

    Logged In: YES
    user_id=500015

    I have applied the "import project" part of this patch to the
    up-coming 1.02 release of dotproject.

    Could people please check it out from cvs and make sure
    there are no immediate problems.

     
  • Peter

    Peter - 2004-01-19

    Logged In: YES
    user_id=861395

    That's great Dylan, thanks very much. Does anyone know if
    the Dynamic Tasks part of this will also be included in 1.02?
    That will really be the bee's knees.

    Peter

     
  • Dylan Cuthbert

    Dylan Cuthbert - 2004-01-19

    Logged In: YES
    user_id=500015

    I decided to hold off implementing that part of the patch right
    now as there have been a lot of changes to that bit of the
    code.

    If Herve wants to re-apply that part of the patch to the
    latest source, test it and then upload it here I will apply it
    though.

     
  • Handco

    Handco - 2004-04-06

    Logged In: YES
    user_id=513326

    I'm back, and I hope to have some time to analyse the
    recents change on dotproject, and re-apply the date
    dependency functionnality.

     
  • Big Al

    Big Al - 2004-04-14

    Logged In: YES
    user_id=1021385

    Herve,

    Im trying to convince my boss not to go down the Microsoft
    Project direction. I want to use dotProject instead (1.0.2-1)
    but it cant compete with MS Project without your Dynamic
    Task update!!!

    Do you think youll be able to reapply the patch soon?
    My thanks, and good work.

    -Big Al

     
  • Peter

    Peter - 2004-04-16

    Logged In: YES
    user_id=861395

    I am using a version located
    http://zeke.yi.org/downloads/dotproject/

    It was posted by a Sourceforge poster. The templating
    works, and it will also move dependent tasks when their
    parent task is moved.

    However, if you use the latest database, you have to add a
    field to one of the tables for the forums to work properly with
    this version. I suspect it's because the version has an older
    version of the forums script. I was able to correct it using
    Webmin.

    Peter

     
  • Big Al

    Big Al - 2004-04-16

    Logged In: YES
    user_id=1021385

    You say a parent date change would cause a change in the
    child date, but it's a question of one task changing a
    dependent task's dates not a parent/child relationship.

    -Alan

     
  • Peter

    Peter - 2004-04-16

    Logged In: YES
    user_id=861395

    Just trying to help.

     
  • JaMo

    JaMo - 2004-08-20

    Logged In: YES
    user_id=773788

    Downloaded the patch, windows, but how do you apply the patch?
    Thanks...

     

Log in to post a comment.