Modify

Opened 8 years ago

Last modified 4 years ago

#647 new enhancement

RequestTracker import script

Reported by: WBrainerd@… Owned by: anybody
Priority: normal Component: Request-a-Hack
Severity: normal Keywords:
Cc: Trac Release: 0.9

Description

I know of several organizations using Best Practical RT who would love to switch to Trac.

Is anyone working on an importer script?

Best regards,

Wade Brainerd
Technical Director
Activision Central Technology

Attachments (2)

RT To Trac.sql (4.4 KB) - added by nik_js@… 8 years ago.
Convert RT to Trac SQL
Proc.sql (1.3 KB) - added by nik_js@… 8 years ago.
Stored Procedure to Fix Migrated Ticket bug

Download all attachments as: .zip

Change History (7)

comment:1 Changed 8 years ago by anonymous

I'm also planning to take a look at Trac because we are not happy with RT. RT is very clumsy and a pain to maintain. We didn't even try to start changing some of its functionality.

I'll probably look into the problems of importing RT stuff to Trac but I don't know when this will be.

comment:2 Changed 8 years ago by stheophil@…

I should have signed my comment.

Regards,
Sebastian

--
Sebastian Theophil stheophil@…
Software Engineer

think-cell Software GmbH
Invalidenstr. 34
D-10115 Berlin http://www.think-cell.com

Changed 8 years ago by nik_js@…

Convert RT to Trac SQL

comment:3 Changed 8 years ago by nik_js@…

The script attached assumes that the postgres version of trac is installed.

It is also tuned for our custom fields (status, effort, requestor) but can easily be modified for your own setup of RT.

Execute MySql Script to create a set of Postgres SQL scripts.

Execute output SQL scripts on postgres.

Execute series of postgres commands on postgres.

NB. Depending on your data you may need to drop the primary key on ticket_change whilst migrating.

comment:4 Changed 8 years ago by nik_js@…

In addition you will also need to execute the attached Stored Procedure (requires language plpgsql) to sort an issue with migrated tickets not allowing updates.

Changed 8 years ago by nik_js@…

Stored Procedure to Fix Migrated Ticket bug

comment:5 Changed 5 years ago by rjollos

  • Summary changed from Best Practical RT -> Trac importer to RequestTracker import script

Add Comment

Modify Ticket

Action
as new .
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.