<< | Index | >>

20131209-oddb2xml-use-ean-if-no-pharmacode

Summary

• If a product has no pharmacode but an EAN use it to fetch flags/price

Commits

• https://github.com/ngiger/oddb2xml/commit/ebce12bccfe3a21e04ab3a28189550050398aa3a Read article with no pharmacode from BAG.xml Preparation.xml
• https://github.com/ngiger/oddb2xml/commit/fa112150942cd37ead48d8674cc59c3668b28ab1 Added skip-download for debugging
• https://github.com/ngiger/oddb2xml/commit/e7bcc069a66e4cdbe68824af189b2ad2fc2dca50 Fix running specs

Index

• If a product has no pharmacode but an EAN use it to fetch flags/price

---

If a product has no pharmacode but an EAN use it to fetch flags/price.

Eg. "Levetiracetam Desitin" has no more Pharmacode in the SL. In the produced XML we miss price and to which list it belongs. These data can be found in the SL via EAN (aka GTIN).

In the downloaded XMLPublications.zip (as of November 29) we have the file Publications.xls which contains the following item (The pharmacode is missing)

Desitin Pharma GmbH			19417	62069008	B	01.05.2011	Levetiracetam DESITIN, Filmtabl 250 mg, 30 Stk	13.49	27.8			01.07.10.	Levetiracetamum	32894	N

It should have a pharmacode of ??.

After running undle exec bin/oddb2xml -a nonpharma -p zurrose I find in oddb_article.xml the following entries

  <ART DT="">
    <PHAR>0000000</PHAR>
    <SMCAT>B</SMCAT>
    <SMNO>62616002</SMNO>
    <PRODNO>626161</PRODNO>
    <SALECD>A</SALECD>
    <CDBG>N</CDBG>
    <BG>N</BG>
    <QTY>10 Ampullen 5 ml</QTY>
    <DSCRD>LEVETIRACETAM DESITIN 500 mg/5ml</DSCRD>
    <DSCRF>LEVETIRACETAM DESITIN 500 mg/5ml</DSCRF>
    <SORTD>LEVETIRACETAM DESITIN 500 MG/5ML</SORTD>
    <SORTF>LEVETIRACETAM DESITIN 500 MG/5ML</SORTF>
    <ARTCOMP>
      <COMPNO>7601001320451</COMPNO>
    </ARTCOMP>
    <ARTBAR>
      <CDTYP>E13</CDTYP>
      <BC>7680626160024</BC>
      <BCSTAT>A</BCSTAT>
    </ARTBAR>
  </ART>
<..>
  <ART DT="">
    <PHAR>5819012</PHAR>
    <SMCAT>B</SMCAT>
    <SMNO>62069008</SMNO>
    <PRODNO>620691</PRODNO>
    <VAT>2</VAT>
    <SALECD>A</SALECD>
    <CDBG>N</CDBG>
    <BG>N</BG>
    <QTY>30 Stk</QTY>
    <DSCRD>LEVETIRACETAM DESITIN Filmtabl 250 mg</DSCRD>
    <DSCRF>LEVETIRACETAM DESITIN cpr pell 250 mg</DSCRF>
    <SORTD>LEVETIRACETAM DESITIN FILMTABL 250 MG</SORTD>
    <SORTF>LEVETIRACETAM DESITIN CPR PELL 250 MG</SORTF>
    <ARTCOMP>
      <COMPNO>7601001320451</COMPNO>
    </ARTCOMP>
    <ARTBAR>
      <CDTYP>E13</CDTYP>
      <BC>7680620690084</BC>
      <BCSTAT>A</BCSTAT>
    </ARTBAR>
    <ARTPRI>
      <VDAT>09.12.2013</VDAT>
      <PTYP>ZURROSE</PTYP>
      <PRICE>15.33</PRICE>
    </ARTPRI>
    <ARTPRI>
      <VDAT>09.12.2013</VDAT>
      <PTYP>ZURROSEPUB</PTYP>
      <PRICE>27.80</PRICE>
    </ARTPRI>
  </ART>

In Preparations.xml we find a GTIN 7680620690084 / 7680618480024 for Levetiracetam DESITIN. Looked via grep to see how many time we have a missing Pharmacode grep -c Pharmacode data/20131209/Preparations.xml returns 9311. grep -cw "<Pack" data/20131209/Preparations.xml returns 9567. Therefore we have 9567-9311=256 missing Pharmacodes. But we have also grep -cw GTIN data/20131209/Preparations.xml 9567 EAN (aka GTIN) entries. But grep -c "<GTIN />" data/20131209/Preparations.xml show that we have 531 packages without a GTIN

Created a spec for Oddb2xml::BagXmlExtractor and have now a cool way to test! Pushed commit Read article with no pharmacode from BAG.xml Preparation.xml. But this commit is not enough to add the prices of items without a pharmacode to the created oddb_article.xml.

Pushed commit Added skip-download for debugging

Took some time to fix travis-ci with this commit Fix running specs

Almost finished adding a spec for running oddb2xml and testing the generated output.