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
38
39
|
# File 'app/models/bulk_time_entry.rb', line 4
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])
@time. = row[1].mb_chars[0..255].strip.to_s if row[1].present?
@time.user = User.find_by_login(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
|