Import and manage your member directory

You need the club admin or owner role. Only a club owner can import someone with the owner role. The member directory holds everyone in the club. Adding someone to a crew is a separate step.

Import members

Prepare a .csv file with a header row and no more than 100 member rows.
Open Members, then Import Members.
Choose your file and review the members it resolves.
Submit the import. Check the directory for the new members.

This example adds two fictional members. Replace their details before importing.

email,name,role,canCox,canSweepStrokeside,canSweepBowside,canScull,canCoach,isNovice,program,category
[email protected],Alex Morgan,member,false,true,true,false,false,false,Engineering,open
[email protected],Sam Taylor,member,true,false,false,false,false,true,History,women

Imports add club access. They do not send invitation emails. Give members the member getting-started guide and ask them to sign in with the address you imported.

CSV fields

Use the header names exactly as shown. Omit optional columns you do not need. If you include the role column, fill it with a supported value for each row.

Header	Accepted value
`email`	Required valid email address. Blades converts it to lowercase.
`name`	Full name. Supply it for new accounts, especially non-Cambridge addresses.
`role`	`member`, `admin` or `owner`. New accounts default to `member` when the column is omitted.
`canCox`	`true` or `false`.
`canSweepStrokeside`	`true` or `false`.
`canSweepBowside`	`true` or `false`.
`canScull`	`true` or `false`.
`canCoach`	`true` or `false`. This does not grant admin access.
`isNovice`	`true` or `false`.
`program`	Programme of study or other programme text.
`category`	`open` or `women`. A blank value is ignored.

Boolean fields recognise true without regard to case. Other text, including yes or 1, becomes false. Use true and false to avoid mistakes. Dietary requirements are not an import field; members enter them in their profiles.

Existing accounts and Cambridge names

If an email address already has a Blades account, the import adds that account to the club and keeps its existing profile. It does not replace the profile with your CSV values. If someone is already a member of the club, the import skips them. Reimporting a CSV does not update their profile or club role. For new Cambridge accounts, Blades tries to resolve the name through the university directory. A successful lookup can replace the supplied name. If no name can be resolved, the import needs a valid name in the file. A directory connection error may prevent the import from completing.

Find members and read feedback

Use the directory’s search field to find members by name. Search applies to the records already loaded, so use Load more when needed. Sort columns or change column visibility to compare rowing eligibility, category and other profile details. Use a member’s row action to view their feedback. To write new feedback, open the relevant session. The directory does not currently offer club-member removal or role editing. Removing someone from a crew only removes their membership of that crew.

Fix an import problem

Please upload a valid CSV file

Check the file format, exact header names, email addresses, role values and category values. Export a CSV rather than uploading a spreadsheet workbook. Remove optional columns you do not need.

Import at most 100 members at a time

Split the file into batches of at most 100 member rows. Keep the header row in every file.

Failed to resolve name for an email

Supply a full name for each new account. If a Cambridge directory request fails, the service’s directory connection may need attention.

No new users found in the uploaded file

The listed people may already belong to this club. Check the directory before trying again.

Set up your club

Plan your rowing

Account help

Import and manage your member directory

Import members

CSV fields

Existing accounts and Cambridge names

Find members and read feedback

Fix an import problem

​Import members

​CSV fields

​Existing accounts and Cambridge names

​Find members and read feedback

​Fix an import problem

Import members

CSV fields

Existing accounts and Cambridge names

Find members and read feedback

Fix an import problem