Redmine

    if request.get?

      auto_map_fields

    elsif request.post?

  def auto_map_fields

    # Try to auto map fields only when settings['enconding'] is present

    # otherwhise, the import fails for non UTF-8 files because the headers

    # cannot be retrieved (Invalid byte sequence in UTF-8)

    return if @import.settings['encoding'].blank?

    mappings = @import.settings['mapping'] ||= {}

    headers = @import.headers.map(&:downcase)

    # Core fields

    import_type::AUTO_MAPPABLE_FIELDS.each do |field_nm, label_nm|

      next if mappings.include?(field_nm)

      index = headers.index(field_nm) || headers.index(l(label_nm).downcase)

      if index

        mappings[field_nm] = index

      end

    end

    # Custom fields

    @custom_fields.each do |field|

      field_nm = "cf_#{field.id}"

      next if mappings.include?(field_nm)

      index = headers.index(field_nm) || headers.index(field.name.downcase)

      if index

        mappings[field_nm] = index

      end

    end

    mappings

  end

  AUTO_MAPPABLE_FIELDS = {}

  AUTO_MAPPABLE_FIELDS = {

    'tracker' => 'field_tracker',

    'subject' => 'field_subject',

    'description' => 'field_description',

    'status' => 'field_status',

    'priority' => 'field_priority',

    'category' => 'field_category',

    'assigned_to' => 'field_assigned_to',

    'fixed_version' => 'field_fixed_version',

    'is_private' => 'field_is_private',

    'parent_issue_id' => 'field_parent_issue',

    'start_date' => 'field_start_date',

    'due_date' => 'field_due_date',

    'estimated_hours' => 'field_estimated_hours',

    'done_ratio' => 'field_done_ratio'

  }

  AUTO_MAPPABLE_FIELDS = {

    'activity' => 'field_activity',

    'user' => 'field_user',

    'issue_id' => 'field_issue',

    'spent_on' => 'field_spent_on',

    'hours' => 'field_hours',

    'comments' => 'field_comments'

  }

  <label for="import_mapping_tracker"><%= l(:field_tracker) %></label>

priority;Subject;start_date;parent;private;progress;custom;"target version";category;user;estimated_hours;tracker;status;database;cf_6

High;First;2015-07-08;;no;;PostgreSQL;;New category;dlopper;1;bug;new;"PostgreSQL, Oracle";2

  def test_get_mapping_should_auto_map_fields_by_internal_field_name_or_by_label

    import = generate_import('import_issues_auto_mapping.csv')

    import.settings = {'separator' => ';', 'wrapper'=> '"', 'encoding' => 'ISO-8859-1'}

    import.save!

    get :mapping, :params => {

        :id => import.to_param

      }

    assert_response :success

    # 'subject' should be auto selected because

    #  - 'Subject' exists in the import file

    #  - mapping is case insensitive

    assert_select 'select[name=?]', 'import_settings[mapping][subject]' do

      assert_select 'option[value="1"][selected="selected"]', :text => 'Subject'

    end

    # 'estimated_hours' should be auto selected because

    #  - 'estimated_hours' exists in the import file

    assert_select 'select[name=?]', 'import_settings[mapping][estimated_hours]' do

      assert_select 'option[value="10"][selected="selected"]', :text => 'estimated_hours'

    end

    # 'fixed_version' should be auto selected because

    #  - the translation 'Target version' exists in the import file

    assert_select 'select[name=?]', 'import_settings[mapping][fixed_version]' do

      assert_select 'option[value="7"][selected="selected"]', :text => 'target version'

    end

    # 'assigned_to' should not be auto selected because

    #  - 'assigned_to' does not exist in the import file

    assert_select 'select[name=?]', 'import_settings[mapping][assigned_to]' do

      assert_select 'option[selected="selected"]', 0

    end

    # Custom field 'Float field' should be auto selected because

    #  - the internal field name ('cf_6') exists in the import file

    assert_select 'select[name=?]', 'import_settings[mapping][cf_6]' do

      assert_select 'option[value="14"][selected="selected"]', :text => 'cf_6'

    end

    # Custom field 'Database' should be auto selected because

    #  - field name 'database' exists in the import file

    #  - mapping is case insensitive

    assert_select 'select[name=?]', 'import_settings[mapping][cf_1]' do

      assert_select 'option[value="13"][selected="selected"]', :text => 'database'

    end

  end

    # Assert auto mapped fields

    assert_select 'select[name=?]', 'import_settings[mapping][activity]' do

      assert_select 'option[value="5"][selected="selected"]', :text => 'activity'

    end

    # 'user' should be mapped to column 'user' from import file

    # and not to current user because the auto map has priority

    assert_select 'select[name=?]', 'import_settings[mapping][user]' do

      assert_select 'option[value="7"][selected="selected"]', :text => 'user'

    end

    assert_select 'select[name=?]', 'import_settings[mapping][cf_10]' do

      assert_select 'option[value="6"][selected="selected"]', :text => 'overtime'

    end

  end

  def test_get_mapping_time_entry_for_user_with_log_time_for_other_users_permission

    Role.find(1).add_permission! :log_time_for_other_users

    import = generate_time_entry_import

    import.settings = {

      'separator' => ";", 'wrapper' => '"', 'encoding' => "ISO-8859-1",

      # Do not auto map user in order to allow current user to be auto selected

      'mapping' => {'user' => nil}

    }

    import.save!

    get :mapping, :params => {

        :id => import.to_param

      }

    # 'user' field should be available because User#2 has both

      # Current user should be the default value if there is not auto map present