Export task list from a project

[tbalestreri3]

Hi All,

I have a request to export all of the highest level TASKS within a Project from the project level. I see on the project level you could export to PDF and XML however there is no excel and I really only want the top level tasks anyways.

Is there a way to enable exporting from the tasks related list on a project? I could not find anything on the export excel UI Action.

Thanks in advance!

Tony

[Chris York]

Try just navigating directly to the Project Task table instead of looking at a related list. You should be able to export from there in Excel Format.

[tbalestreri3]

Hi Chris thanks for the response.

I do realize you could do it from the task table, however I was wondering if it was possible to enable it on the task related list on the project form. Some of our project managers have a bunch of projects and creating a filter for each one isn't as efficient as this would be however it seems to be the only way. Thanks again!

[#4]

You could create a UI Action on the project form and modify the following script to export only the tasks that have a parent of the current task. This script will export a CSV file based on your query.

var myFields = new Packages.com.glide.choice.ChoiceList();
 myFields.add('first_name');
 myFields.add('last_name');

var myQuery='first_name=Fred';

var c = new Packages.com.glide.generators.CSVExporter('sys_user', myQuery, myFields);
var outFile = new Packages.java.io.File('/tmp/pat.txt');
var outStream = new Packages.java.io.FileOutputStream(outFile);
c.generate(outStream);
outStream.close();

[DubeyN]

Hi,

Is there is any similar script (UI Action) Avavile to import data from EXCEL to table in SN.

ND