No import function = giving up on Redmine

Added by James R over 9 years ago

Hello,

I am not a developer and have been looking at the possibility of using redmine to manage non IT projects.

I need to import about 100 existing projects with associated custom fields and issues. I have looked for importer plugins but none of them seem to function with v2.3. I have experimented with the API but there seems to be bugs when working with custom fields. I have scoured the forum and stack exchange looking for solutions and have posted a few questions looking for advice.
http://www.redmine.org/boards/2/topics/37645, http://www.redmine.org/boards/2/topics/37509, http://www.redmine.org/boards/2/topics/37595.

Now it seems that maybe python might be the best way of importing things: http://stackoverflow.com/questions/16200812/post-multiple-issues-to-redmine-via-api but this is yet another thing to learn.

It has been fun learning about curl, RESTful APIs and python but honestly at this point I just want to import my data and get on with my day job.

Surely the easy import/export of data to redmine must be a major issue for others people too and would be a major feature to prioritize.

Am I missing something?

Replies (30)

RE: No import function = giving up on Redmine - Added by Korneliusz Moc over 7 years ago

Hi @santhosh babu
I've tried to import issues in Redmine 3.0, but no luck. I've tried all possible ways.
The only solution was downgrate to Redmine 2.6 as several plugins are working with 2.6.
I've used https://github.com/ichizok/redmine_importer. This plugin works but only if you know how to use it, as there are no exceptions returned if import won't succeed for some reason, e.g. versions need to be added before import, dates need to be in proper format, etc.
You need to try and debug it by yourself, but i guess it should fit in your needs, as it support custom fileds/columns.

RE: No import function = giving up on Redmine - Added by Olivier Houdas over 7 years ago

@Korneliuz: We use Redmine importer with Redmine 3.0 and it works.
We're using my fork on the code based on go2null's own fork: https://github.com/gc-olivierho/redmine_importer/
I do agree, though, that error handling is not good in that code. If I can find time to work on it, I'll update the code in github.
[Edit 2015-07-10 15:20 GMT] Sorry, I just noticed that I had left my Redmine 3.0 compatibility changes uncommitted. They are committed now.

RE: No import function = giving up on Redmine - Added by Erica Ting over 7 years ago

Hi @ Korneliusz Moc,

Our web minister installed this importer as you recommended -- https://github.com/ichizok/redmine_importer. We just need to import the standard fields to add new tasks/issues. However, there is no user documentation available. Would you mind to share a sample import CSV file with me?

Thanks for your help!!

RE: No import function = giving up on Redmine - Added by Korneliusz Moc over 7 years ago

Sure.
First of all you need to take care of all statuses, priorities, target versions, etc. before import. Data need to be unified in Redmine and in CSV file you will import. If status will not be available in redmine then importer won't work. About assignee or author you need to provide user's login in CSV. Also the dates, e.g. Start date need to be in Redmine format i.e. yyyy-mm-dd (e.g. 2014-03-26). It's good to format date columns with this patern in excel before save, and while saving use "CSV (MS-DOS) (*.csv)" type. While importing choose "Windows-1250" encoding. Field separator and wrap char leave unchanged. That should be all.
Sample file in attachment.

Sample.csv Magnifier (480 Bytes)

RE: No import function = giving up on Redmine - Added by Erica Ting over 7 years ago

Hi Korneliusz Moc,

Thanks so much! It worked!! I just have one more question - the importer seems cannot import Watchers. Any idea about this?

-erica

1 2 (26-30/30)