Table of Contents
Purpose
On Center has been a trusted provider of construction automation management (CAM) solutions. If you use On Center to manage your takeoffs and help with estimating, that’s great! Did you know that you can export data collected from On Center into Aspire?
Let’s learn more about it!
Requirements
✅In order to import Estimates in Aspire, you’ll need to have Import Estimate added to your User Role or have System Admin permission added to your User Role.
Setting Up On Center to Export Data
Before you are able to import your data from On Center into Aspire, you’ll need to set up your export in the On Center platform.
📌Note: Your Column Groupings have to be configured in a certain way for the export to be in the correct format for Aspire, so follow these steps closely!
Click the Takeoff tab at the top of the screen:
Then, add Group By Area, Group By Zone and Group By Page to start organizing your data export.
Creating your Export File From On Center
Instead of using the Export option, you’ll need to use the Print Preview option instead!
Click the Print Preview button in the toolbar:
The Print Preview window will appear.
In this window, you will have the option to choose an Export Option.
Click the Export button.
The Export window will appear. Verify that your format is selected for Separated Values (CSV).
Once this Format is used, then you can click OK to finish your export!
The file will autosave to your Downloads folder on your computer.
Once this file is saved to your computer, you can then log in to Aspire and import your data file.
Importing Your On Center Data Into Aspire
Once you have exported your data from On Center,you’ll need to import it into Aspire.
🧠 In addition to importing On Center data files you can also import files from Microsoft Excel or other estimating tools.
To start an Estimate Import, you’ll need to navigate to the Opportunities module.
Select an Opportunity from the Opportunities list that you want to have data imported.
The Opportunity you are importing data for needs to be in a status of Bidding.
Then, select the Estimate tab from an opportunity.
Click on the three dot menu.
Choose Import from the list.
The Import window will appear.
Click the Import Type dropdown and select On-Center from the list.
Then, select the Upload button.
Your computer browser Downloads window will open. Select the Import file you exported from On Center.
Then, press Open to finish adding your file into Aspire.
You can see in the example below that the file was attached to the Import file window.
To finish importing your On Center data into your Estimate, click Import.