Bulk Import Ticket Field Values

21 Commentaires

  • Nicole Saunders
    Zendesk Community Team

    Thanks for the feedback, Bonnie. We'll be interested to hear whether this would be useful for other users as well. 

    2
  • Mathew Blanc

    Hi Nicole, 

    I would definitely like to see this added. You can already download the field values as a .csv, it would be great to be able to re-upload that .csv after making the modifications I need to. Especially when dealing with large amounts of field values, editing in a spreadsheet is much easier than the current drag and drop interface. 

    Thanks! 

    2
  • It-Admin

    Hi Nicole,

     

    1oo% relevant for us as well.

    We have an ever expanding product portfilio and need precise information from customer requests.

    Havind to adjust them every time is a pain and costs us valuable time and money.

     

    Please let me know if this can be arranged.

     

    BR
    Pete

    2
  • Nicole Saunders
    Zendesk Community Team

    Hi It-Admin - 

    If this functionality is something that proves valuable for a significant number of users, the product team may take it under consideration. This is a fairly new request with few votes or comments, so I don't believe it's made it onto product's radar yet. 

    1
  • Bonnie Pohlschneider

    I love Matthew's idea of being able to download, modify and then upload again. It is much simpler from a data entry standpoint to modify inside a spreadsheet versus a webpage. And for data that frequently changes, having a single point of entry and then importing it into the custom fields just makes more sense. Less chance for a data entry error that way as well.

    1
  • Judd Higgins

    Yes, please.  I have 300+ Drop Down Ticket Fields to add to the system.

    1
  • Bonnie Pohlschneider

    I agree Judd. When we already have the data in a spreadsheet, there should be an easy way to import that into the system. Eliminates human error and makes our lives easier :)

    1
  • Graeme Carmichael
    Community Moderator

    Just in case it helps.

    When creating a new drop-down field, you should have the option to upload a CSV file of values and tags.

    Once the field is created, this option is not available. Instead, you can download the field's values and tags.

     

    1
  • Bonnie Pohlschneider

    That's awesome Graeme! It definitely helps for the initial upload.

    I realize that we'll end up going the route of the API for constantly changing data but that's a bummer for small companies who don't have developers on staff. We'll end up needing to hire a development firm to do this work for us.

    Just wish there was an easy wizard driven interface that an entry level administrator could use and avoid the API's all together.

    2
  • Beth Yoder

    Our company got a quote from a third party recommended by Zendesk to upload a csv that would autopopulate some of our fields according to a key (for us, we want the agents to be able to type in a unit number and have the name/address/division etc populate. That quote was $35,000, so not realistic for us. I am a very amateur developer, but would like to take on this task if it can be done via the API. Has anyone ever attempted something like what I am describing? Thank you for any help you can provide! 

     

    1
  • Bonnie Pohlschneider

    Our company is too small to house an internal development team and that price tag is outlandish for us as well Beth. We haven't broached the API subject but I'm also interested if anyone else has accomplished this.

    We have a new use case where we need to routinely add/change roughly 200 location records (name, street address, etc). This data already lives in another piece of software and I'd love to eliminate the need to re-key something that another department is already doing.

    2
  • Ruth H

    Great that the bulk import via CSV is available on first creation of a custom field, but would definitely be useful to be able to do this on existing fields.

    I have 100+ options on a field, and have reviewed them with the business and now need to make changes.  Having to do this manually is a pain in the behind

    0
  • Stephanie

    Please allow for this new feature. It doesn't make sense to not be able to update your Field Values in bulk after you've initially created it. It's extremely time consuming to do this one-by-one and not user friendly. Additionally, we're uploading new tags often.

     

    1
  • Jimmy Flores

    I agree you should be able to modify and reupload.

    I have a drop down for Organizations.

    I initially added 400 and now need to add another 500

    Would be great if I could just modify and reupload rather than having to delete the entire field and replace it.

    1
  • Avil Mascarenhas

    Bulk import is available only during field creation
    If it is there even after a field is created, then we can update the field with large number of drop down values

    I am not asking for bulk update (refresh of value) - that will be wonderful to have

    Having a Bulk add is also helpful to add 100+ field values

    0
  • Jimmy Lin

    Avil Mascarenhas - we have an app in the marketplace here to update dropdown ticket fields by CSV, perhaps it would meet your needs?

    0
  • Sarah

    Jimmy Lin does that app allow to upload new dropdown ticket fields while keeping the existing values?  I want to be able to add new accounts as we sign them.

     

    0
  • Jimmy Lin

    Hi Sarah, that is indeed the purpose of this app.  We noticed that users would have to delete a ticket field and create a new one in order to update the values, which is obviously a pain point, so with this app, it will keep the existing values and add the new ones, or it can also remove values that are no longer needed.  As a note, when updating a field all the values that you want in the final version of the field must be included in the CSV.  Hope this helps!

    0
  • Laura Campbell

    For anyone still looking for a solution to bulk update ticket field values from an external data source, we've recently released the app Elements Connect which could meet your needs.

    The app works by querying your datasource (SQL database, Shopify...) to create a dataset that you use to populate your ticket field values. If you need to update field values, just re-sync the field. You can also set how tags are created to avoid manually managing them.

    0
  • Jonathan Cavey

    +1, I am looking for a way to have a dynamic drop down list that could be correlated with an outside database of information. For instance if we have a list of 'Current Codes' in another system, I would like a way that our drop down in Zendesk (Current Codes) could update daily with this information. 

    0
  • Laura Campbell

    Jonathan Cavey What kind of outside database are you using? MySQL? Oracle? Something else?

    0

Vous devez vous connecter pour laisser un commentaire.

Réalisé par Zendesk