Class: Oddb2xml::MigelExtractor

Inherits:
Extractor show all
Defined in:
lib/oddb2xml/extractor.rb

Instance Attribute Summary

Attributes inherited from Extractor

#xml

Instance Method Summary collapse

Constructor Details

#initialize(bin) ⇒ MigelExtractor

Returns a new instance of MigelExtractor.



346
347
348
349
350
# File 'lib/oddb2xml/extractor.rb', line 346

def initialize(bin)
  Oddb2xml.log("MigelExtractor #{io} #{File.size(io)} bytes")
  book = Spreadsheet.open(io, "rb")
  @sheet = book.worksheet(0)
end

Instance Method Details

#to_hashObject



352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
# File 'lib/oddb2xml/extractor.rb', line 352

def to_hash
  data = {}
  @sheet.each_with_index do |row, i|
    next if i.zero?
    phar = row[1]
    next if phar == 0
    ean13 = row[0]
    ean13 = phar unless ean13.to_s.length == 13
    data[ean] = {
      refdata: true,
      ean13: ean13,
      pharmacode: phar,
      desc_de: row[3],
      desc_fr: row[4],
      quantity: row[5], # quantity
      company_name: row[6],
      company_ean: row[7],
      data_origin: "migel"
    }
  end
  data
end