This Report was generated by: cpp2sqlite

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

File Analysis

swisspeddose.ch

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

Cases 728

<CaseID> set: 727
<ATCCode> set: 249
<ROACode> set: 14

Indications 365

<IndicationKey> map: 365

Dosages 1307

<CaseId> set: 727
vec: 1307

Codes 5918

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

Swissmedic

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

rows: 17916

ATC Codes

../input/atc_codes_multi_lingual.txt

# lines: 2635

Drugshortage

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

GTINs : 689
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: 98
Without Zulassungsnummer: 7

DHPC HPC

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

Count: 44
Without Zulassungsnummer: 76

AIPS

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

medicalInformation fi fr 4573

ATC codes 4573

from aips: 4520
from swissmedic: 42
unique (from both aips and swissmedic): 1794

Titles with empty or invalid ATC code: 11

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: <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: 4100
from peddose: 416
no text found: 46

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

RefData

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

PHARMA items: 16489
PHARMA items with GTIN starting with "7680": 15397
articles: 16491

BAG

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

preparations: 6576
packs: 10240
packs without GTIN: 67
GTIN recovered from <SwissmedicNo8>: 63
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

9977 GTIN are also in swissmedic
10048 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: 4870/579 (5449)
in swissmedic: 1261/4188 (5449)
in bag: 23/5426 (5449)
not found anywhere: 83

54802, 54803, 66078, 42127, 55179, 55442, 68721, 66996, 56475, 25022, 67063, 55114, 31839, 43319, 39828, 10286, 42134, 56422, 57191, 30157, 47646, 41569, 67022, 57933, 65179, 47956, 55508, 44676, 65331, 52489, 20406, 03579, 71204, 59795, 17664, 59093, 62840, 67546, 65120, 54032, 54033, 55461, 67197, 46871, 56264, 56264, 00654, 65150, 41341, 68478, 47915, 26339, 44778, 55494, 51741, 51742, 54974, 62809, 68579, 57659, 56469, 60489, 67819, 67557, 65840, 66642, 66708, 67095, 67158, 49034, 01677, 46003, 61560, 61561, 61562, 61564, 61566, 24024, 47110, 42441, 56198, 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"
52787, 52788 "Trabar 50; Trabar 100"
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
58734
62385
62386
62780
63123
65561
66533
67007
67806
67941
68229
68864
68996

RefData

GTINs used: 13905

Swissmedic

GTINs used: 3072
recovered dosage 778

BAG

GTINs used: 33

ATC Codes

68 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, 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, L91, L91A, L91AB, M03BA, M04AC, N02BF, N02CD, N03X, N03X1, N05BX, N05CJ, P02CF, R07AB

swisspeddose.ch

ATC with <Case>: 1049
ATC without <Case>: 3512
tables created: 3854

Sappinfo

Unique ATC

breastFeed: 145
pregnancy: 192

Tables created

breastFeed: 903
pregnancy: 1279

Sat Dec 21 04:08:15 2024