Modify

Opened 11 years ago

Closed 12 months ago

#647 closed enhancement (wontfix)

RequestTracker import script

Reported by: Wade Brainerd 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@… 11 years ago.
Convert RT to Trac SQL
Proc.sql (1.3 KB) - added by nik_js@… 11 years ago.
Stored Procedure to Fix Migrated Ticket bug

Download all attachments as: .zip

Change History (8)

comment:1 Changed 11 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 11 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 11 years ago by nik_js@…

Attachment: RT To Trac.sql added

Convert RT to Trac SQL

comment:3 Changed 11 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 11 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 11 years ago by nik_js@…

Attachment: Proc.sql added

Stored Procedure to Fix Migrated Ticket bug

comment:5 Changed 8 years ago by Ryan J Ollos

Summary: Best Practical RT -> Trac importerRequestTracker import script

comment:6 Changed 12 months ago by Ryan J Ollos

Resolution: wontfix
Status: newclosed

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain anybody.
The resolution will be deleted.

Add Comment


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

 
Note: See TracTickets for help on using tickets.