Export view to CSV file without 10 min limit

Thanks Serge! It works great.

Bookmarklet is a great idea!

I have slightly modified your script. Now I can export ticket descriptions, which I can not by standard way.

Awesome!  Thanks Serge!

@Deniel, can you share your modified script so I can export ticket descriptions as well?

Thanks!

I'm glad you liked it.

Following is the script code with "description".

javascript:var win=window.open("","","width=600,height=500,scrollbars=yes");var vn=+window.location.href.replace(/(.*filters\/)/,""); var w=win.document; w.write("<p style='font-family: Arial; color:black; margin:3; font-size: 12; align-text:right;'>Export view to CSV file <a href='http://app1.roundrobin-assignment.com/?utm_source=prs' target=' _blank'>Created by Round Robin App team</a> (<a href='https://twitter.com/RoundRobinApp' target=' _blank'>@RoundRobinApp</a>)</p><div style='background-color:#4C4F53; margin-bottom:15'><input type='text' id='fn' value='view"+vn+".csv' style='margin:4'><button type='button' onclick='mycl()'>Save</button></div>"); w.write("<script>function mycl(){var saveData = (function () { var a = document.createElement('a'); document.body.appendChild(a); a.style = 'display: none'; return function (data, fileName) { try{ var blob = new Blob([data], {type: 'octet/stream'}); var url = window.URL.createObjectURL(blob); a.href = url; a.download = fileName; a.click(); setTimeout(function(){window.URL.revokeObjectURL(url);}, 2000); } catch(e) {alert('Your browser does not support saving files created on the client side. Please use Copy and Paste.')} }; }());var data=document.getElementById('data').innerHTML;data=data.replace(/(<br.*>)/g,'');var fileName = document.getElementById('fn').value;saveData(data, fileName);}</script>");var url="/api/v2/views/"+vn+"/execute.json";var l=1;f(url);function ai(a, s, p){for(var i = 0, len = a.length; i < len; i++){if (a[i][p] === s) return i;} return -1;}; function gv(o, r, a){var v=o.rows[r][a]; if (typeof v == "undefined") {v=o.rows[r][a+"_id"];}; if (v !== null) {if(a=="assignee" || a=="requester"){return o.users[ai(o.users, v, "id")].name}; if (a=="group") {return o.groups[ai(o.groups, v, "id")].name};if (a=="organization"){return o.organizations[ai(o.organizations, v, "id")].name};if (a=="via"){return v.channel}; return v;} else {return ""};};function f(u){var xh=new XMLHttpRequest();xh.onreadystatechange=function() {var obj; if(xh.readyState==4&&xh.status==200){obj=JSON.parse(xh.responseText); w.write("<div id='data'style='font-family:Arial;font-size:14;'>"); var q=String.fromCharCode(34); var q1 =String.fromCharCode(39); var s="id,Description"; if (l == 1) {for (var j = 0; j < obj.columns.length; j++) { s += ","+q+obj.columns[j].title+q; }; l=0; w.write(s+String.fromCharCode(13,10)+"<br id=0>"); }; for (var i = 0; i < obj.rows.length; i++) {var s=obj.rows[i].ticket.id+","+q+obj.rows[i].ticket.description.replace(/[\r\n]/g," ").replace(/"/g, q1).replace(/\s+/g, " ")+q; for (var j = 0; j < obj.columns.length; j++) {s += ","+q+gv(obj,i,obj.columns[j].id).toString().replace(/[\r\n]/g," ").replace(/"/g, q1).replace(/\s+/g, " ")+q; }; w.write(s+String.fromCharCode(13,10)+"<br id=0>"); }; if(obj.next_page!==null){f(obj.next_page)}else{w.write("</div>")}; }; };xh.open("GET",u,true);xh.send();};

Thanks! I'm glad you liked it.

The script code with "description" is here.

The addition of Description fields to the CSV is exactly what we needed to compile and efficiently distribute high volumes of user feedback to other departments.

Thank you Serge, and thank you Deniel.

@Alexander Thanks!

Last week we had found and fixed a bug in the code of this script. The double quote character was not escaped in Description field. All who are faced with the issue, please update your bookmarklet.

The fixed script is here.

thanks for the update, Serge!

Thanks for the update Serge!

This works well for me.  Does anyone know how to or if it is possible to export the following:

1. all public comments, not just the original 

2. links to attachements

Thanks,

Brian

Hi Brian!

You can get this information using our API: https://developer.zendesk.com/

Hi Jessie,

Thanks for the info on the API - I have gone through it.  Here is my goal - I want to export a specific view to a CSV, but with the public comments and the attachment link. I need those elements for my weekly review with the requestor.

The tool above is great because it dumps the view easily to a CSV, but does not have the other fields I need.

I can get the API to export my view to a CSV as well, but not with the custom fields.

Trying to find the best solution and I thought the above was the closest solution.  Any ideas for me?

Brian

Hi Brian!

If you're pulling the View itself via API it'll be subject to the same restrictions as the in-product tool.

What you want to do is actually pull the information via API completely independent of the View you created. The API contains all the endpoints you need to pull the exact set of tickets you need, along with the custom fields you want. 

I'm afraid I don't have in-depth knowledge of how to accomplish so I can't personally give more guidance than that. But if you have further questions I can certainly find somebody to help you out!