Hi, I've finally finished the migration.
We have to test everything but I'm reasonably happy about it. I will send an update with my code changes asap. Cheers, Javier -----Original Message----- From: Keith A McDermott [mailto:[email protected]] Sent: 23 April 2009 13:56 To: Ken Crocker Cc: Javier Garcia; [email protected] Subject: Re: [rt-users] Migration Kenn, I have not, however I am definitely not too good at programming - let alone perl (my brain is hard-coded to procedural not object-oriented programming). Sounds interesting though as a possible side-project as we're not going to be live with RT for some time. Keith Ken Crocker wrote: > Kieth, > > Have you thought about writing a program to copy all the Bugzilla data > into flatfiles that can then be used as input to another program that > uses API to create tickets, etc? We just converted an old legacy > ticket system into RT doing just that, comments and email included. > Converted 17,000 tickets. Of course, I had to take RT down and then > turn OFF /all/ scrips, etc (didn't need 17,00 emails going out). > Afterwards, I did a little bulk updating for some custom fields and > viola! All done. Tirn system on, Turn on scrips. ready to go. > > > Kenn > LBNL > > On 4/22/2009 5:48 AM, Keith A McDermott wrote: >> I'd like to see this if it does eventually work. I gave up on converting >> our bugzilla database many months ago. Although we have 12,000 bugzilla >> tickets, it wasn't worth the time and pain for us to try to fix the script. >> >> Thanks, >> Keith >> >> Javier Garcia wrote: >> >>> OK. I've found out that my initialdata file is wrong. There's nothing >>> on the @Groups array. >>> >>> I've downloaded a new initialdata file (the syntax is as follows): >>> >>> @Groups = ( >>> >>> { Name => '', >>> >>> Type => 'Everyone', # loc >>> >>> Domain => 'SystemInternal', >>> >>> Instance => '', >>> >>> Description => 'Pseudogroup for internal use', # loc >>> >>> }, >>> >>> But then I get a new error: >>> >>> Odd number of elements in hash assignment at >>> /opt/rt3/lib/RT/Group_Overlay.pm line 405. >>> >>> /opt/rt3/lib/RT/Group_Overlay.pm line 405: >>> >>> my %args = ( >>> >>> Name => undef, >>> >>> Description => undef, >>> >>> Domain => undef, >>> >>> Type => undef, >>> >>> Instance => '0', >>> >>> InsideTransaction => undef, >>> >>> _RecordTransaction => 1, >>> >>> @_ >>> >>> ); >>> >>> I'm not an expert Perl developer, but I have tried modifying the >>> @Groups array, adding more fields or deleting others, but nothing, >>> same error. >>> >>> *From:* [email protected] >>> [mailto:[email protected]] *On Behalf Of >>> *Javier Garcia >>> *Sent:* 21 April 2009 10:50 >>> *To:* Jo Rhett >>> *Cc:* [email protected] >>> *Subject:* Re: [rt-users] Migration >>> >>> Hi all, >>> >>> I have found the scripts here: >>> >>> http://www.gossamer-threads.com/lists/rt/users/53073?do=post_view_thread ed#53073 >>> >>> But they are not working. After following the README I ran "sh >>> migrate.sh" and got the following: >>> >>> Could not load Everyone group on user creation. >>> (/opt/rt3/lib/RT/User_Overlay.pm:222) >>> >>> The error is on the following block: >>> >>> my $everyone = RT::Group->new($self->CurrentUser); >>> >>> $everyone->LoadSystemInternalGroup('Everyone'); >>> >>> unless ($everyone->id) { >>> >>> $RT::Logger->crit("Could not load Everyone group on user creation."); >>> >>> $RT::Handle->Rollback(); >>> >>> return ( 0, $self->loc('Could not create user') ); >>> >>> } >>> >>> And we are not able to solve it. There's no information about it on >>> the Internet. Any ideas? >>> >>> I have a hunch that it has to do with the relationship between the >>> principals, groups and ACL table. >>> >>> Any help would be greatly appreciated, otherwise we can continue >>> writing bespoke scripts to fit our needs. >>> >>> We are currently running RT 3.8.2 under Debian Etch. >>> >>> Cheers, >>> >>> Javier >>> >>> *From:* Jo Rhett [mailto:[email protected]] >>> *Sent:* 20 April 2009 17:34 >>> *To:* Javier Garcia >>> *Cc:* [email protected] >>> *Subject:* Re: [rt-users] Migration >>> >>> Yes. Search the mailing list archives or Google. Both of which return >>> the script you need quickly. >>> >>> On Apr 20, 2009, at 8:59 AM, Javier Garcia wrote: >>> >>> We are manually migrating all our Bugzilla databases to RT using >>> Perl, but we are having issues with some of them and I can't find >>> anything on the Internet. >>> >>> Is there a documented way on How to migrate Bugzilla to RT? >>> >>> Does anybody have a script for that? >>> >>> PS: Both servers are running on Debian and using MySQL. >>> >>> Thanks, >>> >>> Javier Garcia >>> >>> Systems Engineer >>> >>> [email protected] <mailto:[email protected]> >>> >>> 10 Emerald Street, London, WC1N 3QA >>> >>> Website: http://www.snowvalley.com <http://www.snowvalley.com/> >>> >>> _______________________________________________ >>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >>> >>> Community help: http://wiki.bestpractical.com >>> Commercial support: [email protected] >>> <mailto:[email protected]> >>> >>> >>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>> Buy a copy at http://rtbook.bestpractical.com >>> >>> -- >>> >>> Jo Rhett >>> >>> Net Consonance : consonant endings by net philanthropy, open source >>> and other randomness >>> >>> ------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >>> >>> Community help: http://wiki.bestpractical.com >>> Commercial support: [email protected] >>> >>> >>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>> Buy a copy at http://rtbook.bestpractical.com >>> >> _______________________________________________ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: [email protected] >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> >> _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
