Excel Template for Skipper to Import Crew Members

Contains user manuals, frequently asked questions & responses. This is a read only forum.
User avatar
Site Admin
Posts: 16
Joined: Fri Dec 28, 2018 11:51 am

Excel Template for Skipper to Import Crew Members

Post by admin » Fri Jan 04, 2019 11:06 am

The attached Excel spreadsheet provides a template that may be populated with crew information. This allows easy importing into the Crew Manager site.

The WordPress plugin “Import users from CSV with meta” is installed on all sites to allow a convenient method to import a list of users all at once. This is typically only done when Crew Manager is initially setup for a boat.
  1. Download the attached spreadsheet and save on your hard drive.
  2. Open in Excel and populate each row in the spreadsheet with Crew information under the column names. The only mandatory fields are Username and email. Other fields are optional and may be edited later in the WordPress user’s profile by either the Skipper or the Crew member. There are comments in the template. Delete these comments.
  3. Save the spreadsheet, first in native Excel format (allows easier updates in the future), then using the Save As menu option in Excel as a CSV (Comma delimited) (*.csv) text file.
  4. Log in to your Crew Manager site as the Skipper if you have multiple logins.
  5. Once logged in mouse over Skipper on the menu and click on WordPress Admin.
  6. The WordPress Admin screen will load. On the left side menu, mouse over Tools and click on Import users from CSV.

    The plugin will load and provide a plethora of options. If this is a one time upload, just use the default settings.
  7. Click on the Choose File button located to the right of the CSV file (required) label. When the dialog box opens, navigate to the directory where the CSV file containing the Crew was saved and select the file.
  8. Click on the blue button at the bottom of the plugin Admin screen labeled Start Importing.
When the upload is complete, the screen will display the list of Crew that were imported. You may now review and edit any user information by mousing over Users and clicking on All Users.
(12.11 KiB) Downloaded 22 times
Crew Manager Administrator