How to export from Trac tickets into TeamForge

Export your Trac tickets to a CSV file

 

Login to Trac as an Admin > View Tickets > Custom Query

Remove filter by owner > ensure you are filtering in all your tickets > Select Columns that are important (ie: Summary, Status, Owner, Type, Priority, Milestone, Component, Version) > SAVE QUERY

ss1.png

 

Change the query to include the description: col=description > Save Report

Screen_shot_2011-07-01_at_4.26.23_PM.png

Once the report shows an updated view of all your tickets: click Download in other Fomats -> "Comma-delimited Text"

ss2.png

 

Prepare the CSV

Once you have a CSV file saved locally, you will need to make some changes to import it to TeamForge. The best way to do this is by opening the file with a spreadsheet program like MS Excel (or OpenOffice).

Then make the following changes:

- change column summary to Title
- change status to Status
- change description to Description
- map priority
blocker, critical, major, minor, trivial -> 5..1
- map status: (this could vary a lot - note capitalization)
new,assigned,accepted,reopened,closed
Open, In Progress, Fixed, Pending, Closed, Re-opened (not fixed), Can't reproduce, Not a bug, Duplicate
Advance:
- Change owner to "Assigned To", and map users to "firstname_lastname", where "firstname_lastname" is a user in that TFP

 

- change column top field 'summary' to 'Title'

- change column top field 'status' to 'Status'

- change column top field 'description' to 'Description'

 

 

- map priority:

blocker, critical, major, minor, trivial -> 5, 4, 3, 2, 1

(meaning that where ever it says "blocker" it should now say 5, or where it says "trivial" it should be changed to "1" ... and so on)

 

- map status:

This can vary if you have custom statuses in Trac, but in a default instance the mapping looks more or less like this:

 

new -> Open

assigned -> In Progress

accepted -> In Progress

reopened -> Re-opened (not fixed)

closed -> Closed

 

Here are the default available statuses in TeamForge, but you can also create/customize them:

Open, In Progress, Fixed, Pending, Closed, Re-opened (not fixed), Can't reproduce, Not a bug, Duplicate

 

Advance:

- Change owner to "Assigned To", and map users to "firstname_lastname", where "firstname_lastname" is a user in that TFP

 

Save the file in the spreasheet program (ie: Excel) as a CSV file

Import the CSV to TeamForge in CloudForge

Once you have modified the CSV file, you can now import it into TeamForge:

Login to TeamForge as an Admin > Trackers > Defects (or any other tracker you might want) > Import > In the pop-up: select your CSV file > Import

 

Notes:

It's important to note:

- No history in the ticket will be migrated.

- Only Title, Status, Owner (and a few others) will migrated. However, things like reporter, attachments, etc will be lost in the migration. 

If you need help with this process, please send us an email to support@cloudforge.com

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.