{"id":76678,"date":"2023-05-19T13:26:02","date_gmt":"2023-05-19T17:26:02","guid":{"rendered":"https:\/\/jumpcloud.com\/?post_type=support&#038;p=76678"},"modified":"2024-09-19T17:13:09","modified_gmt":"2024-09-19T21:13:09","slug":"import-users-from-csv-with-powershell-module","status":"publish","type":"support","link":"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module","title":{"rendered":"Import Users from CSV with the PowerShell Module"},"content":{"rendered":"\n<p>The&nbsp;<a href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\" target=\"_blank\" rel=\"noreferrer noopener\">JumpCloud PowerShell Module<\/a>&nbsp;contains two CSV import-specific commands designed to be used in tandem for importing users into JumpCloud from a CSV file. The first command creates the .CSV import template file on the local machine, which administrators then populate with their end user information and import with the second command.<\/p>\n\n\n\n<div class=\"wp-block-cgb-notification-card-wysiwyg notification-card note\"><div class=\"notification-card-content\"><div class=\"notification-card-icon\"><p><img decoding=\"async\" src=\"\/wp-content\/themes\/jumpcloud\/assets\/images\/gutenberg-blocks\/note-icon.png\" \/><\/p><\/div><div class=\"notification-card-copy is-type-body-default\"><div><strong class=\"notification-card-type\">Note:<\/strong> \n<p>Need to install the module? The module can be installed on Mac, Windows, and Linux in a&nbsp;<a href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\/Installing-the-JumpCloud-PowerShell-Module\" target=\"_blank\" rel=\"noreferrer noopener\">few quick steps<\/a><em>.<\/em><\/p>\n <\/div><\/div><\/div><\/div>\n\n\n\n<p>Using this import workflow, JumpCloud administrators can:<\/p>\n\n\n\n<ul>\n<li>Create JumpCloud users.<\/li>\n\n\n\n<li>Add JumpCloud users to JumpCloud user groups.<\/li>\n\n\n\n<li>Bind JumpCloud users to JumpCloud systems with either standard or administrator system permissions.<\/li>\n\n\n\n<li>Add custom attributes to JumpCloud users.<\/li>\n<\/ul>\n\n\n\n<p>By adding JumpCloud users to JumpCloud user groups during import, administrators can:<\/p>\n\n\n\n<ul>\n<li>Grant JumpCloud users access to JumpCloud SSO applications.<\/li>\n\n\n\n<li>Grant JumpCloud users permissions to JumpCloud System Groups.<\/li>\n\n\n\n<li>Add JumpCloud users to JumpCloud LDAP and Radius.<\/li>\n\n\n\n<li>Add JumpCloud users to the JumpCloud Microsoft 365 or Google Workspace directory integrations.\n<ul>\n<li>Take over existing user accounts or provision new user accounts in Microsoft 365 or Google Workspace.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>Considerations<\/strong>:<\/p>\n\n\n\n<ul>\n<li>Each user you import must be a unique user with a unique email address.<\/li>\n\n\n\n<li>The user state assigned to these imported users, staged or active, is determined by the setting under: <strong>Settings<\/strong> &gt; <strong>User Management<\/strong> &gt; <strong>Default User State for User Creation<\/strong> &gt;&nbsp;<strong>CSV Import \/ Bulk User API Import<\/strong>.&nbsp;<\/li>\n\n\n\n<li>Don&#8217;t import users that you don&#8217;t intend to manage with JumpCloud. You have 48 hours to remove unwanted users and to contact your Technical Account Manager to avoid being charged for any users you remove after import.&nbsp;<\/li>\n\n\n\n<li>You can also&nbsp;import users via CSV&nbsp;in the Admin Portal. See <a href=\"https:\/\/jumpcloud.com\/support\/add-users-to-admin-portal\" target=\"_blank\" rel=\"noreferrer noopener\">Add Users to the Admin Portal<\/a>.<\/li>\n\n\n\n<li>Custom attributes are only presented over the JumpCloud API. Custom attributes aren\u2019t presented over JumpCloud LDAP.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-cgb-notification-card-wysiwyg notification-card important\"><div class=\"notification-card-content\"><div class=\"notification-card-icon\"><p><img decoding=\"async\" src=\"\/wp-content\/themes\/jumpcloud\/assets\/images\/gutenberg-blocks\/important-icon.png\" \/><\/p><\/div><div class=\"notification-card-copy is-type-body-default\"><div><strong class=\"notification-card-type\">Important:<\/strong> \n<p>Active users created with a password aren\u2019t sent an activation email on CSV import. If you do <strong>NOT<\/strong> want JumpCloud to send emails to your users, you <strong>MUST<\/strong> set user passwords. Note that emails will never be trigger for users created as staged. <\/p>\n <\/div><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-creating-the-csv-import-file\">Creating the CSV Import File<\/h2>\n\n\n\n<p>The command <code>New-JCImportTemplate<\/code> creates a blank CSV import file on a JumpCloud administrator&#8217;s local machine.<\/p>\n\n\n\n<p>To run the command, open a PowerShell terminal and enter the PowerShell command at the prompt:<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>New-JCImportTemplate<\/p>\n<\/div><\/div>\n\n\n\n<p>After running the command, administrators will be asked a series of interactive questions in the terminal. The answers to these questions will define the column headers that are added to the CSV template file that is created by this command. The questions that are asked are shown below.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-question-1\">Question 1<\/h3>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>The CSV file will be created within the directory:<br>\/Users\/buster<br>Enter Y to confirm or N to change output location:<\/p>\n<\/div><\/div>\n\n\n\n<p>This file is created within the current working directory of the PowerShell session by default.<\/p>\n\n\n\n<ul>\n<li>To create the file in this location, press <strong>Y<\/strong>.<\/li>\n\n\n\n<li>If you want to choose a different output location, press <strong>N<\/strong> and provide a full path to the folder where you want to create the file.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-question-2\">Question 2<\/h3>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Do you want to create an import CSV template for creating new users or for updating existing users?<br>Enter &#8220;N&#8221; for to create a template for new users<br>Enter &#8220;U&#8221; for creating a template for updating existing users<br>Enter N for &#8216;new users&#8217; or U for &#8216;updating users&#8217;:<\/p>\n<\/div><\/div>\n\n\n\n<ul>\n<li>To create a CSV new user import file, press <strong>N<\/strong>.<\/li>\n\n\n\n<li>If you want to create a CSV update file instead, press <strong>U<\/strong> at this prompt and refer to the article <a href=\"https:\/\/jumpcloud.com\/support\/update-users-from-csv-file\" target=\"_blank\" rel=\"noreferrer noopener\">Update Users from a CSV File<\/a>.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-question-3\">Question 3<\/h3>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Do you want to add extended user information attributes available over JumpCloud LDAP to your users during import?<br>Extended user information attributes include: MiddleName, preferredName, jobTitle, employeeIdentifier, department, costCenter, company, employeeType, description, and location<br>Enter Y for Yes or N for No:<\/p>\n<\/div><\/div>\n\n\n\n<ul>\n<li>To add columns to the import file for adding extended user information attributes, enter <strong>Y<\/strong> at the prompt. \n<ul>\n<li>Fields to import all extended user information attributes will be added to the import file. <\/li>\n\n\n\n<li>Only fields populated with information will be imported.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-question-4\">Question 4<\/h3>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Do you want to add extended user location attributes available over JumpCloud LDAP to your users during import?<br>Extended user location attributes include: home_streetAddress, home_poBox, home_city, home_state, home_postalCode, home_country, work_streetAddress, work_poBox, work_city, work_state, work_postalCode, work_country<\/p>\n<\/div><\/div>\n\n\n\n<ul>\n<li>To add columns to the import file for adding location attributes, enter <strong>Y<\/strong> at the prompt. \n<ul>\n<li>Fields to import all location attributes will be added to the import file. <\/li>\n\n\n\n<li>Only fields populated with information will be imported.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-question-5\">Question 5<\/h3>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Do you want to add extended user telephony attributes available over JumpCloud LDAP to your users during import?<br>Extended user telephony attributes include: mobile_number, home_number, work_number, work_mobile_number, work_fax_number<\/p>\n<\/div><\/div>\n\n\n\n<ul>\n<li>To add columns to the import file for adding telephony attributes, enter <strong>Y<\/strong> at the prompt. \n<ul>\n<li>Fields to import all telephony attributes will be added to the update file. <\/li>\n\n\n\n<li>Only fields populated with information will be imported.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-question-6\">Question 6<\/h3>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Do you want to bind your new users to existing JumpCloud systems during import?<br>Enter Y for Yes or N for No:<\/p>\n<\/div><\/div>\n\n\n\n<p>JumpCloud users can be bound to JumpCloud devices during import. To leverage this feature, the JumpCloud agent must first be installed on the devices you want to manage. JumpCloud devices are identified by their SystemID.<\/p>\n\n\n\n<p>By pressing <strong>Y<\/strong> at this prompt, you&#8217;ll be asked for your JumpCloud API key. This API key will be used to authenticate to the JumpCloud API to create a <strong>.CSV<\/strong> file in the home folder of the logged-in user that contains all JumpCloud devices, as well as the SystemID for these systems. This file is named <strong>JCSystems_CurrentDate.csv<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-question-7\">Question 7<\/h3>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Do you want to add the new users to JumpCloud user groups during import? Enter Y for Yes or N for No:<\/p>\n<\/div><\/div>\n\n\n\n<p>Users can be added to JumpCloud User groups during import. <\/p>\n\n\n\n<div class=\"wp-block-cgb-notification-card-wysiwyg notification-card note\"><div class=\"notification-card-content\"><div class=\"notification-card-icon\"><p><img decoding=\"async\" src=\"\/wp-content\/themes\/jumpcloud\/assets\/images\/gutenberg-blocks\/note-icon.png\" \/><\/p><\/div><div class=\"notification-card-copy is-type-body-default\"><div><strong class=\"notification-card-type\">Note:<\/strong> \n<p>If you want to add users to groups, these groups must already be created within the JumpCloud Admin Portal. Enter <strong>Y<\/strong> at this prompt to add columns in the CSV import template for group additions.<\/p>\n <\/div><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Do you want to add the new users to JumpCloud user groups during import? Enter Y for Yes or N for No: y<br>What is the maximum number of groups you want to add a single user to during import? ENTER A NUMBER:<\/p>\n<\/div><\/div>\n\n\n\n<p>If <strong>Y<\/strong> is entered, enter a numeric value for the MAXIMUM number of groups to which you want to add a single user. For example, if I wanted to add my imported users to groups Denver, AllEmployee, Microsoft 365, and Admins, I would enter <strong>4<\/strong> at this prompt. <\/p>\n\n\n\n<div class=\"wp-block-cgb-notification-card-wysiwyg notification-card note\"><div class=\"notification-card-content\"><div class=\"notification-card-icon\"><p><img decoding=\"async\" src=\"\/wp-content\/themes\/jumpcloud\/assets\/images\/gutenberg-blocks\/note-icon.png\" \/><\/p><\/div><div class=\"notification-card-copy is-type-body-default\"><div><strong class=\"notification-card-type\">Note:<\/strong> \n<p>This doesn\u2019t mean that I have to add all imported users to four groups.<\/p>\n <\/div><\/div><\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-question-8\">Question 8<\/h3>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Do you want to add any custom attributes to your users during import? Enter Y for Yes or N for No:<\/p>\n<\/div><\/div>\n\n\n\n<p>Custom attributes are only presented over the JumpCloud API. Custom attributes aren\u2019t presented over JumpCloud LDAP. Enter <strong>Y<\/strong> at this prompt if you want to add custom attributes to your users during import.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Do you want to add any custom attributes to your users during import? Enter Y for Yes or N for No: y <br><br>What is the maximum number of custom attributes you want to add to a single user during import? ENTER A NUMBER:<\/p>\n<\/div><\/div>\n\n\n\n<p>If <strong>Y<\/strong> is entered, enter a numeric value for the MAXIMUM number of attributes to which you want to add a single user. For example, if I wanted to add attributes Favorite Food, Birthday, and Emergency Contact, I would enter <strong>3<\/strong> at this prompt. <\/p>\n\n\n\n<div class=\"wp-block-cgb-notification-card-wysiwyg notification-card note\"><div class=\"notification-card-content\"><div class=\"notification-card-icon\"><p><img decoding=\"async\" src=\"\/wp-content\/themes\/jumpcloud\/assets\/images\/gutenberg-blocks\/note-icon.png\" \/><\/p><\/div><div class=\"notification-card-copy is-type-body-default\"><div><strong class=\"notification-card-type\">Note:<\/strong> \n<p>This doesn\u2019t mean that I have to add three attributes to all users.<\/p>\n <\/div><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Creating file JCUserImport_03-14-2015.csv in the location \/Users\/buster<br>Do you want to open the file JCUserImport_03-14-2015.csv? Enter Y for Yes or N for No:<\/p>\n<\/div><\/div>\n\n\n\n<p>After answering all questions, the import file will be located in the home directory of the logged in user. Enter <strong>Y<\/strong> at this prompt to open the file in the system&#8217;s default CSV editor.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-populating-the-csv-import-file\">Populating the CSV Import File<\/h2>\n\n\n\n<p>After creating a CSV import template using the steps described above, JumpCloud administrators can populate this CSV import file with their end user information and fill in the related fields for custom attributes, JumpCloud system associations, or JumpCloud groups.<\/p>\n\n\n\n<div class=\"wp-block-cgb-notification-card-wysiwyg notification-card tip\"><div class=\"notification-card-content\"><div class=\"notification-card-icon\"><p><img decoding=\"async\" src=\"\/wp-content\/themes\/jumpcloud\/assets\/images\/gutenberg-blocks\/tip-icon.png\" \/><\/p><\/div><div class=\"notification-card-copy is-type-body-default\"><div><strong class=\"notification-card-type\">Tip:<\/strong> \n<ul>\n<li>JumpCloud usernames and email addresses must be unique for each JumpCloud user. A single username or email address can&#8217;t be used twice.<\/li>\n\n\n\n<li>If a custom attribute &#8220;WorkdayID&#8221; is added to the CSV template, each input value must be unique per user. For more information about Workday users, see&nbsp;<a href=\"https:\/\/jumpcloud.com\/support\/integrate-with-Workday\" target=\"_blank\" rel=\"noreferrer noopener\">Integrate with Workday<\/a>.<\/li>\n\n\n\n<li>If end user information lives in an external directory, it may be advantageous to export this information to a CSV format, then copy and paste this information into the import CSV file to save time.<\/li>\n\n\n\n<li>It\u2019s very important that the column headings names&nbsp;<strong>aren&#8217;t modified or edited<\/strong>,&nbsp;as these values are dependencies for the Import-JCUsersFromCSV command.<\/li>\n\n\n\n<li>If binding users to systems, the &#8216;Administrator&#8217; field takes a &#8220;$True\/$False&#8221; value.\n<ul>\n<li>When set to $True, users will be given administrator permissions.<\/li>\n\n\n\n<li>When set to $False, users will be set as standard users.<\/li>\n\n\n\n<li>If left blank, users will be created as standard users by default.&nbsp;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n <\/div><\/div><\/div><\/div>\n\n\n\n<p>Find below an example <strong>.CSV<\/strong> file filled out with information for three users:<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>FirstName,LastName,Username,Email,Password,Nate,Nickerson,nnickerson,nnickerson@sabre.com,P@ssword1! Holly,Flax,hflax,hflax@sabre.com,P@ssword1!@,Deangelo,Vickers,dvickers,dvickers@sabre.com,P@ssword1!<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-importing-the-csv-import-file\">Importing the CSV Import File<\/h2>\n\n\n\n<p>Once the import CSV template has been filled out with end-user information and saved, it&#8217;s ready to be imported using the command&nbsp;<a target=\"_blank\" href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\/Import-JCUsersFromCSV\" rel=\"noreferrer noopener\">Import-JCUsersFromCSV<\/a>.<\/p>\n\n\n\n<p>To run the command, open a PowerShell terminal, enter the PowerShell command&nbsp;<a target=\"_blank\" href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\/Connect-JCOnline\" rel=\"noreferrer noopener\">Connect-JCOnline<\/a>&nbsp;at the prompt, and pass in your JumpCloud API key to authenticate the PowerShell session to the JumpCloud API.<\/p>\n\n\n\n<div class=\"wp-block-cgb-notification-card-wysiwyg notification-card note\"><div class=\"notification-card-content\"><div class=\"notification-card-icon\"><p><img decoding=\"async\" src=\"\/wp-content\/themes\/jumpcloud\/assets\/images\/gutenberg-blocks\/note-icon.png\" \/><\/p><\/div><div class=\"notification-card-copy is-type-body-default\"><div><strong class=\"notification-card-type\">Note:<\/strong> \n<p>Your JumpCloud API key can be found in the JumpCloud Admin Portal within <strong>API Settings<\/strong>, accessible from the icon in the top right corner of the JumpCloud Admin Portal.<\/p>\n <\/div><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Connect-JCOnline<\/p>\n<\/div><\/div>\n\n\n\n<p>After successfully connecting to JumpCloud, navigate in the terminal to the location of the import .CSV file.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>PS \/Users\/buster\/Desktop\/Import Files&gt; dir <br>Directory: \/Users\/buster\/Desktop\/Import <br>Files Mode LastWriteTime Length Name <br>&#8212;- &#8212;&#8212;&#8212;&#8212;- &#8212;&#8212; &#8212;- &#8212;&#8212; <br>3\/14\/15 9:26 AM 535 JCUserImport_03-14-2015.csv<\/p>\n<\/div><\/div>\n\n\n\n<p>The <code>dir<\/code> command, which is an alias for the command&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/powershell\/module\/microsoft.powershell.management\/get-childitem?view=powershell-6\" target=\"_blank\" rel=\"noreferrer noopener\">Get-ChildItem<\/a>,&nbsp;returns all the items in the current directory.<\/p>\n\n\n\n<p>In this example, you will see the import CSV file <strong>JCUserImport_03-14-2015.csv<\/strong> is within the current directory.<\/p>\n\n\n\n<p>Next, run the&nbsp;<a target=\"_blank\" href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\/Import-JCUsersFromCSV\" rel=\"noreferrer noopener\">Import-JCUsersFromCSV<\/a>&nbsp;command and enter the full path to the CSV import file to the CSVFilePath parameter.<\/p>\n\n\n\n<div class=\"wp-block-cgb-notification-card-wysiwyg notification-card note\"><div class=\"notification-card-content\"><div class=\"notification-card-icon\"><p><img decoding=\"async\" src=\"\/wp-content\/themes\/jumpcloud\/assets\/images\/gutenberg-blocks\/note-icon.png\" \/><\/p><\/div><div class=\"notification-card-copy is-type-body-default\"><div><strong class=\"notification-card-type\">Note:<\/strong> \n<p>If you&#8217;ve navigated to the directory where the CSV file lives in the PowerShell session, all that must be entered for this parameter is the name of the CSV import file.<\/p>\n <\/div><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Import-JCUsersFromCSV -CSVFilePath JCUserImport_03-14-2015.csv<\/p>\n<\/div><\/div>\n\n\n\n<p>The CSV file will be validated to ensure that there are no username or email address collisions, and any systems or groups that are being added will be validated to ensure they exist.<\/p>\n\n\n\n<p>After validation, administrators will be presented with a Y\/N prompt to either confirm the import or quit.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Import Summary:&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;<br>    Number Of Users To Import = 3&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;<br>    Would you like to import these users?<br><br>Press Y to confirm or N to quit:<\/p>\n<\/div><\/div>\n\n\n\n<p>If <strong>Y<\/strong> is entered, administrators will be presented with an import summary after the import completes.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>Hang tight! Creating your users. DO NOT shutdown the console. &nbsp; <br><br>Feel free to watch your user count increase in the JumpCloud admin console! &nbsp; <br><br>It takes ~ 1 minute per 100 users. &nbsp; <br><br>Username : nnickerson <br>Status : User Created <br>UserID : 5b4781bce3c61c2f3940f2b6 <br>GroupsAdd : {} <br>SystemID : <br>SystemAdd : &nbsp; <br><br>Username : hflax <br>Status : User Created <br>UserID : 5b4781bc4907674a1e7bc382 <br>GroupsAdd : {} <br>SystemID : <br>SystemAdd : &nbsp; <br><br>Username : dvickers <br>Status : User Created <br>UserID : 5b4781bd23e457661be364ca <br>GroupsAdd : {} <br>SystemID : <br>SystemAdd :<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-pre-compiled-binary\">Pre-Compiled Binary<\/h2>\n\n\n\n<p>JumpCloud also provides a precompiled binary within our API Utility rollup. Download the latest rollup on <a href=\"https:\/\/github.com\/TheJumpCloud\/support\/releases\" target=\"_blank\" rel=\"noreferrer noopener\">GitHub<\/a>. The uncompressed package will contain the file <strong>CSVImporter_ os_arch<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-using-csvimporter\">Using CSVImporter<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-linux-mac-os-x\">Linux \/ Mac OS X<\/h4>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>#  .\/CSVImporter_darwin_amd64<br>Usage of .\/CSVImporter:<br>   -csv=&#8221;&#8221;: -csv=&lt;filename&gt;<br>   -key=&#8221;&#8221;: -key=&lt;API-key-value&gt;<br><br>#  .\/CSVImporter_darwin_amd64 -csv=&#8221;PATH_TO_CSV&#8221; -key=&#8221;YOUR_API_KEY&#8221;<\/p>\n<\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-windows\">Windows<\/h4>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>PS C:\\Users\\Administrator\\Downloads&gt; .\\CSVImporter_windows_amd64.exe<br>Usage of .\/CSVImporter:<br>   -csv=&#8221;&#8221;: -csv=&lt;filename&gt;<br>   -key=&#8221;&#8221;: -key=&lt;API-key-value&gt;<br><br>PS C:\\Users\\Administrator\\Downloads&gt; .\\CSVImporter_windows_amd64.exe -csv=&#8221;PATH_TO_CSV&#8221; -key=&#8221;YOUR_API_KEY&#8221;<\/p>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-building-the-csv-file\">Building the CSV File<\/h3>\n\n\n\n<p><strong>Considerations<\/strong>:<\/p>\n\n\n\n<ul>\n<li>A minimum of nine (9) fields is required.<\/li>\n\n\n\n<li>Username and email are required.<\/li>\n\n\n\n<li>If SUDO Access is left blank, the user will be granted Global Administrator permissions.<\/li>\n\n\n\n<li>Email addresses must be all lowercase.<\/li>\n\n\n\n<li>If the password isn&#8217;t set, the user will receive an email to complete registration. Setting the password will bypass that step and immediately activate the user.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"107\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2023\/05\/load-users-from-csv-file-1024x107.png\" alt=\"\" class=\"wp-image-87290\" style=\"width:900px\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2023\/05\/load-users-from-csv-file-1024x107.png 1024w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2023\/05\/load-users-from-csv-file-300x31.png 300w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2023\/05\/load-users-from-csv-file-768x80.png 768w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2023\/05\/load-users-from-csv-file.png 1054w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-importing-only-a-user\">Importing Only a User<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" width=\"965\" height=\"110\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2023\/05\/importing-only-a-user.png\" alt=\"\" class=\"wp-image-87291\" style=\"width:900px\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2023\/05\/importing-only-a-user.png 965w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2023\/05\/importing-only-a-user-300x34.png 300w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2023\/05\/importing-only-a-user-768x88.png 768w\" sizes=\"(max-width: 965px) 100vw, 965px\" \/><\/figure>\n\n\n\n<p>The exported CSV should look like this:<br><kbd>,,jdoe,jdoe@example.com,,,FALSE,,<\/kbd><\/p>\n\n\n\n<div class=\"wp-block-cgb-notification-card-wysiwyg notification-card note\"><div class=\"notification-card-content\"><div class=\"notification-card-icon\"><p><img decoding=\"async\" src=\"\/wp-content\/themes\/jumpcloud\/assets\/images\/gutenberg-blocks\/note-icon.png\" \/><\/p><\/div><div class=\"notification-card-copy is-type-body-default\"><div><strong class=\"notification-card-type\">Note:<\/strong> \n<p>Some spreadsheet programs might not output commas when the column has no values. One possible workaround is to add a space in the empty column. A space can be used for an empty value to overcome this.<\/p>\n <\/div><\/div><\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-other-fields\">Other Fields<\/h3>\n\n\n\n<ul>\n<li>(Optional) <strong>UID\/GID<\/strong>: If the global setting <strong>Enable UID\/GID management for users<\/strong> is enabled in <strong>Settings<\/strong>, the UID and GID will be automatically assigned. Otherwise, specify the desired values.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The&nbsp;JumpCloud PowerShell Module&nbsp;contains two CSV import-specific commands designed to be used in tandem for importing users into JumpCloud from a [&hellip;]<\/p>\n","protected":false},"author":205,"featured_media":0,"template":"","meta":{"_acf_changed":false,"_oasis_is_in_workflow":0,"_oasis_original":0,"_oasis_task_priority":"","inline_featured_image":false,"footnotes":""},"support_category":[2932,2850],"support_tag":[],"coauthors":[2839,2843],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.9 (Yoast SEO v22.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Import Users from CSV with the PowerShell Module - JumpCloud<\/title>\n<meta name=\"description\" content=\"Learn about the two import-specific commands designed to be used in tandem for importing users into JumpCloud from a CSV file with the Powershell Module.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import Users from CSV with the PowerShell Module\" \/>\n<meta property=\"og:description\" content=\"Learn about the two import-specific commands designed to be used in tandem for importing users into JumpCloud from a CSV file with the Powershell Module.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module\" \/>\n<meta property=\"og:site_name\" content=\"JumpCloud\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-19T21:13:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2023\/05\/load-users-from-csv-file-1024x107.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"11 minutes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"joyjaswinski, sashaharrington\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module\",\"url\":\"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module\",\"name\":\"Import Users from CSV with the PowerShell Module - JumpCloud\",\"isPartOf\":{\"@id\":\"https:\/\/jumpcloud.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module#primaryimage\"},\"image\":{\"@id\":\"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module#primaryimage\"},\"thumbnailUrl\":\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2023\/05\/load-users-from-csv-file-1024x107.png\",\"datePublished\":\"2023-05-19T17:26:02+00:00\",\"dateModified\":\"2024-09-19T21:13:09+00:00\",\"description\":\"Learn about the two import-specific commands designed to be used in tandem for importing users into JumpCloud from a CSV file with the Powershell Module.\",\"breadcrumb\":{\"@id\":\"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module#primaryimage\",\"url\":\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2023\/05\/load-users-from-csv-file-1024x107.png\",\"contentUrl\":\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2023\/05\/load-users-from-csv-file-1024x107.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jumpcloud.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Support\",\"item\":\"https:\/\/jumpcloud.com\/support\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Import Users from CSV with the PowerShell Module\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jumpcloud.com\/#website\",\"url\":\"https:\/\/jumpcloud.com\/\",\"name\":\"JumpCloud\",\"description\":\"Daily insights on directory services, IAM, LDAP, identity security, SSO, system management (Mac, Windows, Linux), networking, and the cloud.\",\"publisher\":{\"@id\":\"https:\/\/jumpcloud.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jumpcloud.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jumpcloud.com\/#organization\",\"name\":\"JumpCloud\",\"url\":\"https:\/\/jumpcloud.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jumpcloud.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2021\/01\/jc-logo-brand-2021.png\",\"contentUrl\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2021\/01\/jc-logo-brand-2021.png\",\"width\":598,\"height\":101,\"caption\":\"JumpCloud\"},\"image\":{\"@id\":\"https:\/\/jumpcloud.com\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Import Users from CSV with the PowerShell Module - JumpCloud","description":"Learn about the two import-specific commands designed to be used in tandem for importing users into JumpCloud from a CSV file with the Powershell Module.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module","og_locale":"en_US","og_type":"article","og_title":"Import Users from CSV with the PowerShell Module","og_description":"Learn about the two import-specific commands designed to be used in tandem for importing users into JumpCloud from a CSV file with the Powershell Module.","og_url":"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module","og_site_name":"JumpCloud","article_modified_time":"2024-09-19T21:13:09+00:00","og_image":[{"url":"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2023\/05\/load-users-from-csv-file-1024x107.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"11 minutes","Written by":"joyjaswinski, sashaharrington"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module","url":"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module","name":"Import Users from CSV with the PowerShell Module - JumpCloud","isPartOf":{"@id":"https:\/\/jumpcloud.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module#primaryimage"},"image":{"@id":"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module#primaryimage"},"thumbnailUrl":"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2023\/05\/load-users-from-csv-file-1024x107.png","datePublished":"2023-05-19T17:26:02+00:00","dateModified":"2024-09-19T21:13:09+00:00","description":"Learn about the two import-specific commands designed to be used in tandem for importing users into JumpCloud from a CSV file with the Powershell Module.","breadcrumb":{"@id":"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module#primaryimage","url":"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2023\/05\/load-users-from-csv-file-1024x107.png","contentUrl":"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2023\/05\/load-users-from-csv-file-1024x107.png"},{"@type":"BreadcrumbList","@id":"https:\/\/jumpcloud.com\/support\/import-users-from-csv-with-powershell-module#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jumpcloud.com\/"},{"@type":"ListItem","position":2,"name":"Support","item":"https:\/\/jumpcloud.com\/support"},{"@type":"ListItem","position":3,"name":"Import Users from CSV with the PowerShell Module"}]},{"@type":"WebSite","@id":"https:\/\/jumpcloud.com\/#website","url":"https:\/\/jumpcloud.com\/","name":"JumpCloud","description":"Daily insights on directory services, IAM, LDAP, identity security, SSO, system management (Mac, Windows, Linux), networking, and the cloud.","publisher":{"@id":"https:\/\/jumpcloud.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jumpcloud.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jumpcloud.com\/#organization","name":"JumpCloud","url":"https:\/\/jumpcloud.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jumpcloud.com\/#\/schema\/logo\/image\/","url":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2021\/01\/jc-logo-brand-2021.png","contentUrl":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2021\/01\/jc-logo-brand-2021.png","width":598,"height":101,"caption":"JumpCloud"},"image":{"@id":"https:\/\/jumpcloud.com\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/support\/76678"}],"collection":[{"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/support"}],"about":[{"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/types\/support"}],"author":[{"embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/users\/205"}],"version-history":[{"count":2,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/support\/76678\/revisions"}],"predecessor-version":[{"id":115681,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/support\/76678\/revisions\/115681"}],"wp:attachment":[{"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/media?parent=76678"}],"wp:term":[{"taxonomy":"support_category","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/support_category?post=76678"},{"taxonomy":"support_tag","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/support_tag?post=76678"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/coauthors?post=76678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}