Create Reports Using Excel - FogBugz Knowledge Exchange

Create Reports Using Excel

2009-10-15T07:00:09Z

How can I use FogBugz data to make reports in Excel?

Answer by Rich Armstrong for Create Reports Using Excel

2009-11-12T03:03:27Z

FogBugz 7 and later has an Excel export functionality straight out of the grid view. If you want to export all edits for your cases, you can do so using the XML API (without doing any programming).

For older versions, there's a blog post about using the API and Excel 2007's data import functionality here:

http://www.fogcreek.com/FogBugz/blog/post/An-API-Tutorial-Plus-Excel-2007-Export-Plus-Zombies!.aspx

Answer by Andrew for Create Reports Using Excel

2010-02-17T14:32:47Z

Is there a version for people that only speak English ?

I lost the will to live at the point when the instructions refer to "API" What is API ? where can I get one ?

Us administrators are just that, administrators, not programmers, so we do not have the rights to download Google Chrome or FireFox, nor I suspect API. The instructions need to be on a key press by key press basis.

All I want to do is dump a list of Fogbugz cases to Excel. Cut and Paste would do nicely

I finally managed by using Internet Explorer as follows: Get List of Cases in Fogbugz Click 'Edit' (top line) Click Select all Open Excel Paste (Ctrl V)

The top 100 lines of the spreadsheet are complete rubbish, but delete it and you have a usable spreadsheet.

So my method is 3 clicks, or you can spend hours with API and Pivot tables (Programmers only)