Module: I18n::Backend::Weeler::Importer::ClassMethods

Defined in:
lib/i18n/backend/weeler/importer.rb

Instance Method Summary collapse

Instance Method Details

#import(file) ⇒ Object

Loads file and iterates each sheet and row.



25
26
27
28
29
30
31
32
33
34
35
36
37
38
# File 'lib/i18n/backend/weeler/importer.rb', line 25

def import(file)
  xls = open_spreadsheet(file)

  xls.each_with_pagename do |_, sheet|
    # Lookup locales
    locales = locales_from_xlsx_sheet_row(sheet.row(1))
    tranlsations_by_locales = Translation.where(locale: locales).group_by(&:locale)

    # Lookup values
    (2..sheet.last_row).each do |row_no|
      store_translations_from_xlsx_row(tranlsations_by_locales, sheet.row(row_no), locales)
    end
  end
end