After entering a number of tasks with start/finish
dates, work, percentage of parent task, owner, etc, I
would like to have a possibility to "export" a detailed
list. Preferably in CSV format, so I can import the
data in Excel/Project.
I would like to see all values belonging to a task, So
task-id, task name, estimated hours, startdate,
enddate, people, description etc. Just like when you
click on a task and get the detailed info.
Might be a useful feature to fill MSproject (or another
planning tool to do the auto scheduling/leveling of
tasks and resources.
As a work around you can play with SQL statements like:
select task.id, CONCAT(people.fname, ' ',
people.lname), task.PercentComplete, task.TaskName,
task.TaskDesc into outfile '/tmp/tasks.csv' FIELDS
TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\'
LINES TERMINATED BY "\n" from task, person_task, people
where person_task.personID = people.id and
person_task.owner = 'Y' and person_task.taskID =
task.id and task.ProjectID = 2 and task.PercentComplete
(Thanks to Guy Davis for this SQL statement)