600 sites moved from Qube into BOSS by script, not by hand

01The challenge

Warwick's acquisition of Anthem Management brought about 600 sites and 23,000 units into the group, all held in MRI Qube, which would be kept only for a short transition before being decommissioned. Re-keying that by hand would have taken temporary staff months and introduced errors at scale, and some of the data could not be entered through BOSS's standard screens at all. The two portfolios also shared many suppliers, so a straight import risked duplicate supplier records and payments.

02What we did

1. 01Set-up: a full copy of BOSS on separate staging infrastructure, and profiling of the live system ahead of the extra data
2. 02Mapping: Qube's data mapped to the BOSS schema, with suppliers and cost centres matched against BOSS and confidence-scored for review
3. 03Import: a scripted extract, validate, transform and import pipeline, run in staging through twelve versions of the Qube export
4. 04Validation: reports broken down by property manager sent issues back to be fixed in Qube, followed by three rounds of user acceptance testing
5. 05Cutover: final export, production import and post-import checks

03What we built

• Staging copy of BOSS for repeat full imports
• Scripted extract, validate, transform and import
• Supplier matching on name, bank details and email
• Cost-centre mapping with confidence ratings
• Validation reports by property manager
• Opening balances and ground rent accounts

04The result

The Anthem portfolio now runs in BOSS with the rest of Warwick's sites, so staff work in one system rather than two. Validation reports by property manager found problems no bulk check would have caught, fixing them in the Qube export proved cheaper than patching them in the pipeline, and the pipeline is ready to reuse for the next portfolio Warwick brings across.