To successfully import your data, the import file has to be in comma delimited ASCII file format.
In the table below, 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 |
2 |
100 |
A |
WBS Description |
3 |
20 |
A |
Alias |
4 |
20 |
A |
User-defined XREF1 |
5 |
20 |
A |
User-defined XREF2 |
6 |
20 |
A |
User-defined XREF3 |
7 |
20 |
A |
User-defined XREF4 |
8 |
20 |
A |
User-defined XREF5 |
9 |
20 |
A |
User-defined XREF6 |
10 |
20 |
A |
User-defined XREF7 |
11 |
20 |
A |
User-defined XREF8 |
12 |
20 |
A |
User-defined XREF9 |
13 |
20 |
A |
User-defined XREF10 |
14 |
20 |
A |
Manager |
15 |
20 |
A |
Charge Number |
16 |
10 |
A |
Performing Department |
17 |
10 |
A |
Responsible Department |
18 |
1 |
C/W/P/ |
Element Type |
19 |
1 |
A |
Earned Value Method. Use the following codes: 0: No EVM required A: Apportioned |
20 |
8 |
A |
CLIN |
21 |
1 |
R/N |
Recurring or non-recurring |
22 |
6 |
N |
Fee % |
23 |
9 |
N |
Fee Limit Amount |
24 |
1 |
H/P/B/ |
BCWP Base Unit:
|
25* |
40 |
A |
Parent WBS ID (enter * if top level) |
26 |
20 |
A |
Base WBS; used if EVM is Apportioned |
In this example, WBS 21-100 is updated, assuming it already exists in the WBS. The Manager becomes Bob, the EVM becomes 8, the CLIN becomes 002, the BCWP units becomes H(ours), and the Parent WBS is ignored. If the Parent WBS ID is not 2X, the WBS not be changed.
21-100,,,,,,,,,,,,,Bob,,,,,8,002,,,,H,2X,