You can import registrations you received outside of ActivityHero using a CSV file. This allows you to have all your enrollments in one place.
1. Download the sample registration CSV to see the data fields.
2. Add your data into the csv file, then remove the sample row.
To associate the registrations to the correct session, the activity_schedule_id must be included. You can find this value on the Sessions & Spots Manager on your ActivityHero Dashboard.
Please note, be sure to enter enough spots to cover the number of registrations you are importing. Each imported registration will reduce the spot count by one, and once it hits 0 spots, the remaining registrations will be Waitlisted.
3. Upload your csv file by clicking "upload a new file". Select "Registrations" as the import type.
4. After uploading your csv file, click the Validate button to see if your data is ready for import. If there are errors, correct the errors and upload your file again.
5. When the file is validated successfully, the green 'Run' button will be available. Click the Run button to begin importing your registrations.
Data fields
* required fields
** required if the user has not registered on ActivityHero before
* activity_schedule_id
external_schedule_id
** user_email
** first_name
** last_name
** user_zip
* amount (enter the amount paid, if it was free, enter 0)
* enrollment_status (Enrolled, Cancelled, Pending, Wait Listed)
* participant_first_name
* participant_last_name
participant_dob (required if your session is for specific ages)
participant_grade (required if your session is for specific grades)
participant_school_name
participant_allergies
participant_medical_condition
* parent1_first_name
* parent1_last_name
parent1_cell
* parent1_email
parent1_street_address
parent1_city
parent1_state
parent1_zip
parent1_country
parent2_first_name
parent2_last_name
parent2_cell
parent2_email
parent2_street_address
parent2_city
parent2_state
parent2_zip
parent2_country
authorized1_name (adult who is authorized to pick up or sign in/out the participant)
authorized1_cell
authorized1_relation
authorized2_name
authorized2_cell
authorized2_relation
emergency1_name (emergency contact)
emergency1_cell
emergency1_relation (eg: mother, father, aunt)
emergency2_name
emergency2_cell
emergency2_relation
hospital_name
physician_name
physician_phone
insurance_company
sibling_request (Names of siblings who are also attending)
special_request
subscribed (default is "FALSE". Set to "TRUE" if the user is subscribed to your marketing emails)
Custom Questions (For the column heading, copy/paste the custom field name. Must be exact) For example, if the custom question is named Student ID, the heading must be "Student ID".
Contact support@activityhero.com if you have questions or problems.