Import Rosters from Active.com

Top  Previous  Next

This option is primarily for Road Races where athletes have entered the race through the Active.com web site and allows you to import athlete information from a comma separated file (csv file) which has been downloaded from the Active Registration Center.

 

Assuming entries are completed, the steps for creating your csv file are listed here.

 

Click on the Download Registrations choice under Registration Tools as shown in the menu listing below.

 

ActiveRegCenterHeader

 

ActiveRegCenterMenu

After clicking on Download Registrations, click on Build New Profile.

 

ActiveRegCenterBuildProfile

 

Fields that can be exported are displayed in the left column as shown below. You will select the fields you want on the left and click the arrow to move the desired fields to the right column. Only the selected fields will be exported. The mandatory fields are FirstName, LastName, and Gender.

 

ActiveRegCenterBuildProfile2

ActiveRegCenterBuildProfile3

ActiveRegCenterBuildProfile4

 

After selecting your fields and clicking Next, the following screen will appear with instructions for formatting your fields.

Do not check any of the Append to check boxes.

In the Limit Character Field Length boxes, MM will automatically limit the FirstName and LastName to 20 characters each, 1 for MiddleName, 40 for Email, 25 each for Address1 and Address2, and 20 for City.

 

ActiveRegCenterBuildProfile5

ActiveRegCenterBuildProfile6

ActiveRegCenterBuildProfile4

 

After entering your field lengths and clicking Next, you enter the parameters for the text file export.

You can leave all settings as is, but the Field delimiter must be a semi-colon or comma where semi-colon is the preferred delimiter, so type in a semi-colon in the "Other:" box as shown below.

Enter a descriptive name for the Profile in the Save profile as... text box and click Next.

 

ActiveRegCenterBuildProfile7

ActiveRegCenterBuildProfile8

At this point you are ready to download the file.

Select All records as shown below and then click Download File and select Save to Disk (not Open File).

If given the option, provide a name for the file and select your preferred location on your computer. The file extension name can be .csv or .txt.

If you wish to look at the contents of the file before downloading, click Preview and follow the instructions.

 

ActiveRegCenterBuildProfile9