I am unable to import any csv file including the ones provided in test/samples
when i try to choose any csv file and click "upload file", it throws up the 500 error page

i am using Bitnami Redmine Stack 1.2.1 on windows

here is the log detail
Processing ImporterController#match (for 172.30.5.20 at 2011-12-22 16:56:44) [POST]
Parameters: {"encoding"=>"U", "commit"=>"Upload File", "project_id"=>"3", "action"=>"match", "authenticity_token"=>"SCH+utQujAeY1uAENk5pRfZUYz7jJZei4NNMeV98ud0=", "controller"=>"importer", "file"=>#File:C:/WINDOWS/Temp/RackMultipart20111222-6164-f8i3pp-0, "splitter"=>",", "wrapper"=>"""}

ArgumentError (comparison of Array with Array failed):
vendor/plugins/redmine_importer/app/controllers/importer_controller.rb:71:in sort!' vendor/plugins/redmine_importer/app/controllers/importer_controller.rb:71:inmatch'
config/initializers/mongrel_cluster_with_rails_211_fix.rb:62:in `dispatch_cgi'

Rendering C:/Program Files/BitNami Redmine Stack/apps/redmine/public/500.html (500 Internal Server Error)

Import error using sample file. (Bitnami Redmine 1.3.2)
Do I need to create import_in_progresses table manually?
Thanks.

Processing ImporterController#match (for at 2012-04-05 16:17:52) [POST]
Parameters: {"encoding"=>"U", "commit"=>"Upload File", "project_id"=>"1", "action"=>"match", "authenticity_token"=>"AhEQPlwZdUL0nZ0Fr/cMY3j376XEAg75P04s8CG2Wcw=", "controller"=>"importer", "file"=>#File:C:/Windows/Temp/RackMultipart20120405-896-wkl0s4-0, "splitter"=>",", "wrapper"=>"""}

ActiveRecord::StatementInvalid (Mysql::Error: Table 'bitnami_redmine.import_in_progresses' doesn't exist: DELETE FROM import_in_progresses WHERE (user_id = 3) ):
vendor/plugins/redmine_importer/app/controllers/importer_controller.rb:41:in match' config/initializers/mongrel_cluster_with_rails_211_fix.rb:62:indispatch_cgi'

Rendering C:/BitNami/apps/redmine/public/500.html (500 Internal Server Error)

When redmine exports issues it uses the Full name of the author/assignee which does not match the plugin's logic when importing (which uses login name).
Because of this problem I can't automatically import / export issues between redmine instances.

Is there any workaround i'm missing?
I'm using redmine 1.3.

Thanks

After installing the plugin and enabling it for a project the web page breaks. The message from the logfile is:

ActionView::Template::Error (No route matches {:action=>"index", :controller=>"importer", :id=>"mango-hw-architecture", :project_id=>#}):
    42:     <% end %>
    43: 
    44:     
<%= page_header_title %>
    45: 
    46:     <% if display_main_menu?(@project) %>
    47:     

    48:         <%= render_main_menu(@project) %>
  lib/redmine/menu_manager.rb:150:in `render_single_menu_node'
  lib/redmine/menu_manager.rb:102:in `render_menu_node'
  lib/redmine/menu_manager.rb:91:in `block in render_menu'
  lib/redmine/menu_manager.rb:166:in `block in menu_items_for'
  lib/redmine/menu_manager.rb:163:in `each'
  lib/redmine/menu_manager.rb:163:in `menu_items_for'
  lib/redmine/menu_manager.rb:90:in `render_menu'
  lib/redmine/menu_manager.rb:80:in `render_main_menu'
  app/views/layouts/base.html.erb:45:in `_app_views_layouts_base_html_erb__1109490136092492547_70167698725960'

I found the following issue that indicates that /config/routes.rb must be updated starting in version 1.4.

http://www.redmine.org/issues/9778

It's posible to import new issues and to update exsinting issues from one file at the same time? Thank you

I can not get the rake --trace db:migrate_plugins RAILS_ENV="production" to work, it fails with erros msg, i have search DB for importer and did not find anything

** Invoke db:migrate_plugins (first_time)
** Invoke environment (first_time)
** Execute environment
rake aborted!
Child already added
/opt/redmine-1.0/lib/redmine/menu_manager.rb:348:in `add_at'
/opt/redmine-1.0/lib/redmine/menu_manager.rb:267:in `push'
/opt/redmine-1.0/lib/redmine/plugin.rb:188:in `menu'
/opt/redmine-1.0/vendor/plugins/redmine_importer/init.rb:12:in `evaluate_init_rb'
/opt/redmine-1.0/lib/redmine/plugin.rb:70:in `instance_eval'
/opt/redmine-1.0/lib/redmine/plugin.rb:70:in `register'
/opt/redmine-1.0/vendor/plugins/redmine_importer/init.rb:3:in `evaluate_init_rb'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/rails/plugin.rb:158:in `evaluate_init_rb'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/activesupport-2.3.14/lib/active_support/core_ext/kernel/reporting.rb:11:in `silence_warnings'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/rails/plugin.rb:154:in `evaluate_init_rb'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/rails/plugin.rb:48:in `load'
/opt/redmine-1.0/config/../vendor/plugins/engines/lib/engines/plugin.rb:44:in `load'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/rails/plugin/loader.rb:38:in `load_plugins'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/rails/plugin/loader.rb:37:in `each'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/rails/plugin/loader.rb:37:in `load_plugins'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/initializer.rb:369:in `load_plugins'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/initializer.rb:165:in `process'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/initializer.rb:113:in `send'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/initializer.rb:113:in `run'
/opt/redmine-1.0/config/environment.rb:24
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/activesupport-2.3.14/lib/active_support/dependencies.rb:184:in `require'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/activesupport-2.3.14/lib/active_support/dependencies.rb:184:in `require'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/tasks/misc.rake:4
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `call'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `execute'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `each'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `execute'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:158:in `invoke_with_call_chain'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:176:in `invoke_prerequisites'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:174:in `each'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:174:in `invoke_prerequisites'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:157:in `invoke_with_call_chain'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:144:in `invoke'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:116:in `invoke_task'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `top_level'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `each'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `top_level'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:88:in `top_level'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:66:in `run'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:63:in `run'
/opt/ruby-enterprise-1.8.7-2011.03/lib/ruby/gems/1.8/gems/rake-0.9.2.2/bin/rake:33
/usr/local/bin/rake:19:in `load'
/usr/local/bin/rake:19
Tasks: TOP => db:migrate_plugins => environment

I often use import from google docs spreadsheet, and it is really stupid - need download table and select it in redmine importer. I suggest add into page a text box into which you can insert a CSV or tab-separated text. Then there is no need to save and choose the CSV file to import tasks. Will be enough copy the column names and tasks from Google Docs or Excel and paste this into textarea field.

Hi all,
Importing csv file don't work, any ideas ?
My configuration :
Environment:
Redmine version 3.1.1.stable
Ruby version 1.9.3-p194 (2012-04-20) [x86_64-linux]
Rails version 4.2.4
Environment production
Database adapter Mysql2
SCM:
Git 1.7.10.4
Filesystem
Redmine plugins:
csv_import_issues 0.0.2
redmine_importer 1.2.2

tails -f /etc/opt/redmine/log/production.log :
Started POST "/redmine/importer/match" for 10.181.35.80 at 2015-11-09 17:49:55 +0100
Processing by ImporterController#match as HTML
Parameters: {"utf8"=>"â", "authenticity_token"=>"+nz+wZD9QJELh9XxHlJQW1HmVB5sQh5yTRSWQIgxt4vesTe9g/t4IlYaRN9RzroYiikzX09uSeKzz16VB61RLg==", "project_id"=>"5", "file"=>#<ActionDispatch::Http::UploadedFile:0x000000089df4d8 @tempfile=#File:/tmp/RackMultipart20151109-4171-ygl135.csv, @original_filename="import2.csv", @content_type="application/vnd.ms-excel", @headers="Content-Disposition: form-data; name="file"; filename="import2.csv"\r\nContent-Type: application/vnd.ms-excel\r\n">, "encoding"=>"U", "splitter"=>",", "wrapper"=>""", "commit"=>"Upload File"}
Current user: admin (id=1)
Completed 500 Internal Server Error in 218ms (ActiveRecord: 83.4ms)

NoMethodError (undefined method find_or_create_by_user_id' for #<Class:0x00000008c49390>): lib/redmine/sudo_mode.rb:63:insudo_mode'

Try to import next file:
http://www.wuala.com/mike.walker/sharing/import.csv/

Header rows are cyrillic, and

issue.subject = row[attrs_map["subject"]] || issue.subject

Why? How can I fix it?

I created a custome field 'Owner' with format 'user' - with checkbox checked for 'Required', 'For all projects', and 'Used as filter'.

When I import from a file I created from a csv of data from another system, everything but the Owner field is imported.

Column headings on my file are:

'Category', 'ERP CTL XRF', 'Subject', 'description', 'status', 'est (days)', 'Estimated Hours', 'Assignee', 'owner'

• ERP CTL XRF - is a custom field - format 'text' no limit, not required, check box for 'Used as filter' is checked.
• est (days) is ignored

I have tried both the sign-in id format for owner - flastname as well as the format specified for users in my set up 'Firstname Lastname'

I also tried adding a column after owner - Tracker, with Task in each row. No difference.

When importing a list of issues with more than 2 new categories, only the first new category is listed in project->settings->issue categories.

However, the missing categories are listed in issue list. But there is no way to edit them, or select them from category dropdown when updating an issue.

I'm using redmine 1.2.1.
Still a very good plugin, nice job.

I was not able to update existing issue during import.

In the file production.log in the folder \redmine\log, I noticed the error :

NoMethodError (undefined method `project_id' for #<Issue::ActiveRecord_Relation:0x0000000f0c64a8>):
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'

After investigation and debugging session, I have located the problem in the file importer_controller.rb, line 141

140   if unique_attr == "id"
141       issues = [Issue.where(:id => attr_value)]
142   else

The type of the array "issues" is Issue::ActiveRecord_Relation, instead of Issue, which I whould expect. That is the reason why, afterward, I get the error undefined method `project_id'.

Solution :
I have modified the source code as follow.

140   if unique_attr == "id"
141       issues = Issue.where(:id => attr_value).to_a
142   else

It is working normally now.

Redmine version 2.0.0.devel

Started GET "/projects/abc/settings/modules" for 183.1.204.95 at 2012-05-24 10:55:12 +0000
Processing by ProjectsController#settings as HTML
Parameters: {"id"=>"abc", "tab"=>"modules"}
Rendered projects/_form.html.erb (17.0ms)
Rendered projects/_edit.html.erb (18.7ms)
Rendered projects/settings/_modules.html.erb (3.6ms)
Rendered projects/settings/_members.html.erb (11.7ms)
Rendered projects/settings/_versions.html.erb (2.7ms)
Rendered projects/settings/_issue_categories.html.erb (1.1ms)
Rendered projects/settings/_wiki.html.erb (1.7ms)
Rendered projects/settings/_activities.html.erb (79.7ms)
Rendered common/_tabs.html.erb (124.4ms)
Rendered projects/settings.html.erb within layouts/base (125.1ms)
Completed 500 Internal Server Error in 172ms

ActionController::RoutingError (No route matches {:project_id=>#<Project id:1234, name: "ABC", description: "ABC China", homepage: "", is_public: false, parent_id: nil, created_on: "2012-05-24 09:57:30", updated_on: "2012-05-24 09:57:30", identifier: "abc", status: 1, lft: 191, rgt: 220>, :controller=>"importer"}):
lib/redmine/menu_manager.rb:150:in render_single_menu_node' lib/redmine/menu_manager.rb:102:inrender_menu_node'
lib/redmine/menu_manager.rb:91:in block in render_menu' lib/redmine/menu_manager.rb:168:inblock in menu_items_for'
lib/redmine/menu_manager.rb:165:in each' lib/redmine/menu_manager.rb:165:inmenu_items_for'
lib/redmine/menu_manager.rb:90:in render_menu' lib/redmine/menu_manager.rb:80:inrender_main_menu'
app/views/layouts/base.html.erb:51:in `_app_views_layouts_base_html_erb___657420175069464130_23414940'

You can define versions to be shared with sub-projects, everything, nothing, etc... If you try to import a csv of issues into a sub-project and the issues to be imported reference a shared version, you get an "Internal Error" page and the production.log contains:

Rendering importer/result
Completed in 2334ms (View: 159, DB: 440) | 200 OK [http://localhost/redmine/importer/result]
/!\ FAILSAFE /!\  Fri Jan 27 14:40:51 -0600 2012
Status: 500 Internal Server Error
ActionController::Session::CookieStore::CookieOverflow
/ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.14/lib/action_controller/session/cookie_store.rb:111:in `call'
/ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.14/lib/action_controller/failsafe.rb:26:in `call'
/ruby/lib/ruby/gems/1.8/gems/rack-1.1.1/lib/rack/lock.rb:11:in `call'
/ruby/lib/ruby/gems/1.8/gems/rack-1.1.1/lib/rack/lock.rb:11:in `synchronize'
/ruby/lib/ruby/gems/1.8/gems/rack-1.1.1/lib/rack/lock.rb:11:in `call'
/ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.14/lib/action_controller/dispatcher.rb:106:in `call'
/apps/redmine/config/initializers/mongrel_cluster_with_rails_211_fix.rb:62:in `dispatch_cgi'
/ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.14/lib/action_controller/dispatcher.rb:101:in `dispatch_cgi'
/ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.14/lib/action_controller/dispatcher.rb:27:in `dispatch'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel/rails.rb:76:in `process'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel/rails.rb:74:in `synchronize'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel/rails.rb:74:in `process'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel.rb:159:in `process_client'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel.rb:158:in `each'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel.rb:158:in `process_client'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel.rb:285:in `run'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel.rb:285:in `initialize'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel.rb:285:in `new'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel.rb:285:in `run'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel.rb:268:in `initialize'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel.rb:268:in `new'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel.rb:268:in `run'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel/configurator.rb:282:in `run'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel/configurator.rb:281:in `each'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel/configurator.rb:281:in `run'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/mongrel_rails:128:in `run'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/../lib/mongrel/command.rb:212:in `run'
/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/bin/mongrel_rails:281
/ruby/bin/mongrel_rails:19:in `load'
/ruby/bin/mongrel_rails:19

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

Some googling mentions a problem with the en.yml file - but I cannot see any issues with 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..

i use a chinese windows7 and office

use office edit export files,and use impoter plugin import

but ui view garbled

i try edit code use gb gb2312 .....but fialed

please tell me how to upload a ASNI code files to importer plugin

i use redmine 1.4.4

Please help me...

when i import issues display it message.

wrong number of arguments (2 for 0)

Header :
"Subject","Description","External id"

Error on header or line :

"Important Task","A truly critical deed.","5643-4"

FILE csv
"Subject","Description","External id"
"Important Task","A truly critical deed.","5643-4"
"Less Important Task","Something that would be useful.","5644-6"

One of the issue fields is a boolean for whether or not the issue is private. I believe the importer should support setting this value.

Hi,

Thanks for your great plug-in!
I want to report a bug: Though I have set permission for anonymous can do nothing, they still can import issues via Importer page - just come to link: http://my_server/importer?project_id=project_id and import as usual and it is still successful.

Regards,

Hi,

I import a large file and found a problem of cookies overflow. How can I solve it. Thanks

the csv file contains 180 rows.

the log shows:

Processing ImporterController#result (for 192.168.3.94 at 2012-01-09 15:50:43) [POST]
Parameters: {"commit"=>"提交", "fields_map"=>{"报告日期"=>"start_date", "摘要"=>"subject", "编号"=>"", "问题分类"=>"", "最后更新"=>"due_date", "分类"=>"", "出现频率"=>"", "优先级"=>"priority", "说明"=>"description", "分派给"=>"assigned_to", "处理状况"=>"", "项目"=>"", "严重性"=>"", "报告员"=>"author", "状态"=>"status", "查看权限"=>""}, "project_id"=>"21", "unique_field"=>"", "add_versions"=>"true", "action"=>"result", "authenticity_token"=>"1CNktSwDtr9aCCdUsT0JKrWCV8uh4jMNolHflBhqyzA=", "send_emails"=>"true", "add_categories"=>"true", "controller"=>"importer", "import_timestamp"=>"2012-01-09 15:48:55", "default_tracker"=>"1"}
Rendering template within layouts/base
Rendering importer/result
Completed in 5119ms (View: 216, DB: 195) | 200 OK [http://192.168.2.135/importer/result]
/!\ FAILSAFE /!\ Mon Jan 09 15:50:48 +0800 2012
Status: 500 Internal Server Error
ActionController::Session::CookieStore::CookieOverflow
/usr/local/ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.14/lib/action_controller/session/cookie_store.rb:111:in call' /usr/local/ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.14/lib/action_controller/failsafe.rb:26:incall'
/usr/local/ruby/lib/ruby/gems/1.8/gems/rack-1.1.2/lib/rack/lock.rb:11:in call' /usr/local/ruby/lib/ruby/gems/1.8/gems/rack-1.1.2/lib/rack/lock.rb:11:insynchronize'
/usr/local/ruby/lib/ruby/gems/1.8/gems/rack-1.1.2/lib/rack/lock.rb:11:in call' /usr/local/ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.14/lib/action_controller/dispatcher.rb:106:incall'
/usr/local/ruby/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/rails/rack/static.rb:31:in call' /usr/local/ruby/lib/ruby/gems/1.8/gems/rack-1.1.2/lib/rack/urlmap.rb:47:incall'
/usr/local/ruby/lib/ruby/gems/1.8/gems/rack-1.1.2/lib/rack/urlmap.rb:41:in each' /usr/local/ruby/lib/ruby/gems/1.8/gems/rack-1.1.2/lib/rack/urlmap.rb:41:incall'
/usr/local/ruby/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/rails/rack/log_tailer.rb:17:in call' /usr/local/ruby/lib/ruby/gems/1.8/gems/rack-1.1.2/lib/rack/content_length.rb:13:incall'
/usr/local/ruby/lib/ruby/gems/1.8/gems/rack-1.1.2/lib/rack/chunked.rb:15:in call' /usr/local/ruby/lib/ruby/gems/1.8/gems/rack-1.1.2/lib/rack/handler/mongrel.rb:67:inprocess'
/usr/local/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:159:in process_client' /usr/local/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:158:ineach'
/usr/local/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:158:in process_client' /usr/local/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285:inrun'
/usr/local/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285:in initialize' /usr/local/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285:innew'
/usr/local/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285:in run' /usr/local/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:268:ininitialize'
/usr/local/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:268:in new' /usr/local/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:268:inrun'
/usr/local/ruby/lib/ruby/gems/1.8/gems/rack-1.1.2/lib/rack/handler/mongrel.rb:38:in run' /usr/local/ruby/lib/ruby/gems/1.8/gems/rails-2.3.14/lib/commands/server.rb:111 /usr/local/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:ingem_original_require'
/usr/local/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'

script/server:3

add file "Gemfile" on root level with one line as content

gem 'fastercsv'

Redmine importer: 担当者の入力規則はログインIDのみ
エクスポート: 担当者は表示規則に従って出力
→（山田太郎さんで例えると）表示が姓名なら山田　太郎、ログインIDならyamada-taroで出力される

上記仕様から、エクスポートしたチケットをインポートで更新する際は、csvファイルの担当者列を手作業でなおす必要があります。
なおさずにインポートするとチケットの担当者がクリアされます。
プラグインの使い方として一度に多くのチケットを更新することが予想されますが、これを手でなおしていくのはなかなか大変そうです…。

なお、Redmine標準インポートでは姓名でもインポートが可能です。
検討お願いします。

The error in the production.log is:

I, [2017-02-09T11:45:38.957629 #7928] INFO -- : STATEMENT projects.id = 4 AND (issues.status_id IS NOT NULL) AND issues.id IN (SELECT issues.id FROM issues LEFT OUTER JOIN custom_values ON custom_values.customized_type='Issue' AND custom_values.customized_id=issues.id AND custom_values.custom_field_id=1 WHERE (custom_values.value IN ('SHR1600729')) AND (((1=1) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = 1)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = 1 AND ifa.id = 1) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = 1))))) I, [2017-02-09T11:45:38.964629 #7928] INFO -- : Completed 500 Internal Server Error in 256ms (ActiveRecord: 131.0ms) F, [2017-02-09T11:45:38.967630 #7928] FATAL -- : ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'projects.id' in 'where clause': SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM issuesWHERE (projects.id = 4 AND (issues.status_id IS NOT NULL) AND issues.id IN (SELECT issues.id FROM issues LEFT OUTER JOIN custom_values ON custom_values.customized_type='Issue' AND custom_values.customized_id=issues.id AND custom_values.custom_field_id=1 WHERE (custom_values.value IN ('SHR1600729')) AND (((1=1) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = 1)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = 1 AND ifa.id = 1) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = 1)))))) LIMIT 2) subquery_for_count): plugins/redmine_importer/app/controllers/importer_controller.rb:172:inissue_for_unique_attr'
plugins/redmine_importer/app/controllers/importer_controller.rb:361:in block in result' plugins/redmine_importer/app/controllers/importer_controller.rb:304:in result'
lib/redmine/sudo_mode.rb:63:in sudo_mode'

My environment:
Environment: Redmine version 3.3.0.stable Ruby version 2.1.8-p440 (2015-12-16) [i386-mingw32] Rails version 4.2.6 Environment production Database adapter Mysql2

Hi,

Firstly, many thanks for a great plugin. Being able to import data is key for me and the latest version of your plugin works very well.

My issue: I recently upgraded Redmine from 1.3.2.1 to 1.4.1.0 and when I tried to view a project that was previously ok I got an 'Internal error' page. I checked the production log and found this error

Processing ProjectsController#show (for 200.0.0.77 at 2012-04-27 12:00:36) [GET]
  Parameters: {"action"=>"show", "controller"=>"projects", "id"=>"test1"}
Rendering template within layouts/base
Rendering projects/show

ActionView::TemplateError (No route matches {:action=>"index", :project_id=>#<Project id: 1, name: "SomeProject", description: "SomeProject main development", homepage: "", is_public: false, parent_id: nil, created_on: "2012-04-10 12:40:39", updated_on: "2012-04-12 12:18:33", identifier: "test1", status: 1, lft: 3, rgt: 4>, :controller=>"importer"}) on line #57 of app/views/layouts/base.html.erb:
54: 
55:     <% if display_main_menu?(@project) %>
56:     <div id="main-menu">
57:         <%= render_main_menu(@project) %>
58:     </div>
59:     <% end %>
60: </div>

    lib/redmine/menu_manager.rb:150:in `render_single_menu_node'
    lib/redmine/menu_manager.rb:102:in `render_menu_node'
    lib/redmine/menu_manager.rb:91:in `render_menu'
    lib/redmine/menu_manager.rb:168:in `menu_items_for'
    lib/redmine/menu_manager.rb:165:in `each'
    lib/redmine/menu_manager.rb:165:in `menu_items_for'
    lib/redmine/menu_manager.rb:90:in `render_menu'
    lib/redmine/menu_manager.rb:80:in `render_main_menu'
    app/views/layouts/base.html.erb:57
    app/controllers/projects_controller.rb:168:in `show'
    config/initializers/mongrel_cluster_with_rails_211_fix.rb:62:in `dispatch_cgi'

Rendering C:/Program Files/BitNami Redmine Stack 1.4.1/apps/redmine/public/500.html (500 Internal Server Error)

I'm pretty clueless when it comes to Ruby but the error seemed similar to this Redmine issue so without really understanding what I was doing I added a new file '...\plugins\redmine_importer\config\routes.rb' with these contents:

ActionController::Routing::Routes.draw do |map|
  map.connect ':controller/:action/:id'
end

I then restarted redmine and the error no longer occurs. I'm hoping you might understand what the actual problem was and produce a 'correct' fix at some point but in the meantime this information might be useful for anyone else who encounters this issue.

This was with Redmine 2.6 and the very latest Redmine Importer master branch (as of 14 Feb 2017). After restarting Redmine, I went to my Project's page, then clicked on the Modules tab, and activated the "Importer" module. I was redirected to the Project's homepage URL, but I got a "Page not found" error. The project's pages and data are gone. The project is still listed on the Redmine homepage, but when I click on the Project's link, I get "Page not found". Needless to say, this isn't good.

Thank god Redmine was running on a VM and I took a snapshot before I installed the plugin.

One person who was using the importer to manually sync two bug-tracking systems pointed out that in that case (where he's manually generating an export from another system and then importing it into redmine via the importer) it would be more convenient if an addtion to updating or not updating existing issues, it could ignore existing issues completely.

The biggest difficultly would probably be in documenting exactly what this means.

I realize the plugin is not yet compatible with Redmine 1.3 but I installed the plugin anyway. Uploading the CSV file seemed to work, but the only problem I am seeing at this point is just the display of information.

For example, after uploading a file, I see this:

Import Result

{{handle_count}} issues processed. {{success_count}} issues successfully imported.

Affected projects:
* A. Research: Architecture:{{count}} issues

So it seems that there are tags that are not being parsed.

There is also this one:

Refer to top lines of {{value}}：

I love your plug-in!!!
Importing new issues works great!!

When I try to update any existing issues, I get the error message and log entry below.

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.

If you are the Redmine administrator, check your log files for details about the error.

Processing ImporterController#result (for [=my PC's IP addr=] at 2013-01-30 13:33:54) [POST]
Parameters: {"commit"=>"Submit", "fields_map"=>{"Start date"=>"start_date", "Subject"=>"", "#"=>"", "ID number"=>""}, "ignore_non_exist"=>"true", "project_id"=>"22", "unique_field"=>"ID number", "action"=>"result", "authenticity_token"=>"OzqiZv...blah...rPZcIBBaK4=", "update_issue"=>"true", "controller"=>"importer", "import_timestamp"=>"2013-01-30 13:31:51", "default_tracker"=>"8", "journal_field"=>"#", "update_other_project"=>"true"}

ArgumentError (interning empty string):
vendor/plugins/redmine_importer/app/controllers/importer_controller.rb:262:in to_sym' vendor/plugins/redmine_importer/app/controllers/importer_controller.rb:262:inresult'
lib/faster_csv.rb:1521:in each' vendor/plugins/redmine_importer/app/controllers/importer_controller.rb:224:inresult'
config/initializers/mongrel_cluster_with_rails_211_fix.rb:62:in `dispatch_cgi'

I think I'm using the latest plug-in version:

Issue Importer Issue import plugin for Redmine.
Martin Liu / Leo Hourvitz 1.0 c65c222....

The plugin folder is named 'redmine_importer'.

I followed the directions in the Wiki and Sample file - https://github.com/leovitch/redmine_importer/wiki

Using: Redmine 1.2.1.stable (MySQL)

Please help!!

Rick

When I export a CSV file from redmine, parent task appears like that : "User story #11401: User Story 1". To import with your plugin, just a number must be here. That's why I am trying to create a regex but I don't find how to integrate the regex into your code in order to keep only the number 11401.

Thank your for you help.

Quentin

Environment:
Redmine version 2.3.1.stable
Ruby version 1.9.3 (x86_64-linux)
Rails version 3.2.13
Environment production
Database adapter Mysql2
Redmine plugins:
redmine_importer 1.0

I can see this in plugins manage Page
Issue Importer
Issue import plugin for Redmine.
Martin Liu / Leo Hourvitz 1.0

If I enabled this module in any project ,I will can't use this project

I got past some of the early stumbling blocks to progress to the "match" interface for the importer, but after that I get an error as follows below. I'm on Redmine 1.3. I know nothing of Ruby, unfortunately, so sorry if this isn't enough info for an error report. Please help!

Processing ImporterController#index (for 192.168.20.168 at 2012-02-03 14:37:31) [GET]
Parameters: {"action"=>"index", "project_id"=>"dms", "controller"=>"importer"}
Rendering template within layouts/base
Rendering importer/index
Completed in 18ms (View: 14, DB: 2) | 200 OK [http://192.168.21.666/importer?project_id=dms]

Processing ImporterController#match (for 192.168.20.168 at 2012-02-03 14:37:37) [POST]
Parameters: {"encoding"=>"U", "authenticity_token"=>"ut4x/vYZchqwtIojTdIRaToNJKapYQRHN67j64ELjMk=", "commit"=>"Upload File", "action"=>"match", "file"=>#<File:/tmp/RackMultipart20120203-28883-178
rwgt-0>, "wrapper"=>""", "project_id"=>"1", "splitter"=>",", "controller"=>"importer"}
Rendering template within layouts/base
Rendering importer/match
Completed in 153ms (View: 12, DB: 135) | 200 OK [http://192.168.21.666/importer/match]

Processing ImporterController#result (for 192.168.20.168 at 2012-02-03 14:37:40) [POST]
Parameters: {"authenticity_token"=>"ut4x/vYZchqwtIojTdIRaToNJKapYQRHN67j64ELjMk=", "commit"=>"Submit", "action"=>"result", "add_categories"=>"true", "import_timestamp"=>"2012-02-03 14:37:37", "pr
oject_id"=>"1", "default_tracker"=>"1", "unique_field"=>"", "controller"=>"importer", "send_emails"=>"true", "add_versions"=>"true"}

NoMethodError (undefined method []' for nil:NilClass): vendor/plugins/redmine_importer/app/controllers/importer_controller.rb:199:inresult'
passenger (3.0.11) lib/phusion_passenger/rack/request_handler.rb:96:in process_request' passenger (3.0.11) lib/phusion_passenger/abstract_request_handler.rb:513:inaccept_and_process_next_request'
passenger (3.0.11) lib/phusion_passenger/abstract_request_handler.rb:274:in main_loop' passenger (3.0.11) lib/phusion_passenger/classic_rails/application_spawner.rb:321:instart_request_handler'
passenger (3.0.11) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in send' passenger (3.0.11) lib/phusion_passenger/classic_rails/application_spawner.rb:275:inhandle_spawn_application'
passenger (3.0.11) lib/phusion_passenger/utils.rb:479:in safe_fork' passenger (3.0.11) lib/phusion_passenger/classic_rails/application_spawner.rb:270:inhandle_spawn_application'
passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:357:in __send__' passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:357:inserver_main_loop'
passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:206:in start_synchronously' passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:180:instart'
passenger (3.0.11) lib/phusion_passenger/classic_rails/application_spawner.rb:149:in start' passenger (3.0.11) lib/phusion_passenger/spawn_manager.rb:219:inspawn_rails_application'
passenger (3.0.11) lib/phusion_passenger/abstract_server_collection.rb:132:in lookup_or_add' passenger (3.0.11) lib/phusion_passenger/spawn_manager.rb:214:inspawn_rails_application'
passenger (3.0.11) lib/phusion_passenger/abstract_server_collection.rb:82:in synchronize' passenger (3.0.11) lib/phusion_passenger/abstract_server_collection.rb:79:insynchronize'
passenger (3.0.11) lib/phusion_passenger/spawn_manager.rb:213:in spawn_rails_application' passenger (3.0.11) lib/phusion_passenger/spawn_manager.rb:132:inspawn_application'
passenger (3.0.11) lib/phusion_passenger/spawn_manager.rb:275:in handle_spawn_application' passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:357:insend'
passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:357:in server_main_loop' passenger (3.0.11) lib/phusion_passenger/abstract_server.rb:206:instart_synchronously'
passenger (3.0.11) helper-scripts/passenger-spawn-server:99

After importing a CSV file, I'm seeing this message:

{{handle_count}} issues processed. {{success_count}} issues successfully imported.

Affected projects:
COMPRESS:{{count}} issues

I'm on Windows using Chrome and the Bitnami Redmine 1.3.0 stack.

I'm attempting to install

/usr/share/redmine/vendor/plugins/redmine_importer# git log | grep commit | head -n1
commit f7982e9d6ddad7cee4c2b9e6dc264eb5831894be

for Redmine 1.1.2 and have this occur:

root@redmine:/usr/share/redmine# rake --trace db:migrate_plugins RAILS_ENV=production
(in /usr/share/redmine)
** Invoke db:migrate_plugins (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate_plugins
Migrating engines...
Migrating action_mailer_optional_tls...
Migrating acts_as_activity_provider...
Migrating acts_as_attachable...
Migrating acts_as_customizable...
Migrating acts_as_event...
Migrating acts_as_list...
Migrating acts_as_searchable...
Migrating acts_as_tree...
Migrating acts_as_versioned...
Migrating acts_as_watchable...
Migrating awesome_nested_set...
Migrating classic_pagination...
Migrating gravatar...
Migrating open_id_authentication...
Migrating prepend_engine_views...
Migrating redmine_importer...
==  CreateImportInProgresses: migrating =======================================
-- create_table(:import_in_progresses)
NOTICE:  CREATE TABLE will create implicit sequence "import_in_progresses_id_seq" for serial column "import_in_progresses.id"
rake aborted!
An error has occurred, this and all later migrations canceled:

PGError: ERROR:  type modifier is not allowed for type "bytea"
LINE 1: ...cter varying(64), "created" timestamp, "csv_data" bytea(4194...
                                                             ^
: CREATE TABLE "import_in_progresses" ("id" serial primary key, "user_id" integer NOT NULL, "quote_char" character varying(8), "col_sep" character varying(8), "encoding" character varying(64), "created" timestamp, "csv_data" bytea(4194304)) 
/usr/lib/ruby/1.8/active_record/connection_adapters/abstract_adapter.rb:219:in `log'
/usr/lib/ruby/1.8/active_record/connection_adapters/postgresql_adapter.rb:550:in `execute'
/usr/lib/ruby/1.8/active_record/connection_adapters/abstract/schema_statements.rb:114:in `create_table'
/usr/lib/ruby/1.8/active_record/migration.rb:352:in `send'
/usr/lib/ruby/1.8/active_record/migration.rb:352:in `method_missing'
/usr/lib/ruby/1.8/active_record/migration.rb:328:in `say_with_time'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/usr/lib/ruby/1.8/active_record/migration.rb:328:in `say_with_time'
/usr/lib/ruby/1.8/active_record/migration.rb:348:in `method_missing'
/usr/share/redmine/vendor/plugins/redmine_importer/db/migrate/001_create_import_in_progresses.rb:3:in `up_without_benchmarks'
/usr/lib/ruby/1.8/active_record/migration.rb:282:in `send'
/usr/lib/ruby/1.8/active_record/migration.rb:282:in `migrate'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/usr/lib/ruby/1.8/active_record/migration.rb:282:in `migrate'
/usr/lib/ruby/1.8/active_record/migration.rb:365:in `__send__'
/usr/lib/ruby/1.8/active_record/migration.rb:365:in `migrate'
/usr/lib/ruby/1.8/active_record/migration.rb:486:in `migrate'
/usr/lib/ruby/1.8/active_record/migration.rb:560:in `call'
/usr/lib/ruby/1.8/active_record/migration.rb:560:in `ddl_transaction'
/usr/lib/ruby/1.8/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
/usr/lib/ruby/1.8/active_record/transactions.rb:182:in `transaction'
/usr/lib/ruby/1.8/active_record/migration.rb:560:in `ddl_transaction'
/usr/lib/ruby/1.8/active_record/migration.rb:485:in `migrate'
/usr/lib/ruby/1.8/active_record/migration.rb:472:in `each'
/usr/lib/ruby/1.8/active_record/migration.rb:472:in `migrate'
/usr/lib/ruby/1.8/active_record/migration.rb:400:in `up'
/usr/lib/ruby/1.8/active_record/migration.rb:383:in `migrate'
/usr/share/redmine/vendor/plugins/engines/lib/engines/plugin/migrator.rb:20:in `migrate_plugin'
/usr/share/redmine/config/../vendor/plugins/engines/lib/engines/plugin.rb:93:in `migrate'
/usr/share/redmine/lib/tasks/migrate_plugins.rake:8
/usr/share/redmine/lib/tasks/migrate_plugins.rake:5:in `each'
/usr/share/redmine/lib/tasks/migrate_plugins.rake:5
/usr/lib/ruby/1.8/rake.rb:636:in `call'
/usr/lib/ruby/1.8/rake.rb:636:in `execute'
/usr/lib/ruby/1.8/rake.rb:631:in `each'
/usr/lib/ruby/1.8/rake.rb:631:in `execute'
/usr/lib/ruby/1.8/rake.rb:597:in `invoke_with_call_chain'
/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/usr/lib/ruby/1.8/rake.rb:590:in `invoke_with_call_chain'
/usr/lib/ruby/1.8/rake.rb:583:in `invoke'
/usr/lib/ruby/1.8/rake.rb:2051:in `invoke_task'
/usr/lib/ruby/1.8/rake.rb:2029:in `top_level'
/usr/lib/ruby/1.8/rake.rb:2029:in `each'
/usr/lib/ruby/1.8/rake.rb:2029:in `top_level'
/usr/lib/ruby/1.8/rake.rb:2068:in `standard_exception_handling'
/usr/lib/ruby/1.8/rake.rb:2023:in `top_level'
/usr/lib/ruby/1.8/rake.rb:2001:in `run'
/usr/lib/ruby/1.8/rake.rb:2068:in `standard_exception_handling'
/usr/lib/ruby/1.8/rake.rb:1998:in `run'
/usr/bin/rake:28

The Postgresql database on the other end is 9.0.4.

Hello,

Categories and Fixed versions are defined for each projects.

Following changes may be necessary.

app\controllers\importer_controller.rb

174 - category = IssueCategory.find_by_name(category_name)
+ category = IssueCategory.find_by_project_id_and_name(project.id, category_name)

181 - fixed_version = Version.find_by_name(fixed_version_name)
+ fixed_version = Version.find_by_project_id_and_name(project.id, fixed_version_name)

Regards,

Hi

Can you add the compatiblity with redmine 2.6 feature?
This will be very helpful and interesting 💯

Sincerely,
Salehi

Hi,
I just installed your plugin into a 1.2 redmine
Loading your AllStandardFields.csv, I am returned to this error.
Maybe, you can give a quick hint
Regards
cg

Rendering importer/match
�[4;35;1mTracker Load (0.0ms)�[0m �[0mSELECT * FROM trackers INNER JOIN projects_trackers ON trackers.id = projects_trackers.tracker_id WHERE (projects_trackers.project_id = 1 ) ORDER BY trackers.position�[0m

ActionView::TemplateError (missing interpolation argument in "Display all lines of %{original_filename}:" ({:value=>"AllStandardFieldso.csv"} given)) on line #67 of vendor/plugins/redmine_importer/app/views/importer/match.html.erb:
64:
65:

d:/webserver/ruby/lib/ruby/gems/1.8/gems/i18n-0.4.2/lib/i18n/backend/base.rb:174:in `interpolate'
d:/webserver/ruby/lib/ruby/gems/1.8/gems/i18n-0.4.2/lib/i18n/backend/base.rb:46:in `translate'
d:/webserver/ruby/lib/ruby/gems/1.8/gems/i18n-0.4.2/lib/i18n/backend/fallbacks.rb:47:in `translate'
d:/webserver/ruby/lib/ruby/gems/1.8/gems/i18n-0.4.2/lib/i18n/backend/fallbacks.rb:45:in `each'
d:/webserver/ruby/lib/ruby/gems/1.8/gems/i18n-0.4.2/lib/i18n/backend/fallbacks.rb:45:in `translate'
d:/webserver/ruby/lib/ruby/gems/1.8/gems/i18n-0.4.2/lib/i18n.rb:160:in `t'
lib/redmine/i18n.rb:15:in `l'
vendor/plugins/redmine_importer/app/views/importer/match.html.erb:67
config/initializers/mongrel.rb:62:in `dispatch_cgi'

Rendering d:/webserver/Redmine_test/redmine/public/500.html (500 Internal Server Error)

A couple people have reported an issue where when uploading a sizable CSV file (especially with "Update existing issues" turned on, which slows down import a lot), their proxy server times out the connection. It's not really a bug with the importer (the import actually succeeds in the end according to the reports, it's just that you don't get to see the confirmation screen) but if we made the import screen but ajax-ified, we could probably get around this problem as well as provide better user feedback about the import in progress.

Hi, I am applying this plug-in, and it really helps us so much, but one strange issue occurs, when Iimport the issues, error messages are:

•Warning: The following data-validation errors occurred on issue 1 in the list below
•Error: parent_issue_id can't be blank
•Error: estimated_hours can't be blank
•Warning: The following data-validation errors occurred on issue 2 in the list below
•Error: parent_issue_id can't be blank
•Error: estimated_hours can't be blank

But the 2 fields: parent_issue_id, estimated_hour are not mandatory fileds for the new issues, why there are such messages?

More strange is when I change the "author" to me, the import can be sucessfull, so I am wondering author in the csv file shall be the importer or not?

I found such info. in the wiki.

Author: The author of the ticket. It's rarely necessary to supply this, because it will default to the user who does the upload.

Can the author be set to non-importer in the csv file?

Thank you.

First, I want to thank author for this module. Really necessary thing.

Are you planning to make the module compatible with Redmine 2.x? I can help you, if you need it, although Ruby isn`t my primary language.

Thanks!

Suppose I have a CSV with "CID", "Short Name", and "Description". As it turns out, "CID" and "Short Name" together should make up the Redmine Subject with "Description" mapping to Description.

Instead of the subject being the result of a concatenation of "CID" and "Short Name", I only get "Short Name" (appears that last one in wins).

My RFE: When the user maps more than one field in the CSV to the same field in Redmine, cat the CSV fields together to create the Redmine entry.

Thank you!

It would be good to treat imported dates properly depending on the format setting - my month and day were being switched, as the issues I was importing were in dd/mm/yyyy format.

Hi,

I actually use the redmine importer and i have some questions about it.

I would like to import in one shot a CSV file where some issues can already exist into my redmine database and some another not.
Could you tell me if it is possible to do that ?
In other way, do you have an idea to import issues knowing that into my CSV file, I can't identify issues which exist or not into my redmine database ?

Regards,

Hi,

I'm using Redmine_Tags(https://github.com/ixti/redmine_tags/). Redmine can export to CSV file with tags.
But It can't import any plugins. So I'm requesting the feature that this plugin support to import Tags fields.

Thanks.

The new version of Redmine needs the routes for the plugins, as described in http://www.redmine.org/projects/redmine/wiki/Plugin_Tutorial#Generating-a-controller .

Because of the missing router, I'm getting this error:

Processing IssuesController#show (for 10.3.14.32 at 2012-04-17 07:53:41) [GET]
  Parameters: {"action"=>"show", "id"=>"3192", "controller"=>"issues"}
Rendering template within layouts/base
Rendering issues/show

ActionView::TemplateError (No route matches {:controller=>"importer", :action=>"index", :project_id=>#}) on line #57 of app/views/layouts/base.html.erb:
54: 
55:     <% if display_main_menu?(@project) %>
56:     

57:         <%= render_main_menu(@project) %>
58:     
59:     <% end %>
60: 

    lib/redmine/menu_manager.rb:150:in `render_single_menu_node'
    lib/redmine/menu_manager.rb:102:in `render_menu_node'
    lib/redmine/menu_manager.rb:91:in `render_menu'
    lib/redmine/menu_manager.rb:168:in `menu_items_for'
    lib/redmine/menu_manager.rb:165:in `each'
    lib/redmine/menu_manager.rb:165:in `menu_items_for'
    lib/redmine/menu_manager.rb:90:in `render_menu'
    lib/redmine/menu_manager.rb:80:in `render_main_menu'
    app/views/layouts/base.html.erb:57
    app/controllers/issues_controller.rb:118:in `show'
    app/controllers/issues_controller.rb:115:in `show'
    config/initializers/mongrel.rb:62:in `dispatch_cgi'

Rendering C:/webserver/Redmine/public/500.html (500 Internal Server Error)