How do I match columns and fix problem rows when importing members?
Under Members > More > Import, pick a source and file, match its columns, resolve duplicates and problem rows, then import as members or contacts.
Posted Last updated Last reviewed
The import screen reads a list of people and shows what would happen before anything is saved.
Steps
- Open Members, press More and choose Import (CSV, Chess Nut, SwissSys). The screen is called Bring your members.
- Under 1. Source, pick Chess Nut, SwissSys, Spreadsheet or WinTD / TRF. Under 2. File, press Choose a file. Excel (.xlsx) and CSV work; save an old .xls as one of those first.
- Under 3. Match columns, set what each Column in your file Becomes. Choose First name + Last name for one full-name column, Preferred name (goes by) for a column such as "Nickname" or "Goes by", or Skip for columns you do not want. At least one column must hold names. Your choices are remembered in this browser.
- Read 4. Review: New members, Already here, Need a look and Skipped.
- For each row under Need a look, press one choice. The highlighted one applies if you do nothing.
- Under Before you import, choose Members or Contacts. The welcome note is off by default.
- Press the Import button, which shows how many will be added.
What the problem rows mean
- No first and last name: can only be skipped.
- US Chess ID is not 8 digits: Import without ID or Skip.
- Same ID as a member with a different name: Merge (fills only blank details), Keep both or Skip.
- An earlier row has the same ID: Skip or Import without ID.
- A junior with no guardian email or phone: Import or Skip.
Good to know
- People already in the club are matched by US Chess ID or exact name.
- A preferred name fills in only where the person has none yet; it never replaces a name already entered, and the first and last name stay as US Chess has them.
- Ratings and expiry come from US Chess by ID, read in the background right after the import. A rating or expiry column in your file is used only for people without an ID.
- This screen cannot undo an import. The one under Settings > Moving to ChessOS can; see moving from another system.