Scott Havard

Alternatively, if someone is still having success exporting articles internally let us know! It could be good to rule out any settings that we have configured on our end. 

Hello Zendesk! (Maybe @...?) 

I previously have been advising on using OAuth to export all articles. I recently have found that using OAuth doesn't actually export that data by default anymore! Now using Basic Auth or OAuth only exports the fully public/published docs.

Any way to work around this? I tried to edit the endpoint to specify the internal section and category, but it returns no data. 

This may have been a security thing? The OAuth token should be enough security in its own. Either way, most of us need the exports to include internal articles. Would love if the endpoint got reverted or to get an advice on a different approach. I can edit my scripts to try and help enable this for everyone else!

Hi @...,

Sorry for the delayed response.

I am assuming aren't successfully exporting your "internal" articles, or those not viewable to everyone, when you run the script. Is that true?

If you haven't tried already, give the Oauth script a shot:
https://github.com/scotthavard92/Zendesk-Help-Center-Export-Scripts/tree/master/Article_Information_Export#exporting-internal-articles-using-oauth

When I run the script not using Oauth it doesn't return any of our "internal" articles.

When I do use the Oauth script it dumps everything other than archived articles.

Let us know if that helps solve it!

Cosmin, 

Unfortunately Section ID doesn't easily export from the Zendesk API endpoint that I use :(.

I can do a little digging to see if I can't find another solution.

Good luck!

Hi Diogenez!

Thanks for reaching out. So I looked up the error and it looks like a cedilla(ç) is breaking it. Out of curiosity, what language is your data in?

Maybe try replacing the  'NFKC' in lines 47, 51 and 75 with either 'NFD' or 'NFC' and see if that solves the problem? This upcoming week I can dive in more and try to fix it. This is my first guess though, so I would give the above a shot if you are in a hurry.

Here is documentation explaining the character decoding that my script does:

https://docs.python.org/2/library/unicodedata.html#unicodedata.normalize

You can see that there is some commentary on how it tries to interpret characters, including the cedilla.

Let me know if this works!!! Good luck, and keep me up to date!

Hi Ron!

Sorry for the delay on a response. It looks like it is possible to get the body of the article outputted as a CSV. See the 'body' key of this page https://developer.zendesk.com/rest_api/docs/help_center/articles/.

Do you want just the body of the information? Or all of the information in addition (i.e. article id, title, etc.)?

Either way, I think it is possible. If you are familiar with Python, it should be pretty straight forward to edit this script: https://github.com/scotthavard92/Zendesk-Help-Center-Export-Scripts/blob/master/Article_Information_Export/Zendesk_Guide_Article_Export.py.

You will essentially want to do what Mary (above in the comments) did for 'draft', but do it for 'body' instead. something like:

You will also need to add the info to the write rows section at the bottom and the header appending at the top. 

I am happy to help you figure it out! let me know.

Hey Kurt!

I just added the "updated_at" code in the GitHub repository.

https://github.com/scotthavard92/Zendesk-Help-Center-Export-Scripts/blob/master/Article_Information_Export/Zendesk_Guide_Article_Export.py

In short I added the "updated_at" as a string type. Hopefully that will do it for you! I had trouble storing it as a different data type.  

It looks like the YouTube commenter was able to do it! It might be worth asking how Apathia did it in case you need a different data type.

Keep me posted!

I also need this functionality.

Ideally I would use 30x redirection, but I ended up needing to utilize a JS script as people have mentioned above. Many people have shared great solutions, so I would like to share mine as well:

https://github.com/scotthavard92/Zendesk-Help-Center-Redirection

This is far from the ideal, 30x redirect solution though. Feel free to reach out with questions.

This is great Mary!

I am so happy to see that you got it to work, and also thank you for sharing information about the "The Unarchiver". 

Did your code work? (Nice work on adding stuff!)

One comment is that you may want to change int(draft) to bool(draft). If it runs either way, then it is probably fine either way. 

I updated the code in the repository to add a "draft" row as well. 

Hey Mary!

Thank you for the kind words.

I am glad to hear that you were able to successfully get the requests library using pip. This suggests that python is installed correctly, and requests is now installed on your machine.

I want to give you a big thanks for providing feedback so quickly, I imagine your issue is one that will arise on many occasions. 

To address your questions:

• Zendesk has a good article on locating your subdomain here: https://support.zendesk.com/hc/en-us/articles/221682747-Where-can-I-find-my-Zendesk-subdomain-

• My main suspicion with your error is that the file was saved incorrectly. Sometimes adding the “.py” at the end of the file isn’t enough to save it correctly. What program did you use to copy and paste the script? I have had this issue with Microsoft Word before. One solution is to download the full repository from GitHub (as described in the video I posted above), and move Zendesk_Guide_Article_Export.py to where you want to run it from (i.e. your Desktop). Let me know if this works

• You asked about extracting all article links owned by a particular author. Once you get my script working, I strongly suggest you do this from a spreadsheet (such as in Google Sheets or Excel). If you “Sort By” to organize the data, sort the sheet by author id. It will list all articles, article URLs, etc. by author id. This will work similarly in most spreadsheet software, but here is some information if using Google Sheets (which is free): https://support.google.com/docs/answer/3540681?co=GENIE.Platform%3DDesktop&hl=en
• I am not certain how to connect the author id to an authors name, however (our team is small, so I just dive back into Guide and can link author id with a name). We can brainstorm on this one if you have a giant team.

• Lastly, you asked about extracting all Draft articles owned by a particular author. Draft can be exported as TRUE/FALSE as written in the API documentation (true means the article is currently a draft).
• If that value is exported, I would suggest doing the organization from a spreadsheet (such as in Google Sheets or Excel). If this sounds reasonable, then I can add the code to export this value and update you when it is done.

Best,

Scott