Try Now
More in this section

Case Studies

  • Keeping Strawberries Safe: PlanetMagpie Builds Event Management Application to Track Strawberry Grower Safety Training

    • Industry
    • Background
      The California Strawberry Commission is responsible for providing food safety training programs to California's strawberry producers. As the number of producers grew, the trainee volume and frequency of training events grew as well. They needed an application that would allow Commission administrators to create and manage events, strawberry producers to register their trainees, and trainees to receive certificates of attendance. They also needed reporting capabilities and, ideally, a CMS that they could extend in the future for a new California Strawberry Commission website. So they solicited bids for a management platform from California IT agencies. PlanetMagpie IT Consulting won the bid, and set out to create the desired application.
    • Challenge
      Implementing all the desired options for managing events, participant coordinators and their participants' involvement in events. Create a seamless integration between the Sitefinity Events module, custom CMS classifications and a custom CRM module unique to the Strawberry Commission's needs
    • Why Sitefinity
      We chose Sitefinity CMS so we could use its Events module, Classifications and the Dynamic Module Builder. Sitefinity saved the client on development time, and it provided a back-end framework we could build into their existing website.
    • Technical Details
      • Sitefinity CMS 5.1  
      • Windows Server 2012
      • Database: SQL Server 2012
      • Number of Developers: 2
      • Development Time: 3 months
    • Deployment Highlights:
      • Tying custom modules together       
      • Architecting relational database schema
      • Customizing DNS routings
      • Hosting for maximum site performance
    • Results:
      Sitefinity provided a development framework that allowed for easy extension and management of custom features. Sitefinity gave the project all the advantages of CMS–secured pages with role-based access, time-saving data modules, and many other features to help simplify the development efforts (e.g., custom classifications). Future extensions will be easy to integrate (such as localized content) due to Sitefinity's out-of-box module capabilities.
  • The Challenge

    The biggest challenge was meeting all of the client’s requirements with the application.  In order to make the management process a breeze (not a hassle), many details needed to be covered; such as:  

      • Creating different types of events
      • Registration of participants and participant coordinators for events
      • Coordinators need to manage groups of participant information, and allow/deny participants access to the application
      • Event information must coordinate between all participants (no overlap on times/locations)
      • Tracking individual participants’ training progress and certificates awarded
      • Use of role-based permissions, so Participants cannot edit Events, or see the Coordinator, or use management tools
      • Managing and printing certificates of attendance by event
      • Creating custom reports for administrative purposes

    The tracking platform must make the Participant Coordinator’s life easier, by automating most of the management.  It also needed to provide the administrators a simple interface for all Participant and Participant Coordinator features, so even Participants not using the Internet can still be easily tracked.

    The Solution

    We decided to create a web-based application using Sitefinity CMS.  Sitefinity had the modules and structure to support such a platform, even under heavy use.

    The starting guidelines for development were: 

    1.  To control management of training events
    2.  To provide a central location for Participant Coordinator information and the Participants associated with them
    3.  To review and record Participants' training progress 
    4.  To create Participant certificates of attendance

    In order to build the application, we would need to customize existing modules and integrate custom third-party modules.

    The Development Process

    This project started with a 100+ hour requirements gathering effort.  PlanetMagpie had multiple meetings with the Strawberry Commission staff to develop workflow processes, draft form templates, develop user stories and database schema, develop technical and security requirements, etc.

    In order to build the platform database and structure, we had to extend the Sitefinity Events module to work with a tiered hierarchal custom CRM module (Participants and Participant Coordinators CRM, from Sitefinity Dynamic Module Builder).  We also integrated other Sitefinity Dynamic Module Builder elements and custom Sitefinity Classifications to create an object relational database within the application.

    With a database in place, we employed document, image and video library integrations for event-related content.  Then custom Tags and Categories for synchronizing these content items with Events, Event Types, Public versus Private, and the language of the documents.

    The application's interface was designed to accept future extensions for localized pages and content.  It will support an unlimited number of event types (that may or may not need registration through the platform) and reporting on connections to the application.

    We created online documentation so the Commission's administrators could manage Participant Coordinators and Participants through every type of change.  For example, a change in distribution, or Participants merging.

    We even added an online style guide with CSS classes for page elements, so the client could create their own pages in the future.

    The Results

    The application is now live at http://education.calstrawberry.com.  It centralizes the training processes and event tracking…making the whole effort much easier for Participant Coordinators to manage.
    From this management console, Participants can:

    1.  Sign up for events
    2.  Report on their event status
    3.  Access training materials as provided.

    Coordinators, who see an expanded set of options, can create Events, register Participants, track Participants' activity, and issue certificates of completion.  All of this is recorded on the backend, so the Commission has up-to-date records of all grower training.

    The Process works like this:

    1.  Say you're a Coordinator for a grower.  You need to train management and personnel, who'll teach Food Safety at a farm, according to State Commission standards.
    2.  You create a Coordinator account and log in.  You then schedule event attendance for your Participants.
    3.  Participant account creation is automated when a Coordinator adds Participants under their account.  Emails notify Participants and Administration of new accounts.
    4.  The Coordinator registers Participants for a training event.
    5.  At the event, attendance is verified by scanning ID cards.  All scanned information is imported as event attendance records by the site's Administrator.
    6.  The Administrator then scores the attendees who complete and pass the test.
    7.  Participants who completed the event can print their certificate of attendance. 
    8.  Those who complete a series of events & have met the criteria receive a Food Safety Certificate of Completion.

    This new training platform gives the California Strawberry Commission an efficient system for recording and managing grower safety training.  With it they can keep up with the demand for trained strawberry grower safety training.

Schedule one-on-one online consultation

Individual online session to discuss your project needs and questions.

Schedule now
Schedule a demonstration