[rt-users] Migration

[Ken Crocker]

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:* rt-users-bounces at lists.bestpractical.com 
>> [mailto:rt-users-bounces at lists.bestpractical.com] *On Behalf Of 
>> *Javier Garcia
>> *Sent:* 21 April 2009 10:50
>> *To:* Jo Rhett
>> *Cc:* rt-users at lists.bestpractical.com
>> *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_threaded#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:jrhett at netconsonance.com]
>> *Sent:* 20 April 2009 17:34
>> *To:* Javier Garcia
>> *Cc:* rt-users at lists.bestpractical.com
>> *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
>>
>>     javier.garcia at snowvalley.com <mailto:javier.garcia at snowvalley.com>
>>
>>     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: sales at bestpractical.com
>>     <mailto:sales at bestpractical.com>
>>
>>
>>     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: sales at bestpractical.com
>>
>>
>> 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090422/d767aa5a/attachment.htm>