Excel add in for Sage Construction Management

The Microsoft Excel add in has been implemented to export job cost information to Microsoft Excel through the Sage Construction Management Open API. This add in requires the Open API option, which is free for firms using Sage Construction Management Max Employee License Plans, but has an additional fee for firms with individual licenses.

After the add in has been installed and set up, the user will be able to select one or more projects, a Financial API (V1, V2, or V3), and a target Excel sheet. Job cost information will then be exported to the target sheet and cell. All fields retrieved from the API will be populated in Excel.

Requirements

• Windows 10 or higher operating system.
• Internet ports open: 80 (http://) and 443 (https://).
• Microsoft Excel 2016 or higher.
• Access to the Sage Construction Management Open API:
  • Standard (50 Calls/Day and Max 10 Calls/Minute): Free with all license plans
  • Enterprise (1000 Calls / Day and Max 30 Calls/Minute)

Training videos

For more details see the Sage Construction Management training.

Generate the account ID, client ID, and secret key for the API connection

1. Log in to Sage Construction Management as an admin.
2. Go to Seetings () and select Developer Mode.
   
3. If Developer Mode is disabled, select Yes next to the Do you wish to use developer mode? option and select Save.
4. In the My Account Information section, copy the following information:
   • Account Key
   • Integration Key / Client Id
   • Account Base URI

   

   These credentials are required to connect the Excel Add-in to your account and retrieve financial data via the Open API. The client ID is valid for the entire organization and gives full admin access.

5. In the Api Key(s) tab, select Add New Apps & Keys.
6. In the App Name field, enter Sage Construction Management Excel Addin.
7. In the Features section, select the Project Financial option only.
8. In the Authentication section, select the Client Credentials type and copy the secret key.

   The secret key is valid for the entire organization and gives full admin access.

9. In the Scopes section, select the Read option only.
10. In the Additional settings section, do the following:
    1. In the Redirect URIs field, enter corecon.com.
    2. In the State field, enter test.
    3. In the Refresh Token LifeTime (in mins) field, enter 30.
    4. In the Allowed Origins field, enter corecon.com.
11. Select Save.

Install and configure the Microsoft Excel add-in

1. Make sure that Microsoft Excel is closed.
2. Select here to download the Sage Construction Management Excel add-in.
3. If installation does not start automatically, go to your downloads folder and open the setup.exe file.
4. Open Microsoft Excel and create a new Excel file.
5. Select the Add-ins tab.
6. Select Sign In.
   
7. In the dialog, enter the following information that you copied from Sage Construction Management:
   1. In the Base URL field, enter the account base URI.
   2. In the Account ID field, enter the account key.
   3. In the Client ID field, enter the integration key / client ID.
   4. In the Secret Key field, enter the secret key.
   5. Select Save Keys and Submit.
      

   After successfully accessing the API, a Sign Out option displays on the Sage Construction Management Connect add-in.

8. Select Project Financial.
9. In the dialog, do the following:
   1. Select the Sage Construction Management API in the API Name dropdown.
      
   2. Optionally, select the Project Status to filter the project listing.

      For example, All, Active Only, or Archived Only.

   3. Optionally, enter text in the Project field to filter the project listing.
   4. Select one or more projects from the list.
   5. Optionally, select the Start and End Date for transaction filters.
   6. Select Fetch Data.

   7. Select the target Sheet Name in the dropdown and enter the Cell Number.

      This is where the financial data will be populated.

   8. Select OK.