Developer blog

Monday, September 26, 2005

Bugzilla bugs import

I have got a lot of problems trying to do import bugs into bugzilla form external source. Problem was that we have got about 135 from external tester, that was stored in excel format. So I googled, that we can use standard importxml.pl script to perform import. So we exported excel to XML and tried to use this script. But this script not imported bugs well. After about two hours of trying to make this script work I found out that it do not work properly if you do not have every single tag in your XML file stored on single line. I do not know person who wrote this script, but his code style looks terrible.
So solution was to do

sed -e "s/></>\n</g" <1.xml >2.xml

with my XML file. So have got not just "XML file", and "XML file that you can use with importxml.pl script".