Case Study
Central Coast Smoke Alarm Services (CCSAS)
Client
CCSAS
Platform
Cloud Database
Industry
Real Estate Servicing
Services
Database Development, API & System Integrations, Support & Maintenance.
Project Brief
In phase 1 they wanted an online system so they could track when their clients wanted a compliance check or were due a retest on their smoke alarms, blinds and RCDs.
In phase 2 they wanted an API gateway to connect their database with PropertyMe. PropertyMe is the online portal used by most real estate agencies in Australia to manage their properties.
The Solution Delivered
We developed the first prototype in 2019. This was then extended to capture all of the details around property rentals and the servicing of those properties.
Since then, we have developed an online portal for CCSAS that has allowed them to go paperless. This portal lets CCSAS view and manage all of the properties they service using a web browser, accessible from anywhere with an internet connection.
For the real estate agents, they can sign in to PropertyMe and see all the properties being taken care of by CCSAS.
On the home page of the CCSAS portal, staff can see a list of all the properties which they can filter them using a variety of options. This allows them to easily see which properties have been added recently, either manually or via the PropertyMe API. They can drill down into each property and see details on the following:
- Tenant
- Property
- Owner and Landlord
- Evacuation Plans
- Safety Equipment
- Tests Performed
- Compliance Certificates
- Activities and Work Orders
Delivery Timeline
We were first contacted by CCSAS at the end of 2019. We delivered a working system in 2020 and there have been a number of improvements since then, especially in reporting and templates.
We have also integrated the PropertyMe API into their database which allowed them to bring properties into their database simply by adding a tag to the property in PropertyMe.
Project Snapshot
Business Need
Replace spreadsheet-based processes with a centralised system to manage property compliance services, inspections, and rental property records.
Solution
Cloud-based database platform with property management, compliance tracking, work order management, and PropertyMe integration.
Technologies
TheDatabase Platform, Cloud Database, PropertyMe API Integration, Reporting & Workflow Automation
Duration
Initial system delivered in 2020, with ongoing enhancements and feature improvements.
DB Gurus Services
Custom Database Development, API & System Integrations, Business Process Automation, Reporting Solutions, Support & Maintenance.
Review
What challenges have been faced along the way?
The integration took longer than expected for several reasons:
- There were multiple offices involved.
- We did not have any experience with this API and it was a BETA version.
- The requirement regarding having multiple accounts was not clear at the start.
- We did not have multiple accounts in PropertyMe to test our software with.
What were the successful aspects of the project?
We were able to connect our database with the PropertyMe system and that provided massive value for the client who was able to offer his clients an extremely useful and low effort solution. All the end client had to do was sign up and tag the properties that needed a safety certificate and CCSAS did the rest.
What special or new features have been used?
We were able to use a single secret key for multiple accounts with different access tokens. This meant the client could set up multiple accounts for the same portfolio and keep the agent records separate or view them all together.
What went “sub-optimally”?
The project took longer than expected.
What training or other materials were provided?
We provided manuals and videos to the client to explain how various aspects of the database worked.
More Related Case Studies
Explore how MediBoard modernises Microsoft Access without disruption, centralising operations across 730 locations in New Zealand.
Discover how Russell Island Tractor Slashing and Mowing upgraded from an old system to a custom cloud-based application for efficiency.
DB Gurus created a customised Environmental Tracking System (ETS) for Abbot Point Operations to simplify the management of environmental monitoring data.
Ready to
Future Proof Your Business?
Book your FREE 30-minute consultation or get a ballpark estimate today. Discover how our technology solutions can streamline your workflows, boost performance, and future-proof your business.
Trusted by leaders in mining, manufacturing, and government. ISO 9001 & ISO 27001 certified. Local team. Real results.