You are here

Create your own custom daily Get Satisfaction email report with emailReport.rb

Submitted by Roland on Mon, 2010-08-02 23:42

UPDATE November 2011:

The code has been dramatically re-factored so i deleted it from the gist. Please use the revised code at:
https://github.com/rtanglao/momogs/blob/master/emailReport-m.rb

For my technical support lead job at Mozilla Messaging, I continue to try to find the best way to sort and sift and help out folks who need support and identify the hot issues. We currently use Get Satisfaction for Thunderbird support and I subscribe via email to everything but it's really difficult to read through the over 200 emails a day that Get Satisfaction sends

So I developed over the last 9 months a series of Ruby scripts to see the most active support topics (getactive.rb),  the contributors who are actually being marked by the community of users as solving a support topic (getcontributors.rb), who's doing the most replies (gethappykludged.rb) and pick out some random support topics (getrandom.rb)

Up until last week I have been using these scripts on a manual basis but not as consistently as I would like since it's pain to run all four manually.

To make a single email report that ties together everything in one nice summary, last week I finally took 3 hours and wrote emailReport.rb (code after the jump). It's crude but it works and is a useful report that I run every day now for the previous day (e.g. on Monday morning, I run it for Sunday and Saturday). It runs all the above mentioned scripts and then emails a summary email:

Here's an example of how you invoke it:

(for August 2, 2010)

./emailReport.rb 2010 8 2 2010 8 2 2>emailreport.20100802.20100802.stderr 1>emailreport.2010082002.20100802.stdout

And here's a sample email:

From: xxxx@gmail.com
To: yyyy@zzzzzo.com
subject: MoMo Support Report FROM: 2010.8.2 TO: 2010.8.2
Date: Mon, 02 Aug 2010 23:31:16 -0700
Get Satisfaction Top 5 active:
5,http://getsatisfaction.com/mozilla_messaging/topics/how_do_i_export_folders_as_mbox_files_thanks_chris
5,http://getsatisfaction.com/mozilla_messaging/topics/migration_of_thunderbird_data_from_old_to_new_computer
4,http://getsatisfaction.com/mozilla_messaging/topics/delivering_mail_98_thunderbird_problem
4,http://getsatisfaction.com/mozilla_messaging/topics/from_thunderbird_to_outlook_how
4,http://getsatisfaction.com/mozilla_messaging/topics/cannot_start_thunderbird_already_runnning

Get Satisfaction Contributors:


Top 10 Get Satisfaction Repliers:
2, cam_1319937
3, simonpaquet
3, ankitgupta1980
3, davro
3, pat_drummond
3, kent_james
4, bhuvnesh_thakar
5, wayne_mery
9, archaeopteryx
30, michael_a_pasek


5 Random Get Satisfaction Topics:
http://getsatisfaction.com/mozilla_messaging/topics/crashing_after_start_up
http://getsatisfaction.com/mozilla_messaging/topics/problems_editing_an_email_to_be_forwarded
http://getsatisfaction.com/mozilla_messaging/topics/dmg_file_whats_this
http://getsatisfaction.com/mozilla_messaging/topics/want_to_use_thunderbird_for_mass_mailing
http://getsatisfaction.com/mozilla_messaging/topics/pasting_images_takes_minutes

What I did well

  • It works and when it doesn't I can check stderr for diagnostics and usually quickly figure out what went wrong (Get Satisfaction has a known bug on topics that have URLS that begin with numbers and also JSON can't cope when folks paste binary data into support topics; fortunately both cases are rare -:-) !)

What could be improved

  • The JSON API is called on the same data four times, once for each script (i.e. I don't store any of the GS data) so it takes 5-10 minutes to run emailReport.rb!
  • It would be more efficient to just read the data into a database, e.g. couchdb and then have the four scripts read from the database
  • Ruby is not an excellent choice for Windows users; would be better to write this in JavaScript and then anybody (i.e. other support contributors not just folks on Mac OS X or Linux) could use it
  • Badly need to way to extract the GS conversations I am involved in and highlight the top 5
  • Although a separate can of worms :-), I would love to have a really great search engine that works on the GS support data; unfortunately the GS management view search doesn't work so well.

Help Wanted

I'd love some help :-) (what's in it for you! Open Source Whuffie, fame and adventure :-) !!!)   in the following areas:

  • Convert to JavaScript and to a web app so all can use it :-) !
  • Put the GS support data into a JSON friendly database like CouchDB

 

The Code

The code has been dramatically re-factored so i deleted it from the gist. Please use the revised code at:
https://github.com/rtanglao/momogs/blob/master/emailReport-m.rb

 

Comments

Very awesome post , i am really impressed with it a lot

<a href="http://www.zecrosoft.com/2014/09/Benefits-of-Ginger.html">فوائد الزنجبيل</a>   <a href="http://www.zecrosoft.com/2014/09/Pomegranate-benefits-for-diet.html">فوائد الرمان</a>

 <a href="http://www.zecrosoft.com/2014/09/Benefits-of-the-ring.html">فوائد الحلبة</a>

 <a href="http://www.zecrosoft.com/2014/09/Onion-benefits.html">فوائد البصل </a>

 <a href="http://www.zecrosoft.com/2014/09/Benefits-thyme.html">فوائد الزعتر</a>

 <a href="http://www.zecrosoft.com/2014/09/benefits-sesame-oil.html">فوائد زيت السمسم </a>

 <a href="http://www.zecrosoft.com/2014/10/hemorrhoids-treatment.html">علاج البواسير</a>

 <a href="http://www.zecrosoft.com/2014/10/Benefits-of-anise.html">فوائد اليانسون</a>

 <a href="http://www.zecrosoft.com/2014/09/turmeric-benefits-for-hair.html">فوائد الكركم</a>

<a href="http://www.zecrosoft.com/2014/10/joha-stories.html">قصص جحا</a>   <a href="http://www.zecrosoft.com/2014/10/Photos-on-Friday.html">صور يوم الجمعه</a>

 <a href="http://www.zecrosoft.com/2014/10/Signs-of-Pregnancy.html">علامات الحمل</a>

 <a href="http://www.zecrosoft.com/2014/10/Definition-of-Love.html">تعريف الحب</a>

 <a href="http://www.zecrosoft.com/2014/10/life-of-isthmus.html">حياة البرزخ</a>

 <a href="http://www.zecrosoft.com/2014/10/Benefits-of-Raisins.html">فوائد الزبيب</a>

The clarity in your post is simply great Must confess that you present powerful steps on this blog, MrqePromoCode You definitely know what you were talking about and Your intelligence on the post could be giving us new knowledge.Pretty great post. InkPromoCode I simply stumbled upon your  weblog and wanted to say that I have really loved browsing your blog posts.Simply wish to say your article is as astonishing. The clarity in your post is simply great and i could asume you are an expert on this subject. AutoPartsPromoCode Well with your permission let me to grab your RSS feed to keep updated with forthcoming post.

http://www.jordanconcords.net http://toryburchoutlet.projectsouthomaha.net http://www.michaelkors-outletonlinesale.eu.com http://www.burberryoutletsale.name http://www.hogan-shoes.us http://copywatches.freebirdspublishing.com http://ralphlaurenuk.josephsiri.com http://www.louisvuitton.name http://www.retrojordans.name http://www.outlet-celine.com http://www.gucci-outlet.org http://www.kobeshoes.org http://www.dior-handbags.us http://timberlands.fairskinmen.com http://www.rayban-sunglasses.eu.com http://www.louisvuittonhandbags.net.co http://adidasrunningshoes.coloradosoapstone.com http://timberlands.colegrovephotography.com http://uggsoutlet.fairskinmen.com http://michaelkorsoutlet.new-letter.com http://www.canadagooseoutlet.name http://abercrombie.rekey-your-locks.com http://jordanretro.sellittodaywithebay.com http://www.gucci.net.co http://www.moncler-jackets.cc http://www.cheapnfljerseys.eu.com http://www.tomsshoes.name http://www.michaelkors--outletonline.in.net http://timberlanduk.fairskinmen.com  http://guccibelts.realestatecranbrook.net http://adidasoutlet.coloradosoapstone.com http://tomspromocode.raleighdowntowner.co http://chaneloutlet.milaneverett.com http://www.thenorthface.net.co http://www.prada-outlet.us http://todsshoesoutlet.kingmancommercialrealestate.com http://timberlandearthkeepers.thedailysabs.com http://www.canadagooseoutlet.cc http://oakleyvault.oakleywebsite.net http://www.celine-outlet.us http://michaelkors.aphidsymposium.org http://truereligionjeans.charleschin.com http://timberlandcanada.fairskinmen.com http://www.burberryoutlet.net.co http://whitetimberlandboots.thedailysabs.com http://toryburchhandbags.projectsouthomaha.net http://chaneloutletonline.milaneverett.com http://www.jordan6.net http://timberlandoutlet.thedailysabs.com http://whitetimberlandboots.colegrovephotography.com http://www.marc--jacobs.com http://www.poloralphlauren.us.com http://burberryscarf.totalwealthplanner.com http://www.jordan11.name http://burberrysale.thewhimsicalsage.com http://www.toryburch-outlet.in.net http://redtimberlandboots.colegrovephotography.com http://guccioutlet.realestatecranbrook.net http://www.guccioutlet.net.co http://guccishoes.realestatecranbrook.net http://timberlandpro.thedailysabs.com http://www.ugg-boots.eu.com http://burberryhandbags.totalwealthplanner.com http://www.coachfactoryoutletonline.eu.com http://www.oakleysunglasses-wholesale.name http://www.canada-goose-jackets.com http://burberrybags.suleymanaltun.com http://www.rayban-sunglass.net http://www.guccishoes.us.com http://www.oakleysunglasses.us.com http://todssale.kingmancommercialrealestate.com http://timberlandoutlet.colegrovephotography.com http://www.abercrombie.in.net http://abercrombieoutlet.rekey-your-locks.com http://jordanretro11.sellittodaywithebay.com http://tomscanada.raleighdowntowner.co http://chanelhandbags.coloradosoapstone.com http://www.jimmy-choo.cc http://airjordan11.sellittodaywithebay.com http://www.oakleysunglasses-outlet.name http://canadagoosejackets.pensacolacandles.com http://burberrybags.totalwealthplanner.com http://redbottomshoes.maximumguarantee.com http://www.dolcegabbana.us.com http://www.kevindurantshoes.name http://burberryoutlet.thewhimsicalsage.com http://www.abercrombieoutlet.name http://timberlandboots.fairskinmen.com http://www.truereligion-outlet.in.net http://www.canadagoose-outlet.us.com http://www.uggbootoutlet.in.net http://discountoakleysunglasses.oakleywebsite.net http://hollister.charleschin.com http://www.redchristianlouboutin.com http://ralphlauren.josephsiri.com http://www.louisvuitton-lvoutlet.com http://www.tory-burch-outlet.us.com http://truereligionoutlet.colosseum-club.com http://chanel.coloradosoapstone.com http://www.ugg-boots.com.co http://burberryoutletonline.suleymanaltun.com http://www.holisterclothingstore.com http://raybanaviators.thedailysabs.com http://jordan11s.sellittodaywithebay.com http://knockoffwatches.freebirdspublishing.com http://www.louisvuittonoutlet-inc.us http://christianlouboutin.maximumguarantee.com http://timberlandcanada.thedailysabs.com http://www.ghdhairstraighteners.com.co http://redbottoms.maximumguarantee.com http://burberrysale.suleymanaltun.com http://www.moncler-jackets.org http://canadagoosesale.pensacolacandles.com http://hollisterclothing.charleschin.com http://www.the-northface.us.com http://www.oakleysunglasses-wholesale.net http://www.ray-bansunglasses.name http://www.abercrombiestores.net http://montblancpen.cabanavacationrentals.com http://www.truereligion.eu.com http://truereligionsale.colosseum-club.com http://www.christianlouboutin-shoes.info http://rayban.letterpresskids.com http://uggs.uggaustralia.de.com http://www.holister.name http://www.michaelkorshandbags.eu.com http://beatsbydrdre.letterpresskids.com http://raybansunglasses.thedailysabs.com http://www.abercrombiestore.org http://montblanclegend.cabanavacationrentals.com http://www.monclerjacketsoutlet.us.com http://www.canada-gooses.name http://timberlandboots.colegrovephotography.com http://toryburchsale.projectsouthomaha.net http://www.ralph-laurenoutlet.com.co http://fakewatches.freebirdspublishing.com http://www.northfacejacketsoutlet.us.com http://www.christianlouboutinoutlet.org http://www.coach-factory.eu.com http://www.jordan13.org http://www.alexander-wang.us http://beatsheadphones.letterpresskids.com http://www.chiflat-iron.us http://www.juicy-couture.us http://www.rolexwatchesoutlet.us http://cheapoakleysunglasses.oakleywebsite.net http://blacktimberlandboots.fairskinmen.com http://chanelonlineshop.milaneverett.com http://www.jordan4.net http://abercrombieandfitch.rekey-your-locks.com http://www.abercrombie-fitch.cc http://www.coachoutletstoreonline.us.org http://todsoutlet.kingmancommercialrealestate.com http://www.ray-banoutlet.name http://www.canada-goosejackets.net http://oakleysunglasseswholesale.oakleywebsite.net http://www.toms--shoes.com http://burberryoutletonline.thewhimsicalsage.com http://burberrysale.totalwealthplanner.com http://burberrybags.thewhimsicalsage.com http://www.fitflops.org http://www.jordan11s.name http://www.abercrombieoutlet.us.com http://toryburchflats.projectsouthomaha.net http://canadagoosejacket.pensacolacandles.com http://www.michael-korsoutlet.eu.com http://www.ugg-boots.eu http://www.mulberry.com.co http://www.adidasshoes.name http://raybanwayfarer.thedailysabs.com http://www.oakley-sunglasses.info http://burberryscarf.suleymanaltun.com http://www.oakleysunglass.eu.com http://lululemon.suleymanaltun.com http://www.timberlandboots.cc http://burberryoutletonline.totalwealthplanner.com http://www.hollisterclothing.us http://tomsoutlet.raleighdowntowner.co http://www.uggsoutlet.in.net http://www.coach-outlet.us.com http://www.christian-louboutinshoes.com http://imitationwatches.freebirdspublishing.com http://oakleysunglassescheap.oakleywebsite.net http://www.abercrombiekids.name http://timberlandboots.thedailysabs.com http://www.fendi.us.com http://www.hollisteroutlet.name http://www.cheap--nfljerseys.us http://www.raybanwayfarer.biz http://www.christianlouboutinoutlet.com.co http://www.jordan11concord.org http://polooutlet.josephsiri.com http://uggoutlet.uggaustralia.qc.com http://www.kobebryantshoes.name http://www.louisvuitton.us.com http://www.raybansunglassesoutlet.name http://christianlouboutinoutlet.maximumguarantee.com http://www.hollisterclothing.info http://www.burberry-outlet.us.com http://cheapbeatsbydre.letterpresskids.com http://www.supra-shoes.cc http://www.ugg-boots.in.net http://www.fitflop.us.com http://www.bottega-veneta.cc http://christianlouboutinsale.maximumguarantee.com http://www.todsshoes.us http://www.chanelbags.com.co http://montblancmountain.cabanavacationrentals.com http://www.blackfriday-2014.us http://www.burberry-outlet.net.co http://poloralphlauren.josephsiri.com http://raybans.thedailysabs.com http://www.guessoutlet.org http://todsoutletstore.kingmancommercialrealestate.com http://www.givenchy.us.com http://burberryhandbags.thewhimsicalsage.com http://www.burberry-outletonline.net http://www.cheapuggssale.in.net http://raybanoutlet.thedailysabs.com http://timberlanduk.thedailysabs.com http://oakleyoutlet.oakleywebsite.net http://adidasoutletstore.coloradosoapstone.com http://truereligion.colosseum-club.com http://www.jordan8.net http://timberlandoutlet.fairskinmen.com http://jeremyscottadidas.coloradosoapstone.com http://www.jordan3.net http://concord11.sellittodaywithebay.com http://toms.raleighdowntowner.co http://cocochanel.coloradosoapstone.com http://beatsstudio.letterpresskids.com http://raybanglasses.thedailysabs.com http://burberry.thewhimsicalsage.com http://www.canada-goosejackets.biz http://replicawatches.freebirdspublishing.com http://tomswedges.raleighdowntowner.co http://www.coach-handbags.us.com http://timberland.fairskinmen.com http://www.raybans.name http://www.abercrombieandfitch.net.co http://burberryhandbags.suleymanaltun.com http://truereligionsale.charleschin.com http://www.cheapjordansshoes.in.net http://www.christianlouboutinsale.biz http://cheapoakleys.oakleywebsite.net http://www.oakleysunglasses-wholesale.cc http://chanelhandbags.milaneverett.com http://www.lebronjames-shoes.name http://www.nike-outletstores.com http://adidaswings.coloradosoapstone.com http://www.toms-shoes.cc http://www.versaceinc.us http://chanelbags.coloradosoapstone.com http://burberryoutlet.totalwealthplanner.com http://www.uggs-australia.us.com http://truereligionoutlet.charleschin.com http://www.insanityworkout.com.co http://www.toryburchoutlet.com.co http://www.katespadeoutlet.eu.com http://www.hermes-birkin.us http://www.lebronjames-shoes.net http://www.cheapjerseysnfl.eu.com http://www.christianlouboutin.net.co http://beatssolo.letterpresskids.com http://www.oakleysunglassescheap.name http://www.hollisterkids.net http://blacktimberlandboots.colegrovephotography.com http://www.thenorthfaceoutlet.eu.com http://abercrombiestore.rekey-your-locks.com http://www.fitflop-shoes.us http://hollisterco.charleschin.com http://www.cheap-jordans.us.com http://montblancpens.cabanavacationrentals.com http://redtimberlandboots.fairskinmen.com http://toryburchshoes.projectsouthomaha.net http://guccihandbags.realestatecranbrook.net http://www.michael-korsoutlets.eu.com http://www.louis--vuitton.us http://www.concords11.com http://www.canadagoose.com.co http://www.canada-gooseoutlet.net http://replicarolexwatches.freebirdspublishing.com http://ralphlaurenoutlet.josephsiri.com http://oakleysunglasses.oakleywebsite.net http://www.louisvuittonoutlet.net.co http://www.belstaff.name http://chaneloutlet.coloradosoapstone.com http://cheaptoms.raleighdowntowner.co http://www.tory-burch-outlet.eu.com http://www.christianlouboutinsale.name http://www.marc-jacobs.name http://toryburchoutletonline.projectsouthomaha.net http://www.p90xworkouts.us http://www.abercrombie.net.co http://www.montblancpens.com.co http://www.poloralphlaurenhome.net http://truereligionjeans.colosseum-club.com http://www.hollister-co.net http://burberryoutlet.suleymanaltun.com http://canadagoose.pensacolacandles.com http://retro11.sellittodaywithebay.com http://www.canada-gooses.ca http://guccibags.realestatecranbrook.net http://burberryscarf.thewhimsicalsage.com http://jordan11.sellittodaywithebay.com http://www.uggs-outlet.com.co http://www.montblanc.com.co http://www.louisvuitton-outlet.us.com http://www.abercrombieandfitch.cc http://www.canadagoosejackets.name http://www.coachoutlet-storeonline.eu.com http://www.hollister-clothing.net http://www.ferragamo.us.com http://hollisterjeans.charleschin.com http://timberlanduk.colegrovephotography.com http://truereligion.charleschin.com http://www.hermes-belts.org http://www.coachfactorystoreonline.us.com http://chanelbags.milaneverett.com http://abercrombiefitch.rekey-your-locks.com http://www.coachfactoryoutlets.eu.com http://www.canada-gooseoutlet.cc http://canadagooseoutlet.pensacolacandles.com http://hollisterkids.charleschin.com http://truereligionkids.colosseum-club.com

thanks so much for that great blog and thanks also for accepting my links thanks<a href="http://www.zecrosoft.com/2014/11/blog-post_11.html">طريقة عمل الدونات</a> <a href="http://www.zecrosoft.com/2014/11/way-to-preapare-.html">طريقة عمل البان كيك</a>  <a href="http://www.zecrosoft.com/2014/11/how-to-prepare-kanafa.html">طريقة عمل الكنافة</a>  <a href="http://www.zecrosoft.com/2014/11/way-to-prepare-basbousa.html">طريقة عمل البسبوسة </a>  <a href="http://www.zecrosoft.com/2014/11/way-to-prepare-cake.html">طريقة عمل الكيك</a>  <a href="http://www.zecrosoft.com/2014/11/The-way-the-pizza-dough.html">طريقة عمل عجينة البيتزا</a>  <a href="http://www.zecrosoft.com/2014/11/benefits-cinnamon.html">فوائد القرفه </a> 

Panthers quarterback Sale New Jerseys Cam Newton has returned to practice eight days after an automobile accident left Christian Louboutin Shoes him with two fractures in his lower back. Newton, wearing a long sleeve black shirt under his red practice jersey and a helmet, participated in Christian Louboutin Outlet all of the team drills Wednesday and did some throwing during the portion of practice open to the media. He didn't do much running. Coach Ron Rivera 2015 New Jerseys is expected to address Newton's status for Sunday's game against the Browns later Wednesday. Cardale Jones was thrusted into the starting quarterback role for the Buckeyes after J.T. Barrett broke his ankle against Michigan. Jones stepped up to the challenge and played a major role in dominating the Wisconsin Badgers in the Big Ten Championship Game. He passed for 257 yards and three New Nike NFL Hoodies Jerseys touchdowns on only 17 attempts. But you Cardale Jones’ awesome-ness can’t be fully expressed through a stat line. Here’s a couple of reasons why he’s New NBA Hoodies Jerseys our new favorite quarterback in college football:

Add new comment