New and Improved 3.13 Beta. Highlights: Shareable filters and dashboards and lots of other goodies. Any feedback can be raised as JIRA issues in the JIRA project.
Issue Details (XML | Word | Printable)

Key: JRA-1368
Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Edwin Wong [Atlassian]
Reporter: Scott Farquhar [Atlassian]
Votes: 2
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
JIRA

Bugzilla import tool

Created: 25/Feb/03 07:22 AM   Updated: 03/Jun/03 10:14 PM
Component/s: Extensions
Affects Version/s: None
Fix Version/s: 2.1 Pro

Time Tracking:
Not Specified

File Attachments: 1. Java Source File BugzillaImport.java (24 kB)

Participants: Ben Christensen, Edwin Wong [Atlassian] and Scott Farquhar [Atlassian]
Since last comment: 5 years, 18 weeks ago
Resolution Date: 03/Jun/03 10:14 PM
Labels:


 Description  « Hide
Create a bugzilla import tool that would create issues and users from the bugzilla database.

Use jdbc to talk to mysql and get the data straight from the database. Use the JIRA API to insert issues directly.

 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
[ Permlink | « Hide ]
Ben Christensen added a comment - 13/Mar/03 07:25 PM
In JIRA 2.0.1 the Bugzilla import is there, however...

(I'm importing from Bugzilla Version 2.16.1 )

1) The passwords that it converts don't seem to work, and I had to make a new field called password and copy the values from the cryptpassword column into it for it to even try and work. It did successfully create the users in JIRA after that, but the passwords don't work when trying to login.

2) After getting past the user import it errors out right here too...

Importing Projects...

Importing Project: CMS
Error importing Project: CMS
com.atlassian.jira.exception.CreateException: One of the fields (key, lead, name) is not present or of the wrong type
at com.atlassian.jira.action.project.ProjectUtils.createProject(ProjectUtils.java:35)
at com.atlassian.jira.web.action.util.BugzillaImport.createProject(BugzillaImport.java:441)
at com.atlassian.jira.web.action.util.BugzillaImport.createProjects(BugzillaImport.java:421)
at com.atlassian.jira.web.action.util.BugzillaImport.doExecute(BugzillaImport.java:120)
at webwork.action.ActionSupport.execute(ActionSupport.java:114)
at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:113)
at webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:161)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.atlassian.core.security.SecurityFilter.doFilter(SecurityFilter.java:170)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.atlassian.core.security.LoginFilter.doFilter(LoginFilter.java:191)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.atlassian.jira.web.filters.EncodingFilter.doFilter(EncodingFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
at java.lang.Thread.run(Thread.java:536)

0 projects imported from Bugzilla.

Importing Versions...

Importing Version: 1.06
Error importing data from bugzilla.
Unable to load driver.
java.lang.NullPointerException
at com.atlassian.jira.project.DefaultProjectManager.getVersion(DefaultProjectManager.java:95)
at com.atlassian.jira.project.CachingProjectManager.getVersion(CachingProjectManager.java:91)
at com.atlassian.jira.web.action.util.BugzillaImport.createVersion(BugzillaImport.java:382)
at com.atlassian.jira.web.action.util.BugzillaImport.createVersions(BugzillaImport.java:374)
at com.atlassian.jira.web.action.util.BugzillaImport.doExecute(BugzillaImport.java:121)
at webwork.action.ActionSupport.execute(ActionSupport.java:114)
at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:113)
at webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:161)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.atlassian.core.security.SecurityFilter.doFilter(SecurityFilter.java:170)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.atlassian.core.security.LoginFilter.doFilter(LoginFilter.java:191)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.atlassian.jira.web.filters.EncodingFilter.doFilter(EncodingFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
at java.lang.Thread.run(Thread.java:536)

The table structure I have in bugzilla is:

attachments
attachstatusdefs
attachstatuses
bugs
bugs_activity
cc
components
dependencies
duplicates
fielddefs
groups
keyworddefs
keywords
logincookies
longdescs
milestones
namedqueries
products
profiles
profiles_activity
shadowlog
tokens
versions
votes
watch

-------------------

If you want anything more particular about the db please contact me and I'll be more than happy to help, since I'd like to get this imported within the next couple days if possible.


[ Permlink | « Hide ]
Edwin Wong [Atlassian] added a comment - 13/Mar/03 10:09 PM
Ben,

Would you mind sending your sql scripts of the bugzilla database to me so that I can reproduce your problem locally here?

Cheers,
Edwin


[ Permlink | « Hide ]
Scott Farquhar [Atlassian] added a comment - 15/Mar/03 11:16 PM
I have attached the Bugzilla import file that was included with JIRA 2.0.

[ Permlink | « Hide ]
Scott Farquhar [Atlassian] added a comment - 28/Apr/03 12:48 AM
More issues with import:

1. All issues lose their previous time stamps. They now have the time
stamp of the import run.

2. A Bugzilla project title with less than 3 characters width can't be
imported.
Powered by Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13_beta1-#328) - Bug/feature request - Atlassian news - Contact Administrators