[rt-users] Question about migration

[Kenneth Crocker]

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
LBNL

On 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
> 
>