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-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] *On Behalf Of *Javier Garcia
*Sent:* 21 April 2009 10:50
*To:* Jo Rhett
*Cc:* rt-users@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:jrh...@netconsonance.com]
*Sent:* 20 April 2009 17:34
*To:* Javier Garcia
*Cc:* rt-users@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.gar...@snowvalley.com <mailto:javier.gar...@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: sa...@bestpractical.com
    <mailto:sa...@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: sa...@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: sa...@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: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Reply via email to