Class: BulkTimeEntry

Inherits:
Object
  • Object
show all
Defined in:
app/models/bulk_time_entry.rb

Class Method Summary (collapse)

Class Method Details

+ (Object) import_from_csv(file)



2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
# File 'app/models/bulk_time_entry.rb', line 2

def self.import_from_csv(file)
  csv_file = File.read(file)
  row_counter = 0
  failed_counter = 0

  begin
    ActiveRecord::Base.transaction do
      FasterCSV.parse(csv_file) do |row|
        if row[0].blank? ||
            row[2].blank? ||
            row[3].blank? ||
            row[4].blank? ||
            row[5].blank?
          
          failed_counter += 1
          next

        end
        @time = TimeEntry.new(:issue_id => row[0],
                             :spent_on => row[2],
                             :activity => TimeEntryActivity.find_by_name(row[3].strip),
                             :hours => row[4])
        # Truncate comments to 255 chars
        @time.comments = row[1].mb_chars[0..255].strip.to_s if row[1].present?
        @time.user = User.(row[5].strip)

        @time.save!
        row_counter += 1
      end
    end
  rescue ActiveRecord::StatementInvalid, ActiveRecord::RecordNotSaved, ActiveRecord::RecordInvalid => ex
    return "ERROR: #{ex.message} on:\n\n#{@time.inspect}"
  end
  failed_message = failed_counter == 0 ? '' : "#{failed_counter} records failed to import."
  return "Imported #{row_counter} records. #{failed_message}"
end