Can I load data into redmine database running query?

Hi,

We have a local system which we can export tickets into an Excel file. I try to find an importer file to load them into RedMine but didn't find a simple plugin.

Can I load the data into Redmine running a mySQL query? Can I access and add data to the table in the database directly?

We have 4-5 customized fields which we need to add, such as who submit a ticket, their departments, etc.

Thanks.

Jenny

Replies (2)

RE: Can I load data into redmine database running query? - Added by Martin Denizet (redmine.org team member) over 10 years ago

Hi Jenny,
I strongly recommend you don't do that. It would bypass the Rails validators and very likely create problems.
Instead you could generate a file with Ruby code and feed it to the runner such as:

Issue.create(subject:'My subject',due_date:Date.today, [...more properties here...])

Note it is a short, simplified example.
Cheers,

RE: Can I load data into redmine database running query? - Added by Jenny Jing over 10 years ago

Hi, Martin:

Thank you very much for your reply. Is there any detailed instruction for doing that? I assume a lot of people might be interested in something like this because people are using different ticketing systems, and they might want to migrate to RedMine but don't know how to load their data into it. I searched the documentation site and found instructions about how to migrate from 4 systems (such as TRAC) to Redmine, but none of the instructions I can use.

Cheers

(1-2/2)

Project

General

Profile

Redmine