In previous posts we looked at how to retrieve repair works orders  and then pull back full works order details  from Civica Cx. If you have not already seen that post, I suggest you read that first. That’s great, but only a piece of the whole picture. Typically Cx is the client system, and a 3rd party contractor is using their own in house, or off the shelf software. I refer to this as the external system. Once the external system has received a works order and started d

Databases have a habit of growing quietly in the background until, one day, they’re suddenly everyone’s problem. Storage might feel cheap, but the ripple effects of an oversized database are anything but. Longer nightly ETL runs, sluggish reporting, bloated backups, and clogged networks all trace back to unchecked growth. The result? Your business loses precious time and flexibility, especially when jobs that should finish in an hour creep into the early morning. This post i