Bugzilla database model contains valuable information about the status of bugs, change request and the so forth. It is very productive to have an Ant (optional) task to exploit the Bugzilla tables (in MySQL) and translated the data into an output (say in XML format). Currently, I am not aware of any Ant task performing this.
our site's bugzilla generates XML on a GET request, which ant does support already via <get>. If you can get your site to do the same, you get what you want without coupling ant to bugzilla internals
Thank you Steve. It sounds like a good idea to use the 'get' task. This will solve my problem for now. However, using this approach, we are still stuck with HTML output :( It would be more practical to have the output in XML.
Steve, can you please give an example URL that returns an XML stream from BugZilla? Thanks, --DD
sorry, cant do that - its one of the private behind-the-firewall installations, hosted by Collab.net. So maybe it is a custom thing that isnt widely available, which of course it ought to be.
Hi Steve, As you are unable to provide your solution, don't you agree that this might be a valid enhancement request ? In my opinion, one possible approach to output Bugzilla content in XML format would be: (1) To abstract out the Bugzilla data model (kept in MySQL tables) using Java/JDBC (2) Output the fetched data in XML format (3) Use XSL/XSLT to translate the XML content into the desired format (e.x. HTML). Of course one could use the Ant SQL task to perform step (1) and fetch the data directly from the Bugzilla tables. Javad
I already do it for Cocoon, by using plain Ant tasks. 1 - I get the data using an http get 2 - run a jtidy task on it (submitted the task to ant-contrib, no reply yet) 3 - xslt the resulting xml 4 - send the result to the cocoon-dev list I have the server run this script once a week. What Ant (or maybe ant-contrib) could provide are a task that transform a declarative question to bugzilla in an http request URL, and a stylesheet to transform in xml the result. If you want I can put here tomorrow (now I'm at home) the scripts I have so you can work on it :-)
If this can be done by chaining a few Ant tasks, then there is no need for a enhancement request as I indicated previously. It will be constructive (or should I say productive) if you could make your scripts available so that others (including me) could use them. thank you. Javad
Attached below is a zip with the ant task+resources I use on my server for the Cocoon list. Don't hesitate to ask if in need.
Created attachment 7210 [details] bugger.zip
Thank you Nicola. I'll go over the files and get back to you (should I need to).
hello everyone i have already implemented some ant tasks that can export bugs from bugzilla to an xml file. my implementation also has some features that can be usefull for bugzilla administrators: - create/delete/edit versions/milestones i'm planning to have a FULL bugzilla support with ant tasks. please take a look at my attachment and let me know your opinion if it worth it for you or not. currently it is in development phase and i can test it only with our company's bugzilla installation. that is version 2.16.3 using ldap.
Created attachment 8581 [details] ant-bugzilla v1.0.4
fyi: changing show_bug.cgi to xml.cgi will output XML with bugzilla. http://issues.apache.org/bugzilla/xml.cgi?id=21414
XSLT documentation states Ant taskdef jars should be located on PATH Please correct XSLT doc to state XSLT Ant Classes and Jars will need to be located on CLASSPATH
Martin, please create new issues rather than modifying existing ones to report something entirely different than the ticket's been about.