This Report was generated by: cpp2sqlite

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

File Analysis

swisspeddose.ch

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

Cases 770

<CaseID> set: 769
<ATCCode> set: 270
<ROACode> set: 14

Indications 386

<IndicationKey> map: 386

Dosages 1436

<CaseId> set: 769
vec: 1436

Codes 6168

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

Swissmedic

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

rows: 17823

ATC Codes

../input/atc_codes_multi_lingual.txt

# lines: 2635

Drugshortage

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

GTINs : 715
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: 200
Without Zulassungsnummer: 15

DHPC HPC

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

Count: 18
Without Zulassungsnummer: 28

AIPS

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

medicalInformation fi fr 4549

ATC codes 0

from aips: 0
from swissmedic: 0
unique (from both aips and swissmedic): 0

ATC code text

from aips: 0
from peddose: 0
no text found: 0

Missing html files

Regnrs: 56539 html: 7452fa6ab6a04698b5411ea837d57f97-fr.html
Regnrs: 29080 html: be82a9bfde43416c9e17a122bff8988a-fr.html
Regnrs: 49621 html: 07a778ddf1be4a2eb5de908e93c84986-fr.html
Regnrs: 15322 html: 09295ff68ade441796d9052e9a325d55-fr.html
Regnrs: 52489 html: 61a856a9b7934f2a859eb62a5142e5e7-fr.html

Swissmedic has 15994 matching packages

RefData

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

PHARMA items: 16035
PHARMA items with GTIN starting with "7680": 14514
articles: 16035

BAG

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

preparations: 6576
packs: 10225
packs without GTIN: 63
GTIN recovered from <SwissmedicNo8>: 59
GTIN unrecoverable from <SwissmedicNo8>: 4

<SwissmedicNo8> empty

<NameFr> Morphinium HCl, <DescriptionFr> sol inj 10 mg
<NameFr> Morphinium HCl, <DescriptionFr> sol inj 10 mg
<NameFr> Morphinium HCl, <DescriptionFr> sol inj 20 mg
<NameFr> Morphinium HCl, <DescriptionFr> sol inj 20 mg

Cross-reference

9948 GTIN are also in swissmedic
9892 GTIN are also in refdata

Swissreg

../input/swissreg.json

Count: 0

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: 76

68326, 68286, 65940, 60727, 42127, 67451, 66214, 66078, 68147, 22672, 68922, 68182, 55381, 12730, 68478, 65210, 50490, 68400, 68359, 67792, 68596, 38174, 01677, 46003, 68579, 47915, 38824, 44676, 03579, 20406, 67197, 39828, 10286, 58034, 67022, 67819, 67557, 30984, 67063, 56929, 59210, 48299, 66236, 66237, 49034, 17664, 65840, 66642, 66708, 67095, 67158, 54032, 54033, 26339, 42134, 24024, 54089, 65120, 65161, 54173, 61560, 61561, 61562, 61564, 61566, 57755, 41547, 56545, 56212, 52537, 47110, 45699, 46871, 48147, 43667, 37687

in refdata: 0/0 (0)

in swissmedic: 0/0 (0)

in bag: 0/0 (0)

not found anywhere: 76

ATC not found: 62

68326, 68286, 65940, 42127, 67451, 66214, 66078, 68147, 22672, 68922, 68182, 55381, 12730, 68478, 65210, 50490, 68400, 68359, 67792, 68596, 38174, 68579, 47915, 44676, 67197, 39828, 10286, 58034, 67022, 67819, 67557, 30984, 67063, 56929, 59210, 48299, 66236, 66237, 65237, 49034, 17664, 65840, 66642, 66708, 67095, 67158, 58943, 54032, 54033, 26339, 42134, 24024, 54089, 62038, 65120, 65161, 54173, 18346, 57755, 41547, 56545, 56212, 52537, 47110, 45699, 46871, 48147, 37687

RefData

GTINs used: 13231

Swissmedic

GTINs used: 2923
recovered dosage 712

BAG

GTINs used: 156

ATC Codes

71 missing branches from ../input/atc_codes_multi_lingual.txt

A01, A03AD, A05AX, A08AA, B05CB, B06AX, C02DD, C02KN, D08AE, D09, D09A, D09AA, G03XX, H02C, H02CA, J05AJ, J06BC, J06BD, J07BN, L01CE, L01E, L01EA, L01EB, L01EC, L01ED, L01EE, L01EF, L01EG, L01EH, L01EJ, L01EK, L01EL, L01EM, L01EN, L01EX, L01F, L01FA, L01FB, L01FC, L01FD, L01FE, L01FF, L01FG, L01FX, L01FY, L01XF, L01XG, L01XH, L01XJ, L01XK, L01XL, L01XM, L01XY, L04AE, L04AF, L04AG, L04AH, L04AJ, L04AK, M03BA, M04AC, N02BF, N02CD, N05BX, N05CJ, P02CF, R07AB, V03AH, V06, V06D, V08CB

swisspeddose.ch

ATC with <Case>: 1106
ATC without <Case>: 3380
tables created: 3949

Sappinfo

Unique ATC

breastFeed: 144
pregnancy: 190

Tables created

breastFeed: 876
pregnancy: 1246

Wed Dec 10 04:09:09 2025