view · edit · sidebar · attach · print · history

Index>

20150511-desitin-first

Summary

  • Minipack from desitin must come just after originals
  • oddb2xml: Use parslet to split column_C of packages into preparation_name and galenic_form

Commits

Index

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.

Minipack from desitin must come just after originals

Minipacks from Desitin must appear in the search result for evidentica (Levetiracetam) just after the orgininals, too. At the moment, some like Levetiracetam DRAC 250 mg EAN 7680630580016 appear too low. Got the followin result today. 


        Präparat  Galenische Form Stärke  Packungsgrösse  EFP PP  SB  Wirkstoff Zulassungsinhaber Kat.
Levetiracetam (N03AX14) 94 Präparate     
  FI      Keppra 250 mg Filmtabletten 250 mg  30 Tablette(n)  14.99 29.50 10% Levetiracetamum UCB-Pharma SA B / SL / SO
  FI      Keppra 500 mg ‐ F Filmtabletten 500 mg  20 Tablette(n)  15.26 33.90 10% Levetiracetamum UCB-Pharma SA B / SL / SO
  FI      Keppra 500 mg ‐ F Filmtabletten 500 mg  100 Tablette(n) 79.10 107.20  10% Levetiracetamum UCB-Pharma SA B / SL / SO
  FI      Keppra 500 mg ‐ F Filmtabletten 500 mg  2 x 100 Tablette(n) 154.18  193.40  10% Levetiracetamum UCB-Pharma SA B / SL / SO
  FI      Keppra 1000 mg  Filmtabletten 1000 mg 30 Tablette(n)  49.88 73.65 10% Levetiracetamum UCB-Pharma SA B / SL / SO
  FI      Keppra 1000 mg  Filmtabletten 1000 mg 100 Tablette(n) 152.87  191.90  10% Levetiracetamum UCB-Pharma SA B / SL / SO
  FI      Keppra 1000 mg  Filmtabletten 1000 mg 2 x 100 Tablette(n) 295.43  355.55  10% Levetiracetamum UCB-Pharma SA B / SL / SO
  FI      Keppra 100 mg/mL  Lösung (oral) 100 mg/ml Flasche(n) ā 300 ml 56.94 81.75 10% Levetiracetamum UCB-Pharma SA B / SL / SO
  FI      Levetiracetam Desitin 250 mg  Filmtabletten 250 mg  30 Tablette(n)  11.87 25.95 10% Levetiracetamum Desitin Pharma GmbH B / SL / SG
  FI      Levetiracetam Desitin 500 mg  Filmtabletten 500 mg  20 Tablette(n)  13.83 28.20 10% Levetiracetamum Desitin Pharma GmbH B / SL / SG
  FI      Levetiracetam Desitin 500 mg  Filmtabletten 500 mg  100 Tablette(n) 63.53 89.35 10% Levetiracetamum Desitin Pharma GmbH B / SL / SG
  FI      Levetiracetam Desitin 500 mg  Filmtabletten 500 mg  200 Tablette(n) 125.36  160.30  10% Levetiracetamum Desitin Pharma GmbH B / SL / SG
  FI      Levetiracetam Desitin
1000 mg Filmtabletten 1000 mg 30 Tablette(n)  38.95 61.10 10% Levetiracetamum Desitin Pharma GmbH B / SL / SG
  FI      Levetiracetam Desitin
1000 mg Filmtabletten 1000 mg 100 Tablette(n) 124.32  159.10  10% Levetiracetamum Desitin Pharma GmbH B / SL / SG
  FI      Levetiracetam Desitin
1000 mg Filmtabletten 1000 mg 200 Tablette(n) 243.81  296.30  10% Levetiracetamum Desitin Pharma GmbH B / SL / SG
  FI      Levetiracetam Desitin 100
mg/mL Lösung (oral) 100 mg/ml Flasche(n) ā 300 ml 46.65 69.95 10% Levetiracetamum Desitin Pharma GmbH B / SL / SG
  FI      Levetiracetam Desitin 100
mg/mL ‐ F Lösung (oral) 100 mg/ml Flasche(n) ā 300 ml 46.65 69.95 k.A.  Levetiracetamum Desitin Pharma GmbH B
  FI      Levetiracetam Actavis 250 mg  Filmtabletten 250 mg  30 Tablette(n)  k.A.  k.A.  k.A.  Levetiracetamum Actavis Switzerland AG  B
  FI      Levetiracetam Actavis 250 mg  Filmtabletten 250 mg  30 Tablette(n)  11.02 24.95 10% Levetiracetamum Actavis Switzerland AG  B / SL / SG
  FI      Levetiracetam Actavis 500 mg  Filmtabletten 500 mg  30 Tablette(n)  k.A.  k.A.  k.A.  Levetiracetamum Actavis Switzerland AG  B
  FI      Levetiracetam Actavis 500 mg  Filmtabletten 500 mg  30 Tablette(n)  19.26 38.50 10% Levetiracetamum Actavis Switzerland AG  B / SL / SG
  FI      Levetiracetam Actavis 500 mg  Filmtabletten 500 mg  100 Tablette(n) 59.00 84.15 10% Levetiracetamum Actavis Switzerland AG  B / SL / SG
  FI      Levetiracetam Actavis 500 mg  Filmtabletten 500 mg  100 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum Actavis Switzerland AG  B
  FI      Levetiracetam Actavis 500 mg  Filmtabletten 500 mg  200 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum Actavis Switzerland AG  B
  FI      Levetiracetam Actavis 500 mg  Filmtabletten 500 mg  200 Tablette(n) 116.42  150.05  10% Levetiracetamum Actavis Switzerland AG  B / SL / SG
  FI      Levetiracetam Actavis
1000 mg Filmtabletten 1000 mg 30 Tablette(n)  36.17 57.90 10% Levetiracetamum Actavis Switzerland AG  B / SL / SG
  FI      Levetiracetam Actavis
1000 mg Filmtabletten 1000 mg 30 Tablette(n)  k.A.  k.A.  k.A.  Levetiracetamum Actavis Switzerland AG  B
  FI      Levetiracetam Actavis
1000 mg Filmtabletten 1000 mg 100 Tablette(n) 117.24  151.00  10% Levetiracetamum Actavis Switzerland AG  B / SL / SG
  FI      Levetiracetam Actavis
1000 mg Filmtabletten 1000 mg 100 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum Actavis Switzerland AG  B
  FI      Levetiracetam Actavis
1000 mg Filmtabletten 1000 mg 200 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum Actavis Switzerland AG  B
  FI      Levetiracetam Actavis
1000 mg Filmtabletten 1000 mg 200 Tablette(n) 226.42  276.35  10% Levetiracetamum Actavis Switzerland AG  B / SL / SG
  FI      Levetiracetam Helvepharm
250mg Filmtabletten 250 mg  30 Tablette(n)  12.02 26.10 10% Levetiracetamum Helvepharm AG B / SL / SG
  FI      Levetiracetam Helvepharm
500mg Filmtabletten 500 mg  20 Tablette(n)  14.00 28.35 10% Levetiracetamum Helvepharm AG B / SL / SG
  FI      Levetiracetam Helvepharm
500mg Filmtabletten 500 mg  100 Tablette(n) 64.35 90.25 10% Levetiracetamum Helvepharm AG B / SL / SG
  FI      Levetiracetam Helvepharm
500mg Filmtabletten 500 mg  200 Tablette(n) 126.99  162.20  10% Levetiracetamum Helvepharm AG B / SL / SG
  FI      Levetiracetam Helvepharm
1000mg  Filmtabletten 1000 mg 30 Tablette(n)  39.46 61.70 10% Levetiracetamum Helvepharm AG B / SL / SG
  FI      Levetiracetam Helvepharm
1000mg  Filmtabletten 1000 mg 100 Tablette(n) 125.93  160.95  10% Levetiracetamum Helvepharm AG B / SL / SG
  FI      Levetiracetam Helvepharm
1000mg  Filmtabletten 1000 mg 200 Tablette(n) 246.97  299.90  10% Levetiracetamum Helvepharm AG B / SL / SG
  FI      Levetiracetam Sandoz 250 mg Filmtabletten 250 mg  30 Tablette(n)  11.87 25.95 10% Levetiracetamum Sandoz
Pharmaceuticals AG  B / SL / SG
  FI      Levetiracetam Sandoz 500 mg Filmtabletten 500 mg  20 Tablette(n)  13.83 28.20 10% Levetiracetamum Sandoz
Pharmaceuticals AG  B / SL / SG
  FI      Levetiracetam Sandoz 500 mg Filmtabletten 500 mg  100 Tablette(n) 63.53 89.35 10% Levetiracetamum Sandoz
Pharmaceuticals AG  B / SL / SG
  FI      Levetiracetam Sandoz 500 mg Filmtabletten 500 mg  200 Tablette(n) 125.36  160.30  10% Levetiracetamum Sandoz
Pharmaceuticals AG  B / SL / SG
  FI      Levetiracetam Sandoz 1000 mg  Filmtabletten 1000 mg 30 Tablette(n)  38.95 61.10 10% Levetiracetamum Sandoz
Pharmaceuticals AG  B / SL / SG
  FI      Levetiracetam Sandoz 1000 mg  Filmtabletten 1000 mg 100 Tablette(n) 124.32  159.10  10% Levetiracetamum Sandoz
Pharmaceuticals AG  B / SL / SG
  FI      Levetiracetam Sandoz 1000 mg  Filmtabletten 1000 mg 200 Tablette(n) 243.81  296.30  10% Levetiracetamum Sandoz
Pharmaceuticals AG  B / SL / SG
  FI      Levetiracetam Spirig HC 250 mg  Filmtabletten 250 mg  30 Tablette(n)  12.02 26.10 10% Levetiracetamum Spirig HealthCare AG  B / SL / SG
  FI      Levetiracetam Spirig HC 500 mg  Filmtabletten 500 mg  20 Tablette(n)  14.00 28.35 10% Levetiracetamum Spirig HealthCare AG  B / SL / SG
  FI      Levetiracetam Spirig HC 500 mg  Filmtabletten 500 mg  100 Tablette(n) 64.35 90.25 10% Levetiracetamum Spirig HealthCare AG  B / SL / SG
  FI      Levetiracetam Spirig HC 500 mg  Filmtabletten 500 mg  200 Tablette(n) 126.99  162.20  10% Levetiracetamum Spirig HealthCare AG  B / SL / SG
  FI      Levetiracetam Spirig HC
1000 mg Filmtabletten 1000 mg 30 Tablette(n)  39.46 61.70 10% Levetiracetamum Spirig HealthCare AG  B / SL / SG
  FI      Levetiracetam Spirig HC
1000 mg Filmtabletten 1000 mg 100 Tablette(n) 125.93  160.95  10% Levetiracetamum Spirig HealthCare AG  B / SL / SG
  FI      Levetiracetam Spirig HC
1000 mg Filmtabletten 1000 mg 200 Tablette(n) 246.97  299.90  10% Levetiracetamum Spirig HealthCare AG  B / SL / SG
  FI      Levetiracetam Spirig HC 100
mg/mL Lösung  100 mg/ml 300 ml  k.A.  k.A.  k.A.  Levetiracetamum Spirig HealthCare AG  B
  FI      Levetiracetam-Mepha 100
mg/mL Lösung  100 mg/ml 300 ml  46.05 69.25 10% Levetiracetamum Mepha Pharma AG B / SL / SG
  FI      Levetiracetam-Mepha Teva 250 mg Filmtabletten 250 mg  30 Tablette(n)  12.02 26.10 10% Levetiracetamum Mepha Pharma AG B / SL / SG
  FI      Levetiracetam-Mepha Teva 500 mg Filmtabletten 500 mg  20 Tablette(n)  14.00 28.40 10% Levetiracetamum Mepha Pharma AG B / SL / SG
  FI      Levetiracetam-Mepha Teva 500 mg Filmtabletten 500 mg  100 Tablette(n) 64.35 90.30 10% Levetiracetamum Mepha Pharma AG B / SL / SG
  FI      Levetiracetam-Mepha Teva 500 mg Filmtabletten 500 mg  200 Tablette(n) 126.99  162.20  10% Levetiracetamum Mepha Pharma AG B / SL / SG
  FI      Levetiracetam-Mepha Teva 750 mg Filmtabletten 750 mg  30 Tablette(n)  k.A.  k.A.  k.A.  Levetiracetamum Mepha Pharma AG B
  FI      Levetiracetam-Mepha Teva 750 mg Filmtabletten 750 mg  100 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum Mepha Pharma AG B
  FI      Levetiracetam-Mepha Teva 750 mg Filmtabletten 750 mg  200 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum Mepha Pharma AG B
  FI      Levetiracetam-Mepha Teva
1000 mg Filmtabletten 1000 mg 30 Tablette(n)  39.46 61.70 10% Levetiracetamum Mepha Pharma AG B / SL / SG
  FI      Levetiracetam-Mepha Teva
1000 mg Filmtabletten 1000 mg 100 Tablette(n) 125.93  160.95  10% Levetiracetamum Mepha Pharma AG B / SL / SG
  FI      Levetiracetam-Mepha Teva
1000 mg Filmtabletten 1000 mg 200 Tablette(n) 246.97  299.90  10% Levetiracetamum Mepha Pharma AG B / SL / SG
  FI      Keppra 500 mg/5 mL  Infusionskonzentrat 500mg / 5ml 10 Durchstechflasche(n) k.A.  k.A.  k.A.  Levetiracetamum UCB-Pharma SA B
L FI      Keppra 100 mg/mL  Lösung (oral) 100 mg/ml 150 ml  43.55 66.40 10% Levetiracetamum UCB-Pharma SA B / SL
L FI      Keppra 100 mg/mL  Lösung (oral) 100 mg/ml 150 ml  43.55 66.40 10% Levetiracetamum UCB-Pharma SA B / SL
  FI      Levetiracetam DRAC 250 mg Filmtabletten 250 mg  30 Tablette(n)  k.A.  k.A.  k.A.  Levetiracetamum DRAC AG B
  FI      Levetiracetam DRAC 500 mg Filmtabletten 500 mg  20 Tablette(n)  k.A.  k.A.  k.A.  Levetiracetamum DRAC AG B
  FI      Levetiracetam DRAC 500 mg Filmtabletten 500 mg  100 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum DRAC AG B
  FI      Levetiracetam DRAC 500 mg Filmtabletten 500 mg  200 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum DRAC AG B
  FI      Levetiracetam DRAC 1000 mg  Filmtabletten 1000 mg 30 Tablette(n)  k.A.  k.A.  k.A.  Levetiracetamum DRAC AG B
  FI      Levetiracetam DRAC 1000 mg  Filmtabletten 1000 mg 100 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum DRAC AG B
  FI      Levetiracetam DRAC 1000 mg  Filmtabletten 1000 mg 200 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum DRAC AG B
  FI      Levetiracetam Desitin 500
mg/5 mL Infusionskonzentrat 500mg / 5ml 10 Durchstechflasche(n) k.A.  k.A.  k.A.  Levetiracetamum Desitin Pharma GmbH B
  FI      Levetiracetam Desitin 500
mg/5 mL ‐ F Infusionskonzentrat 500mg / 5ml 10 Durchstechflasche(n) k.A.  k.A.  k.A.  Levetiracetamum Desitin Pharma GmbH B / SG
  FI      Levetiracetam Desitin 250 mg  Minipacks mit Mini-Filmtabletten  250 mg  30 Tablette(n)  13.49 27.80 10% Levetiracetamum Desitin Pharma GmbH B / SL
  FI      Levetiracetam Desitin 500 mg  Minipacks mit Mini-Filmtabletten  500 mg  20 Tablette(n)  13.73 28.05 10% Levetiracetamum Desitin Pharma GmbH B / SL
  FI      Levetiracetam Desitin 500 mg  Minipacks mit Mini-Filmtabletten  500 mg  100 Tablette(n) 71.19 98.15 10% Levetiracetamum Desitin Pharma GmbH B / SL
  FI      Levetiracetam Desitin 500 mg  Minipacks mit Mini-Filmtabletten  500 mg  200 Tablette(n) 138.76  175.70  10% Levetiracetamum Desitin Pharma GmbH B / SL
  FI      Levetiracetam Desitin
1000 mg Minipacks mit Mini-Filmtabletten  1000 mg 30 Tablette(n)  44.89 67.95 10% Levetiracetamum Desitin Pharma GmbH B / SL
  FI      Levetiracetam Desitin
1000 mg Minipacks mit Mini-Filmtabletten  1000 mg 100 Tablette(n) 137.58  174.35  10% Levetiracetamum Desitin Pharma GmbH B / SL
  FI      Levetiracetam Desitin
1000 mg Minipacks mit Mini-Filmtabletten  1000 mg 200 Tablette(n) 265.89  321.65  10% Levetiracetamum Desitin Pharma GmbH B / SL
  FI      Levetiracetam Sandoz 500
mg/5 mL Infusionskonzentrat 500mg / 5ml 10 Durchstechflasche(n) k.A.  k.A.  k.A.  Levetiracetamum Sandoz
Pharmaceuticals AG  B
  FI      Levetiracetam Spirig HC 500
mg/5 mL Infusionskonzentrat 500mg / 5ml 10 Durchstechflasche(n) k.A.  k.A.  k.A.  Levetiracetamum Spirig HealthCare AG  B
  FI      Levetiracetam-Mepha 500
mg/5 mL Infusionskonzentrat 500mg / 5ml 10 Durchstechflasche(n) k.A.  k.A.  k.A.  Levetiracetamum Mepha Pharma AG B
  FI      Levetiracetam-Mepha 500
mg/5 mL Infusionskonzentrat 500mg / 5ml Durchstechflasche(n)  k.A.  k.A.  k.A.  Levetiracetamum Mepha Pharma AG B
  FI      Rivoleve 250  Filmtabletten 250 mg  30 Tablette(n)  k.A.  k.A.  k.A.  Levetiracetamum Rivopharm SA  B
  FI      Rivoleve 500  Filmtabletten 500 mg  20 Tablette(n)  k.A.  k.A.  k.A.  Levetiracetamum Rivopharm SA  B
  FI      Rivoleve 500  Filmtabletten 500 mg  100 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum Rivopharm SA  B
  FI      Rivoleve 500  Filmtabletten 500 mg  200 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum Rivopharm SA  B
  FI      Rivoleve 1000 Filmtabletten 1000 mg 30 Tablette(n)  k.A.  k.A.  k.A.  Levetiracetamum Rivopharm SA  B
  FI      Rivoleve 1000 Filmtabletten 1000 mg 100 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum Rivopharm SA  B
  FI      Rivoleve 1000 Filmtabletten 1000 mg 200 Tablette(n) k.A.  k.A.  k.A.  Levetiracetamum Rivopharm SA  B
Legende einblenden

The sort order might be wrong if the generic_type is not correct. Checking via bin/admin for Levetiracetam Desitin 250 mg Minipacks mit Mini-Filmtabletten EAN 7680620690091. bin/admin gives 

ch.oddb> registration('62069').packages.first.generic_type
-> unknown
ch.oddb> registration('62069').packages.first.sl_generic_type.class
-> NilClass
ch.oddb> registration('62069').packages.last.sl_generic_type.class
-> NilClass
ch.oddb> registration('62069').packages.last.generic_type
-> unknown

Conclusion: Sort order is correct, but sl_generic_type for registration('62069') is not correct. Must look at the bsv-XML-import, which reads Preparations.xml from XMLPublications-latest.zip. There we find for 

  <Preparation ProductCommercial="26257">
    <NameDe>Levetiracetam DESITIN</NameDe>
    <NameFr>Levetiracetam DESITIN</NameFr>
    <NameIt>Levetiracetam DESITIN</NameIt>
    <DescriptionDe>Minipacks mit Mini-Filmtabl 250 mg </DescriptionDe>
    <DescriptionFr>minipacks avec cpr pell mini 250 mg </DescriptionFr>
    <DescriptionIt>minipacks con cpr riv mini 250 mg </DescriptionIt>
    <AtcCode>N03AX14</AtcCode>
    <SwissmedicNo5>62069</SwissmedicNo5>
    <FlagItLimitation>Y</FlagItLimitation>
    <OrgGenCode />
    <FlagSB20>N</FlagSB20>
    <CommentDe />
    <CommentFr />
    <CommentIt />
    <VatInEXF>N</VatInEXF>
    <Packs>
      <Pack ProductKey="26257" PackId="32894">
        <DescriptionDe>30 Stk</DescriptionDe>
<..>

The element OrgGenCode is not set. Therefore it gets the weight 20 and is places last.

This is only one many products. As seen via 

grep -c "<OrgGenCode />" Preparations.xml 
3191

For IKSNR 61651 I find the following packs in Preparations.xml 

  grep 768061651 Preparations.xml 
        <GTIN>7680616510013</GTIN>
        <GTIN>7680616510020</GTIN>
        <GTIN>7680616510037</GTIN>
        <GTIN>7680616510150</GTIN>
        <GTIN>7680616510051</GTIN>
        <GTIN>7680616510068</GTIN>
        <GTIN>7680616510167</GTIN>

Whereas in bin/admin I find 14 packages, e.g. 

ch.oddb> registration('61651').packages.collect{ |x| x.barcode }[0..7]
-> ["7680616510013", "7680616510082", "7680616510020", "7680616510037", "7680616510044", "7680616510099", "7680616510105", "7680616510150"]
ch.oddb> registration('61651').packages.collect{ |x| x.barcode }[8..14]
-> ["7680616510051", "7680616510068", "7680616510075", "7680616510129", "7680616510136", "7680616510167"]
ch.oddb> registration('61651').packages.collect{ |x| x.barcode unless x.out_of_trade }.compact
-> ["7680616510013", "7680616510020", "7680616510037", "7680616510150", "7680616510051", "7680616510068", "7680616510167"]
ch.oddb> registration('61651').packages.collect{ |x| x.barcode if x.out_of_trade }.compact
-> ["7680616510082", "7680616510044", "7680616510099", "7680616510105", "7680616510075", "7680616510129", "7680616510136"]

Ignoring the out_of_trade packages I get the same results as in Preparations. Conclusion: The search-result includes out-of-trade packages. Probably not what we intended?

Okay. It looks like if my commit to exclude the digits from the search sometimes was wrong and resulted in a way too short name. Therefore substituted gsub(/\d.*/, ) by gsub(/\S+\s+\d+/, ) and improved the unit tests.

Collecting all different combinations of out_of_trace, generic_type and sl_generic_type via bin/admin gives 

$xx = {}; active_packages.each {|item| $xx["out_of_trade #{item.out_of_trade.inspect} generic_type #{item.generic_type.inspect} sl_generic_type #{item.sl_generic_type.inspect}"] = item.barcode};
aus = File.open('ausgabe.txt', 'w+') { |f| $xx.each{|item,value| f.puts "#{item.inspect}. Example #{value}"} }
creates file ausgabe.txt. Looking at cat ausgabe.txt | sort gives 
"out_of_trade false generic_type :generic sl_generic_type :generic". Example 7680655530096
"out_of_trade false generic_type :generic sl_generic_type nil". Example 7680651880027
"out_of_trade false generic_type :original sl_generic_type :original". Example 7680625700146
"out_of_trade false generic_type :original sl_generic_type nil". Example 7680632000130
"out_of_trade false generic_type :unknown sl_generic_type :original". Example 7680574890066
"out_of_trade false generic_type :unknown sl_generic_type nil". Example 7680653310010
"out_of_trade false generic_type nil sl_generic_type :generic". Example 7680626160017
"out_of_trade false generic_type nil sl_generic_type nil". Example 7680656280013
"out_of_trade nil generic_type :generic sl_generic_type :generic". Example 7680656450041
"out_of_trade nil generic_type :generic sl_generic_type nil". Example 7680650500049
"out_of_trade nil generic_type :original sl_generic_type :original". Example 7680560750527
"out_of_trade nil generic_type :original sl_generic_type nil". Example 7680570620063
"out_of_trade nil generic_type :unknown sl_generic_type nil". Example 7680652020026
"out_of_trade nil generic_type nil sl_generic_type nil". Example 7680655760028
"out_of_trade true generic_type :generic sl_generic_type :generic". Example 7680655530102
"out_of_trade true generic_type :generic sl_generic_type nil". Example 7680653080043
"out_of_trade true generic_type :original sl_generic_type :original". Example 7680550900017
"out_of_trade true generic_type :original sl_generic_type nil". Example 7680625700160
"out_of_trade true generic_type :unknown sl_generic_type nil". Example 7680651050062
"out_of_trade true generic_type nil sl_generic_type nil". Example 7680656080019

This mean that I also have to create (at least) 20 different test drugs to ensure correct working.

But the displayed page still has inconsitencies between what I see in the database and what is displayed, eg. Levetiracetam Spirig HC 500 mg ean13/7680614990114 has it's company name displayed in blue even when it's out_of_trade status is true.

Currently my patch looks like Attach:fix_sort_order_desitin.txt.

oddb2xml: Use parslet to split column_C of packages into preparation_name and galenic_form

view · edit · sidebar · attach · print · history
Page last modified on May 11, 2015, at 05:19 PM