Choose import methodThese steps will guide you through the process of importing your membership database from Team Manager and results into SwimOffice. If your memberships are stored in some other format, please read how to import your membership database using our Excel spreadsheet below.Import membership database from Hy-Tek's Team ManagerTeam Manager (TM) is made by Hy-Tek, a separate company, so our systems are not connected to each other. Therefore you need to transfer your data from TM to SwimOffice. Note: If your team has Meet Manager, it likely has Team Manager as well.Prepare membership database and settingsFirst, prepare your settings and membership database for exporting. This is important to make your data as complete as possible to ensure a smooth transition to SwimOffice.If your team belongs to a governing organization such as Swim England or Canadian Swimming that assigns unique IDs to athletes (except for USA Swimming), please skip down to Clean up membership database. If your governing organization does NOT assign IDs to your athletes, or it is USA Swimming (USA-S), you need to make sure every athlete in your membership database has a unique ID. In Team Manager, click Teams in the main menu.Double click your team.Set your Team Registration dropdown to USS if it is not already.Click OK.Close the Teams screen.This enables the Build ID button on the Athlete Information screen to create IDs based on the USA Swimming format. The unique IDs are assembled from a swimmer's date of birth, first three letters of their first name, middle initial, and first four letters of their last name.Clean up membership databaseNext, check your membership data to ensure it is as complete and accurate as possible. Fields highlighted in yellow below are required.Click Athletes in the main menu.Double click the first athlete in the list. This opens the Athlete Information window.Athlete InformationAn athlete's First and Last Name are required. A Middle name or initial is now required by USA Swimming and highly recommended for all non-USA-S teams, as having one increases the probability of each athlete having a unique ID. Use an asterisk ( * ) if the athlete does not have a middle name.Birthdate and Gender are required.ID # is required, even for inactive athletes. Without it, it is impossible to connect the athlete with their meet results. Fill in the number assigned by your swimming governing body, or click Build ID if your governing body does not assign IDs and the ID # field is blank. Exception: If we won't be importing results for you, you will need to build IDs for all athletes once they are in SwimOffice for connecting with future results.Primary Mailing InformationOne parent's First and Last name are required for active athletes. It is good to have their address, although they can log in later to your SwimOffice site and add it themselves.Primary Contact InformationIt is good to have at least one phone number, although they can add it themselves in SwimOffice.At least one parent email is required for active athletes, because that's what the parents use to log in to SwimOffice, and our importer will not import the membership database without it.Click the arrow in the lower right to move to the next athlete.Click OK when finished with all athletes.Scroll through your athletes and make sure every single cell in the ID column is filled in, then click the lower close X in the upper right.Export membership databaseClick File > Export > Athlete Fields in CSV format. This opens the Athlete Fields Export to CSV window.Check the Include Inactive box.Click Select All and Yes to confirm. Don't worry that Athlete Age isn't checked because we don't use that field.If your version of TM does not have a Select All button, manually check every single checkbox in the Fields list.Click Create Export File and Yes to confirm.Note the filename and where it was saved, then click OK.Click Close.Export meet resultsThese instructions are for Team Manager. UK users see below to export from SPORTSYSTEMS.Click File > Export > Meet Results. This will open the Export Results window.Check the Export Splits box.Check the Include Inactive Athletes box.If there is an Include Swimmers with No Results box, make sure it is unchecked.Click OK. A progress meter will activate.Note the filename and where it was saved, then click OK.Click Close. Export results from SPORTSYSTEMSIn the menu click Meet > Export > SDIF to open the Standard Data Interchange Format Export dialog box.Choose All or Club from the Export By box and select the clubs, fill in the City/Town details, and click Export.A pop-up box will confirm the export is complete. The exported file is saved as an SDIF file (sd3 file extension) in a sub-folder called SDIFRank in the main meet folder.Upload membership database and results into SwimOfficeSign In to your SwimOffice site if you haven't already.From the left navigation menu click Help & Training > Deployment Dashboard.Scroll down and click the DATABASE MIGRATION header to open that section if it is not already.Click Member Database Upload.Locate, select and open the membership file.Click Times Database Upload.Locate the results file where TM saved it and double click it (or click it once and click Open).Click Save/Upload.The TU Deployment staff is notified when this action is completed. They verify that the data in the files are usable, import the data into SwimOffice, and mark the tasks as complete in the Deployment Dashboard.Note: TM will export the membership data with the father's email as the primary address, and everyone in the Account will use that for signing in to SwimOffice. If your team would rather have the mother's email be the primary, email deploy@teamunify.com to let us know that and we will make the switch on the backend.Import membership database from a spreadsheetIf your membership database is stored in some format other than Hy-Tek's Team Manager, you may transfer your data to our membership database spreadsheet.Transfer membership database to a spreadsheetSign In to your SwimOffice site if you haven't already.In the side menu click Help & Training > Deployment Dashboard.Scroll down and click the DATABASE MIGRATION header to open that section if it is not already.Click Download Excel Template.Open the spreadsheet and transfer your membership database into it.Please DO NOT CHANGE THE HEADERS (column names), and do not add extra columns. Please contact Deployment if you have questions about any columns or data you want to include.Data for all columns with a red header is REQUIRED. We cannot accept the spreadsheet if ANY of those fields are blank, except for Member Middle Initial if you are NOT an official USA Swimming team (although it's highly recommended), and ID Card since we won't be importing results for you (because they can only be imported from Team Manager). However, you will need to build IDs for all athletes once they are in SwimOffice for connecting with future results.Click select column headers to see a note with more details about the field (at least when using Excel).Columns A-Q all relate to the Member or child. Columns from R on relate to the Account or parent(s).Save the spreadsheet once you've entered all membership data.Upload spreadsheet into SwimOfficeSign In to your SwimOffice site if you haven't already.From the left navigation menu, click Help & Training > Deployment Dashboard.Scroll down and click the DATABASE MIGRATION header to open that section if it is not already.Click Member Database Upload.Locate the spreadsheet file where you saved it and double click it (or click it once and click Open).Check Not Needed under the Times Database Upload button. (You will have an opportunity later to enter times if you have them.)Click Save/Upload.The TU Deployment staff is then notified automatically. They verify that the data in the files are usable, import the data into SwimOffice, and mark the tasks as complete in the Deployment Dashboard.