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-ha...@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-boun...@lists.bestpractical.com [mailto: > rt-users-boun...@lists.bestpractical.com] *On Behalf Of *Bart > *Sent:* 06 June 2011 12:44 > *To:* rt-users@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 >