Migrating from Lighthouse to JIRA


I am trying to migrate my issue tracking system from Lighthouse to JIRA. I haven't noticed any tools to easily import my issues and attachments. (the JSON importer only imports single files. Lighthouse has a file for every single issue)

I have spent the past two weeks writing a script to convert the JSON files to your XML backup format with a considerable degree of success; however reverse-engineering your backup format has been giving me several headaches.

I am at the point where all of my issues are migrated to my local server, but I cannot mark any issues as resolved, and attempting to create an issue yields an exception:

Error creating issue: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Issue][summary,lol][status,1][votes,0][assignee,andrew.ohara][security,null][resolutiondate,null][type,1][timespent,null][id,10400][reporter,andrew.ohara][project,10300][environment,null][created,2013-01-22 15:20:15.202][updated,2013-01-22 15:20:15.202][workflowId,10400][description,null][priority,2][timeestimate,null][duedate,null][timeoriginalestimate,null][watches,0][key,DEV-264] (SQL Exception while executing the following:INSERT INTO PUBLIC.jiraissue (ID, pkey,

Is there a better way to migrate my issues over?

Or can you maybe lend some light on how to resolve the two issues I have mentioned.

Thanks for any help

3 answers

1 accepted

It turns out that the CSV import was tailored specifically towards situations like mine. I'm using that now.

Could you exlpain specifically what part of the interface is supposed to help me? And which of my problems this is supposed to help with?

createIssue would be the most used. The rest would depend on what information you want to bring over (attachments, projects, versions, components, etc...). I have imported issues from a variety of other trackers and all were based on JCLI to do the work on the JIRA side. This approach avoids having anything to do with the XML format or issues related to not getting it right.

Thank you. I have been exploring the CLI and have been adapting my script to use it. However, I need the user id of the issue assignee and reporter, but there seems to be no way to retrieve this information. Google doesn't seem to help. Do you know how I can find the ids?

Also. Is there any way to bundle requests together to reduce wait time for multiple commands akin to an SQL transaction?

Thanks for the suggestion, but it turns out that my boss would rather I use the CSV import. I hadn't realised that it is tailored specifically towards my situation.

I actually ended up trying to "import project" rather than doing a system restore every time I wanted to test my script output. Using this method, I get errors where issues could not be created, but editing and creating an issue works.

After looking at the log, it would appear that there are key collisions (despite the fact that they actually are unique, and based off of their lighthouse bug number. e.g. DEV-1911), so I'm assuming that this is some insanity having to do with issue key conventions. For some reaosn, JIRA tries auto-incrementing some of the keys I give it, but I have no idea why.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

91 views 0 1
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