Manually adding each of your participants and their registration information to your account individually can be time-consuming. We are happy to import your registration and tag information so you don’t have to!
Organizing your data so that it can be used efficiently is essential, and we know that for most, organizing giant sets of data can make your head spin. Not to worry, you don’t need to have a master's degree in computational mathematics or be an Excel wizard to setup your account. In fact, it's extremely easy, and you can review the sections below to see best practices for sending us the data we need.
Oh, and if you ever get stuck, we love Excel and organizing data, so just contact us for help.
In this article:
- Participant Imports
- Uploading An Import File
The Group Structure is the foundation of your account. You can filter and report on each level of the structure, so it is an important thing to discuss with your account manager. A simple Group Structure might include only two groups--one for the Season or Year, and one for the Session. A more complex Group Structure might include several groups listing the Location, the Season or Year, and the Session for each program as shown below.
You can set up your Group Structure in whichever way that you want and can include as many different levels as you need. Your account manager is happy to work with you and make recommendations for how to set up your Group Structure in the most effective way for your organization.
If you are sending us the entire Group Structure for your organization or just the information for a few new sessions, the data must be formatted in a spreadsheet and uploaded to us in your account.
For every Group Import:
- Each level/category of the Group must be listed in a separate column.
- Each session/program must be in a separate row and include the start, end, due, and lockout date.
I'm using a separate registration system. How can I easily export and import my data?
We like to keep things simple and have some tips on how to make the export/import process as smooth as possible. We recommend that you export all of your participants and programs from your current system and share this file with your account manager. They can work with you to organize your Groups in a way that capitalizes on the fields your current registration system employs. This way, the files you export do not have to be manually manipulated to match the spreadsheet you upload to us, and you can reduce the chance of errors.
Can I add or remove columns from the import template?
Yes, your Group Structure can be customized. The Group Structure template provided by your account manager is just a starting point, so feel free to add or remove columns as needed when designing your structure. Just a heads up--we will always need start dates, end dates, due dates, lockout dates, and session names.
For organizations using their own registration system, we need a spreadsheet of all of your participants before your organization is ready to launch.
When a Participant Import is received, it is imported into your account and an automatic email is sent to any new email addresses attached to participants.
For every Participant Import:
- Each row must have a first name, last name, and date of birth for the participant. This helps ensure that duplicate profiles are not created.
- For participants who will be attending multiple sessions/programs, their demographic information along with each session/program name must be listed on separate rows within the spreadsheet.
- Include a unique identifier if possible. Identifiers are located with the demographic information of the profile and are made up of a combination of numbers and/or letters. This is a great way to help us match participants and eliminate the risk of duplicates.
- Each registration must be listed in a separate row. If a participant is attending multiple sessions, the spreadsheet must list one row for each registration.
- Each category of information must be listed in a separate column, and session/program names in the participant spreadsheet must match those listed in the group structure in your account.
Should I send a list of only the newest registrants or the entire master list to be imported?
It’s totally up to you. If you send the entire master list for each import, our system will filter out duplicates based on the unique identifier or using the first names, last names, and dates of birth of the participants.
Please use these templates when creating your group structure and formatting your roster spreadsheets.
In addition to importing your Groups, Participants, and Registrations, you can import your Tags. You can add columns for Tags to your Participant Import, or you can send us a file just for Tags. For every Tag Import:
- Each category of information must be listed in a separate column.
- Each row must include a first name, last name, date of birth, and identifier (if applicable) for the participant.
If you want to learn more about Tags, you can check out this article.
What if I don’t have my cabins or room assignments yet, and I want to add them as tags?
No problem! We can import your data without this information and then add cabins/room assignments when they are available.
Uploading An Import File
To upload an Import File to our data specialists:
- Log in to your Provider Portal.
- In the left column, in the Menu, click Data Import.
- In the submenu that appears, click Data Upload.
- Click the Choose File button, and then select the file that you want to import.
- Click the UPLOAD button. An Upload Complete window will appear.
All imports should be submitted through the Data Imports tab in the application. Once imported by our data team, the provider will receive a confirmation email.
If an import is not correctly formatted, a variety of issues can arise compromising participant registrations and privacy. When the data team receives an incorrectly formatted spreadsheet, the import will not be complete and the data team will reach out to the organization directly.
If an organization is unable to submit properly formatted spreadsheets, they may be asked to sign a waiver.