view · edit · sidebar · attach · print · history

20130321-add-date-sort-of-swissmedicinfo-updater-report-and-pi-updater

<< | Index | >>


Summary

  • Add date field into swissmedic report and sort names by this date.
  • Debug PI Updater.

Commits

Index


Add date sort into swissmedicinfo report

take Publ. am. from swissmedicinfo and sort names with this date value.

Note

parse german format date.

[14] 1.9.3-p194(#<ODDB::TextInfoPlugin>)> Date.strptime('09.02.2013', "%m.%d.%Y").to_s
=> "2013-09-02"
[15] 1.9.3-p194(#<ODDB::TextInfoPlugin>)> Date.strptime('09.02.2013', "%d.%m.%Y").to_s
=> "2013-02-09"
[17] 1.9.3-p194(#<ODDB::TextInfoPlugin>)> Date.parse('09.02.2013').to_s  #=> this may have dependency to locale on machine.
=> "2013-02-09"
[18] 1.9.3-p194(#<ODDB::TextInfoPlugin>)> Date.parse('09/02/2013').to_s
=> "2013-02-09"
[19] 1.9.3-p194(#<ODDB::TextInfoPlugin>)> Date.parse('09/02/13').to_s
=> "2009-02-13"

sorted names by Date Object.

[5] 1.9.3-p194(#<ODDB::TextInfoPlugin>)> names
=> {:fi=>
  [["Coop Vitality Cetirizin", "21.03.2013"],
   ["Apotheke zur Eiche Antitussivum, Sirup", "20.03.2013"],
   ["Kodan forte farblos / gefärbt, Tinktur", "19.03.2013"],
   ["Ritalin® /-SR/-LA", "13.03.2013"],
   ["Gemcitabin Fresenius", "13.03.2013"],
   ["Levocetirizin Sandoz®", "13.03.2013"],
   ["Venlafaxin ER Sandoz® 37,5/75/150", "09.03.2013"],
   ["Nasivin® pur ", "08.03.2013"],
   ["Adcetris", "07.03.2013"],
   ["Coop Vitality Bisacodyl", "06.03.2013"],
   ["Hicoseen N Antitussivum, Sirup", "05.03.2013"],
   ["Gastrolux ", "05.03.2013"],
   ...
commit

Debug FI/PI import

There are some unexpected format FI/PI in swissmedicinfo.

too long name.

ERROR:  index row size 6672 exceeds maximum 2712 for index "search_term_fachinfo_name_de"
HINT:  Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.

DBI::ProgrammingError: ERROR:  index row size 6672 exceeds maximum 2712 for index "search_term_fachinfo_name_de"
HINT:  Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.
 when updating index 'fachinfo_name_de' with a ODDB::Fachinfo
...
[...]
...
  • Renatriol® 57592

Added invalid format detection.

# report
Updates FI from swissmedicXML
  ISKNR : Fachinfo - FR - Renatriol® - [57592]
Skipped FI form swissmedicXML
Invalid FI from swissmedicXML
  INVALID : Fachinfo - DE - Renatriol®

Debug swissmedic PI updater

view · edit · sidebar · attach · print · history
Page last modified on March 21, 2013, at 09:20 AM