4 Ways to Leverage your Investment in Cityworks and Munis

Trimble Cityworks has grown to be a true platform solution capable of integrating with other enterprise systems, experienced Trimble Cityworks users and business partners have identified best practices for ensuring the long-term success of a system integration.

Tyler Munis is a financial software solution used by many local government agencies to manage financials, procurement, human resources, payroll, and revenue. Integrations with Munis allow Trimble Cityworks to access data such as employee labor rates and equipment and material costs, as well as send back to Munis the costs incurred on work orders or the permit revenue that has been collected.

For any integration to be successful, the third-party software provider—in this case, Munis—needs to be involved to confirm the technical approach and functional requirements of the integration.

Involving the third-party provider can help an organization understand how to balance the costs, complexity, ease of use, support, and sustainability of an integration.

Timmons Group used this approach when they worked with the City of Auburn, Alabama, to update their existing Trimble Cityworks and Tyler integration using APIs. A previous integration with Tyler’s legacy system, Eden, relied primarily on flat-file transfers, or manual exports of datafiles from one system to another. We reviewed existing workflows, with an emphasis on functional requirements and business processes. The team then worked to identify where each system should be leveraged in the workflows to maximize the integration.

Auburn’s updated Munis and Trimble Cityworks integration is split into several sections of support: employees, materials, utility billing, and cashiering. Here is how the updated integration benefitted each support section.

1. Employee Record

In a previous integration to Eden, service requests were dispatched to Trimble Cityworks admins every time a human resources (HR) staff member updated an employee record. HR staff could amass hundreds of generated requests a year, particularly during busy seasons.

City staff can now add, remove, or update an employee record without creating additional requests that bog down their HR team. The new one-way integration from Munis to Trimble Cityworks automatically updates the Trimble Cityworks employee table, eliminating most service requests. When human interaction is needed, a subset of the output fields automatically determines whether a service request should be generated for additional follow-up. APIs can be leveraged on both sides by the Munis administrator or the Trimble Cityworks administrator, allowing changes made at any point in the process to automatically update both systems.

“Without this critical piece of the integration, there is simply no way we can support accurate and timely employee data in Trimble Cityworks without also growing support staff. This integration alone has saved the city thousands of Trimble Cityworks administration hours,” says Christopher Graff, deputy chief information officer for the City of Auburn.

2. Materials

Tracking the costs, inventory, and use of raw materials for municipal projects is a critical component of Auburn’s operations management. Items like concrete mix, stone, and cold patch asphalt are all tracked through the city’s Munis system. Trimble Cityworks allows crews to record how much material is used in a project and how much inventory remains. Previously, city staff dedicated valuable work hours to manually update material data between the two systems.

We designed an API integration between Trimble Cityworks Storeroom and Tyler Munis that streamlines raw material tracking. Utility employees now use Trimble Cityworks AMS and Storeroom to maintain the cost of a material, the amount used in a project, and the remaining quantity after the inventory has been adjusted. The system updates nightly to keep both finance staff and utility crews appraised.

“Work stoppages and overtime used during inventory audits has greatly decreased. We’ve been able to lower inventory costs because we better manage what’s on hand and can efficiently order materials,” says Christopher.

3. Utility Billing

Up-to-date finances are an important facet to any successfully operating municipality. The Auburn utility billing team needed a way to immediately update financial records with each filing. The previous configuration produced a 15-minute delay with each utility billing update. Although this delay may not seem significant, it created unnecessary information in a second staging table upon closing a work order and often resulted in orphan canceled billing records. The fields available to Trimble Cityworks were also too limited to be functional.

The new Trimble Cityworks and Munis integration allows for instantaneous data transfer, a function that is vital to reliable customer billing. The integration sends billing and meter information to Trimble Cityworks. When the Trimble Cityworks work order is closed, only applicable information is sent back to Munis, eliminating dual records and unnecessary data transfer.

“The instant communication between office and field—Munis and Trimble Cityworks—facilitates greater teamwork among staff. We see increased productivity from this, and this ultimately builds happy customers,” Christopher says.

4. Cashiering

The final section of Auburn’s Trimble Cityworks and Munis integration did not have a legacy implementation. Instead, city staff manually transposed fees to Tyler Cashiering. We proposed a solution to create a web service that combines Tyler Cashiering and Trimble Cityworks permit management to support fee lookups, permit fee payments, and permit voiding. As a result, finance staff no longer need to manually monitor Trimble Cityworks fee-based transactions.

With the fee lookup, staff can search for a customer name, address, or phone number, and Trimble Cityworks will return a specific output such as fee amount or due date. The Tyler Cashiering side of the integration is responsible for both making the call to the web service and parsing the results. Fees are returned by the web service for permits that do not have a status of closed, denied, expired, void, or withdrawn.

Another critical value added to this new API integration is reporting. Prior to this process, most fees were categorized at a high level and with few details. The new integration allows for highly detailed permitting fee data to flow back to Munis, thus creating a richer data set to helpthe city make data-driven decisions around planning and operations.

To mark Trimble Cityworks permit fees as paid, we developed a web service that will acknowledge payment information and return the output as successful or failed. Tyler Cashiering makes a call to the web service that can parse results for each fee that requires payment. To mark Trimble Cityworks permits as voided, we developed a service that can delete a payment and all its associated records throughout Tyler Cashiering, keeping dual or unnecessary records out of the integration.

As the City of Auburn continues to grow in its business processes, Timmons Group will continue to help its employees, supervisors, and utility workers establish best practices that benefit the entirety of the municipality. Bringing third-party software providers to the table brought Auburn tremendous success. The world of geospatial technology and asset management continues to evolve quickly, and we welcome the challenge of building and implementing forthcoming best practices for our industry partners.

By Michael Edwards, Timmons Group Project Director