{"id":76690,"date":"2023-05-19T10:37:15","date_gmt":"2023-05-19T14:37:15","guid":{"rendered":"https:\/\/jumpcloud.com\/?post_type=support&#038;p=76690"},"modified":"2024-09-19T17:17:10","modified_gmt":"2024-09-19T21:17:10","slug":"update-users-from-csv-file","status":"publish","type":"support","link":"https:\/\/jumpcloud.com\/support\/update-users-from-csv-file","title":{"rendered":"Update Users from a CSV File"},"content":{"rendered":"\n<p id=\"updating-users-from-a-csv-file\">The&nbsp;<a href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\" target=\"_blank\" rel=\"noreferrer noopener\">JumpCloud PowerShell Module<\/a>&nbsp;contains two commands designed to be used in tandem to update existing JumpCloud users from a CSV file. The first command,&nbsp;<a href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\/New-JCImportTemplate\" target=\"_blank\" rel=\"noreferrer noopener\">New-JCImportTemplate<\/a>,&nbsp;creates the CSV update template file on the local machine populated with JumpCloud user information which admins can then add user updates to and import with the second command,&nbsp;<a href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\/Update-JCUsersFromCSV\" target=\"_blank\" rel=\"noreferrer noopener\">Update-JCUsersFromCSV<\/a>.<\/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 create a CSV import file instead, refer to&nbsp;<a href=\"https:\/\/support.jumpcloud.com\/support\/s\/article\/importing-users-into-jumpcloud-from-csv2-2019-08-21-10-36-47\" target=\"_blank\" rel=\"noreferrer noopener\">Importing New Users from a CSV<\/a>.<\/p>\n <\/div><\/div><\/div><\/div>\n\n\n\n<p>The JumpCloud PowerShell Module can be installed on Mac, Windows and Linux devices in a&nbsp;few quick steps, see our GitHub repo, <a href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\/Installing-the-JumpCloud-PowerShell-Module\">Installing the JumpCloud PowerShell Module<\/a> to learn more.<\/p>\n\n\n\n<p>Using this update workflow, JumpCloud Admins can:<\/p>\n\n\n\n<ul>\n<li>Add attributes to existing JumpCloud users.<\/li>\n\n\n\n<li>Update attributes on existing 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 devices with either standard or Admin 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, Admins can:<\/p>\n\n\n\n<ul>\n<li>Grant JumpCloud users access to JumpCloud SSO apps.<\/li>\n\n\n\n<li>Grant JumpCloud users permissions to JumpCloud Device 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 level integrations.<\/li>\n\n\n\n<li>Take over existing user accounts or provision new user accounts in Microsoft 365 or Google Workspace.<\/li>\n<\/ul>\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>Custom attributes are only presented over the JumpCloud API. Custom attributes aren&#8217;t presented over JumpCloud LDAP.<\/p>\n <\/div><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Creating the CSV Update File<\/h2>\n\n\n\n<p>The command&nbsp;<a href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\/New-JCImportTemplate\" target=\"_blank\" rel=\"noreferrer noopener\">New-JCImportTemplate<\/a>&nbsp;creates a blank CSV update file that can be populated with JumpCloud user information on a JumpCloud admin&#8217;s local machine.<\/p>\n\n\n\n<p>To run the command, open a PowerShell terminal that has the&nbsp;<a href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\/Installing-the-JumpCloud-PowerShell-Module\" target=\"_blank\" rel=\"noreferrer noopener\">JumpCloud PowerShell<\/a>&nbsp;module installed, 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><code>New-JCImportTemplate<\/code><\/p>\n<\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"new-jcimporttemplate-questions\"><strong>Question 1<\/strong><\/h4>\n\n\n\n<p><code>PS \/Users\/[user]&gt; New-JCImportTemplate <\/code><\/p>\n\n\n\n<p><code>cmdlet New-JCImportTemplate at command pipeline position 1<\/code><br><code>Supply values for the following parameters: <\/code><br><code>(Type !? for Help.) <\/code><br><code>Type:<\/code><\/p>\n\n\n\n<p>Enter &#8220;Update&#8221; to begin updating the import template file.<\/p>\n\n\n\n<p><code>The CSV file will be created within the directory:<br>\/Users\/[user]<br>Enter Y to confirm or N to change output location<\/code>:<\/p>\n\n\n\n<p>This file is created within the current working directory of the PowerShell session by default. To create the file in this location, enter &#8216;Y&#8217;. If you want to choose a different output location, enter &#8216;N&#8217; and provide a full path to the folder where you want to create the file.<\/p>\n\n\n\n<p><strong>Question 2<\/strong><\/p>\n\n\n\n<p><code>Would you like to populate this update template with all of your existing users?<br>You can remove users you do not wish to modify from the import file after it is created.<br>Enter Y for Yes or N for No:<\/code><\/p>\n\n\n\n<p>An update file can be populated with the usernames of all existing JumpCloud users. Enter &#8220;Y&#8221; at this prompt to add all existing users to the CSV update file or &#8220;N&#8221; if you do not want to add this information to the file.<\/p>\n\n\n\n<p><strong>Question 3<\/strong><\/p>\n\n\n\n<p><code>Would you like to update users email addresses?<br>Enter Y for Yes or N for No:<\/code><\/p>\n\n\n\n<p>Enter &#8220;Y&#8221; at this prompt to update existing users&#8217; email addresses in the CSV update file or &#8220;N&#8221; if you do not want to update this information.<\/p>\n\n\n\n<p><strong>Question 4<\/strong><\/p>\n\n\n\n<p><code>Do you want to add extended user information attributes available over JumpCloud LDAP to your users during import?<br>Extended user information attributes include: AlternateEmail, Manager, ManagedAppleId, MiddleName, preferredName, jobTitle, employeeIdentifier, department, costCenter, company, employeeType, description, and location<br>Enter Y for Yes or N for No:<\/code><\/p>\n\n\n\n<p>To add columns to the update file for updating extended user information attributes, enter &#8220;Y&#8221; at the prompt. Fields to update all extended user information attributes will be added to the update file. Only fields populated with information will be updated.<\/p>\n\n\n\n<p><strong>Question 5<\/strong><\/p>\n\n\n\n<p><code>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<\/code><\/p>\n\n\n\n<p>To add columns to the update file for updating location attributes, enter &#8220;Y&#8221; at the prompt. Fields to update all location attributes will be added to the update file. Only fields populated with information will be updated.<\/p>\n\n\n\n<p><strong>Question 6<\/strong><\/p>\n\n\n\n<p><code>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<\/code><\/p>\n\n\n\n<p>To add columns to the update file for updating telephony attributes, enter &#8220;Y&#8221; at the prompt. Fields to update all telephony attributes will be added to the update file. Only fields populated with information will be updated.<\/p>\n\n\n\n<p><strong>Question 7<\/strong><\/p>\n\n\n\n<p><code>Do you want to set unix UID\/GUID values during import?<\/code><br><code>UID\/GUID value attributes include: unix_uid, unix_guid<br>Enter Y for Yes or N for No:<\/code><\/p>\n\n\n\n<p>To add columns to the update file for UID\/GUID values, enter &#8220;Y&#8221; at the prompt. Columns will be added to the update file. Only fields populated with information will be updated.<\/p>\n\n\n\n<p><strong>Question 8<\/strong><\/p>\n\n\n\n<p><code>Do you want to require MFA to user?<br>enable_user_portal_multifactor, EnrollmentDays<br>Enter Y for Yes or N for No:<\/code><\/p>\n\n\n\n<p>To add columns to the update file for enabling MFA for User Portal logins and setting the number of enrollment days (enrollment period), enter &#8220;Y&#8221; at the prompt. <\/p>\n\n\n\n<p><strong>Question 9<\/strong><\/p>\n\n\n\n<p><code>Do you want to bind the user to LDAP during import<br>ldap_Binding_User, ldapserver_id<br>Enter Y for Yes or N for No:<\/code><\/p>\n\n\n\n<p>To add columns to the update file for setting the LDAP BindDN and binding users to an LDAP server, enter &#8220;Y&#8221; at the prompt. <\/p>\n\n\n\n<p><strong>Question 10<\/strong><\/p>\n\n\n\n<p><code>Do you want to bind your users to existing JumpCloud systems during import?<br>Enter Y for Yes or N for No:<\/code><\/p>\n\n\n\n<p>By entering &#8216;Y&#8217; 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 CSV file in a current working directory containing all JumpCloud devices and the SystemID for these devices. This file is named <strong>JCSystems_CurrentDate.csv<\/strong>.<\/p>\n\n\n\n<p><strong>Question 11<\/strong><\/p>\n\n\n\n<p><code>Do you want to add the users to JumpCloud user groups during import?<br>Enter Y for Yes or N for No:<\/code><\/p>\n\n\n\n<p>If &#8216;Y&#8217;, <\/p>\n\n\n\n<p><code>What is the maximum number of custom attributes you want to add to a single user during import? ENTER A NUMBER:<\/code><\/p>\n\n\n\n<p>Users can be added to JumpCloud user groups during import. Note that if you want to add users to groups, these groups must already be created within the JumpCloud Admin Portal. Enter &#8216;Y&#8217; at this prompt to add columns in the CSV update file for group additions.<\/p>\n\n\n\n<p><strong>Question 12<\/strong><\/p>\n\n\n\n<p><code>Do you want to add any custom attributes to your users during import? Note, customAttribute values must be unique.<br>Enter Y for Yes or N for No:<\/code><\/p>\n\n\n\n<p>Custom attributes are only presented over the JumpCloud API. Custom attributes aren&#8217;t presented over JumpCloud LDAP. Enter &#8216;Y&#8217; at this prompt if you want to add custom attributes to your users during import.<\/p>\n\n\n\n<p><strong>Question 13<\/strong><\/p>\n\n\n\n<p><code>Creating file JCUserUpdateImport_MM-DD-YYYY.csv in the location \/Users\/[user]<\/code><\/p>\n\n\n\n<p><code>Do you want to open the file JCUserUpdateImport_MM-DD-YYYY.csv?<br>Enter Y for Yes or N for No:<\/code><\/p>\n\n\n\n<p>After answering all questions, the update file will be located in the current working directory of the PowerShell session. Enter &#8216;Y&#8217; 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\">Populating the CSV Update File<\/h2>\n\n\n\n<p>After creating a CSV update file using the steps described above, JumpCloud Admins can populate this CSV update file with their end user information and fill in the related fields for attributes, JumpCloud device bindings, or JumpCloud groups additions.<\/p>\n\n\n\n<p><strong>Expert Tips<\/strong><\/p>\n\n\n\n<ul>\n<li>Only fields populated with info will get updated per user.<\/li>\n\n\n\n<li>Fields can be left blank.<\/li>\n\n\n\n<li>You&nbsp;don&#8217;t&nbsp;need to add info for each user for each update field.<\/li>\n\n\n\n<li>If you&#8217;re using a custom attribute &#8220;WorkdayID,&#8221; note that each input value must be unique per user. See<a href=\"https:\/\/support.jumpcloud.com\/support\/s\/article\/workday-integration-2019-08-21-10-36-47\" target=\"_blank\" rel=\"noreferrer noopener\"> Integrate with Workday<\/a> to learn more.<\/li>\n\n\n\n<li>It&#8217;s very important that the column headings names are&nbsp;not<strong>&nbsp;<\/strong>modified or edited, as these values are dependencies for the&nbsp;<code>Update-JCUsersFromCSV<\/code>&nbsp;command.<\/li>\n<\/ul>\n\n\n\n<p>The example below is a CSV file filled out with update info for three users:<\/p>\n\n\n\n<p><code>&#8220;Username&#8221;,&#8221;mobile_number&#8221;,&#8221;home_number&#8221;,&#8221;work_number&#8221;,&#8221;work_mobile_number&#8221;,&#8221;work_fax_number&#8221;<br>nnickerson,123-456-777,,777,,<br>hflax,123-456-888,,888,,<br>dvickers,123-456-999,,999,,<\/code><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Importing the CSV Update File<\/h2>\n\n\n\n<p>Once the update CSV template has been filled out with end user info and saved, it&#8217;s ready to be imported using the command&nbsp;<a href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\/Update-JCUsersFromCSV\" target=\"_blank\" rel=\"noreferrer noopener\">Update-JCUsersFromCSV<\/a>.<\/p>\n\n\n\n<p>To run the command, open a PowerShell terminal and, at the prompt, enter the PowerShell command&nbsp;<a href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\/Connect-JCOnline\" target=\"_blank\" rel=\"noreferrer noopener\">Connect-JCOnline<\/a>&nbsp;and put in your JumpCloud API key to authenticate the PowerShell session to the JumpCloud API.<\/p>\n\n\n\n<p><strong>Considerations<\/strong>:<\/p>\n\n\n\n<ul>\n<li>Your JumpCloud API key can be found in the JumpCloud Admin Portal. In the top right, click your initials, then My API Key. If you don&#8217;t have API key access, see <a href=\"https:\/\/jumpcloud.com\/support\/jumpcloud-apis\">JumpCloud APIs<\/a> to learn more. <\/li>\n\n\n\n<li>Some attributes that can be updated via CSV require additional validation. See&nbsp;<a href=\"https:\/\/jumpcloud.com\/support\/use-the-manager-attribute-in-admin-portal-and-api\">Use the Manager Attribute in the Admin Portal and API<\/a>&nbsp;for more information.<\/li>\n<\/ul>\n\n\n\n<p><code>Connect-JCOnline lu8792c9d4y2398is1tb6h0b83ebf0e92s97t382<br>Successfully connected to JumpCloud<br>Module up-to-date. New LDAP attributes are live! Use Update-JCUsersFromCSV to add them in bulk.<\/code><\/p>\n\n\n\n<p>After successfully connecting to JumpCloud, in the terminal go to the location of the update CSV file.<\/p>\n\n\n\n<p><code>PS \/Users\/buster\/Desktop\/Import Files&gt; dir<\/code><\/p>\n\n\n\n<p class=\"has-text-align-center\"><code>Directory: \/Users\/buster\/Desktop\/Update Files<\/code><\/p>\n\n\n\n<p><code>Mode          LastWriteTime           Length Name<br>&#8212;-          &#8212;&#8212;&#8212;&#8212;-           &#8212;&#8212; &#8212;-<br>&#8212;&#8212;        9\/28\/18 1:12 PM         443 JCUserUpdateImport_09-28-2018.csv<\/code><\/p>\n\n\n\n<p>The &#8216;dir&#8217; command which is alias for the command&nbsp;<a target=\"_blank\" href=\"https:\/\/docs.microsoft.com\/en-us\/powershell\/module\/microsoft.powershell.management\/get-childitem?view=powershell-6\" 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&#8217;ll see the update CSV file &#8216;JCUserUpdateImport_09-28-2018.csv&#8217; is within the current directory.<\/p>\n\n\n\n<p>Next, run the&nbsp;<a href=\"https:\/\/github.com\/TheJumpCloud\/support\/wiki\/Update-JCUsersFromCSV\" target=\"_blank\" rel=\"noreferrer noopener\">Update-JCUsersFromCSV<\/a>&nbsp;command and enter the full path to the CSV update file to the -CSVFilePath parameter.<\/p>\n\n\n\n<p>If you have 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\n\n\n<p><code>Update-JCUsersFromCSV -CSVFilePath .\/JCUserUpdateImport_09-28-2018.csv<\/code><\/p>\n\n\n\n<p>The CSV file will be validated and admins will be presented with a &#8216;Y&#8217;\/&#8217;N&#8217; prompt to confirm the update or quit.<\/p>\n\n\n\n<p><code>Import Summary:<\/code><\/p>\n\n\n\n<p><code>Number Of Users To Update = 3<\/code><\/p>\n\n\n\n<p><code>Would you like to update these users?<\/code><\/p>\n\n\n\n<p><code>Press Y to confirm or N to quit:<\/code><\/p>\n\n\n\n<p>If &#8216;Y&#8217; is entered, Admins will be presented with a update summary after the update completes.<\/p>\n\n\n\n<p>A loading bar will show progress of the update.<\/p>\n\n\n\n<p><code>Import Summary:<\/code><\/p>\n\n\n\n<p><code>Number Of Users To Update = 3<\/code><\/p>\n\n\n\n<p><code>Would you like to update these users?<\/code><\/p>\n\n\n\n<p><code>Press Y to confirm or N to quit: y<\/code><\/p>\n\n\n\n<p><code>Username : nnickerson<br>Status : User Updated<br>UserID : 5b4781bce3c61c2f3940f2b6<br>GroupsAdd : {}<br>SystemID :<br>SystemAdd :<\/code><\/p>\n\n\n\n<p><code>Username : hflax<br>Status : User Updated<br>UserID : 5b4781bc4907674a1e7bc382<br>GroupsAdd : {}<br>SystemID :<br>SystemAdd :<\/code><\/p>\n\n\n\n<p><code>Username : dvickers<br>Status : User Updated<br>UserID : 5b4781bd23e457661be364ca<br>GroupsAdd : {}<br>SystemID :<br>SystemAdd :<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The&nbsp;JumpCloud PowerShell Module&nbsp;contains two commands designed to be used in tandem to update existing JumpCloud users from a CSV file. [&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>Update Users from a CSV File - 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.\" \/>\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\/update-users-from-csv-file\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Update Users from a CSV File\" \/>\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.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jumpcloud.com\/support\/update-users-from-csv-file\" \/>\n<meta property=\"og:site_name\" content=\"JumpCloud\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-19T21:17:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/07\/202405-MISC-JumpCloudHelpCenter-SiteDisplay-min-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"890\" \/>\n\t<meta property=\"og:image:height\" content=\"525\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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=\"9 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\/update-users-from-csv-file\",\"url\":\"https:\/\/jumpcloud.com\/support\/update-users-from-csv-file\",\"name\":\"Update Users from a CSV File - JumpCloud\",\"isPartOf\":{\"@id\":\"https:\/\/jumpcloud.com\/#website\"},\"datePublished\":\"2023-05-19T14:37:15+00:00\",\"dateModified\":\"2024-09-19T21:17:10+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.\",\"breadcrumb\":{\"@id\":\"https:\/\/jumpcloud.com\/support\/update-users-from-csv-file#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jumpcloud.com\/support\/update-users-from-csv-file\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jumpcloud.com\/support\/update-users-from-csv-file#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\":\"Update Users from a CSV File\"}]},{\"@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":"Update Users from a CSV File - JumpCloud","description":"Learn about the two import-specific commands designed to be used in tandem for importing users into JumpCloud from a CSV file.","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\/update-users-from-csv-file","og_locale":"en_US","og_type":"article","og_title":"Update Users from a CSV File","og_description":"Learn about the two import-specific commands designed to be used in tandem for importing users into JumpCloud from a CSV file.","og_url":"https:\/\/jumpcloud.com\/support\/update-users-from-csv-file","og_site_name":"JumpCloud","article_modified_time":"2024-09-19T21:17:10+00:00","og_image":[{"width":890,"height":525,"url":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/07\/202405-MISC-JumpCloudHelpCenter-SiteDisplay-min-2.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"9 minutes","Written by":"joyjaswinski, sashaharrington"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/jumpcloud.com\/support\/update-users-from-csv-file","url":"https:\/\/jumpcloud.com\/support\/update-users-from-csv-file","name":"Update Users from a CSV File - JumpCloud","isPartOf":{"@id":"https:\/\/jumpcloud.com\/#website"},"datePublished":"2023-05-19T14:37:15+00:00","dateModified":"2024-09-19T21:17:10+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.","breadcrumb":{"@id":"https:\/\/jumpcloud.com\/support\/update-users-from-csv-file#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jumpcloud.com\/support\/update-users-from-csv-file"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jumpcloud.com\/support\/update-users-from-csv-file#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":"Update Users from a CSV File"}]},{"@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\/76690"}],"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\/76690\/revisions"}],"predecessor-version":[{"id":115683,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/support\/76690\/revisions\/115683"}],"wp:attachment":[{"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/media?parent=76690"}],"wp:term":[{"taxonomy":"support_category","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/support_category?post=76690"},{"taxonomy":"support_tag","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/support_tag?post=76690"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/coauthors?post=76690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}