This Report was generated by: cpp2sqlite

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

File Analysis

swisspeddose.ch

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

Cases 754

<CaseID> set: 754
<ATCCode> set: 262
<ROACode> set: 14

Indications 376

<IndicationKey> map: 376

Dosages 1397

<CaseId> set: 754
vec: 1397

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

ATC Codes

../input/atc_codes_multi_lingual.txt

# lines: 2635

Drugshortage

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

GTINs : 711
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: 186
Without Zulassungsnummer: 14

DHPC HPC

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

Count: 44
Without Zulassungsnummer: 76

AIPS

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

medicalInformation fi fr 4594

ATC codes 4594

from aips: 4544
from swissmedic: 36
unique (from both aips and swissmedic): 1802

Titles with empty or invalid ATC code: 14

RN: <58943> , title: <Apligraf>
RN: <55442> , title: <Ascosal® comprimés effervescents>
RN: <51390> , title: <Becetamol® Gouttes>
RN: <68297> , title: <Columvi®>
RN: <00000> , title: <Concentré érythrocytaire (CE) déplété en leucocytes, en solution additive>
RN: <00000> , title: <Concentré plaquettaire déplété en leucocytes, à pathogènes inactivés (Intercept®)>
RN: <00000> , title: <DIGIFAB®, Lyophilisat>
RN: <00000> , title: <FACTOR X P BEHRING>
RN: <68733> , title: <Jaypirca™>
RN: <12730> , title: <Méthergin®, solution injectable s.c., i.m., i.v.>
RN: <00000> , title: <Plasma (frais congelé), déplété en leucocytes, conservé en quarantaine (PFCq)>
RN: <00000> , title: <Plasma (frais congelé), déplété en leucocytes, soumis à l’inactivation des agents pathogènes (INTERC>
RN: <00000> , title: <SUCCICAPTAL 200 mg, Gélules>
RN: <67451> , title: <Tegsedi>

ATC code text

from aips: 4093
from peddose: 419
no text found: 68

titles with rn 00000 (ignored)

Concentré érythrocytaire (CE) déplété en leucocytes, en solution additive
Concentré plaquettaire déplété en leucocytes, à pathogènes inactivés (Intercept®)
DIGIFAB®, Lyophilisat
FACTOR X P BEHRING
Plasma (frais congelé), déplété en leucocytes, conservé en quarantaine (PFCq)
Plasma (frais congelé), déplété en leucocytes, soumis à l’inactivation des agents pathogènes (INTERC
SUCCICAPTAL 200 mg, Gélules

Swissmedic has 16093 matching packages

BAG

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

preparations: 6587
packs: 10216
packs without GTIN: 75
GTIN recovered from <SwissmedicNo8>: 71
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

9985 GTIN are also in swissmedic
0 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/5464 (5464)
in swissmedic: 5299/165 (5464)
in bag: 78/5386 (5464)
not found anywhere: 121

54802, 54803, 66078, 48299, 40467, 42127, 69514, 55179, 55442, 41547, 66996, 25022, 51390, 41717, 54824, 54173, 67063, 60372, 55114, 68978, 56545, 43319, 68297, 49259, 39828, 10286, 42134, 66236, 66237, 56422, 57191, 55381, 40841, 68147, 41569, 69241, 67022, 56929, 38174, 57933, 68182, 65179, 47956, 55508, 54904, 44676, 65331, 52489, 67792, 20406, 03579, 71204, 59795, 65161, 34088, 59210, 68733, 17664, 42185, 59093, 62840, 67546, 65120, 54089, 54032, 54033, 55461, 67197, 46871, 48147, 56264, 56264, 65150, 41341, 68478, 68335, 47915, 56212, 26339, 44778, 55494, 51741, 51742, 54974, 52537, 68579, 57659, 22672, 56469, 60489, 45699, 67819, 67557, 65840, 66642, 66708, 67095, 67158, 37687, 49034, 01677, 46003, 43667, 67451, 69161, 69481, 61560, 61561, 61562, 61564, 61566, 24024, 47110, 68400, 42441, 56198, 62955, 58034, 68531, 61260, 62439

XML

title_str separator ';' was replaced for rgnrs

22114, 25644 "Syntocinon®solution à diluer pour solution injectable/pour perfusion; Syntocinon® spray nasal, solution"
50655, 47920 "Ecomucyl® Sandoz comprimés effervescents; Ecomucyl® Sandoz granulés"
50710, 54157, 50709 "Zofran®, comprimés pelliculés; Zofran®, concentré pour perfusion/solution injectable; Zofran®, Zydis comprimés orodispersibles"
54842 "CoAprovel® 150/12,5; 300/12,5; 300/25"
58620, 58674 "Mycophénolate-Mofétil Sandoz® 250 mg, capsules; Mycophénolate-Mofétil Sandoz® 500 mg, comprimés pelliculés"
61222, 61223, 61896 "Montélukast Sandoz® granulé; Montélukast Sandoz® comprimés â mâcher; Montélukast Sandoz® comprimés pelliculés"
62278 "Irbesartan HCT Zentiva® 150/12,5; 300/12,5; 300/25"
62904 "Perindopril-Indapamid-Mepha 2.5/0.625 mg, comprimés pelliculés; Perindopril-Indapamid-Mepha 5/1.25 mg, comprimés pelliculés"

XML

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

46489, 65479
52810
54785, 65474
57460
58734
62385
62386
62780
63123
65561
67007
68229
68864
68996
69443

RefData

GTINs used: 0

Swissmedic

GTINs used: 16093
recovered dosage 3555

BAG

GTINs used: 175

ATC Codes

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

A01, A03AD, A05AX, B05CB, B06AX, C02DD, C09XX, D08AE, D09, D09A, D09AA, G03XX, H02C, H02CA, J05AJ, 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, N03X, N03X1, N05BX, N05CJ, P02CF, R07AB

swisspeddose.ch

ATC with <Case>: 1086
ATC without <Case>: 3493
tables created: 3951

Sappinfo

Unique ATC

breastFeed: 145
pregnancy: 191

Tables created

breastFeed: 895
pregnancy: 1273

Mon Jun 2 04:05:26 2025