#86 Project templating - import tasks from another project

[Handco]

Add-on feature :
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.

Hn'co

[Handco]

Patch to apply into dotproject dir

[Ray Dai]

Logged In: YES
user_id=766652

This is awesome!!! I made some mod to it so it copies files
and assigned users too. I've asked
Adam to put it on demo so people can test and then we will
put it in production! Great work.

[Handco]

Logged In: YES
user_id=513326

It seam there is a problem who depend of the version of
mysql, and an error from myself.

Excuse for the convenience, attached a new patch.
I hope it's correct.

For newbies with patch : To apply the new patch you must
reverse the older with a patch -R -p0 and apply the new one....

[Handco]

Patch correction

[Felipe Martin]

Logged In: YES
user_id=897382

It's really a good work. I was thinking in that feature too, but
it would be better if the solution was based in a "task
template" approach. Then it could be posible to create
iterations or phases into the project, starting from another
project (also the creation of a new project can reuse this
functionality inserting as the first task the replica of the
project template).

[Patrick L. Lykins]

Logged In: YES
user_id=566320

I have tried patching numerous times on different copies of
dotProject and each time I get the following error. I am
using version 1.0.1.

You have an error in your SQL syntax near 'WHERE (
t.task_project = p.project_id ) AND (p.project_id IN
(34,21,36,32,37,10,' at line 3

Any clue how to fix this?

Thanks

[Ray Dai]

Logged In: YES
user_id=766652

When did you download the patch? Notice that handco have
updated his patch, try the new patch?

Ray

[Patrick L. Lykins]

Logged In: YES
user_id=566320

I reverted back like he said, and tried the new one.
Same issue.

[Handco]

Logged In: YES
user_id=513326

Actually, the list of import tasks from projects , shown all
projects the user can see, included the project owned bye
companies that he can't see due to permissions.

This Patch ensure that the user can see only project owned
by visible companies

Just revert the old path and apply the new to correct the
problem.
Please report on this thread any probleme the new
functionnality can do, because, I override the current
project access rules.
By this Rules :
"-------------
I can see a project if I've all permissions on project
module or if the project is specificaly marked visible for
my account or this project is not marked denied for my
account . AND THE PROJECT IS OWNED BY A VISIBLE COMPANY
--------------"

[Handco]

Patch with permissions changed

[Celina]

Logged In: YES
user_id=896022

Ran patch. I can select project to import, but the tasks don't
import. I hit submit and it runs without errors, but upon
returning to the newly created project, I have no tasks.
Thanks for your help! Note that I had a HUNK error in
tasks.class.php when updated that I assume is at fault here.

[Handco]

Logged In: YES
user_id=513326

Major SQL bug correction

[Handco]

Major SQL bug correction

[Handco]

Logged In: YES
user_id=513326

A new patch provide major SQL bug correction,
revert and apply to install it.

[Handco]

Major SQL bug correction again