Feature #950

Import Issues from delimited/CSV file

Added by John Z over 11 years ago. Updated 4 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 almost 4 years ago

Import issues from CSV file (#950).

Revision 14494
Added by Jean-Philippe Lang almost 4 years ago

Adds translation strings (#950).

Revision 14495
Added by Jean-Philippe Lang almost 4 years ago

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

Revision 14496
Added by Jean-Philippe Lang almost 4 years ago

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

Revision 14497
Added by Jean-Philippe Lang almost 4 years ago

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

Revision 14501
Added by Jean-Philippe Lang almost 4 years ago

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

Revision 14503
Added by Jean-Philippe Lang almost 4 years ago

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

Revision 14504
Added by Jean-Philippe Lang almost 4 years ago

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

Revision 14505
Added by Jean-Philippe Lang almost 4 years ago

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

History

#1 Updated by Jean-Philippe Lang over 11 years ago

  • Target version deleted (0.7)

#2 Updated by Mark P about 11 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 about 11 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 about 11 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 over 10 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 over 10 years ago

Push up !

#7 Updated by Nanda P almost 10 years ago

+1

#8 Updated by Nikolay Kotlyarov over 9 years ago

+1

#9 Updated by Jean-Philippe Lang over 9 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 9 years ago

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

+100

#11 Updated by Pete P over 9 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 over 9 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 over 9 years ago

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

#14 Updated by Se Ri about 9 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 about 9 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 about 9 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 about 9 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 almost 4 years 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 almost 4 years ago

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

#20 Updated by Go MAEDA almost 4 years ago

Great! This is long awaited feature.

#21 Updated by Toshi MARUYAMA almost 4 years ago

#22 Updated by Hassan Assalih over 3 years 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 3 years ago

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

#24 Updated by Antoine Verron over 3 years ago

Oh yes!

#25 Updated by Martin P. over 3 years 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 over 3 years 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 over 3 years 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 over 3 years 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 over 3 years 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 over 3 years 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 over 3 years 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 almost 3 years 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 almost 3 years 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 almost 3 years ago

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

#35 Updated by Pablo Estiga over 2 years 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 over 2 years ago

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

#37 Updated by Mayur Gaikwad 4 months ago

Hello,

Just a quick question, how do we use files option with import functionality
I'm able to import issues in bulk but many of the issues have some attachments too that needs to be included.
Please help!

Also available in: Atom PDF