Exporting from an older version of Redmine and Importing into 2.6

Added by Alan MacK almost 7 years ago

Hi Guys,

We have an older version of Redmine which we have been using for several years.

The older version installed is Redmine 1.0.4.stable (MySQL).

The new version we have installed onto a new environment and network is:

Environment:
Redmine version 2.6.0.stable
Ruby version 2.0.0-p594 (2014-10-27) [i386-mingw32]
Rails version 3.2.19
Environment production
Database adapter SQLServer
SCM:
Subversion 1.8.8
Git 1.9.0
Filesystem
Redmine plugins:
clipboard_image_paste 1.9
redmine_importer 1.2.2

What I wish to do, is export all the issues out of the old version into a csv file, and upload them into the new system.

I have installed so far three versions of importer plugins and cannot get any to work.

The last one I installed is this one: https://github.com/zh/redmine_importer - installed step by step as per the instructions, however i now get this error shown on the module and when you click on the imported module the page cannot be displayed:

translation missing: en.label_import

(See attached screenshot)

Some googling mentions a problem with the en.yml file - but I cannot see any issues with it? I have attached it.

Can someone please help or recommend a plugin that works with the above versions?

I only have around 1200 issues I want to import from the older mysql version to SQL server version..

redminescreen.JPG (51.5 KB)

en.yml Magnifier (2.07 KB)

Replies (3)

RE: Exporting from an older version of Redmine and Importing into 2.6 - Added by Martin Denizet (redmine.org team member) almost 7 years ago

Hi Alan,

How I'd try to do it:

  1. Dump the old database using https://github.com/yamldb/yaml_db
  2. Roll the database migrations on the new server up to the last migration of Redmine 1.0.4 (Version 20100819172912, see source:/tags/1.0.4/db/migrate)
  3. Load the database dump in the new server using https://github.com/yamldb/yaml_db
  4. Finish to roll the database migrations on the new server.

Note that it will migrate the entire database and not just the issues.

Cheers,

RE: Exporting from an older version of Redmine and Importing into 2.6 - Added by Martin Denizet (redmine.org team member) almost 7 years ago

Also, to mention it, the message "translation missing: en.label_import" should not affect the behavior of the plugin.
It's just that the translation for the key label_import in the plugin or Redmine's YAML file is missing. I should not break any feature.

RE: Exporting from an older version of Redmine and Importing into 2.6 - Added by Alan MacK almost 7 years ago

Thanks Martin,

at this point I only want to bring across the old issues into the new system if possible. The new Redmine database already has quite a few projects up and running.

Ideally I would like to export the old issues to csv/xls so I can make some modifications prior to importing into the new redmine solution.

There are a few importer plugins, I recall attempting to use them last year but couldnt get any of them to work correctly.

If someone can recommend a good import plugin please advise

(1-3/3)