view · edit · sidebar · attach · print · history

20130208-update-oddb2xml-product

<< | Index | >>

Summary

  • Update oddb_product.xml
    • use (via SwissmedicNo8, SwismedicNo5) Packungen.xls (If product is not found in swissINDEX)
    • generate EAN-Code from Packungen.xls

Commits

oddb2xml

Index

Update product.xml with data from Packungen.xls

Update product.xml

Update (whole changed) oddb_product.xml Structure.

  1. . Base(Grundlage) is all INDEX from swissINDEX
  2. . add TEXT(DESC etc.) from Preparations.xml
  3. . marge CODES(EAN, ATC, IT-CODE) Packungen.xls 
swissINDEX (DE and FR, only EAN[0..3] == 7680)
  SwissmedicNo8 ---> Preparations.xml
    * DESC_DE, DESC_FR, GENCD, etc.
  EAN-CODE (if not found in swissINDEX) ---> Packungen.xls
    * EAN-Code, IT-Code, ATC-Code

This commit discards first XSD-Definiton Structure.

change
  • oddb_product.xml has only EAN-CODE (as GTIN) of Pharma product(7680xxxxxxxxx).
    • Base is swissINDEX
    • If entry of swissINDEX dose not have GTIN, then merge entry from Packungen.xls for EAN-Code, ATC-Code. (Connection-Key is SwissmedicNo8)
    • It takes only TEXT data from Preparations.xml (Connection-Key is Pharmacode.)
commit

Ref.

Update product.xml with data from Packungen.xls

Ref.

from Packungen.xls
    Abgabekategorie (column 'N')            # => (oddb_article.xml)
    ATC (if missing from swissINDEX)        
    Wirkstoff (column 'O')                  # => new "<SubstanceSwissmedic>"
    Packungsgrösse (column 'L')             # => new "<PackGrSwissmedic>"
    Einheit (column 'M')                    # => new "<EinheitSwissmedic>"
commit

(oddb_article.xml)

view · edit · sidebar · attach · print · history
Page last modified on February 08, 2013, at 07:47 PM