Index>

20150602-oddb2xml-caverject

Summary

• oddb2xml --calc: fix caverject
• oddb2xml --calc: Use some rewritten ATC-Codes from Epha
• oddb2xml --calc: fix use of alcohol benzylicus

Commits

• https://github.com/ngiger/oddb2xml/commit/09bdfe7e6b6994bbd6a30a4caff913fecf3d4cae Fix Caverjet by eliminatins semantically wrong leading "Solvens:"
• https://github.com/ngiger/oddb2xml/commit/3e761984446164caf315d331b35a706336044069 Consider changes in ATC-codes by EPha
• https://github.com/ngiger/oddb2xml/commit/2a7e1589e02b30272cddbf9f717ec460cc1e7a87 Give substances for lines starting with Solvens

Index

• oddb2xml --calc: fix caverject
• oddb2xml --calc: Use some rewritten ATC-Codes from Epha
• oddb2xml --calc: fix use of alcohol benzylicus

Keep in Mind for work to do

• Fix dojo error http://www.sitepen.com/blog/2012/10/31/debugging-dojo-common-error-messages/#forgot-dom-ready
• I removed on May-27 tests for ix_registrationss, fix_sequences, fix_compositions, fix_packages from test/test_plugin/swissmedic.rb,as he could not find any references for them in the src code. Did I erroneously remove stuff when cleaning up the swissmedic import earlier?
• The whole test for older/newer Packages must be adapted to xlsx. One must compare the rows (e.g. by creating csv files) and do the same stuff in xlsx!
• creat gem: task: input=file with ean-codes, standard output show ean-codes + atc-code. Source is Swissmedic Packungen.xlsx or XML.
• Import via data/medreg_companies.yaml
• Fix problem with radioactivatum 99m-technetio when parsing Wirkstoffe
• Fix galenic_forms when parsing swissmedic.xlsx
• Cleanup generic_type. Replace it everywhere by sl_generic_type and adapt code accordingly.

oddb2xml --calc: Use some rewritten ATC-Codes from Epha

EPha rewrites some ATC-Codes (see WIDO). The content can be found via https://github.com/epha/robot/blob/master/data/manual/swissmedic/atc.csv

Done (including unit-test) with commit Consider changes in ATC-codes by EPha

oddb2xml --calc: fix use of alcohol benzylicus

When calling grep benzylicus oddb_calc.xml | grep -v SUBSTANCE_NAME we find 16 lines where the substance was not recognized correctly, e.g. <CORRESP>conserv.: alcohol benzylicus 18 mg, aqua ad iniectabilia q.s. ad solutionem pro 2 ml</CORRESP>

Reworking to handle lines starting with Solvens to make them parse the containing substance and setting a "corresp" if this is not possible. E.g. Redimune 3 g, Trockensubstanz mit Solvens which has Solvens: natrii chloridi solutio 9 g/L 100 ml.

Unit-Tests work. Waiting for oddb2xml --calc to finish to compare all items with the previous version.

oddb2xml --calc: fix caverject

The EAN13 7680556740075 has a wrong corresp field, which currently looks like

  <ARTICLE>
    <GTIN>7680556740075</GTIN>
    <NAME>Caverject DC 20, Injektionspräparat</NAME>
    <PKG_SIZE>2</PKG_SIZE>
    <SELLING_UNITS>2</SELLING_UNITS>
    <MEASURE>Spritze(n)</MEASURE>
    <GALENIC_FORM>Injektionspräparat</GALENIC_FORM>
    <GALENIC_GROUP>Injektion/Infusion</GALENIC_GROUP>
    <COMPOSITIONS>
      <COMPOSITION>
        <CORRESP>alprostadilum 20 µg, alfadexum, lactosum anhydricum,
natrii citras dihydricus, conserv.: alcohol benzylicus 4.45 mg, aqua
ad iniectabilia q.s. ad solutionem pro 0.5 ml in solutione recenter
reconstituta</CORRESP>
        <SUBSTANCES/>
      </COMPOSITION>
    </COMPOSITIONS>
  </ARTICLE>

Something odd seems to happen hear, as CompositionParser.new.composition.parse_with_debug of the source string gives a correct result.

The two Caverject are the only product which start their "Zusammensetzung" with "Solvens:", which is semantically just wrong! Therefore adding a fix, which transforms Solvens: alprostadilum by alprostadilum

Pushed commit Fix Caverjet by eliminatins semantically wrong leading "Solvens:"

For EAN13 7680235330306 "Solu-Cortef 100 mg, Injektions-/Infusionspräparat" I have now instead of

      <COMPOSITION>
        <CORRESP>conserv.: alcohol benzylicus 18 mg, aqua ad iniectabilia q.s. ad solutionem pro 2 ml</CORRESP>
        <SUBSTANCES/>
      </COMPOSITION>

      <COMPOSITION>
        <EXCIPIENS>
          <SUBSTANCE_NAME>aqua ad iniectabilia q.s. ad solutionem</SUBSTANCE_NAME>
          <QTY>2</QTY>
          <UNIT>ml</UNIT>
        </EXCIPIENS>
        <LABEL>Solvens</LABEL>
        <SUBSTANCES>
          <SUBSTANCE>
            <MORE_INFO>conserv.</MORE_INFO>
            <SUBSTANCE_NAME>Alcohol Benzylicus</SUBSTANCE_NAME>
            <IS_ACTIVE_AGENT>false</IS_ACTIVE_AGENT>
            <QTY>18</QTY>
            <UNIT>mg/2 ml</UNIT>
          </SUBSTANCE>
        </SUBSTANCES>
      </COMPOSITION>

Pushed commit Give substances for lines starting with Solvens