What importing an estimate does
Most projects get their figures from an Ensign estimate. You create the project first, then import the estimate's .zip file on the project's Project Dashboard. In one step, Project Commander sets up the project's cost codes, Buying List, budgets and Schedule of Rates from the file.
To import from an Excel spreadsheet instead, use the Import Wizard.
Before you start
- Create the project. See Creating a Project.
- Export the estimate from your Ensign estimating software as a
.zipfile. Upload it exactly as Ensign saved it — do not unzip it and zip it up again. - Check the file size. The file must be 10 MB or smaller.
- Check it is the right estimate. The Import a Project card is only on the dashboard until an estimate has been imported.
There is no separate permission for importing. Anyone who can open the project sees the Import a Project card until an estimate or a spreadsheet schedule of rates has been imported.
Importing the estimate
- 1
From the sidebar, click Projects.
- 2
Click the project to open it. The Project Dashboard opens.
- 3
Find the Import a Project card below Project Information.
- 4
Drag your
.zipfile onto the box that reads Drop an Ensign Estimate (.zip) or Spreadsheet (.xlsx, .csv) here, or click the box to choose the file. - 5
Wait while Reading Bill Labels... Please wait shows.
- 6
If Select a Bill Label appears, choose the bill you want to import. The first bill is already selected.
- 7
Click Upload Ensign Estimate.
Bill labels
An Ensign job can hold more than one bill, and each bill has a label. When the file has bill labels, you choose one bill to import. The project's Schedule of Rates is built from the lines in that bill.
If the file has no bill labels, the card says No bill labels found in this file. All sections will be imported.
To use a different file, click Remove next to the file name, then drop the new file.
Importing a file sent from Ensign
Your Ensign estimating software can send an estimate straight to Project Commander. Files sent this way appear in an Uploaded Files list beside the Import a Project card. Each file is named after the job code and job name, and the newest is at the top.
- 1
Type part of the file name in Search for a file... to find it.
- 2
Click Import next to the file. The file loads into the Import a Project card.
- 3
If Select a Bill Label appears, choose the bill you want to import.
- 4
Click Upload Ensign Estimate.
The Uploaded Files list shows every estimate sent from Ensign for your company, not just the ones for this project. Check the job code and name before you click Import.
While the import runs
The import runs in the background. The card shows Importing Project..., a progress bar with a percentage, and a line saying which step it is on — for example Importing Cost Codes..., Importing Buying List... or Importing Schedule of Rates.
How long it takes depends on the size of the estimate. Imports are processed in turn. If others are already running, yours waits and the card shows Import queued, waiting to start...
The progress bar only shows while you stay on the page. If you leave, the import carries on. Come back later and refresh the Project Dashboard — once the import has finished, the Import a Project card has gone and the figures appear. Wait for it to finish rather than uploading the file again.
When the import finishes
If it works:
- The card shows Import Complete, and the message Project details imported successfully. appears.
- The page refreshes and the Import a Project card disappears.
- The Project Dashboard now shows its headline cards, summary table and charts. See The Project Dashboard.
If it fails:
- The card shows Import Failed, the progress bar turns red, and the reason appears in a red box below it.
- The message Error importing project details. appears with the same reason.
- Note the reason, then contact Ensign support before you try again.
What the import creates
| What | Where you see it |
|---|---|
Cost codes — every cost code in the estimate, plus Project Commander's standard cost codes, such as SYS000 Unassigned, SYS006 Preliminaries, L0002 Site Labour and PLANT0001 Plant Hire | The Budgets page and the Cost Code lists across the project |
| Buying List — the items to buy, each with its cost code, quantity and costs | Budgets → View Buying List |
| Cost-code budgets — each cost code's budget from the estimate | The Estimate column on the Budgets page |
| Labour — the estimate's site and shop labour | The Labour row on the Budgets page. Expand it to see Site Labour and Shop Labour. |
| Schedule of Rates — the priced lines of the estimate, in its sections | Budgets → View Schedule of Rates |
| Estimate Value — the total of the imported Schedule of Rates. It replaces the project's Order Value. | The Project Information card on the Project Dashboard |
Provisional sum, prime cost and preliminaries lines in the estimate go on their own standard cost codes: SYS004 Provisional Sums, SYS003 Provisional Sums & Prime Costs and SYS006 Preliminaries.
MCD percentage
If the estimate includes a builder's discount, the import sets the project's MCD Percentage to match it. For example, a builder's discount of 1/39th becomes 2.5%. If the estimate has no builder's discount, the MCD Percentage is left as it was.
What to check afterwards
- Estimate Value — on the Project Information card, check it is the figure you expect for this estimate or bill.
- MCD Percentage — click Update Project on the Project Dashboard and check it, in case the import changed it.
- Budgets — click Budgets in the project sidebar and check each cost code has the budget you expect in the Estimate column.
- Unassigned — on the Budgets page, the
SYS000Unassigned row is always shown. If it has a budget, some lines in the estimate have no cost code, or use one that is not in the estimate's cost code list. To see them, click View Buying List and set the Cost Code filter to SYS000 - Unassigned. - Schedule of Rates — click View Schedule of Rates and check the sections and lines are all there.
Common issues
"This file type is not supported"
You clicked the box and chose a file that is not a .zip, .xlsx or .xls file. Choose the .zip file exported from Ensign.
"Error checking bill labels. Please reupload the file."
Project Commander could not read the file. Every Ensign estimate export holds three files — CostCodeDescriptions.xml, CostCodeBudgets.xml and Edited.xml — at the top level of the zip, not inside a folder. This message appears if the file is not an Ensign estimate export, if one of those files is missing, or if the zip has been unzipped and zipped up again.
Click Remove, export the estimate from Ensign again, and drop the new file.
"Error importing Project details."
The file was refused before the import started. Check the file is 10 MB or smaller.
The Import a Project card is not on the dashboard
The card only shows until an estimate, or a schedule of rates from the Import Wizard, has been imported into the project.
Next steps
- The Project Dashboard — see the project's headline cards, summary table and charts once the estimate is in.
- Budgets — check each cost code's budget from the estimate.
- Schedule of Rates — browse the priced lines you imported.
- Import Wizard — import a project's estimate from an Excel spreadsheet instead.
- Creating a Project — set up the project before you import its estimate.