GreaseMonkey Script to export ALL your My bubble stats to Excel in CSV format with a single click

After playing with my original CSV exporter I couldn’t resist trying to improve it somewhat.

  1. UPDATE (14/05/2009) : Amended to cater for the new MyBubble layout – no visual changes
  2. UPDATE (26/03/2009) : Amended to cater for the new MyBubble page – now look down the right of the page for the little excel icon :)
  3. UPDATE (31/12/2008) : Fixed a bug and all my scripts now also available on UserScripts.org
  4. UPDATE (24/12/2008) : Now added RB work ‘ID’ and Page number (as requested by Jo).

The downside to the original script was that it required you to go onto each ‘works’ page (e.g. clothing p1, p2, art, writing etc) to get the stats for each.

This version (named slightly differently on purpose) works only on the My Bubble page, via a sneakily inserted ‘quick link’ called ‘Retrieve CSV Stats’. Just click the link and ‘hey presto’ (after a number of seconds) you should find a number of tables at the bottom of the page with all your current work statistics (clothing, art, writing, calendars, journal) in a semicolon-delimited format (commas are more likely to appear in work titles and screw everything up :) ).

The idea is that you simply copy the text and paste it directly into Excel – make sure you paste as Text (older versions need this to be explicitly done through ‘Paste Special’). It shouldn’t need too much ‘text to columns’ mucking around.

If you like the sound of this then:

Download it from UserScripts.

Some people have been very kind in reporting bugs from previous scripts so please post a comment if something goes drastically wrong…

PS: For those of a technical disposition it then basically does some rather long-hand processing and retrieves each mybubble works page behind the scenes (using JQuery AJAX), gathers up the stats and then spits them out into separate tables at the bottom of the screen. The tricky bit is grafting together potentially multiple pages of works into one list (something I’d love RB to support as a preference).

Journal Comments

  • sepia
  • geetwee
  • geetwee
  • Matt Simner
  • geetwee
  • Matt Simner
  • Matt Simner
  • geetwee
  • Matt Simner
  • geetwee
  • Walter Quirtmair
  • Matt Simner
  • Walter Quirtmair
  • Sheila Laurens
  • Matt Simner
  • Sheila Laurens
desktop tablet-landscape content-width tablet-portrait workstream-4-across phone-landscape phone-portrait
desktop tablet-landscape content-width tablet-portrait workstream-4-across phone-landscape phone-portrait