Can I change the output settings from XML to a different format?

We recently upgraded to Office 2010 and our group policy blocks the opening of XML files due to security concerns. Since JIRA exports as XML but tags as xls, it appears to Save as a spreadsheet but is really an XML file. Is there a file to modify the output default settings?

2 answers

1 accepted

0 vote
Renjith Pillai Community Champion May 31, 2012

Actually the downloaded file from Jira is not XML rather html. So if you okay with a bit of mouse clicks, you can do the below workaround to open in Excel 2010.

Rename the downloaded .xls as .html. Open the file in Internet Explorer. Right click the displayed table and say, 'Export to Excel'. You should have the data now in Excel (You will lose the formatting and the HTML links to issues).

Renjith, that worked! Thank you. I am working with the security team to allow XML/HTML but that will take some time. Thanks again, Melanie

0 vote

Um, it has to be xml, or it's not an xml output and can't be read. If you look carefully at the files that are downloaded, you'll actually find they're named as office files already.

I'm not aware of anything that would generate the files as though they had been saved by Office 2010, so I'm afraid you'll probably have to write it for yourself. I don't know how "open" a format it is. The point of xml is that it's commonly readable, and not allowing the opening of xml files on modern computers is basically a bit silly (it's certainly pointless as a security measure)

Suggest an answer

Log in or Join to answer
Community showcase
Maarten Cautreels
Posted Thursday in Off-topic

Friday Fun: What's your favourite beer/drink

As a Belgian, beer-lover and home brewer, beer is one of my great passions. I love the fact that with just a few ingredients (usually just water, hop and malt) you can create so many different tastes...

285 views 38 9
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot