[rt-users] converting from gnats to RT3

[Palle Girgensohn]

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 at 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:
> 1) Convert GNATS to rt2 with that script
> 2) Convert rt2 to rt3
> :)
>
> If you want write GNATS to rt3 import tool then my suggestions are:
> 1) 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 at 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
>
>