#!/bin/ksh
###
### convertjira.sh
###
### Usage: convertjira.sh filename
###
### Convert Jira.xml file into HTML
echo "<html>" > jira.html
echo "<head><title>jira</title>" >> jira.html
echo "<meta content=text/css http-equiv=Content-Style-Type>" >> jira.html
echo "<link href=\"http://www.setgetweb.com/lstyle.css\" rel=stylesheet type=text/css>" >> jira.html
echo "</head>" >> jira.html
echo "<body>" >> jira.html
echo "<font class=grey2>" >> jira.html
echo "<blockquote>" >> jira.html
echo "<blockquote>" >> jira.html
echo "<p> </p>" >> jira.html
echo "<center><h1>Jira</h1></center>" >> jira.html
echo "<p> </p>" >> jira.html
echo "<p><hr>" >> jira.html
echo "<table border=1 cellpadding=10>" >> jira.html
awk 'BEGIN{ctr=0}{
FS="<"
RS=">"
for ( i=1; i<=NF; i++ )
{
if ($i ~ /^Issue /)
{
print $0
#num = split ($0,word," ")
#for (x=num; x >= 0; x--)
#{
#print word[x]
#if(word[x] ~ /key=/)
#{
# xkey=word[x]
#}
#if(word[x] ~ /reporter=/)
#{
# xreporter=word[x]
#}
#if(word[x] ~ /summary/)
#{
# xsummary=word[x]
#}
#if(word[x] ~ /description/)
#{
# xdescription=word[x]
#}
#
# print xkey " / " xreporter " / " xsummary " / " xdescription
# #print $key "/" $reporter "/" $summary "/" $description "/"
# }
}
}
}' jira.xml > jira.out
sed -e :a -e "$!N;s/\n / /;ta" -e "P;D" jira.out | sed "/^$/d" | sed "s/\"//g" > tmp.out
mv tmp.out jira.out
sed "s/ id=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ key=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ project=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ component=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ fixfor=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ reporter=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ assignee=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ type=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ summary=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ description=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ environment=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ priority=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ resolution=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ status=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ created=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ updated=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ votes=/~/" jira.out > tmp.out
mv tmp.out jira.out
sed "s/ timeestimate=/~/" jira.out > tmp.out
mv tmp.out jira.out
cut -d"~" -f10 jira.out > tmp.out
mv tmp.out jira1.out
cut -d"~" -f3 jira.out | \
sed "s/^/<tr><td valign=top nowrap><a href=\"http:\/\/jira\/secure\/ViewIssue.jspa\?key=/" | \
sed "s/$/\">/" > jira2.out
cut -d"~" -f3 jira.out | sed "s/$/<\/a><\/td><td valign=top>/" > jira3.out
paste -d" " jira2.out jira3.out jira1.out | \
sed "s/~/<\/td><td valign=top>/g" | \
sed "s/$/<\/td><\/tr>/" >> jira.html
echo "</table>" >> jira.html
echo "<p> </p>" >> jira.html
echo "To regenerate this file" >> jira.html
echo "<ol> <li> Log into <a href=\"http://jira\">jira</a>" >> jira.html
echo "<li> Export to a file called /tmp/jira.xml" >> jira.html
echo "<li> scp emerson:/tmp/jira.xml www.setgetweb.com:/usr/tomcat/webapps/ROOT/engineering" >> jira.html
echo "<li> Log onto www.setgetweb.com and cd /usr/tomcat/webapps/ROOT/engineering" >> jira.html
echo "<li> Execute: convertjira.sh" >> jira.html
echo "</ol> " >> jira.html
echo "<center> " >> jira.html
echo "<p><hr>" >> jira.html
echo "<p> </p>" >> jira.html
echo "<p> </p>" >> jira.html
echo "<script javascript=\"JavaScript\"> " >> jira.html
echo " document.write(\"<br>Last updated: \"+document.lastModified); " >> jira.html
echo "</script> " >> jira.html
echo "</blockquote>" >> jira.html
echo "</blockquote>" >> jira.html
echo "</body>" >> jira.html
echo "</html>" >> jira.html