Bespoke Programming for Cumberland and Westmoreland Herald

What do you do when your new software won't integrate with older programmes? Learn how our bespoke programming allowed Cumberland and Westmoreland Herald introduce Xero Accounting and keep their established ad booking system.

Developers at Conformedia wrote a bespoke programme to bridge both systems. This was tested extensively over a period of weeks to ensure the organisation would experience a seamless changeover.

David Rayner from Conformedia explains how bespoke programming allows publishing companies to modernise. “Publishing organisations rely on niche ad booking systems to plan page layouts as part of the booking process. It’s therefore important we preserve the programmes that work well, but not at the expense of progress. If integration is not possible, we develop a solution to allow our clients to benefit from both legacy and new systems.”

He continues to explain how the whole project was delivered remotely. “The existing system used QSales and Pegasus Opera3 accounts, requiring all sales and management staff to be onsite to view accounts data. Clearly with the COVID-19 pandemic this was not sustainable. The goal was to allow the Herald’s sales staff to access customer account data through QSales and the management team through Xero, regardless of location.

“Under normal circumstances we would have been onsite at the Herald, working with the team throughout testing and implementation, however social distancing restrictions required the project to be delivered remotely.”

Initially the team took a copy of the virtual SQL server and copied this to Conformedia’s virtual server cluster and created a demo Xero account with API access. The bridged system was then developed to replicate data to and from QSales to the Xero API, maintaining a fully synchronised system. Once completed the Herald’s staff could view the results through the demo account and bug testing could be achieved without affecting any live data.

After two weeks of testing, the team was confident the system was stable. The bridge was remotely installed onto the Herald’s live servers and configured to access the live Xero data API.