This Report was generated by: cpp2sqlite

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

File Analysis

swisspeddose.ch

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

Cases 762

<CaseID> set: 762
<ATCCode> set: 266
<ROACode> set: 14

Indications 383

<IndicationKey> map: 383

Dosages 1423

<CaseId> set: 762
vec: 1423

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

ATC Codes

../input/atc_codes_multi_lingual.txt

# lines: 2635

Drugshortage

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

GTINs : 718
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: 198
Without Zulassungsnummer: 14

DHPC HPC

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

Count: 18
Without Zulassungsnummer: 28

AIPS

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

medicalInformation fi fr 4544

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: 69398 html: ca9befac6c6b41d6be950c2b6006dd11-fr.html
Regnrs: 56539 html: 7452fa6ab6a04698b5411ea837d57f97-fr.html
Regnrs: 29080 html: be82a9bfde43416c9e17a122bff8988a-fr.html
Regnrs: 57264 html: b7adabfbf53b46c3a752b4f8251c2d5b-fr.html
Regnrs: 49621 html: 07a778ddf1be4a2eb5de908e93c84986-fr.html
Regnrs: 15322 html: 09295ff68ade441796d9052e9a325d55-fr.html
Regnrs: 52489 html: 61a856a9b7934f2a859eb62a5142e5e7-fr.html

Swissmedic has 15964 matching packages

RefData

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

PHARMA items: 15243
PHARMA items with GTIN starting with "7680": 14229
articles: 15243

BAG

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

preparations: 6561
packs: 10187
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

9945 GTIN are also in swissmedic
9869 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: 4794/603 (5397)
in swissmedic: 1235/4162 (5397)
in bag: 55/5342 (5397)
not found anywhere: 86

68326, 42127, 67451, 66587, 66214, 66078, 44778, 68147, 62955, 22672, 63014, 56469, 60489, 68922, 68182, 68335, 68286, 55381, 12730, 68478, 50490, 68400, 68359, 67792, 68596, 38174, 01677, 46003, 67546, 68579, 47915, 44676, 03579, 20406, 67197, 39828, 10286, 58034, 67022, 67819, 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/603 (5397)

in swissmedic: 1235/4162 (5397)

in bag: 55/5342 (5397)

not found anywhere: 86

ATC not found: 73

68326, 42127, 67451, 66587, 66214, 66078, 44778, 68147, 62955, 22672, 63014, 56469, 60489, 68922, 68182, 68335, 68286, 55381, 12730, 68478, 50490, 68400, 68359, 67792, 67575, 68596, 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: 13167

Swissmedic

GTINs used: 2931
recovered dosage 714

BAG

GTINs used: 147

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>: 1080
ATC without <Case>: 3390
tables created: 3897

Sappinfo

Unique ATC

breastFeed: 144
pregnancy: 190

Tables created

breastFeed: 879
pregnancy: 1245

Sat Oct 25 04:07:26 2025