To successfully import your data, the import file has be in comma delimited ASCII file format.
In the table that follows, an * indicates a required field.
In the Type column:
A = alphanumeric
N = numeric
Y/N = Yes or No
For more information on the table, see Import File Formats Legend.
Field Position |
No. of Chars |
Type |
Field Content |
1* |
40 |
A |
WBS ID; must exist in the project |
2* |
10 |
A |
Resource Code or *EOC Code; must exist in Resource Library but need not exist as an estimate for this WBS. If importing EOC Codes, you must precede the EOC Code with an asterisk. |
3 |
10 |
A |
Resource Department; must exist in OBS (leave blank if import is by EOC Code) |
4 |
1 |
Y/N |
Overtime Factor Enter Y or a valid numeric value if the imported actual data is overtime. This value will be changed to 1.5 upon import and will display as such on reports. Enter N if the imported actual data is not O/T; appears as blank on reports. |
5* |
6 |
N |
Month/Year (YYYYMM) |
6 |
12 |
N |
Hours/Units |
7 |
12 |
N |
Prime dollars |
8 |
12 |
N |
Overhead dollars |
9 |
12 |
N |
G&A dollars |
10 |
12 |
N |
Cost of money dollars |
11 |
12 |
N |
Fee |
12 |
20 |
A |
XREF-EST |
*XREF-EST Field — The XREF-EST import field is an optional field that can be used to make the Actuals record unique.
MPM considers records as duplicates if they have the same values for the following fields:
Period
WBS ID
Resource Code
Resource Department
XREF-EST
Overtime
Using the optional XREF-EST field — each record must contain 11 commas, one after each field except the last field (even those being left blank), and end with a carriage return.
Not using the optional XREF-EST field — each record must contain 10 commas, one after each field except the last field (even those being left blank), and end with a carriage return.
This record imports Actuals into WBS element AA for Resource ENG1 from Dept 200, for the month of January 2008. The values being imported are not overtime values. The Resource worked 200 hours, which was calculated as 30000 Prime, and burdened as 10000 OH, 500 G&A, 100 COM and 1500 Fee.
AA,ENG1,200,N,200801,200,30000,10000,500,100,1500
This record imports Actuals into WBS element AA for EOC Labor, for the month of January 2008. Remember you must add an asterisk if this is an EOC Code. The values being imported are not overtime values, and EOC cannot be autoburdened. LABOR totaled 800 hours, which was calculated as 120000 Prime, and burdened as 40000 OH, 2000 G&A, 400 COM and 6000 Fee.
AA,*L,,N,200801,800,120000,40000,2000,400,6000