On Wed, Jun 07, 2006 at 01:01:16AM +0200, Christian.Iseli@xxxxxxxx wrote: > - The bugzilla report listing all the closed FE-ACCEPT tickets is now pretty > large, and the web server refuses to let me download the CSV file in one go > because the URI is too large. I guess there is a way to directly access > bugzilla's database, but I have no experience there. Can anyone lend me a > hand there ? Crediting Bill Nottingham and Jesse Keating here, they figured this out for my rebuild scripts. wget -O fe-accept.csv \ "https://bugzilla.redhat.com/bugzilla/buglist.cgi?query_format=advanced&query_format=advanced&short_desc_type=allwordssubstr&short_desc=&component_text=&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&fixed_in_type=allwordssubstr&fixed_in=&qa_whiteboard_type=allwordssubstr&qa_whiteboard=&devel_whiteboard_type=allwordssubstr&devel_whiteboard=&keywords_type=allwords&keywords=&cust_facing=&cust_facing_type=substring&emailassigned_to1=1&emailtype1=exact&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailcc2=1&emailtype2=exact&email2=&bugidtype=include&bug_id=&votes=&changedin=&chfieldfrom=&chfieldto=Now&chfieldvalue=&field0-0-0=blocked&type0-0-0=equals&value0-0-0=163779&ctype=csv"; Yes, that's kind of a long URL, but it gets you the CSV file. :-) Note the bug number is 163779 in the URL; you can change that as necessary for other blocker bugs. The other trick is to use a cookie to select your columns. #!/bin/sh COOKIES=~/bin/cookies.txt URL='https://bugzilla.redhat.com/bugzilla/buglist.cgi?query_format=advanced&query_format=advanced&short_desc_type=allwordssubstr&short_desc=&component_text=&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&fixed_in_type=allwordssubstr&fixed_in=&qa_whiteboard_type=allwordssubstr&qa_whiteboard=&devel_whiteboard_type=allwordssubstr&devel_whiteboard=&keywords_type=allwords&keywords=&cust_facing=&cust_facing_type=substring&emailassigned_to1=1&emailtype1=exact&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailcc2=1&emailtype2=exact&email2=&bugidtype=include&bug_id=&votes=&changedin=&chfieldfrom=&chfieldto=Now&chfieldvalue=&field0-0-0=blocked&type0-0-0=equals&value0-0-0=163779&ctype=csv' OUTPUT='fe-accept.csv' wget -O ${OUTPUT} "${URL}" where cookies.txt looks like (note the data is all one line): # HTTP Cookie File # http://www.netscape.com/newsref/std/cookie_spec.html # This is a generated file! Do not edit. # To delete cookies, use the Cookie Manager. bugzilla.redhat.com FALSE /bugzilla FALSE 2145917240 COLUMNLIST alias%20bug_severity%20priority%20rep_platform%20assigned_to%20bug_status%20resolution%20component%20short_short_desc Thanks, Matt -- Matt Domsch Software Architect Dell Linux Solutions linux.dell.com & www.dell.com/linux Linux on Dell mailing lists @ http://lists.us.dell.com -- fedora-extras-list mailing list fedora-extras-list@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/fedora-extras-list
