Recent searches


No recent searches

Exporting and importing dynamic content



Edited Jun 21, 2024


2

15

15 comments

Hi,

I would like to export our DCs, make some slight changes to language versions (I need to delete some lines from text) and import the file back to Zendesk. Would it be possible? 

I tried to do this without success. The email I received states

"Malformed CSV input.

 The error was:

Illegal quoting, line 1."

Would you have any advice? 

0


image avatar

Brett Bowser

Zendesk Community Manager

Hey Mateusz,

I'm going to create a ticket for you so we can take a look at the CSV file you're trying to import.

You'll receive an email shortly stating your ticket has been created.

Cheers!

0


Hello, 
I was struggling a bit for a while with the format for importing, until I realised i couldn't import dynamic content that hadn't been created yet, I think it would be a really useful tool to be able to import a csv file with the needed values to create new items in dynamic content and that they automatically are bulk created after import with the given values, also giving feedback about the process through email instead of directly through the app is a bit cumbersome when you are trying to figure out what's going on wrong.

5


Hello

I also need to know if there is a way to change the default language of each record by import, without having to do it manually? I have done several tests by changing the "Default language" in the file to the default language or the target one, but it does not work.

 

0


Hi,

I agree with Omar that the need for creating dynamic content before importing is not practical at all. I would love to be able to export DC from Help Center to its Sandbox without needing to create the DC items one by one in Sandbox :/

I hope it will be possible to bulk create DC in Sandbox while importing a csv file that is exported from Help Center.

3


Hi,

How do you import the en version? I copied the columns from the exported en-US csv and use that to import but I got an error:

Malformed CSV input.

Expected column missing: Language text

 
 
 

0


image avatar

Dane

Zendesk Engineering

Hi Riah,
 
Your CSV should be similar to the one below. You also need to make sure that you have the values for "Title" and "en-US text".
 

 
 
Hope this helps!
 

0


Hi All,
The system for importing excels within Zendesk is really hopeless. I work on an a Apple computer, but I can't get it done under Windows either.

When you download the file from your Zendesk environment, the delimiter is:

"Title","Default language","Default text","fr text","Variant status","Placeholder"

If I export to a UTF-8 format from Excel (mac or Windows) I get the following string

Title;Default language;Default text;fr-be text;Variant status;Placeholder

Zendesk recognizes the ; not. Why can't you just import an xlx or an xls file?

I am now always get the error: Column Title is missing.

 

1


Hi

for information (and because I had a lot of trouble before I got there), when I was working on the imports, living in France, I had to change : 
- the Country Format of the PC in the "region" settings via the control panel (select "English (US)" )
- the Excel separators in Options / Advanced Options / Editing Options (Uncheck "Use system separators" and change the "Decimal Separator" to ".") 

All this makes that when I saved my excel files in separator ";", they saved in separator "," expected by Zendesk. And combined with the choice of the UTF-8 Format, it was good. 

Note: don't forget to change theses parameters when the Zendesk work is finished

0


Is there a limit of rows for Dynamic Content import?

0


image avatar

Christine

Zendesk Engineering

Hi Riah,

You can create up to 2000 rows, but not exceeding 2MB file size.

If you will need to import more than 2000 rows, please split your files and wait for the ‘import_ready’ mail confirmation before submitting the next file. Remember to keep the headers in the different files to preserve the format.

Hope this helps!

0


Hello,

Quick question : if I export my csv, change some titles, and import back the csv, what would happen ? I guess it wouldn't modify the lines because the title is the identifier. Will it create a new line ?

Any workaround to modify titles in bulk action ?

Thank you

0


image avatar

Salim Cheurfi

Zendesk Customer Care

Hi Maxime, 
 
If you export the CSV file then import it again with a new title for your Dynamic content, you will get an error "Tittle not found" 
I'm afraid we don't have a native way to edit titles in bulk I'm sorry, you can use the API to update titles PUT /api/v2/dynamic_content/items/{dynamic_content_item_id} but it's not meant for bulk editing. 
 
Don't hesitate to post a feature request in our feedback forum 
 
Have a great one !

0


Can we create new dynamic content by importing or this is only to update?

0


image avatar

Darenne

Zendesk Customer Care

Hi Raphaël Peguet, the dynamic content imports do not create new Dynamic content. Importing dynamic content does not allow you to create "new" ones. You have to manually create it first in your Support account and if you have to update it in bulk, that's where you can use the import option
 
You can also check this documentation that we have about creating new dynamic content via API - https://developer.zendesk.com/api-reference/ticketing/ticket-management/dynamic_content/#create-item. I also highly encourage you to send a feature request on this page so that our product team may consider adding an out-of-the-box bulk import for new dynamic content: https://support.zendesk.com/hc/en-us/community/topics/1260801325369--Feedback-Ticketing-System-Support-

0


Please sign in to leave a comment.