SymVolli - App Development & Database Creation | Espria Skip to main content

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
picture of two laughing women

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.

Our clients

Case Studies

IT Services

Vercity – Ensuring Business Continuity & Security into the Future

Vercity provides a range of financial management & consultancy services, and they required an IT vendor to provide industry insights and help keep their data secure.

IT Services

Team17 – Using Power BI to Improve Reporting & Business Decision Making

A multi-award-winning video game development company got in touch with Espria to discuss improving their reporting and utilisation of their data.

IT Services

The Development Bank of Wales – Managing a Laptop Refresh Project

The Development Bank of Wales is a public sector finance company employing almost 300 people based in Wales. Espria were engaged to manage a laptop refresh project.

IT Services

National Association of Head Teachers – Managing a Move to the Cloud

Following the pandemic, NAHT was able to expedite its long-term plan to go fully cloud-based and complete the move from their bricks and mortar head office to the cloud in 2023.

Please fill out the below form and one of our team will get back to you asap. Alternatively please call 0330 175 5588 to speak to a member of the Espria team.

Book a Call​

Why not let us call you? We like to keep things simple, and our team are here to advise and support you in your technology transformation.

Please fill out the below form and one of our team will get back to you asap. Alternatively please call 0330 175 5588 to speak to a member of the Espria team.