How to Prepare a CSV of Users to Import to Wyse Management Suite

Summary: Learn how to create a CSV of users to import into Wyse Management Suite by following these instructions.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Instructions

Wyse Management Suite can import a CSV of users to import multiple users at once. This can be built in Excel or a Text Editor. Click the appropriate method for more information.

 
  1. Open Microsoft Excel.
    Microsoft Excel
  2. In the first horizontal line, input the following categories across the first fourteen cells:
    1. Email address
    2. Login name
    3. First name
    4. Last name
    5. Title
    6. Mobile phone number
    7. Exchange user
    8. Exchange email address
    9. IMAP user
    10. IMAP email address
    11. POP user
    12. POP email address
    13. Office 365 user (UPN)
    14. iOS Contacts & calendar username
    How to Create the Bulk Import CSV File instructions
    Note: When creating the file by Excel:
    • Properties are not separated by commas.
    • Not required properties should have the cell left blank.
  3. By line, populate the user information for each account under the relevant category. Email address, Login name, First name, and Last name are required, all other fields are optional.
    Example Excel CSV
  1. Open a text editor.
    Example text editor Notepad
  2. In the first line, input the following categories separated by commas:
    1. Email address
    2. Login name
    3. First name
    4. Last name
    5. Title
    6. Mobile phone number
    7. Exchange user
    8. Exchange email address
    9. IMAP user
    10. IMAP email address
    11. POP user
    12. POP email address
    13. Office 365 user (UPN)
    14. iOS Contacts & calendar username
    How to Create the Bulk Import CSV File instructions
    Note: When creating the file by text editor:
    • Properties are separated by commas.
    • Not required properties require a comma to move to the next property.
  3. By line, populate the user information for each account under the relevant category. Email address, Login name, First name, and Last name are required, all other fields are optional. An example CSV created by text editor may look like: 
    Email address,Login name,First name,Last name,Title,Mobile phone number,Exchange user,Exchange email address,IMAP user,IMAP email address,POP user,POP email address,Office 365 user (UPN),iOS contacts & calendar username
testuser1@company.local,testuser1,Test,One,Title,,,,,,,,testuser1@company.local,
Testuser2@company.local,testuser2,Test,Two,,,,Testuser2@company.local,,,,,,

Affected Products

Wyse Management Suite
Article Properties
Article Number: 000126010
Article Type: How To
Last Modified: 01 Aug 2024
Version:  5
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.