Priorities lost in RT2 to RT3 upgrade

None of my tickets that I just imported into RT3 have priorities.

I’m using rt2-to-rt3-v1.13

For example, I have a ticket that is at Priority 40 in the dump
file, and the ticket entry where the priority was changed was
preserved, but the Priority is listed as 0/0.

The priority is also at 0 in the database itself, but is set
correctly AFAICT in the dump file, so it really does
seem to be an import script problem.

The import is to “mysql Ver 12.20 Distrib 4.0.13, for pc-linux-gnu (i686)”

Help?

-Robin

Me: http://www.digitalkingdom.org/~rlpowell/ *** I’m a male Robin.
“but I’m not stupid and people are not stupid who think samely with me”
– from an actual, real, non-spam mail sent to webmaster@lojban.org
http://www.lojban.org/ *** .i cimo’o prali .ui

That sounds like RT::Ticket_Overlay doesn’t take the Priority parameter.
I’ll take a patch to rt-bugs@fsck.com.On Tue, Jul 08, 2003 at 11:38:19AM -0700, Robin Lee Powell wrote:

None of my tickets that I just imported into RT3 have priorities.

I’m using rt2-to-rt3-v1.13

For example, I have a ticket that is at Priority 40 in the dump
file, and the ticket entry where the priority was changed was
preserved, but the Priority is listed as 0/0.

The priority is also at 0 in the database itself, but is set
correctly AFAICT in the dump file, so it really does
seem to be an import script problem.

The import is to “mysql Ver 12.20 Distrib 4.0.13, for pc-linux-gnu (i686)”

Help?

-Robin


Me: http://www.digitalkingdom.org/~rlpowell/ *** I’m a male Robin.
“but I’m not stupid and people are not stupid who think samely with me”
– from an actual, real, non-spam mail sent to webmaster@lojban.org
http://www.lojban.org/ *** .i cimo’o prali .ui


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

http://www.bestpractical.com/rt – Trouble Ticketing. Free.

Indeed. Queue.pm and Ticket_Overlay.pm needed to be modified.
Patch submitted, although I make no claims as to its perfection.

-RobinOn Tue, Jul 08, 2003 at 02:41:50PM -0400, Jesse Vincent wrote:

That sounds like RT::Ticket_Overlay doesn’t take the Priority
parameter.
I’ll take a patch to rt-bugs@fsck.com.

On Tue, Jul 08, 2003 at 11:38:19AM -0700, Robin Lee Powell wrote:

None of my tickets that I just imported into RT3 have
priorities.

I’m using rt2-to-rt3-v1.13

For example, I have a ticket that is at Priority 40 in the dump
file, and the ticket entry where the priority was changed was
preserved, but the Priority is listed as 0/0.

The priority is also at 0 in the database itself, but is set
correctly AFAICT in the dump file, so it really does
seem to be an import script problem.

The import is to “mysql Ver 12.20 Distrib 4.0.13, for
pc-linux-gnu (i686)”

Help?

-Robin

Me: http://www.digitalkingdom.org/~rlpowell/ *** I’m a male Robin.
“but I’m not stupid and people are not stupid who think samely with me”
– from an actual, real, non-spam mail sent to webmaster@lojban.org
http://www.lojban.org/ *** .i cimo’o prali .ui

Quoting Robin Lee Powell (rlpowell@digitalkingdom.org):

None of my tickets that I just imported into RT3 have priorities.

I’m using rt2-to-rt3-v1.13

Where is that script located? I am working on a RT1->RT3 script, since
we have a way old database here that needs a little help. Currently I am
almost there it seems, but a look through the code would certainly help
me eradicate the last couple of wierdiness built into the RT3 database.

Jesper

Quoting Jesse Vincent (jesse@bestpractical.com):

That sounds like RT::Ticket_Overlay doesn’t take the Priority parameter.
I’ll take a patch to rt-bugs@fsck.com.

It does. Sets it to InitialPriority under RT::Ticket->Create(). But
changing that behaviour would surely be a bug. So add:

$args{‘Priority’} = $args{‘InitialPriority’} unless $args{‘Priority’};

and then update %params further down to take $args{‘Priority’}

(no, I am not going to do it).

Besides RT::Ticket->Import is dead code and should be elminated.

Jesper

Jesse Vincent wrote:

That sounds like RT::Ticket_Overlay doesn’t take the Priority parameter.
I’ll take a patch to rt-bugs@fsck.com.

A patch like the one at http://rt3.fsck.com/Ticket/Display.html?id=2648
perhaps? :slight_smile:

Jesper Louis Andersen wrote:

I’m using rt2-to-rt3-v1.13

Where is that script located?

http://www.fsck.com/data/pub/rt/devel/

I am working on a RT1->RT3 script, since
we have a way old database here that needs a little help. Currently I am
almost there it seems, but a look through the code would certainly help
me eradicate the last couple of wierdiness built into the RT3 database.

There’s also an RT1 to RT2 importer at

http://www.fsck.com/pub/rt/contrib/2.0/rt-addons/import-1.0-to-2.0

Phil Homewood, Systems Janitor, http://www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances