This Report was generated by: cpp2sqlite

• ./cpp2sqlite
• --verbose
• --lang=fr
• --inDir
• ../input

File Analysis

swisspeddose.ch

../input/../downloads/swisspeddosepublication_v4.xml

Cases 760

• <CaseID> set: 760
• <ATCCode> set: 265
• <ROACode> set: 14

Indications 381

• <IndicationKey> map: 381

Dosages 1410

• <CaseId> set: 760
• vec: 1410

Codes 5919

• _ALTERRELATION: 10
• _FG: 2
• _GEWICHT: 2
• ATC: 5683
• DOSISTYP: 86
• DOSISUNIT: 35
• EVIDENZ: 6
• ROA: 79
• ZEIT: 16

Swissmedic

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

• rows: 17903

ATC Codes

../input/atc_codes_multi_lingual.txt

• # lines: 2635

Drugshortage

../input/../downloads/drugshortage.json

• GTINs : 721
• Total vert(1): 0
• Total vert clair(2): 0
• Total orange(3): 0
• Total rouge(4): 0
• Total Jaune(5): 0

Batchrecalls

../input/../downloads/chargenrueckrufe_fr.json

• Count: 195
• Without Zulassungsnummer: 14

DHPC HPC

../input/../downloads/dhpc_hpc_fr.json

• Count: 18
• Without Zulassungsnummer: 28

Swissmedic has 0 matching packages

RefData

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

• PHARMA items: 14948
• PHARMA items with GTIN starting with "7680": 14079
• articles: 14948

BAG

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

• preparations: 6576
• packs: 10213
• packs without GTIN: 74
• GTIN recovered from <SwissmedicNo8>: 70
• 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

• 9957 GTIN are also in swissmedic
• 9870 GTIN are also in refdata

Sappinfo (filtered)

../input/sappinfo.xlsx

• Unique ATC set: 215
• rows Breast Feeding: 182
• rows Pregnancy: 282

Usage

aips REGNRS (found/not found)

• in refdata: 0/0 (0)
• in swissmedic: 0/0 (0)
• in bag: 0/0 (0)
• not found anywhere: 0

RefData

• GTINs used: 0

Swissmedic

• GTINs used: 0
• recovered dosage 0

BAG

• GTINs used: 0

ATC Codes

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

swisspeddose.ch

• ATC with <Case>: 0
• ATC without <Case>: 0
• tables created: 0

Sappinfo

Unique ATC

• breastFeed: 0
• pregnancy: 0

Tables created

• breastFeed: 0
• pregnancy: 0

Fri Aug 29 04:00:53 2025