This Report was generated by: cpp2sqlite

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

File Analysis

swisspeddose.ch

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

Cases 761

<CaseID> set: 761
<ATCCode> set: 265
<ROACode> set: 14

Indications 382

<IndicationKey> map: 382

Dosages 1417

<CaseId> set: 761
vec: 1417

Codes 6167

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

Swissmedic

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

rows: 17890

ATC Codes

../input/atc_codes_multi_lingual.txt

# lines: 2635

Drugshortage

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

GTINs : 708
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

AIPS

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

medicalInformation fi fr 4548

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: 57264 html: b7adabfbf53b46c3a752b4f8251c2d5b-fr.html
Regnrs: 58179 html: 078b949d48a240d5b6f9bf15a218960f-fr.html
Regnrs: 49621 html: 07a778ddf1be4a2eb5de908e93c84986-fr.html
Regnrs: 15322 html: 09295ff68ade441796d9052e9a325d55-fr.html
Regnrs: 52489 html: 61a856a9b7934f2a859eb62a5142e5e7-fr.html
Regnrs: 47167 html: a1378ef277fa4410a2b195e444387828-fr.html
Regnrs: 52004 html: 878b7e978cb545bfad7b1d84e4aa88b8-fr.html
Regnrs: 38407, 44562 html: 822b637c806c46c49d58e111bdb2d12c-fr.html

Swissmedic has 15952 matching packages

RefData

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

PHARMA items: 15037
PHARMA items with GTIN starting with "7680": 14143
articles: 15037

BAG

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

preparations: 6574
packs: 10202
packs without GTIN: 65
GTIN recovered from <SwissmedicNo8>: 61
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

9944 GTIN are also in swissmedic
9876 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: 4794/600 (5394)
in swissmedic: 1223/4171 (5394)
in bag: 58/5336 (5394)
not found anywhere: 85

42127, 67451, 66078, 44778, 68147, 62955, 49259, 22672, 41341, 63014, 56469, 60489, 68922, 68335, 68286, 55381, 68326, 68478, 50490, 68400, 68359, 67792, 38174, 01677, 46003, 67546, 68579, 47915, 44676, 03579, 20406, 67197, 39828, 10286, 58034, 67022, 67819, 20055, 20065, 67557, 30984, 67063, 34088, 56929, 59210, 48299, 66236, 66237, 49034, 17664, 65840, 66642, 66708, 67095, 67158, 65940, 54032, 54033, 26339, 42134, 24024, 54089, 65120, 65161, 54173, 61560, 61561, 61562, 61564, 61566, 00701, 57755, 60372, 41547, 56545, 42185, 56212, 51390, 52537, 47110, 45699, 46871, 48147, 43667, 37687

in refdata: 4794/600 (5394)

in swissmedic: 1223/4171 (5394)

in bag: 58/5336 (5394)

not found anywhere: 85

ATC not found: 71

42127, 67451, 66078, 44778, 68147, 62955, 49259, 22672, 41341, 63014, 56469, 60489, 68922, 68335, 68286, 55381, 68326, 12730, 68478, 50490, 68400, 68359, 67792, 67575, 38174, 67546, 68579, 47915, 44676, 67197, 39828, 10286, 58034, 67022, 67819, 67557, 30984, 67063, 34088, 56929, 59210, 48299, 66236, 66237, 49034, 17664, 65840, 66642, 66708, 67095, 67158, 65940, 58943, 54032, 54033, 26339, 42134, 24024, 54089, 62038, 65120, 65161, 54173, 00701, 18346, 57755, 60372, 41547, 56545, 42185, 56212, 51390, 52537, 47110, 45699, 46871, 48147, 37687

RefData

GTINs used: 13176

Swissmedic

GTINs used: 2901
recovered dosage 716

BAG

GTINs used: 144

ATC Codes

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

A01, A03AD, A05AX, A08AA, B05CB, B06AX, C02DD, 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>: 1083
ATC without <Case>: 3393
tables created: 3918

Sappinfo

Unique ATC

breastFeed: 144
pregnancy: 190

Tables created

breastFeed: 883
pregnancy: 1250

Wed Sep 17 18:18:10 2025