TeamUnify - Team Roster Import (.xlsx or .xls) – SwimTopia Help Center

» Note: If your team roster and time history are available in Hy-Tek Team Manager, ➞ See our instructions for Team Manager - Team Roster & Time History Import (.mdb). If you are a non-swim team using our Team Topia product, ➞ See Excel Spreadsheet - Team Roster Import (.xlsx or .xls)

Team Roster Export from TeamUnify

We can import your Team Roster from your existing TeamUnify database into your SwimTopia website. For future seasons, SwimTopia’s Registration process will collect all the personal data for you.

In TeamUnify, the team roster is exported as follows (assuming this has not changed):

Login to your TeamUnify account
Go to Back Office > Org Tools > Members
Click the checkbox to the left of "Last Name" to select all active members.
Click the Export button and then Custom Excel Report.
In the dialog that opens, click Select All.

6. Click Create Report. This should create a report ending in .xlsx

» Minimum Required Properties: If you would prefer not to include all of the details in the Team Unify export, the minimum required fields are included in this template ➞ roster-upload-template.xls

Import Your File Into Your Team Site

After you have exported your data, your next step is to import this data into your new SwimTopia site.

This is done from your Settings > Import Roster or Time History page as shown below.

➞ You can also reference the Import Roster or Time History article for instructions as needed.

Time History & Best Times

TeamUnify does not provide an option to export your team’s time history in a format we can import. However, we highly suggest downloading your team's time history report (steps below) before closing down your account if you want to obtain this information and access it if we are able to provide a way to import this information in a future release.

» Note: If your team roster and time history are available in Team Manager, you'll have better results using a Hy-Tek export.

➧ Exporting Time History from TeamUnify

Step 1) Log in to TeamUnify as Admin

Step 2) Choose Time Reports from the left navigation

Step 3) Choose Top Times by Athlete

Set Course
Select all Meet Types
Set "In this period" to your date range
Select "All" for all other fields, except "Show Top"
Set "Show Top" to 0 to get all times
Click Report Now

Step 4) Click Save As Excel from the report results page

➧ Importing Time History and/or Best Times in SwimTopia

Even though TeamUnify does not provide the export data in a format we can import, if you have individual meet’s Meet Results files you can import those into your SwimTopia site to get historical times. If you just want to capture your athletes’ best times, you can do that as well.

➞ See Time History Import (via results files) or Manually Add Best Times for step-by-step instructions.

Viewing Imported Data & Exporting Roster

After your data is imported ➞ See our tutorial on Viewing your Team Roster and History.

To export your roster from your team site ➞ See our Exporting Athlete/Team Roster Report article.

What's Next...How do Parents Log In?

Your parents create their accounts thru the registration process. Regardless of whether you imported a past or current season roster, we suggest that you create a registration form and invite your parents to register so they can activate their accounts by setting a password.

This can be a simple form for collecting contact information or you can use all sections of the form as needed. Each season they register to be affiliated with the current season, but they don’t have to activate their accounts more than once.

See ➞ Creating New Accounts - How do Parents Log In? for more details.

Need Help?

If you have any questions about this format or the roster import process, here are our SwimTopia Support Options for assistance.

hcmanagesettings hcmanagesettingsimportrosterortimehistory hcteamunifyimport

roster-upload-template.xls
30 KB Download