Export LeagueApps Data to Import into Demosphere

Admins and organizers can export registrant details from LeagueApps and import this data directly into Demosphere. 

Step 1: Turn on Required Form Fields in LeagueApps

NOTE: The following option fields must be marked as required and filled in when a participant is registering in LeagueApps, in order for the data to be imported into Demosphere.

  1. Sign in to your LeagueApps Management Console
  2. Go to the Settings dropdown and click Member Profile under the Members header
  3. Under Basic Field Settings, click the toggle on for the following:
    1. Require Member Address
    2. Require Child Birth Date

 

Step 2: Export from LeagueApps

To export registration data from LeagueApps:

  1. Sign in to your LeagueApps Management Console
  2. Tap the Search icon Screen_Shot_2021-05-17_at_2.24.15_PM2.png in the top right corner and type in your team or league name in the search box
  3. Hover over the People tab and click Players
  4. Select any Filters if applicable
  5. Click the Export to CSV button
  6. In the pop-up, these columns must be selected to be included in the export (as well as any other columns you would like to include):
    • First Name
    • Last Name
    • Birthdate
    • Parent 1 First Name
    • Parent 1 Last Name
    • Parent 1 Email 
    • Address
    • City
    • State
    • Zip
  7. Click the Export button in the pop-up

 

Step 3: Map Data Columns in Demosphere Template

  1. After the file automatically downloads, open the file
  2. Click to download and open Demosphere's Registration Import Template
  3. Copy the data from your LeagueApps export file and paste it into the associated column in the Demosphere template's REQUIRED FIELDS sheet tab:
    • First Name = Participant First Name
    • Last Name = Participant Last Name
    • Parent 1 Last Name = Household Name
    • Birthdate = Participant Birthdate
    • Parent 1 First Name = Parent 1 First Name
    • Parent 1 Last Name = Parent 1 Last Name
    • Parent 1 Email = Parent 1 Email
    • Address = Household Street
    • City = Household City
    • State = Household State
    • Zip = Household Zipcode
    • If needed, paste any additional information into the OPTIONAL sheet tab's associated columns in the template.
  4. When you have finished filling in the Registration Import Template, save that excel file

Step 4: Import LeagueApps data into Demosphere

Send an email to support@demosphere.com, attaching your updated Registration Import Template excel file, as well as the program and season name(s) in Demosphere that you want to import your data into.

Was this article helpful?
0 out of 0 found this helpful