Creating and populating Redmine custom fields by ruby code

Question

We are developing a mogration from a small issue tracker software to Redmine. We use the Ruby classes directly to migrate the data. The class for an issue is defined like this:

  class BuggyIssue < ActiveRecord::Base
    self.table_name = :issues
    belongs_to :last_issue_change, :class_name => 'BuggyIssueChange', :foreign_key => 'last_issue_change_id'
    has_many :issue_changes, :class_name => 'BuggyIssueChange', :foreign_key => 'issue_id', :order => 'issue_changes.date DESC'
    set_inheritance_column :none

    # Issue changes: only migrate status changes and comments
    has_many :issue_changes, :class_name => "BuggyIssueChange", :foreign_key => :issue_id

    def attachments
      #BuggyMigrate::BuggyAttachment.all(:conditions => ["type = 'issue' AND id = ?", self.id.to_s])
    end

    def issue_type
      read_attribute(:type)
    end

    def summary
      read_attribute(:summary).blank? ? "(no subject)" : read_attribute(:summary)
    end

    def description
      read_attribute(:description).blank? ? summary : read_attribute(:description)
    end

    def time; Time.at(read_attribute(:time)) end
    def changetime; Time.at(read_attribute(:changetime)) end
  end

Creating an issue and defining custom fields for the issue works. However, populating the custom fields doesn't seem to work. There are 4 custom fields (Contact, Test status, Source and Resolution).

The custom fields are created like this:

    repf = IssueCustomField.find_by_name("Contact")
    repf ||= IssueCustomField.create(:name => "Contact", :field_format => 'string') if repf.nil?
    repf.trackers = Tracker.find(:all)
    repf.projects << product_map.values
    repf.save!

The values for these fields are passed like this:

i = Issue.new :project => product_map[first_change.product_id],
...
:custom_field_values => {:Contact => issue.contact, 'Test status' => '', :Source => '', :Resolution => ''}

I've also tried a version with an index as hash key:

:custom_field_values => {'1' => issue.contact, 'Test status' => '', :Source => '', :Resolution => ''}

The issue can be saved without an issue, however, no value is ever passed over to Redmine. A

mysql> select count(*) from custom_values where value is not null;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.01 sec)

shows that all values for the custom fields are NULL after the migration. I don't seem to be able to find how this is done correctly, the documentation for the Redmine classes is very sparse.

Mikhail V. · Accepted Answer · 2015-03-28 08:33:14Z

2

I spent much time to solve near same issue. Take a look on my code written to transfer data from old system to new via Redmine REST API. Cause I used ActiveResource code will be usable for you.

def update_custom_fields(issue, fields)
    f_id = Hash.new { |hash, key| hash[key] = nil }
    issue.available_custom_fields.each_with_index.map { |f,indx| f_id[f.name] = f.id }
    field_list = []
    fields.each do |name, value|
      field_id = f_id[name].to_s
      field_list << Hash[field_id, value]
    end
    issue.custom_field_values = field_list.reduce({},:merge)

    raise issue.errors.full_messages.join(', ') unless issue.save
end

Now you can just call update_custom_fields(Issue.last, "MyField" => "MyValue" .. and so on)

edited Mar 28, 2015 at 8:33

Mikhail V.

759 bronze badges

answered Jun 20, 2013 at 12:55

Noma4i

7807 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating and populating Redmine custom fields by ruby code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related