• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Construction Viz

Construction Viz

Project Management Perfect

  • About
  • Features
  • Apps
  • Blog
  • Contact
  • Download Brochure
  • Get Started Today
  • Login
Show Search
Hide Search
smartsheet

No PMIS is an Island: Integrating Smartsheet and Construction Viz

August 17, 2022 Reporting

It is not uncommon for organizations to use many disparate web-based project management tools on a construction project. From real estate transactions, environmental assessments, and contract awards to project scheduling, the mix of software systems used across construction organizations can span many different departments and stakeholders.  The challenge is integrating these various solutions into a single view of the project and ensuring the aggregated data is accurate, reliable, and timely.

Smartsheet is one such project management tool we often encounter. Smartsheet is used across many industries and can be a data source and reporting solution for construction information. So it made sense for our team to integrate Smartsheet with Construction Viz to allow our clients using this tool to have the best features of both applications.

While Smartsheet has an API for integrating data, our goal was to build flexible integrated solutions to solve our clients’ unique data challenges. Construction Viz can leverage SQL and SharePoint as the back-end database – with the specifics of how this works depending on the selected apps, client data restrictions, and client-specific customizations. Our Smartsheet integration solution thus needed to be flexible and scalable while offering real-time connectivity to Smartsheet for both SQL and SharePoint.

We deploy our SQL integration solution as an Azure WebJob within an Azure web app. Utilizing Azure web apps as the execution platform enables easy scheduling, automatic restarts, guaranteed stability and uptime, built-in logging, performance tracking, and nearly infinite scalability. Our SharePoint integration solution utilizes industry-standard connectivity via SharePoint’s REST Service.

Intergration Examples

SQL Integration highlights

  • A customer needed a Two-way integration with Smartsheet, so both systems are always up to date.
  • Users can use schedule data created in Smartsheet in our Construction Viz Project Tracker and a custom performance metrics application, so data needed to flow seamlessly between both systems.
  • ConstViz application extensions allow the Customer to add and remove Smartsheet Links as needed for a no-code expansion of the integration scope to new projects.
  • Integration can be scheduled daily with refresh rates that can be adjusted as needed.
  • For troubleshooting any potential integration issues, we implemented user-managed error logs.

SharePoint Integration highlights

  • A customer needed a simple One-way integration with Construction Viz, which allows Smartsheet to access document libraries.
  • Ability to handle large daily data loads as Construction Viz program sites may include up to 6,000 projects.
  • An integration approach that overcomes Smartsheet API limitations:
    • The Smartsheet API limits automated file attachment uploads to 30MB
    • The SharePoint online attachment limitation is 250MB
    • We built a solution to log oversized files into Smartsheet in the appropriate locations and hyperlinks back to the original SharePoint files for retrieval via other methods

Smartsheet is one of many integrations into Construction Viz (SQL and SharePoint) that we have built. From Oracle P6 to Arc GIS, we understand the client’s need to centralize data to manage large-scale construction projects. You can find out more by requesting a consultation here.

Primary Sidebar

Join Our Newsletter

  • This field is for validation purposes and should be left unchanged.

Recent Posts

Construction Questionnaire Phase 2
Forms | June 5, 2025

Construction Viz Questionnaire Phase 2 and Beyond!

Construction Media File Blog
Media | May 15, 2025

Location, Location, Location: Add Location Data to Images and Video with Construction Viz

Customized Questionnaires for Construction
Forms | May 8, 2025

Customized Questionnaires Now Available in All Construction Viz Apps

Footer

About Constructon Viz

Construction Viz is a flexible construction project management software solution powered by Microsoft SharePoint and SQL.
Read More >

Navigation

  • Home
  • About
  • Features
  • Apps
  • Blog
  • Contact
  • Login

Apps

  • Construction Viz Hub
  • Cost Report
  • Drawing Management
  • File Manager
  • GIS Maps
  • Oracle Primavera 6
  • Payment
  • Specification Management

–

  • Project Forms
  • Project Planner
  • Project Scheduler
  • Project Tracker
  • Task Manager

Connect with Us

  • Sign up to receive helpful tips for construction project managers as well as updates about Construction Viz.

  • This field is for validation purposes and should be left unchanged.
Lydon Solutions

© Lydon Solutions

  • Privacy
  • Cookies
  • Terms of Use
  • Disclaimer
  • End-user license

Click here to start a Microsoft Teams chat.

Contact Us
Name(Required)
This field is for validation purposes and should be left unchanged.

Click here to start a Microsoft Teams chat.

Join Our Newsletter

Sign up to receive helpful tips for construction project managers as well as updates about Construction Viz.

  • This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
  • This field is for validation purposes and should be left unchanged.

Join Our Newsletter

Sign up to receive helpful tips for project managers and updates about Construction Viz.

Get Started