<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Kieth,<br>
<br>
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 <i>all</i> 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.<br>
<br>
<br>
Kenn<br>
LBNL<br>
<br>
On 4/22/2009 5:48 AM, Keith A McDermott wrote:
<blockquote cite="mid:49EF121A.9050100@purdue.edu" type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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:* <a class="moz-txt-link-abbreviated" href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a>
[<a class="moz-txt-link-freetext" href="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</a>] *On Behalf Of
*Javier Garcia
*Sent:* 21 April 2009 10:50
*To:* Jo Rhett
*Cc:* <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>
*Subject:* Re: [rt-users] Migration
Hi all,
I have found the scripts here:
<a class="moz-txt-link-freetext" href="http://www.gossamer-threads.com/lists/rt/users/53073?do=post_view_threaded#53073">http://www.gossamer-threads.com/lists/rt/users/53073?do=post_view_threaded#53073</a>
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 [<a class="moz-txt-link-freetext" href="mailto:jrhett@netconsonance.com">mailto:jrhett@netconsonance.com</a>]
*Sent:* 20 April 2009 17:34
*To:* Javier Garcia
*Cc:* <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>
*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
<a class="moz-txt-link-abbreviated" href="mailto:javier.garcia@snowvalley.com">javier.garcia@snowvalley.com</a> <a class="moz-txt-link-rfc2396E" href="mailto:javier.garcia@snowvalley.com"><mailto:javier.garcia@snowvalley.com></a>
10 Emerald Street, London, WC1N 3QA
Website: <a class="moz-txt-link-freetext" href="http://www.snowvalley.com">http://www.snowvalley.com</a> <a class="moz-txt-link-rfc2396E" href="http://www.snowvalley.com/"><http://www.snowvalley.com/></a>
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>
<a class="moz-txt-link-rfc2396E" href="mailto:sales@bestpractical.com"><mailto:sales@bestpractical.com></a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
--
Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source
and other randomness
------------------------------------------------------------------------
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
</pre>
</blockquote>
<pre wrap=""><!---->_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
</pre>
</blockquote>
</body>
</html>