Must know
- Nothing is written to your register until you accept the report and select Start import.
- You start spreadsheet imports yourself. An import of your old database is started for you.
- A cancelled import files nothing. It stays on your list of imports as Cancelled.
- You need the Manage memberships permission.
1
Upload your file
Select Import a spreadsheet. Under Your register file, add a .xlsx, .xls or .csv up to 50 MB, with one row per member, per season.
2
Confirm how it reads
Check Sheet, Header row (rows above it are ignored) and Dates read as: dates read Day first (31/12/2010) unless you choose Month first (12/31/2010). Under What each column holds, check every Holds choice against Your first rows: they are only a starting point. Map the name (Full name, or First name and Last name) and Date of birth, or the import cannot start.
3
Date your seasons
If you map a column to Season, give each season its Starts and Ends. A season left blank takes the dates you give when you accept. Map Email too, or a member listed in two seasons reads as two people and goes to your review queue with no membership.
4
Read the list
Select Read list. You see “Your register has been read. Check the report before anything is written.” and land on the Import report.
5
Check the report
On Summary, tiles show Rows, Can be matched and Cannot be matched (imported and numbered, never matched). Member numbers says where new numbers start. Other tabs: Duplicates, Your organizations, Memberships and Field map.
6
Accept the report
Select Accept report and answer the sheet (below). Until you start, Edit answers reopens it.
7
Start the import
Select Start import. You see “The import has started.” On your list of imports, Status reads Importing, then Finished. Select Review matches to work any held rows.
If a column is wrong. On Field map, select Remap columns and read your file again. This drops your acceptance. A report that changes after you accept it shows “This report has changed since it was accepted” and must be accepted again.
Cancel an import. Until it starts, select Cancel import at the foot of Summary, then confirm, or choose Keep it.
Old database imports. You accept the report, but Start import is not offered to you; the import is started for you.
Related: How do I review held rows from an import? · How do I send members their claim links? · How do I review a member list a club sent me?