SymVolli – App Development & Database Creation
SymVolli provides an innovative and flexible IT Business Management System, aimed at the SMB market which integrates all key functionality into a single system.
As part of its growing capability, SymVolli had asked an external development organisation to create an Events Management solution for one of their customers. It quickly became apparent that due to poor structure and missing capabilities, the application did not meet SymVolli’s expectations.
From the ground up, the app lacked functionality, with a database which was neither fit for purpose nor following best practices. Additionally, certain elements of the application were unavailable to users and counterintuitive, limiting their ability to carry out tasks and making the solution inefficient.
With involvement from multiple parties, it was vital that a clear scope was defined, and communication was consistent throughout the project.
Requirement
The original requirement was to fix broken functionality and make cosmetic adjustments to the application, however, on investigation, Espria peeled back the layers of the app to uncover issues which ran much deeper than just the functionality, right down to the database.
The requirements included:
- Troubleshooting the existing application to identify areas of improvement
- Creating a new relational database with correct levels of access granted throughout the app
- General improvements to the app’s functionality, such as the ability to delete records
- Implementing built-in error handling to ensure data formatted correctly before adding it to the database
Our solution
A new SQL database was created to build the much-needed relationships between the data tables. The key data was extracted from CSV files and business keys were created for the individual tables before surfacing the cleansed data in the Power Apps front end. Stored procedures were created to handle the read/write operations to the database, giving end user’s the functionality that had been lacking.
Espria recreated the connections to the new database from the Power Apps front-end and fixed issues with navigation and button functionality to start rebuilding the structure of the app. Vigorous testing was carried out for the implementation of built-in error handling, and to confirm all elements of the app worked together smoothly.
Espria went above and beyond to overcome hurdles throughout the project and transformed the existing database and application in a pressurised time frame. Through teamwork and collaboration, all the requirements were effectively captured and implemented, resulting in satisfaction for all parties involved.
Espria is now looking ahead to working on Phase 2 of this project and continuing the Power Apps journey with SymVolli as new features and ideas are introduced.
You may be interested in
Why Businesses Should Invest in ESG: Lessons learned by Espria
In today’s competitive landscape, Environmental, Social and Governance (ESG) performance is no longer just a “nice to have”—it is a critical business imperative. Companies that prioritise ESG are better positioned for long-term success, risk mitigation, and reputation enhancement. Today’s world demands more from companies than just financial performance. Customers want transparency. Employees want purpose. Investors want resilience. ESG helps businesses manage risk, seize new opportunities and build trust with the people who matter most. It is how you can stay competitive, stay responsible and stay relevant in a fast-changing world. A powerful case study of…
The Importance of Compliance and Security: Complementary Forces in Today’s Business World
In today’s rapidly evolving business landscape, compliance and security have become paramount. These two elements, often perceived as hurdles, are in fact complementary forces that drive business success and sustainability. Understanding their importance and how they work together can transform them from perceived blockers into enablers of growth and innovation. The Role of Compliance Compliance refers to adhering to laws, regulations, standards and ethical practices relevant to an industry. It ensures that a company operates within the legal framework and maintains its reputation. Compliance is not just about avoiding fines and legal issues; it is…
Businesses are losing money and jeopardising security to IT sprawl and quick fixes, says Espria
IT Leaders must take action on unchecked technology sprawl and shadow IT that are draining budgets, increasing cyber risks, and complicating their digital environment. According to a recent study, budgets towards insider risk management have doubled in the past 12 months, with 81% of business leaders looking to secure their internal business infrastructure as geopolitical tensions escalate and remote workforces become the norm. ‘Digital transformation ushered in new possibilities and solutions for computing, but it also introduced a potential for sprawl that burdens IT teams everywhere,’ said Brian Sibley, Virtual CTO at Espria. ‘When faced…
Espria launches Espria Connect, enhancing Microsoft Teams with Advanced Unified Communications
The new product, Espria Connect, isn’t just another telephony solution. It’s a game-changer, offering a cost-effective, scalable, and secure telephony solution for SMBs, mid-market and enterprise customers. Combining the power of Microsoft Teams with Cloud-Based Unified Communications, Espria, the leading managed services provider, is excited to introduce Espria Connect. This powerful solution streamlines business communication infrastructure and addresses the growing demand for a unified communication solution that supports hybrid work environments. Designed for businesses of all sizes, Espria Connect allows users to manage voicemail, make and receive calls, and access a diverse range of other…
Reimagining education: How AI is changing the way we teach, learn, and collaborate in schools
Technology has long been used by educators to support teaching and operations, facilitating staff with a wide range of platforms and resources. A particular tool that has sparked both controversy and curiosity is the inclusion of artificial intelligence (AI). A study by BCS, the Chartered Institute for IT, found that most teachers are reluctant to use AI for pupil learning with 84% of educators not changing the way they assess their students’ work. This comes after Ofsted recently launched an independent review on the use of AI in schools and how to develop the understanding of…
Espria launches CSP renewal assessment service
Leading managed service provider launches new service to address the costs associated with software sprawl, helping to drive down OpEx as businesses increasingly feel the financial squeeze. Espria, a leading digital solutions provider, has launched a free M365 Licence Assessment programme to help businesses save costs by reviewing existing licence estates and identifying those licences not in use or no longer being utilised. With Microsoft recently changing how they sell and structure licenses, businesses must now reassess their current M365 licenses, looking for ways to reduce costs and keep the capabilities they need as they…