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
Your guide to leveraging NCE pricing to get the best value
Renewing your Microsoft Licensing Agreement is an opportunity to align your IT strategy with your business goals. It allows you to take advantage of the latest technologies, optimise costs, and ensure compliance with industry standards. While this might seem straightforward at first glance, to achieve the best value and biggest discounts, it’s often more complex than it appears and navigating the renewalprocess requires careful planning. In this Blog we will walk through what you need to know about the new Microsoft Licensing rules,when to get the best value from your renewal, and how to review…
Loving your customers with AI, cybersecurity and peace of mind with MSP support
2024 has marked a massive shift for SME IT needs, as creating an appropriate and optimised business strategy has become an increasingly difficult challenge for business owners and IT operators nationwide.
Protect your student data from continued ransomware attacks, says Espria
With ransomware rates still high for education organisations, better security oversight and orchestration is needed across UK schools.
Fortify and Reassure with Compliance and Cybersecurity Synergy
With new cyber threats emerging, businesses will need to develop a seamless and blended approach to cyber and compliance for strategic success.
UK businesses cannot continue risking reputation with shoddy security, says Espria
Sophos’ 2024 Threat Report recently highlighted ransomware as the biggest existential cyber threat to small businesses. While cyberattacks on large companies and government agencies may receive more news coverage, Sophos reported that SMB’s are generally more vulnerable to cybercriminals and suffer more proportionally from the results of a breach.
Peace of mind: Cloud is key in scaling systems to your business needs
Meeting the demands of the modern-day SMB is one of the challenges facing many business leaders and IT operators today. Traditional, office-based infrastructure was fine up until the point where greater capacity was needed than those servers could deliver, vendor support became an issue, or the needs of a hybrid workforce weren’t being met. In the highly competitive SMB space, maintaining and investing in a robust and efficient IT infrastructure can be one of the ways to stay ahead of competitors.