This Report was generated by: cpp2sqlite

• ./cpp2sqlite
• --verbose
• --inDir
• ../input

File Analysis

swisspeddose.ch

../input/../downloads/swisspeddosepublication.xml

Cases 243

• <CaseID> set: 243
• <ATCCode> set: 72
• <ROACode> set: 10

Indications 136

• <IndicationKey> map: 136

Dosages 364

• <CaseId> set: 243
• vec: 364

Codes 5353

• _ALTERRELATION: 7
• _FG: 2
• _GEWICHT: 2
• ATC: 5138
• DOSISTYP: 76
• DOSISUNIT: 31
• EVIDENZ: 6
• ROA: 77
• ZEIT: 14

Swissmedic

../input/../downloads/swissmedic_packages.xlsx

• rows: 17360

ATC Codes

../input/atc_codes_multi_lingual.txt

• # lines: 2635

AIPS

../input/../downloads/aips.xml

• medicalInformation fi de 4328

ATC codes 4328

• from aips: 4272
• from swissmedic: 43
• unique (from both aips and swissmedic): 1694

Titles with empty or invalid ATC code: 13

• RN: <66566> , title: <Alofisel>
• RN: <58943> , title: <Apligraf>
• RN: <00000> , title: <BCG VACCINE SSI>
• RN: <00000> , title: <DIGIFAB® DIGOXIN IMMUNE FAB (OVINE)>
• RN: <00000> , title: <Erythrozytenkonzentrat (EK) leukozytendepletiert, in additiver Lösung>
• RN: <00000> , title: <FACTOR X P BEHRING>
• RN: <66778> , title: <KYMRIAH®>
• RN: <00000> , title: <Plasma (frisch gefroren), leukozytendepletiert, pathogeninaktiviert (INTERCEPT®)>
• RN: <00000> , title: <Plasma (frisch gefroren), leukozytendepletiert, quarantänegelagert (FGPq)>
• RN: <00000> , title: <SUCCICAPTAL 200 mg, Hartkapseln>
• RN: <00000> , title: <Thrombozytenkonzentrat, leukozytendepletiert und pathogeninaktiviert (Intercept®)>
• RN: <66986> , title: <YESCARTA®>
• RN: <63051> , title: <Zeel comp.>

ATC code text

• from aips: 4306
• from peddose: 9
• no text found: 0

rgnrs that contained duplicates

• 26396,26395
• 54320,53898,37397

titles with rn 00000 (ignored)

• BCG VACCINE SSI
• DIGIFAB® DIGOXIN IMMUNE FAB (OVINE)
• Erythrozytenkonzentrat (EK) leukozytendepletiert, in additiver Lösung
• FACTOR X P BEHRING
• Plasma (frisch gefroren), leukozytendepletiert, pathogeninaktiviert (INTERCEPT®)
• Plasma (frisch gefroren), leukozytendepletiert, quarantänegelagert (FGPq)
• SUCCICAPTAL 200 mg, Hartkapseln
• Thrombozytenkonzentrat, leukozytendepletiert und pathogeninaktiviert (Intercept®)

Swissmedic has 15553 matching packages

RefData

../input/../downloads/refdata_pharma.xml

• PHARMA items: 53043
• PHARMA items with GTIN starting with "7680": 14822
• articles: 53045

BAG

../input/../downloads/bag_preparations.xml

• preparations: 6010
• packs: 9349
• packs without GTIN: 256
• GTIN recovered from <SwissmedicNo8>: 252
• GTIN unrecoverable from <SwissmedicNo8>: 4

<SwissmedicNo8> empty

1. <NameDe> Morphinium HCl, <DescriptionDe> Inj Lös 10 mg
2. <NameDe> Morphinium HCl, <DescriptionDe> Inj Lös 10 mg
3. <NameDe> Morphinium HCl, <DescriptionDe> Inj Lös 20 mg
4. <NameDe> Morphinium HCl, <DescriptionDe> Inj Lös 20 mg

Cross-reference

• 8907 GTIN are also in swissmedic
• 9004 GTIN are also in refdata

Sappinfo (filtered)

../input/sappinfo.xlsx

• Unique ATC set: 218
• rows Breast Feeding: 171
• rows Pregnancy: 283

Usage

aips REGNRS (found/not found)

• in refdata: 4652/665 (5317)
• in swissmedic: 1342/3975 (5317)
• in bag: 52/5265 (5317)
• not found anywhere: 58

XML

title_str separator ';' was replaced for rgnrs

• 50655,47920 "Ecomucyl® Sandoz Brausetabletten; Ecomucyl® Sandoz Granulat"
• 51075,51076 "Calciumfolinat Sandoz® eco, Injektionslösung; Calciumfolinat Sandoz®, Kapseln"
• 52787,52788 "Trabar 50; Trabar 100"
• 53985,55622 "ACC Sandoz® Brausetabletten; ACC Sandoz® Granulat"
• 54842 "CoAprovel® 150/12,5; 300/12,5; 300/25"
• 57381 "Co-Ramipril Sandoz® 2,5/12,5; 5/25"
• 61404 "Docetaxel Sandoz®20 mg/2 ml; Docetaxel Sandoz®80 mg/8 ml"
• 62728,62730 "Diclo-Acino 25/50, Filmtabletten; Diclo-Acino 100 retard, Retardkapseln"
• 62848,62849,62850,62851,62852 "CoAmox-Acino 375/625/1000, Filmtabletten; CoAmox-Acino 625/1000 Dispersible, dispergierbare Tabletten"
• 62980,62981 "Clindamycin [phosphat]-Mepha i.v./i.m., Injektionslösung; Clindamycin-Mepha, Kapseln"

XML

For these rgnrs, <img> has no "alt" attribute

• 44521
• 46489,65479
• 47408
• 52509
• 54785,65474
• 56202
• 56688
• 57289
• 58157
• 58182,59376,59377
• 58618
• 58734
• 61384
• 62332
• 62442
• 65080
• 65561
• 66110
• 67019

RefData

• GTINs used: 13061

Swissmedic

• GTINs used: 3239
• recovered dosage 976

BAG

• GTINs used: 96

ATC Codes

• 4 missing branches from ../input/atc_codes_multi_lingual.txt

swisspeddose.ch

• ATC with <Case>: 429
• ATC without <Case>: 3886
• tables created: 1823

Sappinfo

Unique ATC

• breastFeed: 144
• pregnancy: 196

Tables created

• breastFeed: 896
• pregnancy: 1361

Sat May 25 02:10:04 2019