Export
Export community event data from PEARS as an Excel workbook.
The Community Events export generates an Excel (.xlsx) workbook containing data from your events. The export includes event details, collaborators, sessions, registration types, forms, and payment information across multiple worksheets.
Getting Started
To export community events, navigate to the Community Events list under the Plan menu and click the Export button. The export includes all events matching your current filters.
TIP: Apply filters before exporting to limit the results to a specific date range, status, or program area. Large exports are processed in the background and you will receive an email when the file is ready to download.
Workbook Structure
The export workbook contains the following worksheets. Data can be linked across worksheets using the event_id column.
Codebook — Describes each column in the workbook and provides notes about the exported data.
Events — One row per event with fields including title, summary, program areas, unit, location details, time zone, start and end times, payment settings, status, and timestamps.
Collaborators — One row per collaborator per event, including the user's name, access level, event organizer status, contributor status, and contribution description.
Event Sessions — One row per session, including the session name, start and end times, and location.
Event Registration Types — One row per registration type, including the type name, deadline, and capacity.
Event Forms — Form elements and options associated with event registration types, including element names, types, and option labels.
Payment Worksheets
The following worksheets are included when the event payment feature is enabled for your organization:
Event Registration Fees — Base fees associated with registration types.
Event Session Fees — Fees for individual event sessions.
Early Bird Discounts — Time-limited discounts applied to registration fees.
Additional Fees — Add-on fees triggered by form element selections.
Promotional Codes — Discount codes that can be applied during registration.
Payment Details Export
The Payment Details export is available from the event detail page for users with the Export Payment Details permission. It contains one row per transaction with a Transaction Type column indicating "Payment" or "Refund." Refunds appear as separate rows with negative totals, so summing a payment and its refund yields the net amount. Rows are sorted by registration, with refund rows immediately following their corresponding payment.
TIP: Test/preview registrations created while previewing the registration flow are excluded from the Payment Details export.
Last updated