Import Cost Data from Both Deltek Cobra and Work Authorization Docs (WAD)
Use the Cost Data Import wizard to import cost data from both a Deltek Cobra data file and Work Authorization Documents (WAD).
To import cost data from a Deltek Cobra data file and work authorization documents (WAD), complete the following steps:
- Export the Deltek Cobra data file from Cobra (see the Cobra help for instructions).
-
On the S1 // Projects tab, do one of the following:
- In the Projects pane, right-click on the project and select Import Cost Data.
- In the Get External Data From menu group, click Deltek Cobra and click Cost Data.
- On the first page of the Cost Data Import wizard, select Import both Cobra and WAD data and click Next.
- Browse to and select a cost data file. The file that you import must have a .dcde extension.
- Select the cost project that you want to import and click Next.
-
Select the WBS, OBS, Work Package, and Control Account fields that map to the cost data.
- WBS/OBS — Select the fields that map to the cost data.
- Use WBS and OBS as Control Account Keys — If this check box is selected, the activity maps to a work package if the Work Package, WBS, and OBS fields all match. If the check box is not selected, the activity maps to a work package if the Work Package fields match, and the control account key fields match to the control account ID.
- Work Package — Select the field that maps to the cost data.
- Control Account — Select the field that maps to the cost data.
- Click Next.
- Browse to and select the work authorization document and click Next. The file that you import must have a .xls or .xlsx extension.
- Select the worksheet that contains the WAD information.
- Select the WAD column that matches the cost project control account ID and click Finish.
Acumen imports the cost data. The import progress displays at the bottom of the window.