Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#35 Export a detailed task list as CSV

OPT_1.X_(Max)
open
Guy Davis
None
4
2003-10-05
2003-10-02
Martin Vernooij
No

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
< 100;

(Thanks to Guy Davis for this SQL statement)

Martin

Discussion

  • Guy Davis
    Guy Davis
    2003-10-05

    • milestone: --> OPT_1.X_(Max)
    • priority: 5 --> 4
    • assigned_to: nobody --> guy_davis