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

ATC Codes

../input/atc_codes_multi_lingual.txt

# lines: 2635

Drugshortage

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

GTINs : 720
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: 189
Without Zulassungsnummer: 14

DHPC HPC

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

Count: 16
Without Zulassungsnummer: 23

AIPS

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

medicalInformation fi fr 4599

ATC codes 4599

from aips: 4549
from swissmedic: 38
unique (from both aips and swissmedic): 1805

Titles with empty or invalid ATC code: 12

RN: <58943> , title: <Apligraf>
RN: <55442> , title: <Ascosal® comprimés effervescents>
RN: <51390> , title: <Becetamol® Gouttes>
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: <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: 4089
from peddose: 423
no text found: 75

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 16072 matching packages

RefData

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

PHARMA items: 14853
PHARMA items with GTIN starting with "7680": 14000
articles: 14853

BAG

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

preparations: 6584
packs: 10219
packs without GTIN: 74
GTIN recovered from <SwissmedicNo8>: 70
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

9980 GTIN are also in swissmedic
9878 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: 4827/645 (5472)
in swissmedic: 1253/4219 (5472)
in bag: 65/5407 (5472)
not found anywhere: 112

54802, 54803, 66078, 48299, 40467, 42127, 55179, 55442, 41547, 66996, 25022, 68286, 51390, 54173, 67063, 60372, 55114, 56545, 43319, 49259, 39828, 10286, 42134, 66236, 66237, 56422, 57191, 55381, 40841, 68147, 41569, 67022, 56929, 38174, 57933, 00701, 65179, 47956, 55508, 54904, 44676, 65331, 52489, 67792, 20406, 03579, 71204, 59795, 65161, 34088, 59210, 17664, 42185, 59093, 62840, 67546, 65120, 54089, 54032, 54033, 55461, 67197, 46871, 48147, 65150, 41341, 68478, 68335, 47915, 56212, 26339, 44778, 55494, 51741, 51742, 63014, 54974, 52537, 68579, 57659, 22672, 56469, 60489, 45699, 67819, 67557, 65840, 66642, 66708, 67095, 67158, 37687, 49034, 01677, 46003, 43667, 67451, 61560, 61561, 61562, 61564, 61566, 24024, 47110, 68400, 42441, 56198, 62955, 58034, 68238, 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
58108
58734
62385
62386
62780
63123
63255
65561
67007
68229
68864
68996
69443

RefData

GTINs used: 13181

Swissmedic

GTINs used: 2967
recovered dosage 729

BAG

GTINs used: 154

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>: 1099
ATC without <Case>: 3487
tables created: 3977

Sappinfo

Unique ATC

breastFeed: 145
pregnancy: 191

Tables created

breastFeed: 897
pregnancy: 1278

Sat Jul 5 04:06:59 2025