view · edit · sidebar · attach · print · history


<< Masa.20120116-fix-rss-pointer-link-new-patent-link-encode-compress-oddb_csv-fix-download-patinfo-invoices-update-sbsm-simple_uri_parser | Index | Masa.20120112-delete-old-migel-fix-oddb2tdat-fix-pointer-link-oddb_org-check-sbsm-rockit >>

  1. Fix error links
  2. Check oddb.csv encode
  3. Update oddb2tdat format
  4. Check SBSM rockit

  1. Removed require migel from ext/export/src/odba_exporter.rb (
  2. Fix key not found: migel_model_migelid_name_en error. It uses de index table when there is no index table for the language (migel)
  3. Updated RECA, CMUT, PRMO, ITHE format (oddb2tdat)
  4. Update CMUT, if Gültig bis is before today CMUT = 3 (oddb2tdat)
  5. Fix the condition if the download file is new in update_narcotics (
  6. Skip searching migel alphabet by dt index table, and skip ODDB::Migel::Item object when feedbacks are searched (

Fix error links

Error links

  1. /en/just-medical/migel_alphabetical/range/h
  • These are resolved after reboot
  1. /de/swissmedinfo/sequences/range/p
  2. /de/gcc/search/search_query/L03/search_type/st_oddb/code/L03AB05
  3. /de/gcc/search/search_query/L03/search_type/st_oddb/code/L03AB05
  4. /dt/gcc/sequences/range/p/page/7

Check oddb.csv encode


  • oddb.csv is encoded when the report mail is sent, then attached oddb.csv becomes ISO-8859-1.
  • Originally, it is saved with UTF-8, so that the data/downloads/oddb.csv becomes UTF-8.
  • Additionally, the backup of oddb.csv is saved in data/csv directory with date information to the file name.
  • Updater#export_oddb_csv exports oddb.csv and sends a report mail with the ISO-8859-1 encoded oddb.csv
  • Exporter#export_csv (jobs/export_csv) only exports UTF-8 oddb.csv in data/downloads directory but does NOT sends a report mail

Update oddb2tdat format


  1. Products without Pharmacode, or Gültig bis is before today, must be CMUT = 3
  2. 05 PRMO must be taken from column M otherwise set to 0.
  3. Please fill ITHE (Index Therapeuticus) with trailing 000 not with leading zeros.
  4. 01 RECA must be set to 01 not 11.


Check SBSM rockit


  • Apache calls SBSM::TransHanlder#translate_uri(request) and TransHandler#parse_uri calls parser classes in order to parse uri string.
  • The parser classes require rockit


  • /usr/lib64/ruby/site_ruby/1.8/sbsm/trans_handler.rb
    def simple_parse(uri)
      # /language/flavor/event/key/value/key/value/...
      items = uri.split('/')
      lang = items.shift
      flavor = items.shift
      event = items.shift
      values = {}
      until items.empty?
        key = items.shift
        value = items.shift, value)
    def translate_uri(request)
      @@empty_check ||='^/?$')
      @@lang_check ||='^/[a-z]{2}(/|$)')
      config = config(request)
      handle_shortcut(request, config)
      uri = request.uri
      case uri
      when @@empty_check
        request.uri = config['redirect']['/'] || HANDLER_URI
      when @@lang_check
        request.uri = HANDLER_URI


  • link does not work
view · edit · sidebar · attach · print · history
Page last modified on January 13, 2012, at 05:06 PM