To successfully import your data, the import file has be in comma delimited ASCII file format.
The first record (row) must contain three commas; in subsequent rows, commas are ignored. Each BOE imported can contain up to 102 records (rows).
In the Type column:
A = alphanumeric
N = numeric
Y/N = Yes or No
For more information on the table, see Import File Formats Legend.
The first record must be formatted as follows:
|
Field Position |
No. of Chars |
Type |
Field Content |
|
1* |
40 |
A |
WBS ID; must exist in the project |
|
2* |
2 |
A |
Enter an asterisk (*) to include all EOCs; enter specific EOC after the asterisk to limit import to one EOC. The EOC entered must already exist in the Resource Library. |
|
3 |
10 |
A |
Enter a specific Resource Department to include BOEs for one department. The Department entered must already exist in the OBS. Enter an asterisk to include BOEs for all departments. If the field is left blank, the report will include all BOEs that have no Resource Department defined. To include BOEs for a specific group of departments, enter a wildcard of up to nine match characters plus an asterisk. For example, enter LA* and your report will include summary BOEs for all departments that begin with LA. |
In the table above, an * indicates a required field.
Up to 100 records (rows) of BOE text for that WBS must be formatted as follows:
|
Field Position |
No. of Chars |
Type |
Field Content |
|
N/A |
78 |
A |
BOE text. Text may be in upper- or lowercase. More than 100 rows or 78 characters on one line will be truncated. |
The last record, signifying the end of the data, must contain a single asterisk:
|
Field Position |
No. of Chars |
Type |
Field Content |
|
1 |
1 |
A |
* |
This text becomes the Summary BOE for WBS 21-100, limited to Labor EOCs for Department 2000.
21-100,*L,2000
The Design Detail portion of designing the X20 prototype is subcontracted to McAfee & Co.,
who are providing estimates based on available resources in the Waco, Texas branch office. *