Importing and exporting tools make it easier to manage large numbers of events at once. You can bulk add events using an import template, export existing events for review or reporting, and export RSVPs and attendance data for deeper analysis.
AVAILABLE ON WEB BROWSER ONLY
Import Events to the Calendar
Use the import tool when you need to add many events at once, such as full season schedules, training blocks, or tournament games. Keep in mind that recurring events cannot be imported directly.
Navigate to Calendar in the left navigation menu.
Click the Actions button in the top right corner and select Import/Export from the dropdown.
Under Import Calendar, click the hyperlinked Calendar Upload Template to download a template file as a starting point.
In the template file, fill out the Import Layout tab with your event information.
Use the File Specification tab for a description of each column on the Import Layout tab.
For help locating the ClubID, ProgramID(s), TeamID(s), LocationID(s), and/or FieldID/CourtID/RinkID(s), click the Import Help button.
Save the Import Layout tab as a CSV (Comma Delimited) (.csv) file.
Back in Sprocket, click Upload, select your newly saved import file, and then click Import.
Once the import is processed, your events will appear on the Calendar according to the details in your file.
Export Events from the Calendar
Use the event export tool when you need a list of events for reporting, sharing, or offline review.
Navigate to Calendar in the left navigation menu.
Click the Actions button in the top right corner and select Import/Export from the dropdown.
Under Export Calendar, choose which events to export from the Event Types dropdown, and enter the Start Date and End Date range you wish to export.
Click Export.
A file will be generated containing the events that match your selected filters and date range.
Export RSVPs and Attendance
You can also export RSVPs and attendance data for deeper insights into participation.
Navigate to Calendar in the left navigation menu.
Click the Actions button in the top right corner and select Import/Export from the dropdown.
Under Export RSVPs and Attendance:
Choose which events to export from the Event Types dropdown.
Enter the Start Date and End Date range you wish to export.
Optionally, select the Program(s) and Team(s) for more targeted exports.
Click Export.
The export will include RSVP and attendance details for the selected events, within the date and filter criteria you’ve set.
FAQs
Can I import recurring events?
No. Recurring events cannot be imported directly.
What file type is required for event imports?
You must save the Import Layout tab as a CSV (Comma Delimited) (.csv) file before uploading.
Can I export events for a specific date range?
Yes. Use the Start Date and End Date fields when exporting events.
Does the RSVP export include attendance?
Yes. The Export RSVPs and Attendance file includes RSVP and attendance details when applicable.