How to get custom field values for tasks using PDS

[Burki]

Hi all

When we define a Custom Field using MS Project Professional with a
formula then it becomes necessary to update that column in the Project
Plan. Also we are unabe to find a PDS API method/function which return
that Custom Field for a specific project. For example if we define a
Custom Field "Enterprise Baseline Cost" with formula "[Baseline Cost]"
then we cannot access it for a specific project using PDS API
method/function.



Also we need to verify the formula which we are using to get the Tasks
Starting Late.

Formula:

IIf([% Work Complete]="0%" And [Start]>[Current Date] And [Actual
Start]=ProjDateValue("NA"),"Starting Late","On Schedule")

Best Regards
Burki

 

[Earl Lewis]

Burki,

The PDS API reference specifically states that to update task level enterprise custom fields requires a PDS extension. Meaning, it's not a built-in API method. It also refers to the SAP Connector solution starter, which is example code for a PDS extension, as a place to see how you might do this. You can download the PDS solution starters from the M$ website. Hope that helps.

Earl
Hi all

When we define a Custom Field using MS Project Professional with a
formula then it becomes necessary to update that column in the Project
Plan. Also we are unabe to find a PDS API method/function which return
that Custom Field for a specific project. For example if we define a
Custom Field "Enterprise Baseline Cost" with formula "[Baseline Cost]"
then we cannot access it for a specific project using PDS API
method/function.



Also we need to verify the formula which we are using to get the Tasks
Starting Late.

Formula:

IIf([% Work Complete]="0%" And [Start]>[Current Date] And [Actual
Start]=ProjDateValue("NA"),"Starting Late","On Schedule")

Best Regards
Burki

 

[Jerry]

Earl,

I have the same issue. Here is the scanario

1. I need to Create Enterpirse Custom Feilds in Project Professional
with formulas. These formulas are simple Field values e.g [Actual
Cost] in Enterprize Text Field in Enterpize Global. (For Reference i
need to Collect all the Fields that are available in Earned Value View
in Project Web Access - Project Center Views)
2. I need to collect these Enterprize Custom fields using PDS API.
These fields will represent data for a specific project.
3. After Collecting these Fields i wanted to do Earned Value analysis

Here are the problems
1. No PDS API Method is available to collect values from enterprize
custom fields. (VIP)
2. Another problem is that after creating an enterprize field i have to
manually edit the field in Project professional to update the values of
the fields defined in enterprize Global. (Why it is not updating the
value automatically).

Thanks and Regards,
Jerry

Burki,

The PDS API reference specifically states that to update task level

enterprise custom fields requires a PDS extension. Meaning, it's not a
built-in API method. It also refers to the SAP Connector solution
starter, which is example code for a PDS extension, as a place to see
how you might do this. You can download the PDS solution starters from
the M$ website. Hope that helps.

Earl
Hi all

When we define a Custom Field using MS Project Professional with a
formula then it becomes necessary to update that column in the Project
Plan. Also we are unabe to find a PDS API method/function which return
that Custom Field for a specific project. For example if we define a
Custom Field "Enterprise Baseline Cost" with formula "[Baseline Cost]"
then we cannot access it for a specific project using PDS API
method/function.



Also we need to verify the formula which we are using to get the Tasks
Starting Late.

Formula:

IIf([% Work Complete]="0%" And [Start]>[Current Date] And [Actual
Start]=ProjDateValue("NA"),"Starting Late","On Schedule")

Best Regards
Burki

 

[Earl Lewis]

Jerry and Burki,

Look at the code in the SAPFIPDSExtender.cs file in the samples I mentioned in the earlier post. This should give you a place to start.

Earl
Earl,

I have the same issue. Here is the scanario

1. I need to Create Enterpirse Custom Feilds in Project Professional
with formulas. These formulas are simple Field values e.g [Actual
Cost] in Enterprize Text Field in Enterpize Global. (For Reference i
need to Collect all the Fields that are available in Earned Value View
in Project Web Access - Project Center Views)
2. I need to collect these Enterprize Custom fields using PDS API.
These fields will represent data for a specific project.
3. After Collecting these Fields i wanted to do Earned Value analysis

Here are the problems
1. No PDS API Method is available to collect values from enterprize
custom fields. (VIP)
2. Another problem is that after creating an enterprize field i have to
manually edit the field in Project professional to update the values of
the fields defined in enterprize Global. (Why it is not updating the
value automatically).

Thanks and Regards,
Jerry

Burki,

The PDS API reference specifically states that to update task level

enterprise custom fields requires a PDS extension. Meaning, it's not a
built-in API method. It also refers to the SAP Connector solution
starter, which is example code for a PDS extension, as a place to see
how you might do this. You can download the PDS solution starters from
the M$ website. Hope that helps.

Earl
Hi all

When we define a Custom Field using MS Project Professional with a
formula then it becomes necessary to update that column in the Project
Plan. Also we are unabe to find a PDS API method/function which return
that Custom Field for a specific project. For example if we define a
Custom Field "Enterprise Baseline Cost" with formula "[Baseline Cost]"
then we cannot access it for a specific project using PDS API
method/function.



Also we need to verify the formula which we are using to get the Tasks
Starting Late.

Formula:

IIf([% Work Complete]="0%" And [Start]>[Current Date] And [Actual
Start]=ProjDateValue("NA"),"Starting Late","On Schedule")

Best Regards
Burki

 

[Jerry Yasir]

Earl,

Thanks. I found the code and its working. SAP Connector solution
starter is available at Microsoft .com and contains the code to get the
custom outlinfe fields from PWA. Thank you very much

Regards
Jerry