Must know
- Verify list only reads. It never adds anyone, issues a member number or changes your register.
- Up to 5,000 rows per check. Only the first 5,000 rows of a longer file are checked, so split it.
- A member number in the file answers first. Without one, a row matches on name and date of birth together. Capitals, accents and punctuation don’t matter.
- A Match is not good standing. Read Status before you clear anyone.
1
Open Verify list
Go to Athletes > Directory and, on the Members tab, select Verify list. You need the Manage memberships permission.
2
Add your list
Drop a file under CSV or Excel file, or paste rows under Or paste the rows. The first row is the header.
3
Check the columns
Under Which column is which, Uplifter guesses Last name, First name, Date of birth (YYYY-MM-DD) and Member ID (optional) from your headers. Change any guess, or choose Not in this file.
4
Select Check [N] rows
The button needs Last name or Member ID mapped. What we found lists Row, Name, Result, Status, Member number, Organization and Membership; the last four fill in only for a Match. Filter by result to narrow it.
Read Status beside a Match. It shows the membership that covers today, otherwise the latest one. Only a membership that covers today shows green. Not started means its term begins later. Expired, Suspended and Revoked are not cover.
Download the results. Select Download results (Download filtered results while a filter is on) for a CSV. It adds Term start, Term end and, for Ambiguous rows, Could be. The download checks your register again, so it can differ from the screen.
Related: What is my member register? · How do I import my register from a spreadsheet?