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
Change the query to include the description: col=description > Save Report
Once the report shows an updated view of all your tickets: click Download in other Fomats -> "Comma-delimited Text"
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 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
- 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
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 firstname.lastname@example.org