[rt-users] Migration

[Keith A McDermott]

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:* 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
>>
>>