class Oddb2xml::FirstbaseExtractor
Public Class Methods
new(file)
click to toggle source
# File lib/oddb2xml/extractor.rb, line 597 def initialize(file) @sheet = RubyXL::Parser.parse(file).worksheets[0] end
Public Instance Methods
to_hash()
click to toggle source
# File lib/oddb2xml/extractor.rb, line 601 def to_hash data = {} return data unless @sheet @sheet.each_with_index do |row, i| next if i <= 1 if row.nil? puts "Empty row (#{i}) in firstbase" next end gtin = row[0].value.to_s.gsub(/^0+/, '') data[gtin] = { gtin: gtin, gln: row[1].value.to_s, target_market: row[2] ? row[2].value.to_s: "", gpc: row[3] ? row[3].value.to_s: "", trade_item_description_de: row[4] ? row[4].value.to_s: "", trade_item_description_en: row[5] ? row[5].value.to_s: "", trade_item_description_fr: row[6] ? row[6].value.to_s: "", trade_item_description_it: row[7] ? row[7].value.to_s: "", manufacturer_name: row[8] ? row[8].value.to_s: "", start_availability_date: row[9] ? row[9].value.to_s: "", gross_weight: row[10] ? row[10].value.to_s: "", net_weight: row[11] ? row[11].value.to_s: "", } end data end