Spreadsheet Import - Column Details

    Required Columns

    Emails

    The person's email addresses.

    Aliases
    Valid alternate header values
    email
    emailaddress
    email_address
    email-address
    email address
    email_addresses
    email-addresses
    email addresses

    Channel IDs

    Unique codes for the Share911 Communication Channels that the user should have access to.

    Every channel in Share911 has its own unique code which you can see in the URL for that channel or in Manage Channel > Channel Info. If you would like to use your organization's own location IDs you can do that as well, just first add the appropriate Work Place or Location ID to the corresponding Share911 channel in Manage Channel > Registration.

    Aliases
    Valid alternate header values
    channelid
    channel_id
    channelids
    channel_ids
    channel-ids
    location
    locations
    locationid
    location_id
    location-id
    location id
    locationids
    location_ids
    location-ids
    location ids

    Optional Columns

    Employee ID

    Unique employee identification number.

    Aliases
    Valid alternate header values
    employeeid
    employee_id
    employee-id
    employee id
    employeenumber
    employee_number
    employee-number
    employee number

    First Name

    Given name.

    Aliases
    Valid alternate header values
    first
    firstname
    first_name
    first-name
    givenname
    given_name
    given-name
    given name

    Last Name

    Surname/family name.

    Aliases
    Valid alternate header values
    last
    lastname
    last_name
    last-name
    surname
    familyname
    family_name
    family-name
    family name

    Mobile

    Mobile phone number. Used when sending text messages.

    Aliases
    Valid alternate header values
    phone
    phonenumber
    phone_number
    phone-number
    phone number
    mobile_number
    mobile-number
    mobile number

    Title

    Job title.

    Aliases
    Valid alternate header values
    jobtitle
    job_title
    job-title
    job title

    Shift

    Assigned work shift.

    Aliases
    Valid alternate header values
    workshift
    work_shift
    work-shift
    work shift

    Manager IDs

    Manager's employee identification numbers.

    Aliases
    Valid alternate header values
    managerid
    manager_id
    manager-id
    manager id
    managerids
    manager_ids
    manager-ids
    manager ids
    manageremployeenumber
    manager_employee_number
    manager-employee-number
    manager employee number
    manageremployeenumbers
    manager_employee_numbers
    manager-employee-numbers
    manager employee numbers
    manageremployeeid
    manager_employee_id
    manager-employee-id
    manager employee id
    manageremployeeids
    manager_employee_ids
    manager-employee-ids
    manager employee ids

    Emergency Contact Name

    Emergency contact's name.

    Aliases
    Valid alternate header values
    contactname
    contact_name
    contact-name
    contact name
    emergency contact name
    emergencycontactname
    emergency-contact-name
    emergency_contact_name

    Emergency Contact Phone

    Emergency contact's phone number.

    Aliases
    Valid alternate header values
    contactphone
    contact_phone
    contact-phone
    contact phone
    emergencycontactphone
    emergency_contact_phone
    emergency-contact-phone
    emergency contact phone

    Emergency Contact Email

    Emergency contact's email address.

    Aliases
    Valid alternate header values
    contactemail
    contact_email
    contact-email
    contact email
    emergencycontactemail
    emergency_contact_email
    emergency-contact-email
    emergency contact email

    Permissions

    Granted channel permissions.

    Aliases
    Valid alternate header values
    permission
    permissions
    role
    roles

    An optional Permissions column can be included if you wish to set users' permissions during the upload. The Permissions column can have one of the following values per row:

    Empty / Blank

    Leaving the Permissions column empty, or not including the column at all, will leave the user with their current permissions unchanged. Newly created users will receive the default permissions for each channel.

    For instructions on how to set default permissions, please see the "How to Set Default Permissions" video on our Video Training for Administrators page.

    List of Permissions

    Permissions that should be applied to every channel the user has access to.

    For a description of the permissions available in Share911, please see the What are User Permissions help page.

    Example

    Granting permissions
    Action Emails Channel IDs Permissions
    save sally.brown@example.com 00000A, 00000B, 00000C Liveview, Check-in

    In this example, Sally would end up having Liveview and Check-in permission in each of her 3 channels.

    Granting Permissions on Specific Channels

    For more fine-grained control, use JSON format to specify permissions for specific channels.

    Example

    Using JSON format to specify permissions for specific channels
    Action Emails Channel IDs Permissions
    save sally.brown@example.com 00000A, 00000B, 00000C {“00000A”: [“Liveview”, “Check-in”, “Manage Users”], “00000B”: [“Liveview”, “Check-in”, “Broadcast Alert”]}

    In this example, Sally would end up having different permissions for each of her channels:

    • 00000A - Liveview, Check-in, and Manage Users
    • 00000B - Liveview, Check-in, and Broadcast Alert
    • 00000C - Channel's default permissions.

    User Groups

    Aliases
    Valid alternate header values
    usergroup
    user_group
    user-group
    user group
    usergroups
    user_groups
    user-groups
    user groups
    departmentcode
    department_code
    department-code
    department code
    departmentid
    department_id
    department-id
    department id
    deptcode
    dept_code
    dept-code
    dept code
    deptid
    dept_id
    dept-id
    dept id

    An optional User Groups column can be included if you wish to set users' groups during the upload. The User Groups column can have one of the following values per row:

    Empty / Blank

    Leaving the User Groups column empty, or not including the column at all, will leave the user with their current User Groups unchanged.

    DELETE

    A value of "DELETE" in the User Groups column will remove the user from all user groups across all of their channels.

    Example

    Removing all User Groups
    Action Emails Channel IDs User Groups
    save sally.brown@example.com 00000A, 00000B, 00000C DELETE

    In this example, Sally would no longer be in any User Groups.

    List of User Groups

    The set of User Groups that the user should be a member of across all channels that the user has access to.

    Example

    User Groups by List
    Action Emails Channel IDs User Groups
    save sally.brown@example.com 00000A, 00000B, 00000C SECURITY, MEDICAL

    In this example, Sally would end up being a member of the SECURITY and MEDICAL user groups in each of her 3 channels.

    Setting User Groups on Specific Channels

    For more fine-grained control, use JSON format to specify User Groups for specific channels.

    Example

    Using JSON format to specify User Groups for specific channels
    Action Emails Channel IDs User Groups
    save sally.brown@example.com 00000A, 00000B, 00000C {"00000A": ["ADMINISTRATION", "FACILITIES"], "00000B": ["MEDICAL"], "00000C": ["SECURITY"]}

    In this example, Sally would end up having different user groups for each of her channels:

    • 00000A - ADMINISTRATION and FACILITIES
    • 00000B - MEDICAL
    • 00000C - SECURITY

    Manually Managed Channels

    DEPRECATED - This column is no longer used.