Question
Can I bulk update my users?
Answer
Yes, there are three ways to bulk update users within Zendesk:
Import users using the interface
-
Generate a CSV file of your existing users. Export an XML file from your Zendesk Support account (Professional or Enterprise plans only) and use the user data from this export to help build the CSV file.
- Edit the user field columns with your updates.
-
Re-import the file into your Zendesk. Navigate to the Customers page in Support and use the Bulk user import feature.
Note: Only one unique identifier is required when existing users are updated using bulk import, such as an email or external ID.
Update users using the API
- Create a script using the Create or Update Many Users call in the Zendesk API.
- Adjust the user objects you want to update.
- Run the script.
For more information, see the article: Bulk importing users.
Use the Super Admin App
The Super Admin App can be used to update agents and end users quickly. The app can be installed into your account directly from Zendesk Marketplace. For more information on installing apps from the Zendesk Marketplace, see the article: Using the Zendesk Marketplace.
14 comments
Ben Chapman
When bulk updating users I need to replace ALL the current tags with a new set in my CSV file. How do I title the column header to run the 'set tags' function that I assume would accomplish this goal?
0
Dave Dyson
Hi Ben,
Unfortunately, the CSV Bulk Import functionality does not include the capability to remove existing tags, only to add new ones. You'll need to use the Create or Update Many Users call in the Zendesk API as mentioned in the article above instead.
0
Christian Becker
Hi Zendesk Team and Community,
is it possible to use the Create_or_Update_User API to add multiple Organizations to one User?
We have currently the problem, that we aren't able to import this at once.
Following Code is not able to add both or at least one organization to the customer. Is there any workaround so that we do not have to import this user twice? IN CSV Import Method it's possible to add multiple organizations via |.. in API it doesn't work.
Example Code:
0
Christopher Boerger
Hi any updates on having these bulk updates as a native Admin tool?
1
Sergey
Hi Christian,
Users endpoint will not do the job. Org memberships - will. See this page for API call syntax and some other additional info: Create Many Memberships
Note: above API call will fail, if you will try to update a user with an org, to which he already belongs to. So in short: update users with an org, to which they do not belong yet. This endpoint is best for cases when you need to import new users and they belong to 1 or less organisations.
0
Daniel S
Hi,
Will this work to create a functionality (work-space) to be able update in bulk, a number of ticket fields?...thanks
0
Josh
Hi Daniel,
Thank you for messaging us.
This functionality only works with users inside Zendesk. What I can recommend is using our API documentation Here.
Currently this is what we have. Hopefully this helps!
0
CJ Johnson
What are you allowed to update via this feature? I tried Signature, and it returned as though it was successful, but didn't make any of the updates I had put in.
0
Dion
SIgnatures cannot be updated via Bulk Import at the moment. You can use API if you want to update the signatures of your agents:
Update Many Users API Call
Regards,
Dion
0
Katrina Watson
I'm trying to add an external_id to existing users but when I try and run the import it says Email address is already in use. In my file I just have the customers name, email address and external_id. I assumed it would use the email address field to find the record to update but the import just fails every time. Is there a way to add this field to existing users?
0
Arianne Batiles
Hi Katrina Watson,
I created a ticket on your behalf and will continue to assist you from there. Kindly check your email for updates. Thank you!
0
Noelle Cheng
Hello Arianne Batiles,
I've created a CSV and the phone number is not updating accurately. It's supposed to go in as +1234567890 but the CSV won't maintain the + in the phone number so when the person calls, the phone number is not tied to the user and the ticket is created with a requester +1234567890 BECAUSE the bulk update stored the number as 1234567890. I tried adding an apostrophe in the file prior to uploading to reflect '+1234567890 to help maintain the + sign but now it's loading as '+1234567890 and Zendesk still can't recognize the number to the individual. I reached out to customer support, and an agent named Tony said that I would have to reach out to the Google developer. I thought this was a native built in feature since it's in the Admin Center. Please help, thanks in advance! :(
0
Phoebe Morin
I believe this has something to do with the formula on the file, where the "+" is being treated as text. We can't answer Excel or spreadsheet questions; they are a third-party application, and on top of that we don't have access to it. Hence, we normally refer our clients to the designated support system of these applications.
What I can confirm is that, with Talk, if the phone number is added to the user's profile, and is properly formatted, the call will be tied to that profile even if the phone number they're calling from isn't the primary one. The behavior is discussed here: https://support.zendesk.com/hc/en-us/articles/4408893496218-Bulk-importing-users#topic_bck_td1_zg
0
Mattias Malré
Is this entire article even valid any longer? I can't see any “Reports” alternative under Tools.
I need to do an Export so that I can change the Access for my users and do an import.
0