File CHOCETIQ.MDB is with the format Microsoft Access 2. Its structure is:
Table Categories
Name
|
Type
|
Length
|
Nom
|
characters
|
50
|
Index
|
Description
|
Single
|
Primary
|
PrimaryKey
|
+Nom
|
O
|
O
|
Table CompositionLot
Name
|
Type
|
Length
|
NomLot
|
characters
|
50
|
NomProduit
|
characters
|
50
|
Quantite
|
double number
|
8
|
Index
|
Description
|
Single
|
Primary
|
IProduit
|
+NomProduit
|
|
|
PrimaryKey
|
+NomLot;+NomProduit
|
O
|
O
|
Table Compositionproduit
Name
|
Type
|
Length
|
NomProduit
|
characters
|
50
|
NomIngredient
|
characters
|
50
|
Quantite
|
double number
|
8
|
Index
|
Description
|
Single
|
Primary
|
IIngredient
|
+NomIngredient
|
|
|
PrimaryKey
|
+NomProduit;+NomIngredient
|
O
|
O
|
Table Etiquettes
Name
|
Type
|
Length
|
Nom
|
characters
|
50
|
MargeHaute
|
double number
|
8
|
MargeGauche
|
double number
|
8
|
NbVertical
|
double number
|
8
|
NbHorizontal
|
double number
|
8
|
Hauteur
|
double number
|
8
|
Largeur
|
double number
|
8
|
EcartVertical
|
double number
|
8
|
EcartHorizontal
|
double number
|
8
|
Orientation
|
Boolean
|
1
|
RtfLogoVisible
|
Boolean
|
1
|
RtfLogoLeft
|
double number
|
8
|
RtfLogoTop
|
double number
|
8
|
RtfLogoWidth
|
double number
|
8
|
RtfLogoHeight
|
double number
|
8
|
RtfIdentiteVisible1
|
Boolean
|
1
|
RtfIdentiteLeft1
|
double number
|
8
|
RtfIdentiteTop1
|
double number
|
8
|
RtfIdentiteWidth1
|
double number
|
8
|
RtfIdentiteHeight1
|
double number
|
8
|
RtfLibelleVisible
|
Boolean
|
1
|
RtfLibelleTop
|
double number
|
8
|
RtfLibelleLeft
|
double number
|
8
|
RtfLibelleWidth
|
double number
|
8
|
RtfLibelleHeight
|
double number
|
8
|
RtfCompositionVisible
|
Boolean
|
1
|
RtfCompositionTop
|
double number
|
8
|
RtfCompositionLeft
|
double number
|
8
|
RtfCompositionWidth
|
double number
|
8
|
RtfCompositionHeight
|
double number
|
8
|
RtfDateVisible
|
Boolean
|
1
|
RtfDateLeft
|
double number
|
8
|
RtfDateTop
|
double number
|
8
|
RtfDateWidth
|
double number
|
8
|
RtfDateHeight
|
double number
|
8
|
RtfCodeCaisseVisible
|
Boolean
|
1
|
RtfCodeCaisseLeft
|
double number
|
8
|
RtfCodeCaisseTop
|
double number
|
8
|
RtfCodeCaisseWidth
|
double number
|
8
|
RtfCodeCaisseHeight
|
double number
|
8
|
RtfPoidsVisible
|
Boolean
|
1
|
RtfPoidsLeft
|
double number
|
8
|
RtfPoidsTop
|
double number
|
8
|
RtfPoidsHeight
|
double number
|
8
|
RtfPoidsWidth
|
double number
|
8
|
RtfPrixVisible
|
Boolean
|
1
|
RtfPrixLeft
|
double number
|
8
|
RtfPrixTop
|
double number
|
8
|
RtfPrixWidth
|
double number
|
8
|
RtfPrixHeight
|
double number
|
8
|
RtfLibelleFontName
|
characters
|
50
|
RtfLibelleFontSize
|
double number
|
8
|
RtfLibelleAlignment
|
integer
|
2
|
RtfLibelleFontColor
|
double number
|
8
|
RtfLibelleFontBold
|
Boolean
|
1
|
RtfLibelleFontItalic
|
Boolean
|
1
|
RtfLibelleFontUnderline
|
Boolean
|
1
|
RtfLibelleFontStrikeThru
|
Boolean
|
1
|
RtfCompositionFontName
|
characters
|
50
|
RtfCompositionFontSize
|
double number
|
8
|
RtfCompositionAlignment
|
integer
|
2
|
RtfCompositionFontColor
|
double number
|
8
|
RtfCompositionFontBold
|
Boolean
|
1
|
RtfCompositionFontItalic
|
Boolean
|
1
|
RtfCompositionFontUnderline
|
Boolean
|
1
|
RtfCompositionFontStrikeThru
|
Boolean
|
1
|
RtfDateFontName
|
characters
|
50
|
RtfDateFontSize
|
double number
|
8
|
RtfDateAlignment
|
integer
|
2
|
RtfDateFontColor
|
double number
|
8
|
RtfDateFontBold
|
Boolean
|
1
|
RtfDateFontItalic
|
Boolean
|
1
|
RtfDateFontUnderline
|
Boolean
|
1
|
RtfDateFontStrikeThru
|
Boolean
|
1
|
RtfCodeCaisseFontName
|
characters
|
50
|
RtfCodeCaisseFontSize
|
double number
|
8
|
RtfCodeCaisseAlignment
|
integer
|
2
|
RtfCodeCaisseFontColor
|
double number
|
8
|
RtfCodeCaisseFontBold
|
Boolean
|
1
|
RtfCodeCaisseFontItalic
|
Boolean
|
1
|
RtfCodeCaisseFontUnderline
|
Boolean
|
1
|
RtfCodeCaisseFontStrikeThru
|
Boolean
|
1
|
RtfPoidsFontName
|
characters
|
50
|
RtfPoidsFontSize
|
double number
|
8
|
RtfPoidsAlignment
|
integer
|
2
|
RtfPoidsFontColor
|
double number
|
8
|
RtfPoidsFontBold
|
Boolean
|
1
|
RtfPoidsFontItalic
|
Boolean
|
1
|
RtfPoidsFontUnderline
|
Boolean
|
1
|
RtfPoidsFontStrikeThru
|
Boolean
|
1
|
RtfPrixFontName
|
characters
|
50
|
RtfPrixFontSize
|
double number
|
8
|
RtfPrixAlignment
|
integer
|
2
|
RtfPrixFontColor
|
double number
|
8
|
RtfPrixFontBold
|
Boolean
|
1
|
RtfPrixFontItalic
|
Boolean
|
1
|
RtfPrixFontUnderline
|
Boolean
|
1
|
RtfPrixFontStrikeThru
|
Boolean
|
1
|
RtfPhotoVisible
|
Boolean
|
1
|
RtfPhotoLeft
|
double number
|
8
|
RtfPhotoTop
|
double number
|
8
|
RtfPhotoWidth
|
double number
|
8
|
RtfPhotoHeight
|
double number
|
8
|
RtfIdentiteVisible2
|
Boolean
|
1
|
RtfIdentiteLeft2
|
double number
|
8
|
RtfIdentiteTop2
|
double number
|
8
|
RtfIdentiteWidth2
|
double number
|
8
|
RtfIdentiteHeight2
|
double number
|
8
|
RtfPoidsRefVisible
|
Boolean
|
1
|
RtfPoidsRefLeft
|
double number
|
8
|
RtfPoidsRefTop
|
double number
|
8
|
RtfPoidsRefHeight
|
double number
|
8
|
RtfPoidsRefWidth
|
double number
|
8
|
RtfPoidsRefFontName
|
characters
|
50
|
RtfPoidsRefFontSize
|
double number
|
8
|
RtfPoidsRefAlignment
|
integer
|
2
|
RtfPoidsRefFontColor
|
double number
|
8
|
RtfPoidsRefFontBold
|
Boolean
|
1
|
RtfPoidsRefFontItalic
|
Boolean
|
1
|
RtfPoidsRefFontUnderline
|
Boolean
|
1
|
RtfPoidsRefFontStrikeThru
|
Boolean
|
1
|
RtfEAN13Visible
|
Boolean
|
1
|
RtfEAN13Top
|
double number
|
8
|
RtfEAN13Left
|
double number
|
8
|
RtfEAN13Width
|
double number
|
8
|
RtfEAN13Height
|
double number
|
8
|
RtfEAN13Fontname
|
characters
|
50
|
RtfEAN13Fontsize
|
double number
|
8
|
RtfEAN13Legende
|
Boolean
|
1
|
Imprimante
|
characters
|
100
|
RtfNutriLeft
|
double number
|
8
|
RtfNutriTop
|
double number
|
8
|
RtfNutriWidth
|
double number
|
8
|
RtfNutriHeight
|
double number
|
8
|
RtfNutriFontBold
|
Boolean
|
|
RtfNutriBlackcolor
|
double number
|
8
|
RtfNutriWhilteColor
|
double number
|
8
|
RtfNutriVisible
|
Boolean
|
|
RtfNutriModele
|
integer
|
2
|
RtfNoLotFontName
|
characters
|
50
|
RtfNoLotFontSize
|
double number
|
8
|
RtfNoLotAlignment
|
integer
|
2
|
RtfNoLotFontColor
|
double number
|
8
|
RtfNoLotFontBold
|
Boolean
|
|
RtfNoLotFontItalic
|
Boolean
|
|
RtfNoLotFontUnderline
|
Boolean
|
|
RtfNoLotFontStrikeThru
|
Boolean
|
|
RtfNoLotVisible
|
Boolean
|
|
RtfNoLotLeft
|
double number
|
8
|
RtfNoLotTop
|
double number
|
8
|
RtfNoLotWidth
|
double number
|
8
|
RtfNoLotHeight
|
double number
|
8
|
RtfDateFabFontBold
|
Boolean
|
|
RtfDateFabFontBold
|
Boolean
|
|
RtfDateFabFontBold
|
Boolean
|
|
RtfDateFabFontBold
|
Boolean
|
|
RtfDateFabVisible
|
Boolean
|
|
RtfDateFabLeft
|
double number
|
8
|
RtfDateFabTop
|
double number
|
8
|
RtfDateFabWidth
|
double number
|
8
|
RtfDateFabHeight
|
double number
|
8
|
RtfNutriFontName
|
characters
|
50
|
RtfZoneLibre1Visible
|
Boolean
|
|
RtfZoneLibre1Left
|
double number
|
8
|
RtfZoneLibre1Top
|
double number
|
8
|
RtfZoneLibre1Width
|
double number
|
8
|
RtfZoneLibre1Height
|
double number
|
8
|
RtfZoneLibre1Memo
|
Memo
|
|
RtfZoneLibre2Visible
|
Boolean
|
|
RtfZoneLibre2Left
|
double number
|
8
|
RtfZoneLibre2Top
|
double number
|
8
|
RtfZoneLibre2Width
|
double number
|
8
|
RtfZoneLibre2Height
|
double number
|
8
|
RtfZoneLibre2Memo
|
Memo
|
|
Rtf5Cvisible
|
Boolean
|
|
Rtf5CLeft
|
double number
|
8
|
Rtf5CTop
|
double number
|
8
|
Rtf5CWidth
|
double number
|
8
|
Rtf5CHeight
|
double number
|
8
|
Rtf5CCouleur
|
double number
|
8
|
RtfQRcodeVisible
|
Boolean
|
|
RtfQRcodeLeft
|
double number
|
8
|
RtfQRcodeTop
|
double number
|
8
|
RtfQRcodeWidth
|
double number
|
8
|
RtfQRcodeHeight
|
double number
|
8
|
RtfQRcodeContenu
|
Memo
|
|
RtfQRcodeCouleur
|
double number
|
8
|
Index
|
Description
|
Single
|
Primary
|
PrimaryKey
|
+Nom
|
O
|
O
|
Table Ingredients
Name
|
Type
|
Length
|
Name
|
characters
|
100
|
LibelleEtiq
|
characters
|
50
|
Allergen
|
characters
|
100
|
SurEtiquette
|
Boolean
|
1
|
Category
|
characters
|
50
|
NoCiqual
|
double number
|
8
|
Code5c
|
characters
|
2
|
Index
|
Description
|
Single
|
Primary
|
ICategorie
|
+Categorie
|
|
|
PrimaryKey
|
+LibelleEtiq
|
O
|
O
|
Table Lots
Name
|
Type
|
Length
|
Nom
|
characters
|
50
|
Codecaisse
|
characters
|
20
|
LibelleEtiq
|
characters
|
50
|
Poids
|
double number
|
8
|
PoidsRef
|
characters
|
10
|
Prix
|
double number
|
8
|
DureeConservation
|
double number
|
8
|
Photo
|
binary object
|
0
|
TaillePhoto
|
double number
|
8
|
UniteDuree
|
integer
|
2
|
DLCDLUO
|
Boolean
|
1
|
Complement
|
memo
|
|
EAN13
|
characters
|
13
|
FormatEtiq
|
characters
|
50
|
NoLot
|
characters
|
20
|
DateFab
|
characters
|
20
|
FormatEtiq2
|
characters
|
50
|
FormatEtiq3
|
characters
|
50
|
NomEtiq
|
characters
|
50
|
NomEtiq2
|
characters
|
50
|
NomEtiq3
|
characters
|
50
|
ActiveEtiq
|
Boolean
|
1
|
ActiveEtiq2
|
Boolean
|
1
|
ActiveEtiq3
|
Boolean
|
1
|
Portion
|
double number
|
8
|
Code5C
|
characters
|
2
|
Index
|
Description
|
Single
|
Primary
|
PrimaryKey
|
+Nom
|
O
|
O
|
Table Produits
Name
|
Type
|
Length
|
Nom
|
characters
|
100
|
LibelleEtiq
|
characters
|
50
|
Photo
|
binary object
|
0
|
CodeCaisse
|
characters
|
20
|
Poids
|
double number
|
8
|
Poidsref
|
characters
|
10
|
Prix
|
double number
|
8
|
DureeConservation
|
double number
|
8
|
TaillePhoto
|
double number
|
8
|
UniteDuree
|
integer
|
2
|
DLCDLUO
|
Boolean
|
1
|
Complement
|
memo
|
|
EAN13
|
characters
|
13
|
FormatEtiq
|
characters
|
50
|
NoLot
|
characters
|
20
|
DateFab
|
characters
|
20
|
FormatEtiq2
|
characters
|
50
|
FormatEtiq3
|
characters
|
50
|
NomEtiq
|
characters
|
50
|
NomEtiq2
|
characters
|
50
|
NomEtiq3
|
characters
|
50
|
ActiveEtiq
|
Boolean
|
1
|
ActiveEtiq2
|
Boolean
|
1
|
ActiveEtiq3
|
Boolean
|
1
|
Portion
|
double number
|
8
|
Code5C
|
characters
|
2
|
Index
|
Description
|
Single
|
Primary
|
PrimaryKey
|
+Nom
|
O
|
O
|
Table Standards
Name
|
Type
|
Length
|
Nom
|
characters
|
50
|
MargeHaute
|
double number
|
8
|
MargeGauche
|
double number
|
8
|
NbVertical
|
double number
|
8
|
NbHorizontal
|
double number
|
8
|
Hauteur
|
double number
|
8
|
Largeur
|
double number
|
8
|
EcartVertical
|
double number
|
8
|
EcartHorizontal
|
double number
|
8
|
Index
|
Description
|
Single
|
Primary
|
INom
|
+Nom
|
O
|
|
PrimaryKey
|
+Nom
|
O
|
O
|
Table Vendeur
Name
|
Type
|
Length
|
LogoVendeur
|
binary object
|
|
TailleLogo
|
double number
|
8
|
Identite1
|
memo
|
|
Identite2
|
memo
|
|
VCardNom
|
characters
|
100
|
VCardPrenom
|
characters
|
100
|
VCardRue1
|
characters
|
200
|
VCardRue2
|
characters
|
200
|
VCardCodePost
|
characters
|
10
|
VCardVille
|
characters
|
100
|
VCardTel1
|
characters
|
50
|
VCardTel2
|
characters
|
50
|
VCardFax
|
characters
|
50
|
VCardEmail
|
characters
|
100
|
VCardUrl
|
characters
|
100
|
VCardResponsable
|
characters
|
100
|
Table Unités
Name
|
Type
|
Length
|
unite
|
characters
|
10
|
uniteref
|
characters
|
10
|
coeff
|
double number
|
8
|
texte
|
characters
|
50
|
texteref
|
characters
|
50
|
texteportion
|
characters
|
10
|
Index
|
Description
|
Single
|
Primary
|
PrimaryKey
|
+unite
|
O
|
O
|
Table Mentions
Name
|
Type
|
Length
|
NumeroMentier
|
Integer
|
2
|
Mention
|
characters
|
100
|
Index
|
Description
|
Single
|
Primary
|
PrimaryKey
|
+NumeroMention
|
O
|
O
|
Table Parametres
Nom
|
Type
|
Longueur
|
numerodeversion
|
caractères
|
10
|
NUTRI.MDB table, with the format Microsoft Access 2, is a reduction of Ciqual Table with only necessary data for ChocEtiq. It use fields name of Ciqual database2013 of Agence nationale de sécurité sanitaire de l'alimentation, de l'environnement et du travail (Anses).
Table Food
Name
|
Type
|
Longueur
|
ORIGFDCD
|
double number
|
8
|
ORIGFDNM
|
characters
|
250
|
ENGFDNAM
|
characters
|
150
|
Index
|
Description
|
Unique
|
Primaire
|
FOODORIGFDCD
|
+ORIGFDCD
|
N
|
N
|
Table Compiled_data
Name
|
Type
|
Longueur
|
ORIGFDCD
|
double number
|
8
|
ORIGCPCD
|
double number
|
8
|
SELVALtexte
|
characters
|
255
|
Index
|
Description
|
Unique
|
Primaire
|
COMPILED_DATAORIGCPCD
|
+ORIGCPCD
|
N
|
N
|
COMPILED_DATAORIGFDCD
|
+ORIGFDCD
|
N
|
N
|
Category :
|
328
|
Energy
|
|
25003
|
Protein
|
|
31000
|
Carbohydrate
|
|
32000
|
Sugars
|
|
40000
|
Fat
|
|
40302
|
FA saturated
|
|
34100
|
Fibers
|
|
10110
|
Sodium
|
|
Other files:
•BOUTON.WAV: used by the parameter “sound Buttons” •CATEGORIES1.RPT, CATEGORIES2.RPT, INGREDIENT1.RPT, LOT1.RPT, LOTCOMPOSITION1.RPT, LOTCOMPOSITION2.RPT, PRODUIT1.RPT, PRODUITCOMPOSITION1.RPT: printed out in French (generated in Crystal Report 4) •CATEGORIES1EN.RPT, CATEGORIES2EN.RPT, INGREDIENT1EN.RPT, LOT1EN.RPT, LOTCOMPOSITION1EN.RPT, LOTCOMPOSITION2EN.RPT, PRODUIT1EN.RPT, PRODUITCOMPOSITION1EN.RPT: printed out in English (generated in Crystal report 4) •CHOCETIQ.EXE: ChocEtiq application •HISTORIQUE.TXT: description of the various evolutions of the application by numbers of version (free format text) in French •HISTORIQUEEN.TXT: description of the various evolutions of the application by numbers of version (free format text) in English •CHOCETIQ.CHM: this help file in French •CHOCETIQEN.CHM: the help file in English Linguistic resources: Sub-directory \LANGUAGES
•CHOCETIQ.FR French linguistic Resources •CHOCETIQ.EN English linguistic Resources •FR.RLE French Flag •EN.RLE English Flag Sample files included in current application directory (by default C:\program files\chocetiq)
•Ingredients.cei : french file of more than 1790 ingredients grouped in 69 categories •Categories.cei : french file of 69 categories •Standards.cei : file of 66 labels sheets formats. Note : to import this file, double-click on file Standards.cei at desktop, without launching before application
•Exemplelot.cei : sample file of a package, including photos, products, ingredients and necessary categories •Eti... . cei : various files of labels formats
© All rights reserved 2007/2021 - ADAGIO
|