How can I export a list of users? Follow

Comments

11 comments

  • Avatar
    Jimmy Rufo

    Hi Rebecca,


    This isn't accurate.  Only JSON export is allowed for end user exports.  CSV is just for ticket data.

  • Avatar
    Jessie - Community Manager

    Just as a point of clarification, user data and the full data export are both done in XML format, which is detailed in the article Rebecca linked above.

  • Avatar
    Gina (Edited )

    I was able to find out that only Professional and Enterprise accounts have access to exporting users as XML, but account owner needs to apply for access by writing to support@zendesk.com:
    https://support.zendesk.com/hc/en-us/articles/203662346-Exporting-data-to-a-CSV-or-XML-file-Professional-and-Enterprise-

    Also read the article on how to use the Customer Lists add-on, however, I'd like to see more information about cost/how to get it.

    Thanks!

  • Avatar
    Jessie - Community Manager

    Hey Gina!

    Your account manager (if you have one) can get you pricing information on Customer Lists. If you don't know who your account manager is, or if you don't have one, you can contact Support and they'll be able to help you out!

  • Avatar
    Gina

    Thanks!

  • Avatar
    Jeffraymon

    Hi. We have professional and the customer list is not an option. I was told the following about an add on I needed.

    o get customer lists add to your account, you'll have to purchase our customer lists+NPS survey add on. The add-on is a starting cost of $250/month and will be $25/agent/month once you reach 10 support agents or above. Let me know if you'd like to add this to your account, I'll have to send over a service order.

    Seems a bit miseading. Am I missing something? Or do I need to pay an extra $250 a month on top of my professional fees for a customer export feature?

  • Avatar
    Jessie - Community Manager

    Hey Jeff!

    As you'll see on our pricing page, the Customer Lists feature is a paid add-on for the Professional plan. So the information you were given is correct. 

    We're not really able to answer billing questions here in the Community, so if you have additional questions about this our Support team will be able to help you out in your ticket. :)

  • Avatar
    Nicole - Community Manager

    Hey Jeff -

    You can pull that data out of the Zendesk Rest API via the Users endpoint. I'm working on getting some additional information for you, but hopefully that's a start to get you headed in the right direction. 

     

  • Avatar
    Yoram Dagan

    Hi

    This is really frustrating.

    I have added a new user field and I want to update all of my users with the correct value.

    The way to do so without write code (I think it is a reasonable request) is to export the user list, edit the values and import. 

     

    Here is where I was pulling hairs from my head:

    • Export for users is available only in XML format and import is available only in CSV format. 
    • Not all of the values are exported. Any field with multiple values such as email, organization which the user might be configured for is not being fully pulled and only one value exists.

    So Actually, if you don't write code or haven't got the time to write code for a one time action such as user maintenance, you are stuck.

     

    No way to update the users with information which were supposed to be used in triggers and reporting...

     

    Thanks

    Yoram

  • Avatar
    Dwight Bussman

    Greetings Yoram,

    It should be possible to perform a JSON export of users. The resultant JSON file should be able to be converted into a CSV file (there are a number of services/websites that can do this), after which you could add values to this field in bulk for re-import.

    There are a few ways to accomplish this same sort of task using an external system as well (Salesforce + bulk-sync within our integration, or having users auth in via SAML which could push custom-field information over from the identity provider), but the JSON export is likely the easiest way to accomplish what you're looking to do.

    Apologies for not having a more graceful way to accomplish this bulk-user updating task. Hopefully this is somewhat helpful!

  • Avatar
    HDM Contact

    You don't need to be a programmer or use complicated scripts to export data from your Zendesk (even User List).

     

    Use this tool to export data to CSV easily and quickly.

    Hope that will help.

     

Please sign in to leave a comment.

Powered by Zendesk