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* |
6/8 |
A |
Status Date; date may be entered in year/month format or year/month/day format. If year/month format is used, date defaults to last day of fiscal month. (The full date is used only to set the last status tick mark on barcharts.). The YYMMDD date format is not a valid format for BCWP Import.Valid Date Formats: See Creating Import Files for details. |
|
3* |
6 |
N |
Cumulative Percent Complete; must be expressed in percent format (i.e., 50.50% = 50.50). |
|
4* |
12 |
N |
Cumulative BCWP Amount; value must be expressed in the base unit specified for the WBS in Plan Milestones Function. |
The WBS ID, Status Date, and Cum Percent Complete fields are mandatory when importing to WBS elements which use the Percent Complete EVM.
The WBS ID, Status Date, and Cum BCWP fields are mandatory when importing to WBS elements which use Earned Standards or BCWP Entry EVM.
Each record must contain three commas, one after each field except the last field (even those being left blank), and end with a carriage return.
This record updates WBS 1X using Percent Complete EVM 50.50%, as of the status date March 31, 2008. Since the full date was used, the last status tick mark on barcharts is set also.
1X,20080331,50.50,
This record updates WBS 1X using BCWP Entry EVM; as of the status date March, 2008, $15,175.50 of BCWP have been earned.
1X,200803,,15175.50