Jira Cloud for Excel Functions stopped working

[jbruno]

I have some VBA that creates a new spread sheet, then pops in a Jira function

Here is an example.

=@JIRA.JQL("project = CLIENT and issuetype = 'Client' order by summary","key, summary, status, linked issues",,)

The plug-in worked beautifully. It would grab the data, everything was right in the world.

Then it stopped working.  I had someone else at my company try it, it doesn't work for them either. 

It looks like it is trying to import data, but just does nothing. 

I am able to open a new sheet and click the 'Get Data Now' and have it pull in data, so I know I can connect to Jira.

And yes...

1. I did try a different copy of my workbook

2. Rebooted

3. Made sure it wasn't just me.

4. Rebooted again.

5. Googled

Thanks for the help!

[SimonS · Accepted solution]

Hey Jesse,

There are instructions to importing JIRA issues to OnDemand here:

http://confluence.atlassian.com/display/AOD/Importing+Issues

Essentially, you create a backup and use the import wizard to import it.

The import will wipe out what you have in JIRA OnDemand, so be warned!

-Simon

[Jesse Anson]

Is there any way to just load in issues for 1 project on the new instance of Jira without impacting the other jira? I'm starting down the path of manually updating but was just curious. Certainly don't want to overwright anything.

[SimonS]

I'm afraid there isn't a way to import one project. However, you could get a backup of your OnDemand data, import it into a local, evaluation version of JIRA, use the "project import tool"

(http://confluence.atlassian.com/display/JIRA/Restoring+a+Project+from+Backup)

And then re-import the data back to OnDemand.

It is a bit of legwork though and might not be worth the effort. We also don't (ofically) support giving out OnDemand backups unless you are moving to a download version of the licenses. Since it would be your first time requesting a backup, and you are already a paying customer, it may be worth filing a ticket in our support portal requesting a backup.

https://support.atlassian.com/secure/Dashboard.jspa

[Andre Lehmann]

Why not make a csv-import? There you can map all your fields and all your status.