Easiest way to export all issues from a project to plain text files?

We are moving away from ClearQuest as our main issue tracking system and replacing it with Jira.

One tool we developed in house for dealing with ClearQuest, called BugSearch, is based on Google Desktop Search (now a discontinued product). The way it worked with ClearQuest is that we have a doxygen & php based engine that would extract all of the issues from CQ and store them in a directory as flat plain-text files, and then BugSearch would use Google Desktop Search to look for the provided search terms.

This provided much more relevant search results than the native CQ queries could - as our web developer guy explained it to me, a query simply looks for the occurrence of the query string and produces a result set, whereas a search will look at the number of times the search string occurs and weight the results.

Because we have tens of thousands of issues in ClearQuest, we aren't going to spend the time to migrate them to Jira as we don't see any benefit, but it would be nice if we could update BugSearch so that it could search between CQ issues and new Jira issues in a way that is transparent to the user - because our existing bug database is very valuable in helping us to diagnose new bugs, whether we've seen them before, if it might be a hardware issue etc.

So what is the simplest way to extract issues from a Jira project into some sort of simple plain text file record? Is anyone aware of any plugins that might do what we want, or other existing Jira features that could work? We'd need to export the data at least once a day and it'd need to be automated.

2 answers

Hi Boris,

Can you elaborate further on the script? What we would need is to generate new txt files of all issues that were modified since the last time the script was run, rather than just new issues created since the last run, since it's quite possible for issues to sit around for months before they have work done on them, at which point we'd need to ensure any new content on those old issues was searchable. Would the script you suggest achieve that?

Also using the URL you've provided gives me these errors:

type Status report

message Error in the JQL Query: The character '%' is a reserved JQL character. You must enclose it in a string or use the escape '\u0025' instead. (line 1, character 14)

description The request sent by the client was syntactically incorrect (Error in the JQL Query: The character '%' is a reserved JQL character. You must enclose it in a string or use the escape '\u0025' instead. (line 1, character 14)).

The problem with the URL is that I've posted it encoded, so you have to pass it in normal form like http://yourjiraserver/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?jqlQuery=createdDate>startOfDay(-1d)&tempMax=1000

To find issues that were updated you can use the "updated" JQL keyword like:

updated>startOfDay(-1d)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,711 views 17 21
Read article

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