Exporting and importing dynamic content (Professional and Enterprise)

Return to top
Have more questions? Submit a request

26 Comments

  • Jack Elver-Fiddimore

    Is it possible to import/export macros? I ask this because many macros include commas, but when I try to import/export CSVs Excel reads these commas as separators instead of part of the text. 

    0
  • Jessie Schutz
    Zendesk team member

    Hey Jack!

    One of our Moderators has answered this question over here: Can you export macros into a csv or word doc?

    0
  • Brad Marshall

    Can you batch import without the DC existing already? I just created 30+ DC in my sandbox, and now I want to create them in my production.

    2
  • Jenni

    Hi Brad!

    I'm going to reach out to you in a ticket to be able to discuss your situation a little more in depth, just so we can confirm the best options for you! 

    0
  • Brendan Farrar-Foley

    @Jenni could you share this with all of us please?  I have the same question.

    0
  • Jenni

    Hi Brendan,

    Yes! If you are looking to batch import Dynamic Content, you can do so even without having existing Dynamic Content.

    0
  • Evelia Casales

    Hi!

    Does anybody knows how long does the process could take?

    0
  • Nicole S. - Community Manager
    Zendesk Community Team

    Hi Evelia, 

    It depends how much content you're working with. 

    0
  • Claire Santos

    Hi There,

    I've tried downloading and exporting on a Mac + Windows pc and everytime our english version does not have characters.. e.g - they still appear as:

    We would love to assist you as quickly as possible, so here are a few helpful links that may have the information you’re after.
    FAQ – 

    How can I get the export to have the correct character please?

    Thanks

     

    0
  • Molly
    Zendesk Customer Success

    Hi Claire!

    Special characters should definitely render. It may be an issue with the application you're using to view the file. I'm going to open a ticket so we can get some more details on what you're seeing.

    Stay tuned!

    0
  • Cherla Cheung

    Hi Molly,

    I am also trying to export the dynamic content to csv. They are in English (US) and Traditional Chinese (ZH-TW).

    If I open the csv with TextEdit, the Traditional Chinese characters are fine. But if I open the csv with Excel, they are not rendered correctly.

    I wish to be able to edit with Excel, could you please help out to see if it would be possible? Thank you!

    0
  • Jessie Schutz
    Zendesk team member

    Hi Cherla! Welcome to the Community!

    In my experience, special characters don't render because of some settings in Excel. I don't know exactly what needs to be changed (I'm sure you can find details via Google), but I know that Excel has language settings which is probably a good jumping off point.

    0
  • Lucas Martins Lousada

    export and import macros:

     

    100% working, 100% stupid.. but I had no time to do this

    $ cat desk.sh

     

    #!/bin/bash
    user='email'
    passwd='passwd'

    # how many entries to create

    #this could get how many entries json have with something like ( cat file.json | grep title | wc -l )
    howmany=90

    #get macros from zendesk user

    #this will not get page 2 /3 etc.. need to be updated to do this
    #nciphermacros=$(curl https://{GET_FROM_HERE}.zendesk.com/api/v2/macros/active.json -v -u $user:$passwd)

     

    # get only user's personal macros and just useful information
    #mymacros=$(echo $nciphermacros | jq '.macros[] | select(.restriction.type == "User") | {title: .title , active: .active , actions: .actions , restriction: .restriction}')

    # get only non personal user macros
    #mymacros=$(echo $nciphermacros | jq '.macros[] | select(.restriction.type != "User") | {title: .title , active: .active , actions: .actions , restriction: .restriction}')

    for((i=0; i <= $howmany ; ++i)) do

    #this will post 1 macro at a time 

    echo $mymacros | jq -s ".[$i]" | xargs -0 -I DATA curl -X POST -H "Content-Type: application/json" -d '{"macro": DATA }' -u $user:$passwd "https://{POST_TO_HERE}.zendesk.com/api/v2/macros.json"

    done

    0
  • Jessie Schutz
    Zendesk team member

    Thanks for sharing, Lucas!

    0
  • Mikkel Diurhuus

    Can i only add translations to already created content? I get an error every time i try to import the content i made and tested in sandbox. The error is "The expected column missing: Title".

    1
  • Aswin Kannan

    How to import multiple language variants at once? I tried with Title, fr text, de text, pt-br text as columns. It only took the last column pt-br and ignored the other variants.

    0
  • Brett - Community Manager
    Zendesk Community Team

    Hi Aswin,

    I double checked on my end and it looks like you'll be limited to one language variant per file you upload. You'll need to import 3 separate files if you'd like to create a language variant for fr, de, and pt-br.

    Let me know if you have any other questions :)

    0
  • Fernando

    @brett

    How do we create multiple DCs at once? I am unable to do so by importing a CSV and manually creating 350+ would be rather redundant. 

    It would be great if this information would be available somewhere. 

    2
  • Nicole S. - Community Manager
    Zendesk Community Team

    Hi Fernando -

    The .csv import and the API are the only ways to create multiple pieces of dynamic content at once.

    Here is the API documentation on dynamic content, you'll want to look specifically at the create item section.

    0
  • Fernando

    Thanks Nicole - I'm not sure it works to create DC by uploading a CSV file. We tried and marked an error every single time we did so with DC that didn't exist in zendesk. We had to create a Python script linked to a spreadsheet  and the API to make updates in bulk. 

    0
  • Aswin Kannan

    How to add new DC using CSV import? I can add translations for existing DC, but cannot create new DC. I have 100+ items to be added, but HATE to add them one by one.

    0
  • Devan - Community Manager
    Zendesk Community Team

    Hello Aswin,

    As the product currently stands Dynamic content is that it's an update, and not a create function. If you wish to add new dynamic content in, I would recommend using our Dynamic content API: Create Item endpoint instead.

    Best regards,

    Devan

    -1
  • Aswin Kannan

    I know everything can be done by API, because that's the only recommendation you guys ever give. This should be a native functionality in Zendesk. Why would we pay for Zendesk and then use our own software resources to build these stuff?

    1
  • Bonnie Schofield

    Is there a way to import dynamic content that contains commas and is in multiple lines (i.e. a macro)?  When the import process hits the first comma it errors out.

    I've created a csv file that looks like this:

    "Title","nl text"
    "Admin::Account Update Closed Ticket Transfer","Hallo {{ticket.requester.first_name}},

    We moesten het ticket dat je op 00/00/2016 hebt ingediend, opnieuw aanmaken.

    We hebben een schermafdruk van je originele ticket bijgevoegd.

    Met vriendelijke groet,
    {{ticket.assignee.name}}"

    The import process errors out with Malformed CSF input - Unclosed quoted field, line 2.

    I'm assuming this is because line 2 ends in a comma so it sees this as the end of the 'nl text' field. 

    This is a bad omen because I have 955 records to update (far too many to upload manually).

    0
  • Mikell Beechinor

    Is special formatting carried back into the system when additional languages are imported? For example, we've used a lot of tables to break out information. Does this detail exist in the exported CSV and if updated, will it pull back into Guide? Any guidance is appreciated. Thanks! 

    1
  • Brett - Community Manager
    Zendesk Community Team

    Hey Mikell,

    I'm not quite sure if the formatting is saved when importing additional languages into Guide. I'm going to create a ticket on your behalf so our Customer Advocacy team can follow-up with you.

    Cheers!

    0

Please sign in to leave a comment.

Powered by Zendesk