Construction Viz

Project Management Perfect

Reporting

Construction Viz PDF Report Wizard 2.0

Construction Viz, Forms, Reporting |

Printing off a construction form such as an RFI and easily including all of the attachments is a great feature of any construction management system. With the latest update to Construction Viz, find out how we take our PDF Report Wizard feature a step further.

Construction Viz includes a PDF Report Wizard feature where users can generate a PDF binder from a form while providing the ability to add its attachments. The easy-to-follow wizard walks the user through selecting which attachments to include, the order in which they print, and providing a name for the generated PDF binder. Construction Viz automatically converts the form and any Microsoft Office attachments and images to PDF and then merges them into a PDF binder upon execution.

The Construction Viz PDF Report Wizard feature is excellent for printing one or more forms and then emailing them off to a contractor or archiving project documents.

What’s New in Construction Viz PDF Report Wizard 2.0

Construction Viz - PDF Report Wizard 2.0 -screenshot 1

In our latest update, we added a new report builder to the settings so you can create custom form reports and set default reports for your instance of Construction Viz. The new form report setting includes the ability to:

  • Create one or more reports for each form app and profile with a custom name.
  • Select which form components to include in a report.
  • Select whether to print components that contain no data.
  • Set a report as the default so it is automatically selected when you click print.
Construction Viz - PDF Report Wizard 2.0 - screenshot 2

While Construction Viz utilizes reporting via Power BI for the heavy lifting, the PDF Report Wizard is a simple tool to generate form-specific reports and attachments quickly. This new feature was a requested enhancement that provides even more flexibility to system users.

If you are looking to utilize Microsoft 365 SharePoint Online to manage your projects, check out Construction Viz for an enterprise-scale solution that allows you to get the most out of your investment in Microsoft 365. You can request a demo here. If you need help doing more with Microsoft 365, you can request a free one-hour consultation.

Request a Free Demo

Archive Your Project Data in Three Clicks with the Construction Viz PDF Report Wizard 

Project Management, Project Management Tools, Reporting |

Have you ever needed an easy way to archive PDF versions of all your project correspondence, such as RFIs and daily reports, including attachments (which could be in various file formats)?  

The new Construction Viz PDF report wizard aims to build on our existing technology with the ability to generate PDFs from multiple forms at the same time. Read on to find out more about this new feature. 

Introducing the Construction Viz PDF Report Wizard

We built the Construction Viz PDF Report Wizard based on the Construction Viz Form archive wizard which is a powerful and heavily used feature in Construction Viz. It allows users to create PDF binders from any form, including the form attachments. The step-by-step wizard walks you through selecting a form, adding and ordering attachments, and naming the generated PDF binder.

Picture1

Form archiving wizard – re-ordering attachments 

The cool part is the archive wizard converts attached files from their native format (Excel, Word, etc.) to PDF and automatically provides a name for the PDF binder. So, if you want to send a contractor a PDF of an RFI with any relevant attachments, select the form, select which attachments they need to see, and follow the wizard to generate a PDF you can email.  

This feature is an excellent form-by-form solution, but what if you want a push-button way to choose more than one form? Let's say you want to archive all of the RFIs, submittals, and dailies on a project and include all the form attachments. And you want to do this in bulk. 

The new PDF report wizard leverages some of the same technology from our form archive wizard to create multi-form PDF binders of your project correspondence. Users select one or more forms, click the PDF Form Report(s) button, and have the option to include attachments, images, or both. And just like the form archive wizard, the attachments are automatically converted from their native format (Excel, Word, etc.) to PDF, including any images. 

Picture2

If you are wondering about file sizes impacting the system and preventing you from continuing your work, don't. While the file conversion runs, the tool prompts you to load another screen to continue working without interruption. Construction Viz will notify you when the processing is complete and the PDF files are downloaded locally.  

Picture3

Our development team at Lydon Solutions continues to drive innovations in your day-to-day workload with our Construction Viz product for Microsoft 365 so you can focus on what's important, delivering the project on time and within budget. You can request a demo of Construction Viz here, or if you need help with Microsoft 365, you can click here for a free one-hour consultation with our Microsoft technology experts. 

Embed Power BI Reports into Construction Viz!

Reporting |

Power BI is a powerful reporting solution available as a service in Microsoft 365. You can generate dashboards, KPIs, and even paginated reports that can be embedded into SharePoint pages, Teams, and even external websites. Since Construction Viz utilizes Microsoft 365 SharePoint Online, your project data is securely available 24x7 for building your own Power BI reports. And, with Construction Viz, you can publish your Power BI reports as new dashboards to Construction Viz Hubs. Check out a few sample reports that leverage the Daily Report and RFI forms!

Construction Viz Daily Status Power BI report captures project data by phase, location, tailgate attendees, on site personnel, trades, equipment, weather, lessons learned, observations, and activities so you can analyze what occurs on site every day.
Construction Viz Daily Status Power BI report captures every piece of equipment on the jobsite by day and whether the equipment is used.
Construction Viz RFI Power BI report captures project RFI data by project, location, status, time or cost impact, company, due date, and priority.

Construction Viz can help you get the most out of Microsoft 365 to manage your projects. Leverage our existing Power BI reports or create your own and add them to your Construction Viz projects so they can be shared with the project teams. To find out more about Construction Viz, you can schedule a one hour demo here or if you need help with Power BI reports or Microsoft 365 in general, you can visit lydonsolutions.com to submit a free one hour consultation.

Construction Viz’s Spreadsheet Component Meets You Where You Work

Reporting |

The most common software used on construction projects is Microsoft Excel. The catch-all tool has allowed project teams to build localized solutions for tracking, reporting, and sharing project information. Unfortunately, Excel has created a problem for most project management information systems (PMIS) on the market that expect users to give up their Excel files and adopt their platform. The bottom line is that users are entrenched in Excel and, more often than not, don't give it up.

The new Construction Viz Spreadsheet component embraces Excel

Over the years, we have found that disregarding Excel in favor of only using a web-based PMIS can create resentment among project teams, with users ultimately returning to their old faithful at the end of the day.

At Lydon Solutions, we choose our battles wisely, meeting users where they work: Excel, Outlook, and Teams. We built the new Spreadsheet component to bridge the gap between our Construction Viz PMIS and Excel users, delivering a best of both worlds approach.

What is the Spreadsheet Component?

We build Construction Viz applications to use components like mini-applications that perform discrete tasks, such as attaching documents, uploading images, and capturing approvals. Components can be combined to deliver turnkey applications like RFI or daily report forms. Adding the Spreadsheet component to an application enables interaction with Excel files saved to Construction Viz, allowing users to display, modify, and extract data from worksheets.

How Does it Work?

The process of using the Spreadsheet component in a Construction Viz form would go like this:

  • Create a new form record, like a status report, and fill in the required fields.
  • Upload your Excel file(s) using the Document Attachment component within the form. The file is automatically tagged and stored in the supporting SharePoint Online library.
  • Open the Spreadsheet component in the form and select the Excel file you uploaded from the list.
  • The Spreadsheet component will display the Excel file selected and extract data from rows, columns, or cells as identified in the setup and displayed beneath the spreadsheet.
  • You can then make changes to the spreadsheet (formatting, adding columns, adding formulas, etc), save it locally, and then upload it back to the Document Attachments component.

How is this different than Excel Online and your Construction Viz Cost Report application?

Excel Online displays an Excel file in the browser once stored in a SharePoint document library. If you want to extract data from that Excel file to use in another SharePoint list, application, or report, you will need to build and maintain a Power Automate workflow. Our Cost Report application leverages a Power Automate Workflow or Microsoft Graph to extract data out of Excel, but this approach is limited to data stored within a specific Excel table.

Organizations can add the Construction Viz Spreadsheet component to any of our applications to enable their users to read and display Excel files directly without needing a workflow. The Spreadsheet component can also read data from anywhere in an Excel file (rows, columns, and cells) and is not limited to an Excel table.

To find out more about the new Spreadsheet component or any of our applications, visit Construction Viz.com to sign up for a free demo. If you are not ready for an enterprise construction management PMIS like Construction Viz but want to manage your projects in Microsoft 365, you can visit LydonSolutions.com and submit a request for a free one-hour consultation to help you on your way.

No PMIS is an Island: Integrating Smartsheet and Construction Viz

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.

Generate a Power BI Dashboard from Microsoft Lists in Three Clicks with Construction Viz

Reporting |

Microsoft 365 Lists is a relatively new app that allows users to view and create interactive lists for managing items such as tasks, issues, and even assets for a construction project. If you have used Microsoft SharePoint Online, Lists will seem familiar since it uses the same list technology.

Construction Viz leverages SharePoint lists and libraries to store project data so you can be assured that it is always safe and available 24x7. And because both Microsoft Lists and Construction Viz both use SharePoint lists under the hood, you can interact with your lists in either application. For example, you can use Microsoft Lists to view, create reports, and interact with any of your lists without going into Construction Viz or SharePoint.

RFIs with revisions displayed in Construction Viz and Microsoft 365 Lists
RFIs with revisions displayed in Construction Viz and Microsoft 365 Lists

To access an existing  Construction Viz SharePoint list from Microsoft Lists, click the new list button and select an existing Teams site or SharePoint site to find an available list.

View of the New List menu in Microsoft Lists
View of the New List menu in Microsoft Lists

One of the great features of Microsoft Lists is its ability to quickly create a Power BI report from the list with as little as three clicks. From Microsoft Lists, if you click Integrate, select Power BI, and then Visualize the List, Power BI will assess all of your list data fields and automatically generate a configurable dashboard. With a few minor changes, you can quickly publish a powerful dashboard to report on the status of your list data, such as your Construction Viz RFI log.

MS-Lists-Power-BI_3

This is just one of many integrations with Microsoft 365 services that Construction Viz can leverage.

You can request a demo of Construction Viz here to learn how to get the most out of your Microsoft 365 investment to manage your construction projects.