Get project data out

[Diane]

I would like to "export" a file from my Project Database/Timesheets. I
simply want a file that has Resource, Act. Work (hrs) and date.

What is the best way to accomplish this? The data will be going into third
party software for processing.

Should I be creating a query in SQL? If so, perhaps a hint as to where this
code might go?

 

[Sara - EPM]

Diane,

If you are looking for total actual hours charged, its simple. If you want
timephased data, meaning total actual hours in a given date range, its a
little more difficult.

For total actual hours - within Professional, with the file open, go to
File, Save As. Change the type to xls. This will walk you through a wizard.
Choose the fields you need, remembering to use Actual Work, Actual Start,
etc.

Hope this helps.

Sara

If you need timephased data, within Professional, with the file open, go to
View, Toolbars, Analysis. Go through the Analyze Timescale Data in Excel
Wizard. This should get you what you need.

Both of these methods are for individual projects. If you need to run this
against your SQL db for all projects, its more work. MS Project development
site has SQL scripts for timephased data against the db.

 

[Diane]

Thank you. I actually found a document with all the tables & fields
explained, so I'lljust write some SQl code to suck out the data I need.

But I didn't know about those other features too, so thank you for telling
me about them ;-)

 

[Jonathan Sofer - MCP]

I personally think that if you are going to automate a data feed to a 3rd
party system, your approach of writing some SQL procedures would be the
best. Make sure to test them thoroughly.

Good luck.

 

[Diane]

I agree - thanks

I personally think that if you are going to automate a data feed to a 3rd
party system, your approach of writing some SQL procedures would be the
best. Make sure to test them thoroughly.

Good luck.

 

[SSGurney]

Hi Diane; May I ask where I can find the document you are refering to.

Thanks Steph

 

[Kevin W Flanagan]

You can find it on your project server install CD as a help file