Exporting and importing dynamic content (Professional and Enterprise)

Have more questions? Submit a request

20 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

    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 K.

    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 K.

    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 - Community Manager

    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 VS

    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

    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

    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".

    0
  • 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

    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. 

    0
  • Nicole - Community Manager

    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.

    -1
  • 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

Please sign in to leave a comment.

Powered by Zendesk