Getting Buildertrend data into a dashboard: four things that went wrong
On one reporting build we took Buildertrend data three ways: lists exported from the screen, exports from Business Insights, and Data Flow files delivered to cloud storage. All three worked. Each one also had a trap that would have put a wrong number on a dashboard.
Screen exports shorten some cells
A screen export was enough to start. But on several hundred purchase orders, the cost-code cell showed one code followed by "(+N)…". The order total was there. The other codes were not.
We took the remaining codes from the line-item feed. Assigning each whole order to the first visible code would have produced a convincing but wrong cost breakdown.
Rows are not records
One export of daily logs had ten more rows than there were logs, out of about 26,000. A handful of log IDs appeared more than once, because related records took up extra rows.
Count distinct IDs, not rows. Ten rows is a small error. The same mistake on a list with many related records is not.
A download that works for a person may not work unattended
We could download the Data Flow files using a person's login. The dashboards refresh under a separate account that runs with nobody present, and that account's access was verified ten days later.
The second test is the one that matters for handover, because it is what runs when nobody is watching.
Switching feeds moves fields
When we moved from the Business Insights export to the cloud delivery, eleven fields moved. Custom answers such as delays and safety incidents had been on the daily-log row. In the new delivery they arrived in a separate file.
We matched nearly ten thousand custom-field records back to their logs. Treating the missing columns as "no incidents" would have quietly changed the dashboard.
Checks worth keeping
- Compare totals with the source after every load.
- Count IDs, not rows.
- Test the refresh with the account that will run it.
- When a feed changes, compare it field by field before you switch.
If you would rather have this built for you, I do it for building and remodeling firms. It starts with a small fixed-price review.