This Report was generated by: cpp2sqlite

• cpp2sqlite
• --verbose
• --lang=fr
• --inDir
• /home/zeno/.software/cpp2sqlite/scripts/../input

File Analysis

swisspeddose.ch

/home/zeno/.software/cpp2sqlite/scripts/../input/../downloads/swisspeddosepublication.xml

Cases 212

• <CaseID> set: 212
• <ATCCode> set: 64
• <ROACode> set: 10

Indications 192

• <IndicationKey> map: 192

Dosages 300

• <CaseId> set: 212
• vec: 300

Codes 5269

• _ALTERRELATION: 5
• _FG: 2
• _GEWICHT: 2
• ATC: 5059
• DOSISTYP: 74
• DOSISUNIT: 30
• EVIDENZ: 6
• ROA: 77
• ZEIT: 14

Swissmedic

/home/zeno/.software/cpp2sqlite/scripts/../input/../downloads/swissmedic_packages.xlsx

• rows: 17314

ATC Codes

/home/zeno/.software/cpp2sqlite/scripts/../input/atc_codes_multi_lingual.txt

• # lines: 2632

AIPS

/home/zeno/.software/cpp2sqlite/scripts/../input/../downloads/aips.xml

• medicalInformation fi fr 4318

ATC codes 4318

• from aips: 4265
• from swissmedic: 41
• no ATC code in atc_columns: 12

ATC code text

• from aips: 4282
• from peddose: 24
• no text found: 0

rgnrs that contained duplicates

• 26396,26395
• 54320,53898,37397

Swissmedic has 15509 matching packages

RefData

/home/zeno/.software/cpp2sqlite/scripts/../input/../downloads/refdata_pharma.xml

• PHARMA items: 52474
• PHARMA items with GTIN starting with "7680": 14731
• articles: 52476

BAG

/home/zeno/.software/cpp2sqlite/scripts/../input/../downloads/bag_preparations.xml

• preparations: 6008
• packs: 9358
• packs without GTIN: 304
• GTIN recovered from <SwissmedicNo8>: 300
• GTIN unrecoverable from <SwissmedicNo8>: 4

<SwissmedicNo8> empty

1. <NameFr> Morphinium HCl, <DescriptionFr> sol inj 10 mg
2. <NameFr> Morphinium HCl, <DescriptionFr> sol inj 10 mg
3. <NameFr> Morphinium HCl, <DescriptionFr> sol inj 20 mg
4. <NameFr> Morphinium HCl, <DescriptionFr> sol inj 20 mg

Cross-reference

• 8895 GTIN are also in swissmedic
• 8975 GTIN are also in refdata

Usage

aips REGNRS (found/not found)

• in refdata: 4631/679 (5310)
• in swissmedic: 1367/3943 (5310)
• in bag: 59/5251 (5310)
• not found anywhere: 50

XML

title_str separator ';' was replaced for rgnrs

• 31514 "Posologie / Mode d’emploiDose initialeAdultes: 250 mg (4 mg/kg de poids corporel) par injection i.v. lente en bolus; enfants: 4 à 8 mg/kg de poids corporel par injection i.v. lente. La première application doit être faite le plus tôt possible."
• 39255 "Effets indésirablesLes indications suivantes sont utilisées pour classifier les données de fréquence des effets indésirables: «très fréquents» (≥1/10), «fréquents» (<1/10, ≥1/100), «occasionnels» (<1/100, ≥1/1000), «rares» (<1/1000, ≥1/10 000), «très rares» (<1/10 000)."
• 50655,47920 "Ecomucyl® Sandoz comprimés effervescents; Ecomucyl® Sandoz granulés"
• 51075,51076 "Folinate de calcium Sandoz®eco, solution injectable; Folinate de calcium Sandoz®, capsules"
• 52787,52788 "Trabar 50; Trabar 100"
• 53985,55622 "ACC Sandoz® comprimés effervescents; ACC Sandoz® granulés"
• 54842 "CoAprovel® 150/12,5; 300/12,5; 300/25"
• 57381 "Co-Ramipril Sandoz® 2,5/12,5; 5/25"
• 61404 "Docétaxel Sandoz®20 mg/2 ml; Docétaxel Sandoz®80 mg/8 ml"
• 61492 "Co-Candésartan Sandoz® 8/12,5; 16/12,5; 32/12,5; 32/25"
• 62728,62730 "Diclo-Acino 25/50, comprimés pelliculés; Diclo-Acino 100 retard, capsules à libération prolongée"
• 62848,62849,62850,62851,62852 "CoAmox-Acino 375/625/1000, comprimés pelliculés; CoAmox-Acino 625/1000 Dispersible, comprimés dispersibles"
• 62980,62981 "Clindamycin [Phosphat]-Mepha i.v./i.m., solution pour injection; Clindamycin-Mepha, capsules"

XML

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

• 46489,65479
• 47408
• 52509
• 52599,52273
• 54785,65474
• 55955
• 56688
• 56828
• 58157
• 58182,59376,59377
• 58734
• 60687,60688,62806
• 61384
• 62332
• 63123
• 63237
• 65080
• 65175
• 65267
• 65561
• 66611
• 67019

RefData

• GTINs used: 12915

Swissmedic

• GTINs used: 3412
• recovered dosage 997

BAG

• GTINs used: 132

ATC Codes

• 5 missing branches from /home/zeno/.software/cpp2sqlite/scripts/../input/atc_codes_multi_lingual.txt

swisspeddose.ch

• ATC with <Case>: 391
• ATC without <Case>: 3927
• tables created: 1602

Fri Mar 1 19:24:34 2019