Third party Integration - How to Map Fields in MS Project?

[Sharjeel]

We have a Basic Task management system, with task id, description, work,
planned & actual dates. We want to synchronize this with MS Project. I am
able to map most of System's fields with MS Project.
The problem comes when i am trying to update 'Actual Start/Finish/Work'
fields. Instead of updating those fields it actually updates
'Start/Finish/Work' fields.

When i do it manually it updates both ( that is fine as I have set the
Baseline ).
But programmatically i am not able to achieve the same.

Any help would be appreciated..

 

[JulieS]

Hello Sharjeel,

Are you mapping your data to the Actual Start fields or the Start
fields in the map? As you note, when updating Actual Start and
Actual Finish, the Start and Finish fields will change to match the
Actual dates. Are you saying that when you update Actual Start you
are not seeing the Actual Start value stay in Project?

Give us a bit more information about your map definition and we'll
try to be more helpful. Please also let us know what version of
Project (2003? 2007?) including service pack you are using.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project


..

 

[Sharjeel]

Hello Julie,

Thanks for the response. Well I am using MS Project Professional 2007.
The idea is to create a project plan in ms project & push this data to System.
And after that pull the Actual info from System & update ms project file.
I am sending the Baseline data as planned data to System
And setting Actual data of MS Project by reading from System.

I am facing problem in setting actual data in MS Project.
When i update ActualStart, it somehow updates Start & ActualStart remains
blank.

Regards,
Sharjeel

 

[JulieS]

Hello Sharjeel,

Thanks for the information that you are using Project 2007. What
service pack have you applied? Are you using Project Server or just
Project Professional. When you note you are pulling information
from the System is it coming as an excel file, and xml file, or what
file format?

Let us know more details about specifically what you are doing --
how are you pulling the data? How are you updating project?

Julie

 

[Sharjeel]

Hello Julie,

I am using stand alone MS Project Professional 2007.
I have written a COM addin using VS 2005, which interacts between MS Project
& System to synchronize the data programmetically.

///SAMPLE CODE ///
task.ActualStart = action.ActualStartDate.Value;
task.ActualFinish = action.ActualEndDate.Value;
task.ActualWork = action.TakenHrs * 60;
//////

Let me know if any more information is required

 

[JulieS]

Thanks Sharjeel, the additional information is very helpful. Now,
at the very least, I can direct you to a more appropriate newsgroup.
I am not at all adept at programming, so I'm going to suggest you
re-post this thread to Project Developer newsgroup. It looks like
you may be posting through the web interface -- you should find a
listing for Developer on the left pane grouped under Microsoft
Project. If you are posting through a newsreader, post to
Microsoft.Public.Project.Developer

I've set follow-up to that newsgroup, so I believe if you reply to
this post, it will automatically post the thread to the correct
newsgroup.

Julie

 

[Jack Dahlgren]

That isn't enough information to determine what is going on here.
Can you post a bit more of the code?
It could have a number of different causes including the datatypes or the
values you are passing. Do you have some example data?
Another cause could be settings in project or the way assignments are made.

-Jack Dahlgren

 

[JulieS]

Thanks for jumping in Jack - Julie

That isn't enough information to determine what is going on here.
Can you post a bit more of the code?
It could have a number of different causes including the datatypes
or the
values you are passing. Do you have some example data?
Another cause could be settings in project or the way assignments
are made.

-Jack Dahlgren

 

[Sharjeel]

We have a Basic Task management System, with task id, description, work,
planned & actual dates.
I want to synchronize this with MS Project Professional 2007.

The idea is to create a project plan in ms project & push this data to
System.
And after that pull the Actual info from System & update ms project file.

I am sending the Baseline data as planned data to System & setting Actual
data of MS Project by reading from System.

I am able to map most of System's fields with MS Project.
The problem comes when i am trying to update 'Actual Start/Finish/Work'
fields. Instead of updating those fields it actually updates
'Start/Finish/Work' fields.

When i do it manually it updates both ( that is fine as I have set the
Baseline ). But programmatically i am not able to achieve the same.

About the program to do this sync
I have written a COM addin using VS 2005, which interacts between MS Project
& System to synchronize the data programmetically.

////// ////// SAMPLE CODE ////// //////
foreach (MSProject.Task task in project.Tasks)
{
if (task.EnterpriseText10 != null)
{
string key = task.EnterpriseText10.Trim();
Action action = new Action();
action.Key = key;
action.Nr = (decimal)task.Number10;
action.Descr = task.Name;
action.PlannedStartDate = (DateTime)task.BaselineStart;
action.PlannedEndDate = (DateTime)task.BaselineFinish;
action.AllottedHrs = (decimal)((double)task.BaselineWork) / 60;
action.Resources = new
List<Resource>(ResourceSync.GetResources(task.Resources).Values);

UpdateItem(ref action);

task.ActualStart = action.ActualStartDate.Value;
task.ActualFinish = action.ActualEndDate.Value;
task.ActualWork = action.TakenHrs * 60;
}
}
////// ////// ////// //////

 

[Sharjeel]

Hello Jack,

I have reposted the query with complete code in Project Developer newsgroup

 

[Sharjeel]

We have a Basic Task management System, with task id, description, work,
planned & actual dates.
I want to synchronize this with MS Project Professional 2007.

The idea is to create a project plan in ms project & push this
data to System.
And after that pull the Actual info from System & update ms
project file.

I am sending the Baseline data as planned data to System & setting
Actual data of MS Project by reading from System.

I am able to map most of System's fields with MS Project.
The problem comes when i am trying to update 'Actual
Start/Finish/Work'
fields. Instead of updating those fields it actually updates
'Start/Finish/Work' fields.

When i do it manually it updates both ( that is fine as I have set
the Baseline ).
But programmatically i am not able to achieve the same.

About the program to do this sync
I have written a COM addin using VS 2005, which interacts between
MS Project & System to synchronize the data programmetically.

////// ////// SAMPLE CODE ////// //////
foreach (MSProject.Task task in project.Tasks)
{
if (task.EnterpriseText10 != null)
{
string key = task.EnterpriseText10.Trim();
Action action = new Action();
action.Key = key;
action.Nr = (decimal)task.Number10;
action.Descr = task.Name;
action.PlannedStartDate = (DateTime)task.BaselineStart;
action.PlannedEndDate = (DateTime)task.BaselineFinish;
action.AllottedHrs = (decimal)((double)task.BaselineWork) /
60;
action.Resources = new
List<Resource(ResourceSync.GetResources(task.Resources).Values);

UpdateItem(ref action);

task.ActualStart = action.ActualStartDate.Value;
task.ActualFinish = action.ActualEndDate.Value;
task.ActualWork = action.TakenHrs * 60;
}
}
////// ////// ////// //////