Excel Template for Skipper to Import Crew Members

Contains user manuals, frequently asked questions & responses. This is a read only forum.
Locked
User avatar
admin
Site Admin
Posts: 302
Joined: Fri Dec 28, 2018 11:51 am
Location: Portsmouth, RI
Contact:

Excel Template for Skipper to Import Crew Members

Post by admin »

Procedure Updated 26 February 2021

The attached Excel spreadsheet provides a template that may be populated with crew information. This allows easy importing into the Crew Manager site with many, but not all fields. Once a Crew member is imported, either the Skipper or Crew member may update fields in the users profile.

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.

Crew Manager Import Template

Download the custom Excel template available below to populate with crew names, emails, mobile phone numbers and other optional information.  This allows an easy method to add multiple crew to Crew Manager.   Template instructions and import directions are provided below.

Protections to Prevent Overwriting Existing Users

Duplicate Email Address Protection: Crew Manager employs a consolidated user database that spans across all sites.  Users on one site are not visible to other sites unless added by the Crew Manager administrator to additional sites.  This means that no login user name or email address may be used twice.  If a user exists on another site with the same email address being imported, that row will be skipped.  The Skipper importing users should look at their own site user list after import to verify all users were imported.  A Skipper who desires to add an existing user not successfully imported to their site should  send the user email address bypassed by the importer to admin@crew-mgr.com and the user will be added to the site requested.

Duplicate Username Protection: Should the Skipper attempt to import a user name (user_login) that already exists in the database, an import error "User with username xxxxxxxx exists, we ignore it" is displayed.  To correct this error, change the user_login in the CSV file (e.g. smith may be changed to smith1, jsmith, jsmith1, etc.). Save the file and run the import process again.  Users successfully imported the first time may be removed from the file, or remain which will result in the same error message for those users when reimported with no harm if the error is displayed. 

Import User Template Instructions
  1. Download the Excel spreadsheet available below and save it to your hard drive. The template has multiple tabs.
    Basic is the tab most Skippers will use.  This has fields most commonly used. The only mandatory fields are user_login and user_email (yellow background on template) but it is highly recommended that the fields for display_name, first_name and last_name be filled in, otherwise these will need to be manually edited individually after import. If the mobile phone numbers are known, the mobile field can be filled in too.
    All_Fields has a complete set of optional fields in addition to the basic fields.  This tab can save time if all the information is know, otherwise each crew member (or the skipper) may update the information later.
    Lookup_tables contains a mapping of clothing sizes and mobile carrier codes.  These values are entered in the respective fields for each user.
  2. Open the downloaded Excel file and populate each row with Crew information under the column names. There are comment bubbles in the template. You may delete these comments but do not need to since they are not saved in the CSV text file.
  3. Save the spreadsheet, first in native Excel format (allows easier updates in the future), then using the Save As menu option in Excel select the  CSV (Comma delimited) (*.csv) text file option. Before saving the file in CSV format, you may delete any rows with Crew who have already been imported but do not need to.  The importer will not reimport any users already in the database
  4. Reformat the file by closing Excel, then navigate to the directory where the CSV file was saved. Double click on the saved CSV file (not the xlsx file) to open it in Excel again. Click Save (not save as) to overwrite the existing CSV file saved in the previous step then close Excel. This removes extra commas that Excel inserted on the 1st save. Remember where the CSV file is stored so it may be accessed for import.
Import Crew Instructions
  1. Log in to your Crew Manager site as the Skipper if not already logged in.
  2. Once logged in mouse over Skipper on the menu and click on WordPress Admin.
  3. The WordPress Admin screen will load. On the left side menu, mouse over Crew Manager and click on Import Users. The Import Users from Excel Spreadsheet page will load.
  4. Scroll to the bottom and click the grey Choose File button located below the CSV file (required) label. When the dialog box opens, navigate to the directory where the CSV file containing the saved template is and select the file.
  5. Click on the blue button at the bottom of screen labeled Upload and Process.
When the upload is complete, the screen will display the list of Crew that were imported.  You should count the number of rows imported and compare with the number in the saved template file.   If there a fewer rows imported than in the file, it means a user already exists in the database, or there was an invalid field.  Invalid fields usually produce an error which may be corrected, and reimported.  If there are no errors, but a difference in the number of rows imported, send the saved template file to admin@crew-mgr.com with the email address of the skipped rows.

You may now review and edit any user information by mousing over Crew and clicking on Roster.  All crew names have links the Skipper may click on to open that users profile. Alternately return to WordPress Admin using the button below then mouse over Users and click on All Users.[acui_import]

Note: Updated template V2.2 created 27 December 2020 updates import field names and adds descriptions to help users. Supports extra user fields described in Extra Crew Profile Fields for Passport, Emergency Contact & Travel. Download the updated template at this link:
Attachments
Crew_Manager_User_Import_TemplateV2.2.xlsx
(22.55 KiB) Downloaded 420 times
Crew Manager Administrator
Image
Locked