Feature #950

Import Issues from delimited/CSV file

Added by John Z about 9 years ago. Updated 3 months ago.

Status:ClosedStart date:2008-03-29
Priority:NormalDue date:
Assignee:Jean-Philippe Lang% Done:

0%

Category:Importers
Target version:3.2.0
Resolution:Fixed

Description

I agree with this thread. It would be very useful to be able to import issues* from external files. This would allow for pre-planned work items to be created in other tools such as a spreadsheet or other project planning tool and imported. This would also allow us a work-around for the inability to "Copy" projects as templates for re-use.

http://www.redmine.org/boards/1/topics/show/159

*(we work with tasks, and so the name "Issues" only applies to a small subset of work that is tracked).


Related issues

Related to Redmine - Defect #20551: Typo "coma" (correct: "comma") Closed
Duplicated by Redmine - Feature #7103: Import form csv Closed 2010-12-13
Duplicated by Redmine - Feature #7884: Import issues from Excel or CSV file Closed 2011-03-16

Associated revisions

Revision 14493
Added by Jean-Philippe Lang over 1 year ago

Import issues from CSV file (#950).

Revision 14494
Added by Jean-Philippe Lang over 1 year ago

Adds translation strings (#950).

Revision 14495
Added by Jean-Philippe Lang over 1 year ago

Adds support for custom date format when importing a CSV file (#950).

Revision 14496
Added by Jean-Philippe Lang over 1 year ago

Set default date format based on user locale (#950).

Revision 14497
Added by Jean-Philippe Lang over 1 year ago

Use named scope to find the matching version (#950).

Revision 14501
Added by Jean-Philippe Lang over 1 year ago

Use same logic for finding user when importing a file (#950).

Revision 14503
Added by Jean-Philippe Lang over 1 year ago

Use same logic for finding user as a custom field (#950).

Revision 14504
Added by Jean-Philippe Lang over 1 year ago

CSV importer raises I18n::InvalidLocale exception if current user's language is "(auto)" (#905, #20535).

Revision 14505
Added by Jean-Philippe Lang over 1 year ago

DEPRECATION WARNING: `#timestamps` was called without specifying an option for `null` (#905, #20533).

History

#1 Updated by Jean-Philippe Lang about 9 years ago

  • Target version deleted (0.7)

#2 Updated by Mark P almost 9 years ago

I originally posted this in the forums, but I will post it here as well. Seems to make more sense keeping it with the feature request. I would like the same functionality. If someone at Redmine could help me get started with data structure, I would be interested in contributing some effort for this. I am a newbie to Redmine, but I really like the product so far and would be willing to help.

#3 Updated by Mark P almost 9 years ago

Any interest in my helping with this? At this time, my approach was to use a csv to Trac python script. Then use the Trac import program within Redmine to get the data the rest of the way into Redmine. I would much prefer to have a direct flight rather than a layover in Trac. I have been really happy with Redmine so far, and would be happy to give back by assisting with this in any way I can.

#4 Updated by John Z almost 9 years ago

Personally I'd love to see a direct import option and for you to work on it. I could test it for you and maybe create an Excel template for people to match for importing. But being on the PM side of things, I'm not a coder. Wish I could contribute more directly though.

#5 Updated by Vianney Stroebel about 8 years ago

This feature would be so useful!

We often start a project with a hundred tasks and it's much easier to create them in a spreadsheet than in Redmine.

Is anyone working on it?

#6 Updated by Benjamin Baroukh about 8 years ago

Push up !

#7 Updated by Nanda P over 7 years ago

+1

#8 Updated by Nikolay Kotlyarov over 7 years ago

+1

#9 Updated by Jean-Philippe Lang over 7 years ago

John Z wrote:

This would also allow us a work-around for the inability to "Copy" projects as templates for re-use.

Project copy (with issues) is now available.

#10 Updated by Michael Ivanov over 7 years ago

Without this feature implemented we’re importing hundreds of issues from Excel to Redmine by hand.

+100

#11 Updated by Pete P about 7 years ago

Having this feature really expands the capability of Redmine. I would be able to import whatever I wanted into the issue database. Unfortunately, the importer plugin doesn't work with the latest version of Redmine.

#12 Updated by Robert Chady about 7 years ago

What happens to the importer plugin with the latest version of Redmine? I haven't seen any issues raised against it, so I'm not sure what other issues there are other than the ones that make it marked 'unsupported' at the moment.

#13 Updated by Pete P about 7 years ago

Was using the wrong version of the importer. Switched to yours and it worked. Thanks!

#14 Updated by Se Ri almost 7 years ago

Hey Robert Chady,

I used your importer with redmine 0.9.4. I keeps getting this error:

"Internal error

An error occurred on the page you were trying to access.
If you continue to experience problems please contact your redMine administrator for assistance."

Thinking about utf-8 encoding, I have used tools to convert csv file to utf-8, but same error. I know this is not listed as compatible with redmine 0.9.x, but just ask if you have any fixes.

Please help. Thanks a lot.
Seri

#15 Updated by ha thach almost 7 years ago

try this one, dude. It is called redmine_loader http://github.com/simonstearn/redmine_loader, Supports XML files output by MS Project etc and does a simple load into a default tracker for the selected project. Work with 0.9.3

#16 Updated by Se Ri almost 7 years ago

great, thanks for your quick reply, ha thach. i'll try it.

btw, any plugins for exporting to ms project file ?

Seri

#17 Updated by Se Ri almost 7 years ago

Hey ha thach,

I tried that plugin. I faced error with priority is blank in my file, so not yet successful (MS Project uses priority as number, while I use my own priority values as High/Normal/Low). But I think it's not exactly what I want, cause I need to import issues and related custom fields, not MS project fields. And currently, I have those issues in Excel file.

Anyways, thanks for your info. I might need that when I start to import tasks.

Any other options for me ?

Seri

#18 Updated by Jean-Philippe Lang over 1 year ago

  • Subject changed from Import Issues from delimited file to Import Issues from delimited/CSV file
  • Status changed from New to Closed
  • Assignee set to Jean-Philippe Lang
  • Target version set to 3.2.0
  • Resolution set to Fixed

Feature added in r14493.

#19 Updated by Jean-Philippe Lang over 1 year ago

  • Duplicated by Feature #7884: Import issues from Excel or CSV file added

#20 Updated by Go MAEDA over 1 year ago

Great! This is long awaited feature.

#21 Updated by Toshi MARUYAMA over 1 year ago

#22 Updated by Hassan Assalih over 1 year ago

Jean, could you please provide an estimated date to release version 3.2.0 with this feature. I am sure many many people will thank you. So big thanks :)

#23 Updated by Jean-Philippe Lang over 1 year ago

I think that 3.2.0 will be released by the end of the next week.

#24 Updated by Antoine Verron over 1 year ago

Oh yes!

#25 Updated by Martin P. about 1 year ago

For anybody searching for this feature:

Per default, only admin role users see the import link. You can activate this for more roles under:
https://your-redmine-url.xyz/roles/permissions

Then you will find the Link in the ticket category/tab (/issues/) in the menu list as the last menu point or via the adress in the url:
https://your-redmine-url.xyz/issues/imports/new

Hope this helps one or two.. ;)

#26 Updated by Frank Zebre about 1 year ago

M P wrote:

For anybody searching for this feature:

Per default, only admin role users see the import link. You can activate this for more roles under:
https://your-redmine-url.xyz/roles/permissions

Then you will find the Link in the ticket category/tab (/issues/) in the menu list as the last menu point or via the adress in the url:
https://your-redmine-url.xyz/issues/imports/new

Hope this helps one or two.. ;)

Is it possible you can post a picture of where this is? I can see the option under permissions and have enabled it but cannot for the life of me find an import button...

#27 Updated by Robert Schneider about 1 year ago

@FrankZebre: In version 3.2.0 go to a Project, go to Issues and then it is in the sidebar on the right side.

There are the links

View all issues
Summary
Calendar
Gantt
Import

#28 Updated by Frank Zebre about 1 year ago

@RobertSchneider: Hmmm I guess I must have a plugin installed that is getting rid of it. Even when I try to browse to redmine/projects/tickets/issues/imports (or with /new) as suggested by @MP above I get a Page Not Found.

#29 Updated by Frank Zebre about 1 year ago

Frank Zebre wrote:

@RobertSchneider: Hmmm I guess I must have a plugin installed that is getting rid of it. Even when I try to browse to redmine/projects/tickets/issues/imports (or with /new) as suggested by @MP above I get a Page Not Found.

Oops I made a mistake! I had to browse to redmine/issues/imports/new (leaving out the projects/tickets) portion. The button is still missing from the sidebar but my guess is the Agile plugin I have installed for evaluation has removed that section of the side bar.

#30 Updated by Robert Schneider about 1 year ago

@FrankZebre: Note sure - if you have Agile plugin of RedmineCRM the link is also there. Have a look into the demo: http://demo.redminecrm.com/projects/agile/issues

#31 Updated by shuozhi fenxi about 1 year ago

Frank Zebre wrote:

Frank Zebre wrote:

@RobertSchneider: Hmmm I guess I must have a plugin installed that is getting rid of it. Even when I try to browse to redmine/projects/tickets/issues/imports (or with /new) as suggested by @MP above I get a Page Not Found.

Oops I made a mistake! I had to browse to redmine/issues/imports/new (leaving out the projects/tickets) portion. The button is still missing from the sidebar but my guess is the Agile plugin I have installed for evaluation has removed that section of the side bar.

I found what plugin remove the import link.

I my case it is redmine_sidebar_toc_pt.

I think in your case maybe something similar overwrites your issue sidebar. You can check the file app/views/issues/_sidebar.html.erb to find which call_hook is there.

#32 Updated by Alfredo Bonilla 9 months ago

Is there any kind of documentation about the import process included in 3.2? I've been searching in the wiki and.. I dindn't find anything

#33 Updated by Joel Bearden 9 months ago

Alfredo Bonilla wrote:

Is there any kind of documentation about the import process included in 3.2? I've been searching in the wiki and.. I dindn't find anything

Second this request. This would be a tremendous help, but there is no documentation on scheme, headers, etc.

#34 Updated by Moritz Who Cares 8 months ago

I just added a minimal HowTo. Feel free to extend and/or fix: HowTo_import_issues

#35 Updated by Pablo Estiga 3 months ago

Moritz Who Cares wrote:

I just added a minimal HowTo. Feel free to extend and/or fix: HowTo_import_issues

Thanks you all for working on this feature, I have extened a little the wiki HowTo_import_issues after done some tests.

#36 Updated by Go MAEDA 3 months ago

Moritz Who Cares and Pablo Estiga, thank you for writing the detailed document!
HowTo_import_issues

Also available in: Atom PDF