Limited rt1->rt2 import

Heya.

I’ve previously asked about doing a date limited import from rt1 to rt2, as I didn’t get any response, I guess its not that easy.

so… second idea is to just not import the transaction data. eg , comment out the line ,
MigrateTrasactions($row->{serial_num}, $ticket);

this would speed up our test import hugely (as we have 7gb of transaction data) , but would rt2 have major errors if
there was tickets but no transaction data?

If that is no good, then I’ll just comment out the MigrateTickets(); line to ensure our users and queues are going to be imported correctly.

Regards,
Mat.

Matthew,

If you have a staging/testing server, you can copy limited data from RT1
dir and database over to the test server, install RT2 and run the import
script. The transactions and each_req tables are what you should look
for. You can copy over only few records of those two tables by using
something like “where serial_num < 100”. Make sure the tickets with
serial_num <100 are in ~rt/transactions/ dir. Then it will just run
through that 99 tickets. The rest of tables should be copied over
entirely for the conversion.

SherrillOn Wed, 26 Sep 2001, Matthew Watson wrote:

Heya.

I’ve previously asked about doing a date limited import from rt1 to rt2, as I didn’t get any response, I guess its not that easy.

so… second idea is to just not import the transaction data. eg , comment out the line ,
MigrateTrasactions($row->{serial_num}, $ticket);

this would speed up our test import hugely (as we have 7gb of transaction data) , but would rt2 have major errors if
there was tickets but no transaction data?

If that is no good, then I’ll just comment out the MigrateTickets(); line to ensure our users and queues are going to be imported correctly.

Regards,
Mat.


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

Sherrill (Pei-chih) Verbrugge
spv@gospelcom.net

http://www.gospelcom.net
http://bible.gospelcom.net