Creating MPP file TimePhased Data

[Cantekin GUNESER]

Hi
I have custom developed web project which includes different modules. i have
project module in my project, it mange simply project management.
i want to export and import MPP file to my project. i have developed
importing part.
i hold project data in DB as AssignmentTimephasedByDay table in mpp file.
i connect mpp file via adodb (Provider=Microsoft.Project.OLEDB.11.0) and
read AssignmentTimephasedByDay table to read daily schedule of resource.
i hold data like: a resource will work on a task on specified date and
duration. as below

RESOURCEID TASKID DUEDATE DURATION(Hour)
---------------- ---------- ------------- --------------
R1 T1 2008-07-14 4
R1 T1 2008-07-15 8
R2 T1 2008-07-14 3

importing is no problem, i read AssignmentTimephasedByDay
BUT, exporting is problem, i use VS 2005 C# to develop my project. i tried
object model to create MPP file
but i could not assign TimePhased data to a task as in
AssignmentTimephasedByDay table

i can tell more about ways i tried.

thanks in advance for any help or leading

 

[Rod Gill]

Hi,

Firstly OLEDB for Project 2003 is read only so you can't write to a .mpp
file. Secondly OLEDB has gone for 2007 :-((

To update a project, use automation to open the project them import and
merge a csv or Excel file or update task by task. You will find VB easier
than C# for this as VB has better Intellisense help and has optional
parameters which makes your code much easier to read.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Cantekin GUNESER]

Thanks for help
i gues, i need to export my project information to csv or excel file
firstly, then open and import by MS project. if it is like this. can you
help me about finding how to import from excell file.
thanks again

 

[Jack Dahlgren]

I have several articles on reading and writing to Excel files using VBA here:

http://zo-d.com/blog/archives/programming.html

-Jack Dahlgren