Converting from gnats to RT3

Palle_Girgensohn · November 5, 2003, 5:19pm

Hi!

I want to migrate my GNATS database into RT. I’m just now looking at the
import-gnats script from the cvs module rt-addons. It is old, written for
RT2 and just does not work. I’ve been doing a bit of rewriting, but it
seems the script does not do basic stuff like creating the responsible
users before importing, or convert to Unicode before inserting into
database. Does anyone have an updated script for this task, one that works?

If not, I need a hint: Can I tell RT that my strings are ISO-8859-1 when I
use $Ticket->Import()?

Thanks
Palle

Ruslan_U_Zakirov · November 5, 2003, 5:42pm

Palle Girgensohn wrote:

Hi!

I want to migrate my GNATS database into RT. I’m just now looking at the
import-gnats script from the cvs module rt-addons. It is old, written
for RT2 and just does not work. I’ve been doing a bit of rewriting, but
it seems the script does not do basic stuff like creating the
responsible users before importing, or convert to Unicode before
inserting into database. Does anyone have an updated script for this
task, one that works?

If not, I need a hint: Can I tell RT that my strings are ISO-8859-1 when
I use $Ticket->Import()
You can try next trick:

Convert GNATS to rt2 with that script
Convert rt2 to rt3

If you want write GNATS to rt3 import tool then my suggestions are:

rt2-to-rt3 have two parts rt2-to-filedump and filedump-to-rt3 so you
have to write GNATS-to-rt3_filedump only.
rt2 don’t have utf support so rt2-to-filedump do all crossencoding
convertions.

I hope this would help.
Good luck. Ruslan.

Palle_Girgensohn · November 5, 2003, 10:18pm

Thanks, interesting approach.

About the Unicode conversion, since I use PostgreSQL, all I need to do is
tell Postgresql “set client_encoding = ‘LATIN1’” and I can insert
iso8859-1 characters into a unicode database; they will be converted
on-the-fly. Only, I cannot find a way to tell anything to postgresql
directly

Palle–On onsdag, november 05, 2003 20.42.54 +0300 “Ruslan U. Zakirov” cubic@acronis.ru wrote:

Palle Girgensohn wrote:

Hi!

I want to migrate my GNATS database into RT. I’m just now looking at the
import-gnats script from the cvs module rt-addons. It is old, written
for RT2 and just does not work. I’ve been doing a bit of rewriting, but
it seems the script does not do basic stuff like creating the
responsible users before importing, or convert to Unicode before
inserting into database. Does anyone have an updated script for this
task, one that works?

If not, I need a hint: Can I tell RT that my strings are ISO-8859-1 when
I use $Ticket->Import()
You can try next trick:

Convert GNATS to rt2 with that script

Convert rt2 to rt3

If you want write GNATS to rt3 import tool then my suggestions are:

rt2-to-rt3 have two parts rt2-to-filedump and filedump-to-rt3 so you
have to write GNATS-to-rt3_filedump only. 2) rt2 don’t have utf support
so rt2-to-filedump do all crossencoding convertions.

I hope this would help.
Good luck. Ruslan.

Thanks
Palle

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

Jesse_Vincent · November 5, 2003, 10:27pm

Thanks, interesting approach.

About the Unicode conversion, since I use PostgreSQL, all I need to do is
tell Postgresql “set client_encoding = ‘LATIN1’” and I can insert
iso8859-1 characters into a unicode database; they will be converted
on-the-fly. Only, I cannot find a way to tell anything to postgresql
directly

Be very careful with that approach. If you’ve got unicode dat a in the
database that has a MIME header that says it’s latin1, I expect you’re
going to hurt yourself.
Jesse

Palle

Palle Girgensohn wrote:

Hi!

I want to migrate my GNATS database into RT. I’m just now looking at the
import-gnats script from the cvs module rt-addons. It is old, written
for RT2 and just does not work. I’ve been doing a bit of rewriting, but
it seems the script does not do basic stuff like creating the
responsible users before importing, or convert to Unicode before
inserting into database. Does anyone have an updated script for this
task, one that works?

If not, I need a hint: Can I tell RT that my strings are ISO-8859-1 when
I use $Ticket->Import()
You can try next trick:

Convert GNATS to rt2 with that script

Convert rt2 to rt3

If you want write GNATS to rt3 import tool then my suggestions are:

rt2-to-rt3 have two parts rt2-to-filedump and filedump-to-rt3 so you
have to write GNATS-to-rt3_filedump only. 2) rt2 don’t have utf support
so rt2-to-filedump do all crossencoding convertions.

I hope this would help.
Good luck. Ruslan.

Thanks
Palle

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

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

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

Danny_Smith · November 5, 2003, 11:25pm

Hi all,

I’ve just started playing with RT - using the Windows port at the moment
because I don’t have a linux box handy - forgive me! Version 3.0.4.

My problem is that I seem to have broken my installation. If I go to
the appropriate web address, I get the login screen - login, and get a
HTTP 500 error. From then on in I don’t even get a login screen, only
the error (unless I restart RT).

http-error.log has the following:

[Wed Nov 05 14:26:37 2003] [error] [client 192.168.90.37] Can’t locate
RT/CompanySpecific.pm in @INC (@INC contains:
C:/Progra~1/OurInternet/Reques~1/winrt/lib
C:/Progra~1/OurInternet/Common/perl/lib
C:/Progra~1/OurInternet/Common/perl/site/lib
C:/Progra~1/OurInternet/Reques~1/rt/lib
C:/Progra~1/OurInternet/Reques~1/rt/local/lib . C:\Program
Files\OurInternet\Request Tracker/ C:\Program Files\OurInternet\Request
Tracker/lib/perl C:/Progra~1/OURINT~1/Common/…/reques~1/rt/local/lib
C:/Progra~1/OURINT~1/Common/…/reques~1/rt/lib) at
C:\Progra~1\OURINT~1\reques~1\rt\html\CALLBA~1\SYNC10~1\AUTOHA~1\Default
line 52. Stack:
[C:\Progra~1\OURINT~1\reques~1\rt\html\CALLBA~1\SYNC10~1\AUTOHA~1\Defaul
t:52], [C:\Progra~1\OURINT~1\reques~1\rt\html\Elements\Callback:58],
[C:\Progra~1\OURINT~1\reques~1\rt\html\AUTOHA~1:173]
, referer: http://192.168.90.32:8284

Now I can’t find a CompanySpecific.pm anywhere… What is it meant to
be doing?

I’ve read through what there is of the documentation, and tried to
search through the mailing list to now avail. I’m starting to think
either I’m missing something, or there’s a bug in the port (always
possible!).

Any ideas?

Cheers,

Danny Smith - Systems Engineer

Sirocco Broadband
NEXTEP Networked Channel Partner

Email: dsmith@sirocco.com.au

Palle_Girgensohn · November 5, 2003, 11:25pm

Thanks, interesting approach.

About the Unicode conversion, since I use PostgreSQL, all I need to do
is tell Postgresql “set client_encoding = ‘LATIN1’” and I can insert
iso8859-1 characters into a unicode database; they will be converted
on-the-fly. Only, I cannot find a way to tell anything to postgresql
directly

Be very careful with that approach. If you’ve got unicode dat a in the
database that has a MIME header that says it’s latin1, I expect you’re
going to hurt yourself.
Jesse

Aha. Well, I get the following error in the postgresql log:

query: INSERT INTO Tickets (Creator, Due, Told, Status, EffectiveId,
LastUpdatedBy, Resolved, Type, TimeWorked, LastUpdated, Subject, Queue,
FinalPriority, id, Owner, InitialPriority, Created, Priority) VALUES (‘1’,
NULL, NULL, ‘resolved’, 1489, ‘1’, NULL, ‘ticket’, ‘0’, NULL, ‘Går ej att
godkänna en.’, ‘3’, NULL, 1489, ‘10’, NULL, NULL, NULL)

ERROR: Invalid UNICODE character sequence found (0xe57220)

So, this subject has to be converted to unicode, right?

Perhaps the best approach is to convert via RT2? It just sounds a bit odd…

Regards,
Palle

Autrijus_Tang · November 6, 2003, 3:23am

I’ve just started playing with RT - using the Windows port at the moment
because I don’t have a linux box handy - forgive me! Version 3.0.4.

Try upgrading to 3.0.6 and it should’ve got that fixed.

http://p4.elixus.org/dist/rt-3.0.6.exe

Thanks,
/Autrijus/

Danny_Smith · November 6, 2003, 6:03am

Thanks Autrijus, will give that a go.

Good work on the windows port too (I assume it was your work!). Always
nice to have this sort of thing available on different platforms…

Cheers,

Danny

-----Original Message-----
From: Autrijus Tang [mailto:autrijus@autrijus.org]
Sent: Thursday, 6 November 2003 1:23 PM
To: dsmith@siroccoresources.com.au
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] CompanySpecific.pm?

I’ve just started playing with RT - using the Windows port at the
moment because I don’t have a linux box handy - forgive me!
Version
3.0.4.

Try upgrading to 3.0.6 and it should’ve got that fixed.

http://p4.elixus.org/dist/rt-3.0.6.exe

Thanks,
/Autrijus/