Skip to content
ChessOS
Start free

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

  1. Open Members, press More and choose Import (CSV, Chess Nut, SwissSys). The screen is called Bring your members.
  2. 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.
  3. 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.
  4. Read 4. Review: New members, Already here, Need a look and Skipped.
  5. For each row under Need a look, press one choice. The highlighted one applies if you do nothing.
  6. Under Before you import, choose Members or Contacts. The welcome note is off by default.
  7. 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.
Was this article helpful?

Not really, tell us why

Related articles

All help topics