Import Athletes from a Registration File |
Top Previous Next |
This feature allows you to import the athletes into your MM Database from a semicolon delimited file that has been provided from a National or Regional Registration database. The file extension is RE1.
Click on File / Import / Registration File. Tell MM where the file is located and MM will import the athlete's last, first and preferred name, Registration ID, sex, birth date, and team. You may also choose any set of teams that are included in the file to filter only the information that you need for your meet. The feature is currently implemented for LSCs in the United States using USA Swimming's LSC Registration software LSCDB for Swimming.
The file format is as follows:
The first line contains information about the file. The 5 fields are:
File title Date file created Created by Version of software creating the file LSC code (optional)
All successive lines are for athletes, one line per athlete. The 10 fields are:
USSID or other ID Last Name First Name Middle Initial Gender (M/F) Birth Date (MM/DD/YYYY) Team Abbreviation Code (up to 5 characters) Team Name Preferred Athlete First Name Annual Registration (optional, "N" means Year Round, "S" is Seasonal)
A sample of the format with one athlete follows:
"USA Swimming Registration List";"5/28/2009";"LSCDB for Windows";"1.08";"SE" "030391JOHFDOEL";"Doel";"John";"J";"F";"03/03/1991";"HURR";"Hurricane Swim Club";"Johnny";"N"
|