Question about migration

RT Users
1

We currently use an open source solution called IRM for our ticket system.
It uses a mysql database. Does anyone have any knowledge of migrating from
IRM to RT. Any info would be greatly appreciated.
Thanks
Bo Lynch

2

Bo Lynch wrote:

We currently use an open source solution called IRM for our ticket system.
It uses a mysql database. Does anyone have any knowledge of migrating from
IRM to RT. Any info would be greatly appreciated.
Thanks

are you using IRM for tickets onnly or alsoe for asset mgmt ?

–Chaim Rieger

3

Bo Lynch wrote:

We currently use an open source solution called IRM for our ticket
system.
It uses a mysql database. Does anyone have any knowledge of migrating
from
IRM to RT. Any info would be greatly appreciated.
Thanks

are you using IRM for tickets onnly or alsoe for asset mgmt ?

–Chaim Rieger

We use IRM for tickets only.
Bo

4

Bo,

I know of no ready-built programs (unfortunately). However, RT offers

CLI which allows you to create/edit/show tickets in RT outside of the
WebUI. I have about 7k to 8k tickets I need to migrate from a home-grown
system in Oracle to our current RT (3.6.4) in Oracle. My plan is to
write some SQL code that will walk thru the “home-grown” DataBase and
for each ticket it finds, execute some embedded CLI to map that data and
create a new RT ticket. So, if you’re the kinda person that gets all
excited about writing new code and have any SQL and/or CLI experience,
I’d be more than happy to collaborate with you on this task.

Kenn
LBNLOn 7/2/2008 11:38 AM, Bo Lynch wrote:

We currently use an open source solution called IRM for our ticket system.
It uses a mysql database. Does anyone have any knowledge of migrating from
IRM to RT. Any info would be greatly appreciated.
Thanks

5

Bo,

The RT Essentials book. That's where I am now. In fact, I tried to

execute some CLI on my server (RT up and running) and when I keyed in a
command, it said command unknown. So I have to try and figure out THAT
first, then I can develop the code structure. If you dig into CLI and
find something, let me know. If I get this up and running, I’ll share
the code with everyone. Thanks.

Kenn
LBNLOn 7/2/2008 6:51 PM, Bo Lynch wrote:

On Wed, July 2, 2008 6:41 pm, Kenneth Crocker wrote:

Bo,

I know of no ready-built programs (unfortunately). However, RT offers
CLI which allows you to create/edit/show tickets in RT outside of the
WebUI. I have about 7k to 8k tickets I need to migrate from a home-grown
system in Oracle to our current RT (3.6.4) in Oracle. My plan is to
write some SQL code that will walk thru the “home-grown” DataBase and
for each ticket it finds, execute some embedded CLI to map that data and
create a new RT ticket. So, if you’re the kinda person that gets all
excited about writing new code and have any SQL and/or CLI experience,
I’d be more than happy to collaborate with you on this task.

Kenn
LBNL

On 7/2/2008 11:38 AM, Bo Lynch wrote:

We currently use an open source solution called IRM for our ticket
system.
It uses a mysql database. Does anyone have any knowledge of migrating
from
IRM to RT. Any info would be greatly appreciated.
Thanks
Ken,

Unfortunatly, I have never coded SQL or CLI. I do understand most coding
structures though and am proficient in scripting languages like
python,awk,bash and a little perl. I know that I probably don’t have the
experience that one would like to assist in this task but would be happy
to help in any way and learn. Where is a good place to start to understand
the coding aspect of CLI and mysql? I