The Event Sign-Up Bulk Upload Extension is a standard add-on for the CyberGrants platform that enables program administrators to offer a bulk file upload option for volunteers signing up for events.
This donor-facing portlet simplifies the event registration process by allowing participants to upload multiple sign-up records, on behalf of themselves and others, through a single .TXT file.
Core Functionality
At its core, this extension provides:
A donor-facing portlet where files can be uploaded with sign-up information.
A file processing system that runs nightly to interpret and validate bulk uploads.
Validation and error handling, ensuring accurate data and user feedback.
Automated sign-up record creation for valid entries, including Friends and Family associations.
Key Components
Key components of the extension include:
Portal Page - A dedicated donor-facing webpage that includes file upload instructions, the upload tool, and a history table.
Bulk Upload Template - Provided by CyberGrants, this defines required and optional fields.
Upload File -Users select and upload their .TXT files through the 'Choose File' and 'Upload File' options.
Upload History Table -Tracks the status of uploaded files, including validation status and details.
Workflow Example
A donor accesses the portal page with the upload portlet
The donor downloads the file template and populates fields such as:
Event ID
Donor ID
Shift Number
Friends and Family information
They save the file in .TXT format using the designated naming convention.
The donor uploads the file using the portlet.
The system processes the file overnight.
If successful, sign-up records are created, and the Upload History table is updated.
If errors exist:
Valid rows are processed.
Invalid rows are rejected.
A detailed error report is emailed to the predefined distribution list.
Technical Specifications
File Format - Must be a .TXT file.
Validation - Includes checks for field format, naming, duplicate records, and more.
Processing Frequency - Nightly.
Disposition Logic -
Enrolled if slots are available.
Waitlisted if event maximums are exceeded and the waitlist is enabled.