[rt-devel] First attempt at importing

[Jesse]

On Fri, Jun 08, 2001 at 11:00:02AM -0700, Bob Finch wrote:
> >>>>> "Jesse" == Jesse  <jesse at fsck.com> writes:
> 
>     > The transactions appear out of order on some tickets.  I think this
>     > only happens with tickets that were originally imported from Req.
>     > Maybe "order by trans_date" should be added to the select in
>     > MigrateTransactions?
> 
>     Jesse> Hmmm. That shouldn't be necessary with a standard RT
>     Jesse> install. But give that a shot on your local instance. if it
>     Jesse> looks like it does the right thing, I'll roll it into the
>     Jesse> release.
> 
> OK.  I'll try that today.   The problem is just with Req records that
> were imported into RT1.  When I do an unordered select in the RT1
> database for a serial number that was imported from Req, they appear
> in reverse cronological order -- the ones inserted by RT1 are OK.

Weird. Incidentally, which of the three req importers did you use?


> The import finally finished, but only one ticket was merged.  Looks
> like MyMerges is only picking up the first one it's passed. I'm
> going to try it again with the following patch:


Uh. yeah. *sheepish grin*  That might be good :)
> 
> *** import-1.0-to-2.0	Wed Jun  6 13:15:03 2001
> --- import-1.0-to-2.0-test	Fri Jun  8 10:54:35 2001
> ***************
> *** 797,803 ****
>   # {{{ sub MigrateMerges 
>   
>   sub MigrateMerges {
> !     my @merges = shift;
>       
>       foreach my $row (@merges) {
>   	print "Merging ".$row->{'ticket'} ." into ". $row->{'mergeinto'} ."\n";
> --- 797,803 ----
>   # {{{ sub MigrateMerges 
>   
>   sub MigrateMerges {
> !     my @merges = @_;
>       
>       foreach my $row (@merges) {
>   	print "Merging ".$row->{'ticket'} ." into ". $row->{'mergeinto'} ."\n";
> 
> -- Bob
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

Transporters are so ungodly.  if god had wanted us to travel great distances
instantaneously, he would have given us an internal 
materialisation/dematerialisation control.
			  -- Shoshe Cole