[rt-users] Migrating to RT from another ticket system

[Bart]

Hi,

I think I'll have to use the RT api since we have some specific ideas on hoe
we want to implement the old data into RT which can\t be done using the
Offline tool.

I'm not that good with Perl (never tried so not sure where to look) but I'm
currently looking into maybe using bash with the RT command to see if I can
use the CSV file as an input in some way.

Either way, I think I'm going in the right direction. It will take some time
but when done right it will give us a nice migration :)

Best regards,

Bart



2011/6/6 Raed El-Hames <Raed.El-Hames at daisygroupplc.com>

>  Bart:
>
>
>
> The offline tool will help you create the tickets as Ken suggested ,
> however if you are looking to include any of your old tickets history
> (correspondence / updates), then I would recommend you look into using perl
> script and the rt api.
>
>
>
> Roy
>
>
>
> *From:* rt-users-bounces at lists.bestpractical.com [mailto:
> rt-users-bounces at lists.bestpractical.com] *On Behalf Of *Bart
> *Sent:* 06 June 2011 12:44
> *To:* rt-users at lists.bestpractical.com
> *Subject:* [rt-users] Migrating to RT from another ticket system
>
>
>
> Hi,
>
> We are currently working on migrating to Request Tracker.
>
> The step on which we are now is creating a proof of concept, this is coming
> along pretty nicely.
> With the O'Reilly book + mailing lists + wiki at hand we're getting there,
> just filling out the specific details :)
>
> I do however want to look at a road bump ahead, which is migrating the old
> ticket date into RT.
>
> We have the ability to export all the current date to CSV format, keeping
> those fields that we feel are fit for RT. (the old/current ticketing system
> is Assyst from Axios Systems)
> We don't mind if ticket numbers are new, we prefer it really, as long as we
> can store the old ticket number in a CF (which I believe we can).
>
> What would be the best way to import the data?
> Can we use the command-line RT functions or do we have to do some database
> magic? (I'm not a database wizard so we'd have to find someone for that lol)
>
> The reason why I'm asking this is mainly to get some information about the
> migration process before hand, such information would safe me allot of time
> later on.
>
> So any information that would point us in the right direction would be
> helpful.
>
> Thanks in advance.
>
> Best regards,
>
> Bart
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110606/32ca2fa2/attachment.htm>