Project MPX file Problem

[jsulman]

Greetings
I am using the mpjx api (

http://mpxj.sourceforge.net)

to generate an MPX file from a report and import it as am MPP file. The report has a number of columns that are not the default Project display columns. For example I have an Actual Amount that I am adding to the a task. After I generate the file and import it. I right click on the column headers and pick Insert Column… from the menu. I then pick Actual Cost for the field name and give it my title. However, when it appears in Project all the values are zero. I looked at the MPX file and it seems to have all the information needed.

Everything works OK for the columns that are in the default project file, like start and finish. It only happens to new columns/fields.

I have included the MPX file. You can see the header for the Actual Cost and the values as well ($127391.00,$149.00 … ). However they will appear.

Does anybody have any ideas?

Thank you in advance

Jeff Sulman


MPX File
---------------------------------------------------------------
MPX,Microsoft Project for Windows,4.0,ANSI
10,$,1,2,",",.
11,2,0,1,8.00,40.00,$10.00/h,$15.00/h,1,0
12,1,0,480,/,:,am,pm,20,20
30,Project1,,,Standard,01/01/1990,,0,12/08/2005,,$0.00,$0.00,$0.00,0h,0h,0h,0%,0d,0d,0d,0%,,,,,0d,0d
20,Standard,0,1,1,1,1,1,0
25,1
25,2,08:00 AM,12:00 PM,01:00 PM,05:00 PM
25,3,08:00 AM,12:00 PM,01:00 PM,05:00 PM
25,4,08:00 AM,12:00 PM,01:00 PM,05:00 PM
25,5,08:00 AM,12:00 PM,01:00 PM,05:00 PM
25,6,08:00 AM,12:00 PM,01:00 PM,05:00 PM
25,7
60,WBS,Outline Number,Outline Level,Unique ID,ID,Name,Summary,Actual Start,Actual Finish,Actual Cost
61,2,99,3,98,90,1,120,58,59,32
70,1.0,1.0,0,1,1,Region 6 Superfund Sites,Yes
70,1.1,1.1,1,2,2,Currently on the Final NPL,Yes
70,1.1.1,1.1.1,2,3,3,EPA Fund-Financed,Yes
70,1.1.1.1,1.1.1.1,3,4,4,Removal,Yes
70,1.1.1.1.1,1.1.1.1.1,4,5,5,AGRICULTURE STREET LANDFILL,Yes
70,1.1.1.1.1.1,1.1.1.1.1.1,5,6,6,00,Yes
70,1.1.1.1.1.1.1,1.1.1.1.1.1.1,6,7,7,2000,Yes
70,1.1.1.1.1.1.1.1,1.1.1.1.1.1.1.1,7,8,8,REMOVAL,Yes
70,1.1.1.1.1.1.1.1.1,1.1.1.1.1.1.1.1.1,8,9,9,Deobligation,,30/09/1995,30/09/1995,$127391.00
70,1.1.1.1.1.1.1.1.2,1.1.1.1.1.1.1.1.2,8,10,10,Extramural Outlay (Payment),,30/09/1995,30/09/1995,$127391.00
70,1.1.2,1.1.2,2,11,11,"State, Fund Financed",Yes
70,1.1.2.1,1.1.2.1,3,12,12,Pipeline Operations,Yes
70,1.1.2.1.1,1.1.2.1.1,4,13,13,OKLAHOMA REFINING CO.,Yes
70,1.1.2.1.1.1,1.1.2.1.1.1,5,14,14,01,Yes
70,1.1.2.1.1.1.1,1.1.2.1.1.1.1,6,15,15,2000,Yes
70,1.1.2.1.1.1.1.1,1.1.2.1.1.1.1.1,7,16,16,STATE SUPPORT AGENCY COOP AGREEMENT,Yes
70,1.1.2.1.1.1.1.1.1,1.1.2.1.1.1.1.1.1,8,17,17,Deobligation,,20/09/1993,31/12/2009,$149.00
70,1.1.2.1.1.1.1.1.2,1.1.2.1.1.1.1.1.2,8,18,18,Extramural Outlay (Payment),,20/09/1993,31/12/2009,$149.00
70,1.2,1.2,1,19,19,Pre-proposal Site,Yes
70,1.2.1,1.2.1,2,20,20,EPA Fund-Financed,Yes
70,1.2.1.1,1.2.1.1,3,21,21,Pipeline Operations,Yes
70,1.2.1.1.1,1.2.1.1.1,4,22,22,CALCASIEU ESTUARY,Yes
70,1.2.1.1.1.1,1.2.1.1.1.1,5,23,23,00,Yes
70,1.2.1.1.1.1.1,1.2.1.1.1.1.1,6,24,24,2000,Yes
70,1.2.1.1.1.1.1.1,1.2.1.1.1.1.1.1,7,25,25,BULK FUNDING,Yes
70,1.2.1.1.1.1.1.1.1,1.2.1.1.1.1.1.1.1,8,26,26,Deobligation,,,,$60733.00
70,1.2.1.1.1.1.1.1.2,1.2.1.1.1.1.1.1.2,8,27,27,Extramural Outlay (Payment),,,,$60733.00
70,1.2.1.1.1.2,1.2.1.1.1.2,5,28,28,01,Yes
70,1.2.1.1.1.2.1,1.2.1.1.1.2.1,6,29,29,2000,Yes
70,1.2.1.1.1.2.1.1,1.2.1.1.1.2.1.1,7,30,30,COMMUNITY INVOLVEMENT,Yes
70,1.2.1.1.1.2.1.1.1,1.2.1.1.1.2.1.1.1,8,31,31,Deobligation,,01/02/1998,30/09/2006,$11080.00
70,1.2.1.1.1.2.1.1.2,1.2.1.1.1.2.1.1.2,8,32,32,Extramural Outlay (Payment),,01/02/1998,30/09/2006,$11080.00

 

[PDQBach]

Actual Cost is a derived amount and is calculated based on several figures ((rate * actualwork) + (OTrate * OTactualwork) + FixedTaskCost + FixedResourceCost).

I *think* it is regenerated on the fly when actual work is entered.

If you want to have your own cost then then use something like Cost1.

 

[jsulman]

PDQBach,
Thanks for the help that worked fine. The problem is that my knowledge if Project is limited.

Thanks alot!!!

Jeff Sulman