Bulk Import

Note: Entire HELP section  is searchable. If you do not see a topic  - you can search for it.
 

 Import Players from Excel

Create and save Excel file on your computer.
File format should be as shown  below.
Go to 'Utils' page
Browse to the Excel file and click Import button.

All the records with be imported with the exception of:
-duplicate records
-above subscription plan quota
-empty records
-not properly formatted records
Note:This function is available for Advanced plan
Important: 1st row must have column names:
First/Last names and Gender are required columns. Other columns are optional.
Column Names: 'First Name', Last Name', 'Gender','Age','Email', 'Phone','Notes'
 
 
 
 

 Import Teams from Excel

Create and save Excel file on your computer.
File format should be as shown  below.
Browse to the Excel file and click Import button.
All the records with be imported with the exception of:
-duplicate records
-above subscription plan quota
-empty records
-not properly formatted records
Note:This function is available for Advanced plan
Important: 1st row must have column names:
Team Name and Game Type are required columns. Notes column is optional.
Column Names: 'Team Name', 'Game Type', 'Notes'
 



 
 

 Import Players to Teams from Excel


It is similar to importing players from Excel. The file should be prepared as shown below.
Required Columns:
'First Name', 'Last Name', 'Gender','Team Name', 'Game Type'
Team record must be created prior to the import.




 

 Import Players to Singles Leagues/Tournaments


It is similar to importing players from Excel. The file should be prepared as shown below.
Required Columns:
'First Name', 'Last Name', 'Gender','League Name', 'Season'
League record must be created prior to the import
League/Tournament must have 'Registration' status. You can not add players to a 'started' league/tournament


 


 

 Import Teams to Leagues/Tournaments


It is similar to importing teams from Excel. The file should be prepared as shown below.
Required Columns:
'Team Name', 'Game Type', 'League Name', 'Season'. All other fields optional
League record must be created prior to the import.
League/Tournament must have 'Registration' status. You can not add teams to a 'started' league/tournament
!!!! Important. Your team and league/tournament  MUST have the same 'Game Type'
If your team has game type 'Soccer' and your league has game type 'Tennis' - it's a mismatch and your import will fail.


 


 

 Import Schedule Date/Time/Score/Location/Notes


In order order to import schedule date/time/score/locations/notes from Excel you must first export
one of you league schedules to Excel. The reason is that each exported record has an ID (see circled column). Without this ID you can not
import your schedule data back.



1) step Export Schedule to Excel
Go To Schedule page and click 'Export To Excel' button as shown below:



2) Save File to your computer. Very important to 'Save As' as Excel document as shown below. Otherwise you won't be able to
import it back



3) Your export is done and you now should have a similar looking file.




4) Change data (dates, times..) Do not change or remove ID column. If it is messed up your import will fail.
Below are some rules explaining how you need to format your import data
    All fields are optional with the exception of ID column
    a) Home Score, Guest Score - must be numbers (otherwise will not be loaded)
        Home Score, Guest Score can only be loaded for round robin leagues and social pairs.
        For Single/Double elimination tournaments and playoffs - home/guest scores CAN NOT be loaded.

    b)Location - must be a text field. If it is a number it will be ignored. Must be one of your existing location. If it is not recorgnised
     it will be ignored.
    c) Date/Time !!! are prepended with '*' symbol (see picture). You must keep it. It's inconvenient but it is one of the requirements in order to import dates correctly.



5) Once you have formatted/prepared your data go to 'Utils' screen and import your schedule:











If some of the records fail to insert/update during the import you can manually update it directly in the application

Contact Us  if you have questions




 
Comments