---
layout: wiki
title: TracImport
updated: 2021-04-16 08:25
author: trac
default: true
toc: true
---

## Importing ticket data

To migrate issue tickets from other issue-tracking systems into Trac or perform housekeeping actions on tickets or simply synchronize different databases, there are some tools, plugins and scripts available.

### TicketImportPlugin

[TicketImportPlugin](https://trac-hacks.org/notes/TicketImportPlugin): a plugin that lets you import or update into Trac a series of tickets from a **CSV file** or (if the [xlrd library](https://pypi.python.org/pypi/xlrd) is installed) from an **Excel spreadsheet**.

### ExportImportXlsPlugin

[ExportImportXlsPlugin](https://trac-hacks.org/notes/ExportImportXlsPlugin): a plugin that adds an admin panel for exporting and importing tickets via **XLS file**. Requires the python packages xlwt/rxld.

### Jira

[JiraToTracIntegration](https://trac-hacks.org/notes/JiraToTracIntegration): a plugin that provides tools to import Atlassian Jira backup files into Trac. The plugin consists of a Python 3.1 commandline tool that:

- Parses the Jira backup XML file.
- Sends the imported Jira data and attachments to Trac using the [XmlRpcPlugin](https://trac-hacks.org/notes/XmlRpcPlugin).
- Generates a htpasswd file containing the imported Jira users and their SHA-512 base64 encoded passwords.

### Mantis

[MantisImportScript](https://trac-hacks.org/notes/MantisImportScript): a script to import the following type of data from Mantis into Trac:

- bugs
- bug comments
- bug activity (field changes)
- attachments (as long as the files live in the mantis database, not on the filesystem).

### PlanetForge

[PlanetForgeImportExportPlugin](https://trac-hacks.org/notes/PlanetForgeImportExportPlugin): this plugin exports Trac data (wiki, tickets, compoments, permissions, repositories, etc.) using the open format designed by the [COCLICO](https://gforge.inria.fr/projects/coclico/) project. It extends the webadmin panel and the 'trac admin ...' command. Has no 'import' feature.

### Scarab

[ScarabToTracScript](https://trac-hacks.org/notes/ScarabToTracScript): a script that migrates Scarab issues to Trac tickets. Requires [XmlRpcPlugin](https://trac-hacks.org/notes/XmlRpcPlugin).

### Other

Since Trac uses a SQL database to store the data, you can also custom-import from other systems by examining the database tables. Just go into [sqlite](https://www.sqlite.org/sqlite.html) command line to look at the tables and import them from your application.

---

See also:

- to import/export wiki pages: [TracAdmin](/notes/TracAdmin/),
- to export tickets: [TracTickets](/notes/TracTickets/), [TracQuery](/notes/TracQuery/)