*** importer.rb	2011-12-07 09:12:55.845829041 +0100
--- migel/lib/migel/util/importer.rb	2011-12-07 15:51:14.901223165 +0100
***************
*** 214,220 ****
    def get_products_by_migel_code(migel_code, lang = 'de')
      lang.upcase!
      products = if migelid = Migel::Model::Migelid.find_by_migel_code(migel_code)
!                  migel_code = migelid.migel_code.split('.').to_s
                   if table = Migel::Util::Swissindex.search_migel_table(migel_code, lang)
                     table.select{|record| record[:pharmacode] and record[:article_name]}
                   end
--- 214,221 ----
    def get_products_by_migel_code(migel_code, lang = 'de')
      lang.upcase!
      products = if migelid = Migel::Model::Migelid.find_by_migel_code(migel_code)
!                  #migel_code = migelid.migel_code.split('.').to_s
!                  migel_code = migelid.migel_code.split('.').join
                   if table = Migel::Util::Swissindex.search_migel_table(migel_code, lang)
                     table.select{|record| record[:pharmacode] and record[:article_name]}
                   end
***************
*** 325,331 ****
      total = File.readlines(file_name).to_a.length
      count = 0
      # update cache
!     CSV.open(file_name, 'r') do |line|
        count += 1
        migel_code = line[0]
        if migelid = Migel::Model::Migelid.find_by_migel_code(migel_code)
--- 326,333 ----
      total = File.readlines(file_name).to_a.length
      count = 0
      # update cache
!     #CSV.open(file_name, 'r') do |line|
!     CSV.foreach(file_name) do |line|
        count += 1
        migel_code = line[0]
        if migelid = Migel::Model::Migelid.find_by_migel_code(migel_code)