Exporting and importing dynamic content (Professional and Enterprise)

Have more questions? Submit a request

24 Comments

  • Jack Elver-Fiddimore
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    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.
    Comment actions Permalink

    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
    Comment actions Permalink

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

    0
  • Jenni K.
    Comment actions Permalink

    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
    Comment actions Permalink

    Hi!

    Does anybody knows how long does the process could take?

    0
  • Nicole - Community Manager
    Comment actions Permalink

    Hi Evelia, 

    It depends how much content you're working with. 

    0
  • Claire Santos
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    Thanks for sharing, Lucas!

    0
  • Mikkel Diurhuus
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    @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
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    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 La Spisa
    Comment actions Permalink

    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
    Comment actions Permalink

    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?

    0
  • Bonnie Schofield
    Comment actions Permalink

    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

Please sign in to leave a comment.

Powered by Zendesk