Monday, June 21, 2010

Custom Reporting with Apps Script

Editor's Note: Romain Vialard is a business school student working as a junior product manager at a very large Google Apps Customer. His role is to increase productivity and customer satisfaction through training and knowledge management with Google Apps.

I work at a large enterprise that often deals with thousands of trouble tickets in a day, so we make great use of JIRA’s support and tracking products. We recently embarked on a quest to improve our reporting, which in turn makes managing our projects easier.

Apps Script provides the ability to fetch any url, and easily parse the resulting html or xml document. We can now retrieve our trouble tickets, field by field and month by month to form the basis of our custom reports.

And thanks to the time driven triggers the reports can be automatically generated every morning - waiting for us as we arrive at the office!

We’ve posted ths script in the Apps Script Gallery, and it is also available in this Spreadsheet Template. Take a look at the YouTube video below to see the script in action:



Posted by Romain Vialard, Google Apps Scripter!

6 comments:

  1. 河水永遠是相同的,可是每一剎那又都是新的。......................................................................

    ReplyDelete
    Replies
    1. Machine Learning Projects for Final Year machine learning projects for final year

      Deep Learning Projects assist final year students with improving your applied Deep Learning skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include Deep Learning projects for final year into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Deep Learning Projects for Final Year even arrange a more significant compensation.

      Python Training in Chennai Python Training in Chennai Angular Training

      Delete
  2. 在莫非定律中有項笨蛋定律:「一個組織中的笨蛋,恆大於等於三分之二。」....................................................................

    ReplyDelete
  3. Beberapa tips cara menggugurkan kandungan untuk anda dengan menggunakan obat penggugur janin cytotec , terbukti obat aborsi asli sangat ampuh . Jika anda telah haid obat telat datang bulan terbaik juga manjur , kami jual obat aborsi ini secara online cara menggugurkan hamil

    ReplyDelete