i disabled it and it didnt work, so i uninstalled it and it didnt work. so i deleted all custom fields too and it didnt work. so i reinstalled agile and it didnt work. and now the custom fields are locked so it isnt working. this is an absolute joke, a complete waste of time and money. how long has this issue been untouched? id say it was a pretty major flaw. not impressed.

Yesterday I try Disable Agile, Uninstall Agile and then Install Agile, then the Project Import work. The Story Point/ Sprint field doesn't block the import. But the Agile data is lost.

@Derek M, you would see which field block the import, e.g. "Severity", then you go to "Administration" > "Issues" > "Custom Fields" > Configure (the gear on the right of a custom field, e.g. "Severity", ).....

I found this workaround, but I cant find the option! Where is it?
All I see under Administration is: projects, add ons, user management, issues,system, and audit log

Workaround
Edit the configuration of the custom field 'Atlassian' so that there is no restriction for Issue Type (All Issue Type selected)

Administration -> Fields -> Configure (the gear on the right of a custom field) -> Edit Configuration for Applicable contexts for scheme -> Issue Types -> "All issue type" option.

well i feel like i have wasted money.
i try, i like, i buy. i cant move the data across. this truly sucks.
how can i import all my issues, ignoring the Agile stuff then? looks like i'll just have to bin my scrum board. I cant even remember customising any fields!
and how old is this issue? is it not like, important enough? that we cant do ANYTHING?

Almost a 2 year thread, 50+ comments and 129 votes sure does seem like it should get some attention.

understand my problem we have a standalone JIRA and Ondemand JIRA. Stand alone JIRA already has a lot of data in it and On demand also contains some data(Unfortunately there are two teams using separate On demand's) so i need take all the data from two On demand sites and import into Existing Standalone( Contains Data here too) JIRA. So i really don't know what to do......

Unfortunately, you have no choice (like me) .. unless, of course you accept to loose some data related to Agile (Sprints, etc).
Trust me - it's better to go as I said (save a lot of time and nerves). I know it has to be backed up and restored a huge amount of data but currently there is no other way.

Ohhhh... The existing instance already has a lot of data in it. So i cant do that

No workaround. The only way - full backup, restore on other instance. Then delete all that's not required leaving only desired project.

How close is a resolution for this? I need to import a project (that includes Agile) into another instance. What is the current workaround to get the Sprint data and User stories into the import target?

We finely decide to upgrade to Jira v6.1.5. But I do not feel very well, thinking on the frustation that will follow, after the next update. We surely will have to spend a lot of work again, in order to restore (fr)agile.

I have a feeling this wont be fixed any time soon. Its been almost 2 years since this was opened and there isn't even a person assigned to the issue to investigate it. Its almost criminal since Atlassian sells JIRA with greenhopper/Agile in one lenience package for development yet wont fix this basic functionality flaw.

This is an essential feature also for us. We are trying to migrate some projects from one JIRA instance to another and are not willing to lose all the sprint history and the backlog ordering.

This issue has the priority Blocker, but what is it blocking: The release 6.2

screenshot attached

Dear Support,

I face the same issue - cannot import a single project in JIRA 6.1.5 because of 'Sprint' field which is ridiculous.
I followed all the instructions with preparation of target instance before import (spent a lot of time) to finally know that this is impossible ... very frustrating. Project import simply doesn't work! Please update the guide as it's misleading - https://confluence.atlassian.com/display/JIRA/Restoring+a+Project+from+Backup
When do you plan to fix this?

One question: Are you going to implement it in Jira v6.2, as far as I know planned to be released in February?

I there any update on this yet....from anybody? Our company just invested pretty heavily in a 100 user license and we have three sites that use greenhopper/agile so we need to merge the sprints and everything onto one site (from three). When will this problem be resolved? It was first reported a year and a half ago, this is somewhat intolerable for an enterprise environment.

Hi.
One question: Is there a possibility to upgrade Jira by installing it unto an existing directory? Maybe in this way we can save all existing data.

Thanks and best regards,
José

are there any updates on this?

Is there any update on this as far as resolution or workarounds? We recently migrated jira via project import and have lost our Agile and Capture data.

How close is a resolution for this? I need to import a project (that includes Agile) into another instance. What is the current workaround to get the Sprint data and User stories into the import target?

Where is the Ranking, Start/EndRelease dates for versions exist? Is there specifics can be shared so we can perform this operation on our own? I already have a script to migrate Sprint information but require the information recently posted by David.

Am I understanding that with Agile 6.3 the sprints will be migrated? What version of JIRA? 6.0.8?

we will look at this, I sent you a linkedin invite

GH 6.3 – I upgraded both instances before and btw, that's something you want to do before because finally they fixed the mess with the sprint assignment.

You're doing it for GH 6.3? or 6.2?

If you think you can help me finishing the scripts, send me and email with your bitbucket accounts.

All right.. Thanks for the reply, can't wait to see it

I am still working at this, but it should be usable during next week, the problem is more complex that it may seem and my script will work only with latest Jira 5 (not 6) and latest Agile, and postgresql. Obviously, the latest changes in GH slowed me down.

I had to drop using SQL Server on one on the instances and switch to Postgres in order to have the same database.

HI Sorin Sbârnea, could you give us any information on the script you talked about.
We would be really interested into this.

We just ran into this issue when trying to import a new project from another JIRA instance on the same version. How long till a fix?

I think that also the external issue links are just... lost. internal ones are still here.

What is planned release time frame for this issue fix?

Hi Sorin,

I am also very interested in your solution if you plan to make it available. Thank you.

Hi Sorin,

That sounds great. Do you plan to make this script accessible? I would be very interested in a solution for this problem...

I wrote a script that can merge GH data from another instance, assuming that you already imported the projects using project import.

I got this working for sprints using a combination of python, GH REST, and Groovy. There are more details at https://answers.atlassian.com/questions/151204/how-to-create-a-sprint-using-the-greenhopper-rest-api/151803
but I wouldn't call it elegant!

And sprint ids would need to be merged

Quick summary: an XML backup files contain entities.xml (issue data) and activeobjects.xml (plugin data). A full import will import both sets of data. A project import only seems to pull in relevant data from entities.xml so all the data for plugins like GH and Zephyr is not present. Most of the plugin data could be imported to an identically-configured JIRA instance via SQL unchanged except for possibly:

different project ids
different board ids

but that's an ugly solution.

While testing jira 5.1, we realised: It seams, the Activity Stream is not fully imported along with the XML-Backup (missing in some projects), as it does in our Jira 4 (test system). This could be related to the same problem, don't you think so?

In the context of a missing functionality regarding the CSV-Import, the following advise was giving to me: "This would be possible by using JIRA Importers Plugin v4.2 or above. However, the plugin only compatible with JIRA 5.x and above". So what about the JIRA Importers Plugin? There could be also a problem, I can imagine.

Hi Jose, I think it is not related. We are facing a problem that happens after this check. Both license version already matches, the project migration runs, and no error is raised. But when you check the imported data, some fields were not imported.

I wonder, if the topic discussed here is somehow related to: Does my GreenHopper license have to match my JIRA license?

You will only be affected by this if you use single project imports:
https://confluence.atlassian.com/display/JIRA/Restoring+a+Project+from+Backup

This is a completely different process from a full site restore.

Is this also an issue when exporting from Jira OnDemand and restoring all data into a self-hosting jira instance? If so, this will really scupper our plans as it will affect dozens of projects. Additionally - will this mean that historical GH reports based on sprints are no longer available?

We have similar problem with Sprint custom field. We want to merge 2 instances of jira with greenhopper but import ignores sprints.

Boris, we already have Jira with 47 projects. GreenHopper server was a test server to confirm that everything is fine. I will need to merge the 2 servers and I don't want to import 47 projects into the new server. I will import 4 projects with GreenHopper in the main server.

ocourteau If you are importing into a new server, why not do a full restore instead of a project restore?

In case of Greenhopper plugin, there are 17 different tables (all of them starting with AO_60DB71_*) and in my case, one of them has more the 2000 lines. I would like to known how the tables are linked each-other (I mean: Which primary-key on table X is foreign-key on table Y). I use MySQL, and this kind of "link" is not easilly gathered from database, as far as I known.

What we did regarding Zephyr Plugin data:

• Open the JIRA Administration and look at the Plugin Data Storage to get the names of the relevant tables
• Check the tables via SQL
• Export all relevant data
• Import the data on another JIRA instance

PLEASE NOTE:
In order to make this work, we had to perform a JIRA export from the first test instance followed by a PROJECT import of that data on the second test instance.
Like this, we were able to import all tickets and attachments.
The SQL import added all the relevant plugin data to the issues.
BUT there will probably be some differences with the IDs, so you might want to write a mapper and test it on a few issues first.

We're using JIRA 5.1 in combination with the Zephyr plugin and we're facing the same problem.
After making a JIRA data backup on the first system and making a project import of the backup.zip on a second system, only the data from the file entities.xml was taken. The other file of the backup.zip (activeobjects.xml) was ignored.
Therefore, no Zephyr Test Details, Test Executions and Test Cycles were imported.

Did anyone find an alternative solution, yet?

Did anyone manage to transfer Greenhopper data somehow?

Does anybody known where I can found a database schema for Greenhopper database? I would like to try this "SQL magic" mentioned by Alexander, but I need to understand how the tables are connected each other... I'm considering that all the info we need is being stored inside SQL tables, of course.

Thanks

Is there maybe a way to copy the fields using some SQL magic.

Team,

Do we have any workaround to preserve such data during the project import?

Thanks!

In addition to the fields noted above, the Sprint custom field is not carried over from during a project import. I believe that this may be the GreenHopper plugin's failure to implement the correct interface, as described here: https://confluence.atlassian.com/pages/viewpage.action?pageId=223220264. However, it is related to the import of GreenHopper data.