{"id":3364,"date":"2026-09-07T11:51:59","date_gmt":"2026-09-07T09:51:59","guid":{"rendered":"https:\/\/www.yelido.be\/?post_type=case-study&p=3364"},"modified":"2026-09-07T11:52:00","modified_gmt":"2026-09-07T09:52:00","slug":"unipso","status":"publish","type":"case-study","link":"https:\/\/www.yelido.be\/en\/case-studies\/unipso\/","title":{"rendered":"Unipso \u2013 SoDa, centralized management of contacts and events"},"content":{"rendered":"
\n
\n
Methodology<\/div>\n\n\n A centralized database to replace Excel files<\/a>\n Managing events, registrations and reporting<\/a>\n Integrations, architecture and methodology<\/a>\n <\/div>\n\n
\n\n
\n

A centralized database to replace Excel files<\/h3>\n

Before SoDa, Unipso’s data was scattered across Excel files managed individually by each employee: duplicates, unshared information and time-consuming manual processes.<\/p>\n

Yelido first modeled, in co-design with Unipso, a database schema and screens based on the existing setup. SoDa now centralizes all contacts and lets them be organized in fine detail: categories, sectors, joint committees, institution types and federations (multiple-choice fields), contact groupings and advanced search (name, email, postal code).<\/p>\n

Data quality is ensured by a uniqueness check on entry, a report of potential duplicates and assisted merging of two records. Historical data was migrated through a bulk import from the existing Excel files.<\/p>\n<\/div>\n <\/div>\n

\n

Managing events, registrations and reporting<\/h3>\n

SoDa covers the entire lifecycle of trainings and events: creation and scheduling (with schedule duplication), registration management and attendance-sheet tracking (present \/ absent \/ excused statuses and hours calculation).<\/p>\n

Registrations are automated: through a REST API, Unipso’s website sends registration forms directly into SoDa. The contact is matched or created automatically, and the form’s custom fields are attached to it, eliminating any manual re-entry.<\/p>\n

On the operational side, SoDa generates dynamic, customizable Excel reports (field selection, participation listings) and enables mail merge, giving Unipso complete autonomy over its reporting.<\/p>\n<\/div>\n <\/div>\n

\n

Integrations, architecture and methodology<\/h3>\n

Designed as a connected hub rather than an isolated tool, SoDa integrates with Unipso’s ecosystem: synchronization of mailing lists with MailChimp from contact groups, and interactions with Outlook \/ Exchange for contacts and calendar.<\/p>\n

The application is built on a Java web architecture (Tomcat), with a REST API open to third-party systems. It was crafted for business use: modernized interface, cross-browser compatibility, responsive display and contextual help.<\/p>\n

The project was run in agile mode (Scrum), in sprints with regular demos and reviews involving Unipso in every decision. Yelido now handles its development, hosting and long-term maintenance.<\/p>\n<\/div>\n <\/div>\n <\/div>\n\n

\n \n <\/svg><\/span>\n Back to case studies list <\/a>\n <\/div>\n \n<\/section>\n","protected":false},"excerpt":{"rendered":"

Unipso is a cross-sectoral federation that represents and supports social-profit enterprises. Day to day, its teams manage a large volume of contacts (institutions, federations, individuals) and training events. To replace a multitude of individual Excel files and professionalize this management, Yelido designed and developed SoDa (Social Data): a business web application backed by a centralized database, giving every team a single, reliable source of information, connected to Unipso’s website, emailing and messaging.<\/p>\n","protected":false},"featured_media":3362,"template":"","meta":{"_acf_changed":false},"category-case-study":[25],"class_list":["post-3364","case-study","type-case-study","status-publish","has-post-thumbnail","hentry"],"acf":{"case_study__client":"Unipso","case_study__year":"2015","animation":{"enabled":false,"name":false,"delay":0}},"yoast_head":"\nCase study: Unipso \u2013 SoDa, centralized management of contacts and events | Yelido<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.yelido.be\/en\/case-studies\/unipso\/\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Case study: Unipso \u2013 SoDa, centralized management of contacts and events | Yelido\" \/>\n<meta property=\"og:description\" content=\"Unipso is a cross-sectoral federation that represents and supports social-profit enterprises. Day to day, its teams manage a large volume of contacts (institutions, federations, individuals) and training events. To replace a multitude of individual Excel files and professionalize this management, Yelido designed and developed SoDa (Social Data): a business web application backed by a centralized database, giving every team a single, reliable source of information, connected to Unipso's website, emailing and messaging.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yelido.be\/en\/case-studies\/unipso\/\" \/>\n<meta property=\"og:site_name\" content=\"Yelido\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-07T09:52:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.yelido.be\/app\/uploads\/2026\/07\/logo_unipso.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1417\" \/>\n\t<meta property=\"og:image:height\" content=\"511\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yelido.be\\\/en\\\/case-studies\\\/unipso\\\/\",\"url\":\"https:\\\/\\\/www.yelido.be\\\/en\\\/case-studies\\\/unipso\\\/\",\"name\":\"Case study: Unipso \u2013 SoDa, centralized management of contacts and events | Yelido\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yelido.be\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.yelido.be\\\/en\\\/case-studies\\\/unipso\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yelido.be\\\/en\\\/case-studies\\\/unipso\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yelido.be\\\/app\\\/uploads\\\/2026\\\/07\\\/logo_unipso.png\",\"datePublished\":\"2026-09-07T09:51:59+00:00\",\"dateModified\":\"2026-09-07T09:52:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yelido.be\\\/en\\\/case-studies\\\/unipso\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yelido.be\\\/en\\\/case-studies\\\/unipso\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.yelido.be\\\/en\\\/case-studies\\\/unipso\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.yelido.be\\\/app\\\/uploads\\\/2026\\\/07\\\/logo_unipso.png\",\"contentUrl\":\"https:\\\/\\\/www.yelido.be\\\/app\\\/uploads\\\/2026\\\/07\\\/logo_unipso.png\",\"width\":1417,\"height\":511},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yelido.be\\\/en\\\/case-studies\\\/unipso\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.yelido.be\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Unipso \u2013 SoDa, centralized management of contacts and events\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yelido.be\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.yelido.be\\\/en\\\/\",\"name\":\"Yelido\",\"description\":\"Partenaire de votre transformation digitale\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yelido.be\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Case study: Unipso \u2013 SoDa, centralized management of contacts and events | Yelido","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.yelido.be\/en\/case-studies\/unipso\/","og_type":"article","og_title":"Case study: Unipso \u2013 SoDa, centralized management of contacts and events | Yelido","og_description":"Unipso is a cross-sectoral federation that represents and supports social-profit enterprises. Day to day, its teams manage a large volume of contacts (institutions, federations, individuals) and training events. To replace a multitude of individual Excel files and professionalize this management, Yelido designed and developed SoDa (Social Data): a business web application backed by a centralized database, giving every team a single, reliable source of information, connected to Unipso's website, emailing and messaging.","og_url":"https:\/\/www.yelido.be\/en\/case-studies\/unipso\/","og_site_name":"Yelido","article_modified_time":"2026-09-07T09:52:00+00:00","og_image":[{"width":1417,"height":511,"url":"https:\/\/www.yelido.be\/app\/uploads\/2026\/07\/logo_unipso.png","type":"image\/png"}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.yelido.be\/en\/case-studies\/unipso\/","url":"https:\/\/www.yelido.be\/en\/case-studies\/unipso\/","name":"Case study: Unipso \u2013 SoDa, centralized management of contacts and events | Yelido","isPartOf":{"@id":"https:\/\/www.yelido.be\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.yelido.be\/en\/case-studies\/unipso\/#primaryimage"},"image":{"@id":"https:\/\/www.yelido.be\/en\/case-studies\/unipso\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yelido.be\/app\/uploads\/2026\/07\/logo_unipso.png","datePublished":"2026-09-07T09:51:59+00:00","dateModified":"2026-09-07T09:52:00+00:00","breadcrumb":{"@id":"https:\/\/www.yelido.be\/en\/case-studies\/unipso\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yelido.be\/en\/case-studies\/unipso\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.yelido.be\/en\/case-studies\/unipso\/#primaryimage","url":"https:\/\/www.yelido.be\/app\/uploads\/2026\/07\/logo_unipso.png","contentUrl":"https:\/\/www.yelido.be\/app\/uploads\/2026\/07\/logo_unipso.png","width":1417,"height":511},{"@type":"BreadcrumbList","@id":"https:\/\/www.yelido.be\/en\/case-studies\/unipso\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yelido.be\/en\/"},{"@type":"ListItem","position":2,"name":"Unipso \u2013 SoDa, centralized management of contacts and events"}]},{"@type":"WebSite","@id":"https:\/\/www.yelido.be\/en\/#website","url":"https:\/\/www.yelido.be\/en\/","name":"Yelido","description":"Partenaire de votre transformation digitale","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yelido.be\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.yelido.be\/en\/wp-json\/wp\/v2\/case-study\/3364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yelido.be\/en\/wp-json\/wp\/v2\/case-study"}],"about":[{"href":"https:\/\/www.yelido.be\/en\/wp-json\/wp\/v2\/types\/case-study"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.yelido.be\/en\/wp-json\/wp\/v2\/media\/3362"}],"wp:attachment":[{"href":"https:\/\/www.yelido.be\/en\/wp-json\/wp\/v2\/media?parent=3364"}],"wp:term":[{"taxonomy":"category-case-study","embeddable":true,"href":"https:\/\/www.yelido.be\/en\/wp-json\/wp\/v2\/category-case-study?post=3364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}