issue import (email or csv)

Added by Dariusz Szczepaniak over 10 years ago

I installed the bitnami redmine on windows, it works ok.
I have one question though:
How to import several issues in one go into the redmine?

I heard it can be done via emails (sending emails to redmine and it will create issues from each of them). Does anyone what I would need to set up in redmine to get this working?

Another solution would be to have a way to import data from some kind of xml or csv file. Did anybody tried something similar?

thank you for help

Replies (20)

Ticket Importer via CSV - Added by SKYARC System over 10 years ago

Hi, I have made a plugin for importing a lot of tickets via CSV at once.
Let's try it and please give your response to me !

(Sorry for that page is written in Japanese language only)

http://www.skyarc.co.jp/engineerblog/entry/post_12.html

RE: issue import (email or csv) - Added by Benjamin Baroukh over 10 years ago

Hi,

I am very interested by this plug-in, but I can't read a sign of Japanese. Could you please send a link to the plug-in and some very basic instructions.

Thanks a lot

Plugin instruction in English - Added by SKYARC System over 10 years ago

Thank you for your interesting :-)
I have published out the translated page in English. (I'm sorry for my cheap English...)
Please check it out.

http://www.skyarc.co.jp/en/archive/09/0317/123.html

RE: issue import (email or csv) - Added by Martin Liu about 10 years ago

For I often import issues from other track system, I wrote another CSV importer plugin, can define CSV column and issues mapping rule.
http://www.martinliu.info/2009/04/redmine_importer-redmine-csv-import-plugin/

Hope this helps.

RE: issue import (email or csv) - Added by Benjamin Baroukh about 10 years ago

Hi,

I am trying to use your brilliant plug-in, I can see it in the plug-in list, I can see the import tab and the permissions, but when I click on the tab I have an error 500. I looked at the log and have:

MissingSourceFile (no such file to load -- fastercsv):
    C:/redmine/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
    C:/redmine/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/dependencies.rb:510:in `require'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/dependencies.rb:355:in `new_constants_in'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/dependencies.rb:510:in `require'
    /vendor/plugins/redmine_importer/app/controllers/importer_controller.rb:1
    C:/redmine/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
    C:/redmine/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/dependencies.rb:510:in `require'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/dependencies.rb:355:in `new_constants_in'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/dependencies.rb:510:in `require'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/dependencies.rb:102:in `require_or_load_without_engine_additions'
    /vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:115:in `require_or_load'
    /vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:110:in `each'
    /vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:110:in `require_or_load'
    /vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:101:in `each'
    /vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:101:in `require_or_load'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/dependencies.rb:261:in `load_missing_constant'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/dependencies.rb:468:in `const_missing'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/dependencies.rb:480:in `const_missing'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/inflector.rb:285:in `constantize'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/inflector.rb:284:in `each'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/inflector.rb:284:in `constantize'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.2/lib/active_support/core_ext/string/inflections.rb:143:in `constantize'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/routing/route_set.rb:387:in `recognize'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:148:in `handle_request'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:107:in `dispatch'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:104:in `synchronize'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:104:in `dispatch'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:120:in `dispatch_cgi'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:35:in `dispatch'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel/rails.rb:76:in `process'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel/rails.rb:74:in `synchronize'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel/rails.rb:74:in `process'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel.rb:159:in `process_client'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel.rb:158:in `each'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel.rb:158:in `process_client'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel.rb:285:in `run'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel.rb:285:in `initialize'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel.rb:285:in `new'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel.rb:285:in `run'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel.rb:268:in `initialize'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel.rb:268:in `new'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel.rb:268:in `run'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel/configurator.rb:282:in `run'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel/configurator.rb:281:in `each'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel/configurator.rb:281:in `run'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/mongrel_rails:128:in `run'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/../lib/mongrel/command.rb:212:in `run'
    C:/redmine/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mswin32-60/bin/mongrel_rails:281
    C:/redmine/ruby/bin/mongrel_rails:16:in `load'
    C:/redmine/ruby/bin/mongrel_rails:16

I'm guessing that I require the "fatercsv" gem, should it be in Redmine, in a specific, included in the importer, should I get it myself.

Thanks.

RE: issue import (email or csv) - Added by Martin Liu about 10 years ago

to Benjamin,

Yes, you should install "fastercsv" gem. Just run "gem install fastercsv", the default 1.4.x version is tested.
I forgot to notice this dependence in the intallation guide, sorry!

RE: issue import (email or csv) - Added by Hans Kazan about 10 years ago

Martin Liu wrote:

For I often import issues from other track system, I wrote another CSV importer plugin, can define CSV column and issues mapping rule.
http://www.martinliu.info/2009/04/redmine_importer-redmine-csv-import-plugin/

Hope this helps.

Hi,

Good job done!
Would you please consider to make this plugin one of the standard plugins?

Currently it works only on the 0.8.3 stable branch, not on the development version.

RE: issue import (email or csv) - Added by Martin Liu about 10 years ago

Thanks for your suggestion, I'll maintain a vertion for development branch.
I'm a newbie in Redmine development, could please tell me what is standard plugins and how can I make a vendor plugins become a standard plugins? Thank you!

RE: issue import (email or csv) - Added by Nanda P almost 10 years ago

Can anyone please post the CSV file format, which is used with this plugin?

Regards,
Nanda

CSV file format - Added by SKYARC System almost 10 years ago

What redmine_importer (http://www.skyarc.co.jp/en/archive/09/0317/123.html) requires format of CSV is same as which Redmine exports.

#,Status,Project,Tracker,Priority,Title,Assigned,Category,Target version,Author,Start Date,Due Date,Done ratio,Estimated Hours,Created,Updated,Description

RE: issue import (email or csv) - Added by Stacey Gordon almost 10 years ago

I've installed fastercsv, but I am still having the same issue (error 500). Do I somehow have to point Redmine to this new version? "gem install fastercsv" was run from the .../ruby/bin directory.

Thanks,
Stacey

RE: issue import (email or csv) - missing fastercsv - Added by Christian Noack over 9 years ago

I also encountered the missing fastercsv problem mentioned above and just wanted to say: be aware to chose the right 'gem' command while installing if you have multiple ruby versions installed. My redmine server runs with enterprise ruby, but on the command line the standard Mac OS X ruby is in the path first. So I installed fastercsv, but it was still not found just because I installed it into the wrong environment. So if you have installed the gem and still have the missing fastercsv error, check which ruby installation is used by your redmine.

Best regards,

Christian

RE: issue import (email or csv) - Added by Johannes Koch over 9 years ago

Is this plugin already upgraded for redmine 0.9?

RE: issue import (email or csv) - Added by Victor Kyarginsky about 9 years ago

Anybody know how can we make import our issues into Redmine from external files (csv, txt)?

It is very important for us!

RE: issue import (email or csv) - Added by Klas Germunder almost 9 years ago

Dose anyone know if the plugin works with 0.9.3?

RE: issue import (email or csv) - Added by Anup Nair over 7 years ago

I spent my entire day at work (with overtime) trying to export users from Active Directory to Redmine.
First half went into getting users into csv file from AD. Once that was fixed, I ended up with Internal Server Error (500) with the importer plugin.

My installs:

redmine - 1.2.1
rails - 2.3.11
fastercsv 1.5.4
redmine_user_imoprt (taken from git) - 0.0.2 (note: I couldn't paste the link here. It says I have spammed!)

Issue: (primarily Internal Server Error 500) -- Possible solution below

I checked the logs and tried various things (such as trying older versions). Initially I didnt encounter fastercsv failure (500). At a later stage (back to latest version) the error was due to fastercsv.

Checks:

Keep an eye on the log file $redmin/logs/production.log
If the issue is due to fastercsv then:

cd $redmine  (where $redmine is the path to redmine home directory)
./script/console production   (if environment is production)
>>require "fastercsv" 

If result is false then :
edit $redmine/config/environment.rb
find text 'config.gem' Few gems will already be declared. Added fastercsv as given below:
config.gem "fastercsv"
save and exit.
restart apache

This fixed it for me.
I hope it saves your day.

Note:

For some reason I am not able to add hyper links.
Just wanted to add that stackoverflow's suggestion of adding config.gem in environment was the key moment of success. Thanks SO
link.. stackoverflow_dot_com/questions/3848566/no-such-file-to-load-fastercsv-error-when-trying-to-use-fastercsv-gem

RE: CSV file format - Added by Jack Sun over 6 years ago

I got Internal Server Error (500) when I submit a CSV file. Please help me to solve it. Thanks!

My installs:

Environment:

Redmine version - 2.1.2.stable.10738
Ruby version - 1.8.7 (i486-linux)
Rails version - 3.2.8
Environment - production
Database adapter - PostgreSQL

Redmine plugins:

redmine_importer - 1.0
redmine_user_profiles - 0.1.1

I also use gem list command to check my fastercsv installation,

# gem list fa
*** LOCAL GEMS ***
fastercsv (1.5.5, 1.5.3)
fastthread (1.0.7)

Issue: I looked at the log/production.log and have some errors:

Started POST "/redmine/importer/match" for 192.168.0.1 at Tue Nov 06 11:57:23 +0800 2012
Processing by ImporterController#match as HTML
  Parameters: {"commit"=>"Upload File", "project_id"=>"2", "splitter"=>",", "utf8"=>"\342\234\223", "encoding"=>"U", "authenticity_token"=>"RKdz8bDTPWmPYzZt3oW+YA+NS+gHelSfofz6oHfK9f4=", "wrapper"=>"\"", "file"=>#<ActionDispatch::Http::UploadedFile:0xb4e0deb8 @original_filename="FileZilla Config.xml", @headers="Content-Disposition: form-data; name=\"file\"; filename=\"C:\\FileZilla Config.xml\"\r\nContent-Type: text/xml\r\n", @tempfile=#<File:/tmp/RackMultipart20121106-14258-1p398y7-0>, @content_type="text/xml">}
  Current user: jack (id=4)
Completed 500 Internal Server Error in 91ms

NameError (uninitialized constant ImporterController::CSV):
  plugins/redmine_importer/app/controllers/importer_controller.rb:68:in `match'
  actionpack (3.2.8) lib/action_controller/metal/implicit_render.rb:4:in `send_action'
  actionpack (3.2.8) lib/action_controller/metal/implicit_render.rb:4:in `send_action'
  actionpack (3.2.8) lib/abstract_controller/base.rb:167:in `process_action'
  actionpack (3.2.8) lib/action_controller/metal/rendering.rb:10:in `process_action'
  actionpack (3.2.8) lib/abstract_controller/callbacks.rb:18:in `process_action'
  activesupport (3.2.8) lib/active_support/callbacks.rb:469:in `_run__666588801__process_action__868924417__callbacks'
  activesupport (3.2.8) lib/active_support/callbacks.rb:405:in `send'
  activesupport (3.2.8) lib/active_support/callbacks.rb:405:in `__run_callback'
  activesupport (3.2.8) lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks'
  activesupport (3.2.8) lib/active_support/callbacks.rb:81:in `send'
  activesupport (3.2.8) lib/active_support/callbacks.rb:81:in `run_callbacks'
  actionpack (3.2.8) lib/abstract_controller/callbacks.rb:17:in `process_action'
  actionpack (3.2.8) lib/action_controller/metal/rescue.rb:29:in `process_action'
  actionpack (3.2.8) lib/action_controller/metal/instrumentation.rb:30:in `process_action'
  activesupport (3.2.8) lib/active_support/notifications.rb:123:in `instrument'
  activesupport (3.2.8) lib/active_support/notifications/instrumenter.rb:20:in `instrument'
  activesupport (3.2.8) lib/active_support/notifications.rb:123:in `instrument'
  actionpack (3.2.8) lib/action_controller/metal/instrumentation.rb:29:in `process_action'
  actionpack (3.2.8) lib/action_controller/metal/params_wrapper.rb:207:in `process_action'
  activerecord (3.2.8) lib/active_record/railties/controller_runtime.rb:18:in `process_action'
  actionpack (3.2.8) lib/abstract_controller/base.rb:121:in `process'
  actionpack (3.2.8) lib/abstract_controller/rendering.rb:45:in `process'
  actionpack (3.2.8) lib/action_controller/metal.rb:203:in `dispatch'
  actionpack (3.2.8) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
  actionpack (3.2.8) lib/action_controller/metal.rb:246
  actionpack (3.2.8) lib/action_dispatch/routing/route_set.rb:73:in `call'
  actionpack (3.2.8) lib/action_dispatch/routing/route_set.rb:73:in `dispatch'
  actionpack (3.2.8) lib/action_dispatch/routing/route_set.rb:36:in `call'
  journey (1.0.4) lib/journey/router.rb:68:in `call'
  journey (1.0.4) lib/journey/router.rb:56:in `each'
  journey (1.0.4) lib/journey/router.rb:56:in `call'
  ...

RE: issue import (email or csv) - Added by Juan Fernandez almost 6 years ago

I created a Configurable PHP CLI tool to import sheets with Custom Fields (CSV or others) to Redmine through Redmine´s API. It also have Field Values mappings for matching redmine custom lists.

Just clone it from github

https://github.com/juanmf/RedmineIssueImporter

in your working directory of choice and download and composer.phar

http://getcomposer.org/doc/00-intro.md#installation-windows

and run

composer install

it will download the dependencies for you. Then configure the sheet-to-issues mapping config file in

Config/config.yml

@see README in github

(1-20/20)