Home

FoodCASE Manual

Contents

1. Figure 4 2 6 3 13 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 5 Main Application 5 1 Main Screen The main screen of the application Figure 5 1 has a very simple layout consisting of six main registers e General Settings e User Administration Figure 5 1 e EuroFIR Thesauri e User Thesauri e Versioning e Data Quality Analysis Some registers contain further sub registers tabs When application is launched user always sees the register which was open when it was last closed Figure 5 1 14 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 5 2 Menu Bar 5 2 1 Menu File Help Exit Ctrl Q Exit Ctrl Q Click the Menu File Exit Ctrl Q or use of the Ctrl Q keys closes the application 5 2 2 Menu Help File Help About About Menu Help About is an information window about version of the application copyright and owner Figure 5 2 2 FoodCASE Product version 1 4 5 DB version 1 4 5 Homepage http www foodcase ethz ch gt va pisa AA ung d E 4 y Figure 5 2 2 6 Working with Registers 6 1 General Settings 6 1 1 Bug Tracking It displays the URL to the current Bug Tracker system Figure 6 1 1 1 When compilers working in the Compiler Client application and want to report bugs they will be directed to this URL when they click on Menu Tools BugTracker The BugTracker system is accessible
2. 2 matrix unit per 100g edible portion should sum to 100 grams If the sum is excactly 100g the rating is 1 0 If the sum is 99 grams or 101 grams the rating is 0 99 and so on Soft constraint case when eege lt gt 9 then 1 0 else case when total lt 100 then total 100 when total gt 100 and total lt 200 then 200 total 100 else 0 0 end end as val select 2 coalesce sum case when aggrfoodcompidunit 8 then cast aggrfoodcompselectedvalue as float 1000 when aggrfoodcompidunit 1 then cast aggrfoodcompselectedvalue as float 1000 when from 1 left join tblaggrfoodcomponent afc on 2 afc aggrfoodcompidaggrfood left join tblcomponent c on afc aggrfoodcompidcomponent c idcomponent and idcomponent in 61 400 282 486 11 382 473 478 479 480 475 476 477 455 422 372 31 296 386 or componer where 3 group by 2 aggrfoodname aggrfoodcompidmatrixunit as tbl 0 lt requirementId gt lt assessmentId gt 1 entity alias 2 keycolumn 3 condition 4 alias Figure 6 6 4 2 56 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Quality Requirement Details When defining new measure for quality assessment Figure 6 6 4 2 following information needs to be defined Entity select it from the drop down window of the existing entities entities can be modified in Quality Entities tab Name enter name of measure Descripti
3. Components Acquisition Types Units Matrix Units Reference Types Value Types Method Types Method Indicators Component Groups ER Code Descriptor analytical generic Scope Note Use this Method Type if no further information o Creation Sep 3 2007 Creation by Mutation kpresser Sep 3 2007 Mutation by kpresser a analytical result s aggregation of contributing a calculated as recipe calculated on component pro Analytical result or statistic of multiple measure Value derived as an aggregation of accepted an Used in case of complete recipe calculation incl E g fatty acid profile amino acid profile for a sp Sep 3 2007 Dresser 3 D Sep 3 2007 Dresser AC lcalculated generic Use this Method Type if no further information o Sep 3 2007 kpresser Sep3 2007 kpresser 5G calculated as aggregate food Used in case of aggregated foods when the com Sep 3 2007 kpresser Sep 3 2007 Sep 3 2007 kpresser kpresser Sep 3 2007 Sep 3 2007 Sep 3 2007 Sep 3 2007 Sep 3 2007 kpresser presser kpresser kpresser kpresser summation from constituent See component description for further informati Sep 3 2007 kpresser Sep 3 2007 kpresser calculations including conver E g for energy calculation or for calculating alph Sep 3 2007 kpresser Sep 3 2007 kpresser calculat
4. S gigem Ee ___ 12 mto PP aen 35 DC 8 Karltest Karltest 7 e d cenitres fm milii 10 dl decilitre ml millili e Id 10 Source Unit dl decilitre Target Unit ml millilitre Conversion Multiplier 100 Figure 6 4 2 1 3 6 4 2 2 Updating Unit Conversion 1 Goto the User Thesauri register and select the Unit Conversions tab Figure 6 4 2 2 1 2 Left click on an item and click the Edit button to activate the item for modification 3 Change source and or target units available in the drop down lists and or define conversion multiplier between these units Figure 6 4 2 2 2 4 Click the Save button to store updated information Compiler Client module must be restarted to update units conversion Figure 6 4 2 2 3 40 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 m millilitre d decilitre 3legals chickenega s oi gram 4ftsteaspon g urem O gram karts L fase Cappuccino mb milii Do Rrio O Karts Sites Warte oo centres fimi milli io 10 dl decilitre mi millili Id Source Unit Target Unit File Help CE Sem O a O orm OOO kartesy 12 glass Cappuccino mi milf 180 Do Rmi latest 35 giereg karites 2 O e d ceniitres ml milii 19 10 1 litre mi millili 1000 Id Source Unit Target Unit Conversion Multiplier Figure 6
5. A W Component Search E IE w wk Column kam bes 50170109 M eh Jeep bes 50 70 BCE W Jur X Function Kab cata 83 70 mg w MR ka am 00 T0 g ur Tem em kem oo ro p w me k C Case sensitive ignore time E km mo 730 70 img WRK pp Food Markers Figure 6 1 2 2 Name of the environment and the coloured strip over the menu displays in Compiler Client module 6 2 User Administration The register is used for management of users of the application There are two user roles created at present e Admin 1 has right to work with FoodCASE Administration Tool and may define and modify existing compilers for using FoodCASE Compiler Client module e Compiler 2 has an access to work with FoodCASE Compiler Client module 6 2 1 Adding New Modifying and Deleting Existing User Admin can add new users and modify or delete existing users Adding new user 1 Go to the User Administration register Figure 5 1 2 Click the New button 3 Complete login name name of a user and a password default password is displayed 4 Click the OK button to save the user Figure 6 2 1 1 18 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Note When creating a new user the administrator defines the password but the password will not be displayed in the table The administrator is not able to see any passwords of any user after creating the account ym fi 1 5 M 1 1
6. Figure 6 4 3 6 4 3 1 Defining New Cooking Method 1 Goto the User Thesauri register and select the Recipe Preparation Methods tab Figure 6 4 3 2 Click the New button to add a new row in the tab Figure 6 4 3 3 Fill in name and description of a cooking method 4 Click the Save button to save the new cooking method Compiler Client module must be restarted to update list of cooking methods 6 4 3 2 Updating Cooking Method 1 Goto the User Thesauri register and select the Recipe Preparation Methods tab Figure 6 4 3 2 Left click on an item and click the Edit button to activate the item for modification 3 Change the cooking method Figure 6 4 3 2 4 Click the Save button to save the change on the cooking method Compiler Client module must be restarted to update list of cooking methods 43 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 User Thesauri Food Indexer LanguaL Data Quality Analysis Standard User Vocabularies Steeped Extacting flavor and other components from food sources by immersion in water usually at near boiling temperature 26 Cooked with fat or oil Cooked by adding fat or oil to those foods that do not contain fat or oil that would render during the cooking process 28 Cooked in small amount of fat or oil Cooked with sufficient fat or oil to coat and moisten the food being prepared but not cooked in enough fat or oil to imr 29Saueed
7. Cooked in a very small amount of very hot fat turning and browning the food on all sides S0jstirfried 1 Cooked by frying foods quickly over high heat stirring constantly Only enough cooking oil is used to coat the bottom of Sijeepfied Cooked in hot fat or oil deep enough to immerse the food entirely 32Pressure fried Usewhen e g meat and cooking oil are brought to high temperatures while pressure is held high enough that the wate S3 Shalowfied Achinese cooking technique similar to sauteing in which thick slices or chunks of floured or battered ingredients are ski 84 Cooked with inherent fat or oil Cooked in fat or oil rendered from the food being prepared 1 138 new cooking method testing cooking method 175 cooking testing testing cooking CEEE 176 f ry Name new cooking method Descriptor testing cooking method Figure 6 4 3 2 6 4 4 Units This tab is used for defining own measure units It can be either rare measure unit e g centilitres or household measure e g spoon cup of tea Figure 6 4 4 Subsequently one can use Unit Conversions tab to define conversion factor between specific unit and EuroFIR standardized measure units see chapter 6 4 2 Unit Conversions 44 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Additional Info Is For Va Is For Co d 83TaseCap Jrafetie
8. UE FoodCASE A E File Help Single Food EH SGE BAG 3 bes NANUSS privat A NANUSS public NANUSS 3 4 to be checked by PC E I Record status i ee partial checked 4 Recipe with no ingredients 5 SGE BAG 3 54 NANUSS privat NANUSS public A NANUSS 4 to be checked by PC Ed Record status io partial checked completed i d deleted EN Value status reported value odie documented value is terribly old added component amp Data Repository regated Food Test a i4 Marked iu Special Dietary Foods i iq Dia food Paolo Cu SGE BAG pa NANUSS privat NANUSS public H NANUSS 44 to be checked by PC fortified food O Aggregated Value 3 4 Marked E SGE BAG 5d NANUSS privat Um NANUSS public 4 NANUSS i to be checked by PC is terribly old added component Data Repository Figure 6 4 1 1 4 35 Single Values Aggregated Values Recipes Gin ch W component Search C Case sensitive Ignore time Search Clear W Food Markers Y NANUSS privat EY NANUSS public 3 NANUSS y to be checked by PC CJ Record status 5 partial e EJ checked 3 Proximates y completed Ey deleted C asdf 3 abd e Ei Test IN Marked fortified food is terribly old CJ Special Dietary Food 3 Dia 5 Gluten Free Negation Marker Operator odie NANUSS privat NANUSS public NANUSS to be checke
9. rmock Jun24 2011 3 24 Jun 13 2011 7 35 rmock Jun 24 20113 3 as rmock rmock Al 1 Blanks Non Blanks Ka Aggregated C Ed value How well does fc bir a Paggana Selected value ha ha En a standard refi y E Jun 13 2011 O IR oam 24 20113 Std Standard error mes Dun 13 2011 8 35 meck hun 24 2011 3 26 L0 Agreed C S lt Nox Deen 13 20118 36 rmok Jun24 20113 26 rmock SP SV gt Min Selected value m Jun 13 2011 8 37 rmock Jun 24 2011 3 26 UnitDegree Brixd 1 jJuni13 20119 39 rmock X Jul22 2011 5 21 Figure 4 2 4 1 I3 FoodCASE Admi ell X File Help User administration EuroFIR Thesauri User Thesauri Versioning Food Indexer LanguaL Data Quality Analysis Data Quality Analysis Toolkit Administration Quality Entities Quality Entity Filter Quality Requirements Quality Assessments Run Quality Assessment Quality Assessment Timer Maintenance Quality Requirements Pm Description 1 Aggregated if acquisition type 1 jReference 2 Single Comp if acquisition type ET Jun 24 2011 26 PM Dun 24 2011 3 58 43 PM Dun 24 2011 3 58 8PM Jun 24 2011 3 59 46 PM Dun 24 2011 3 59 38PM Show rows where Mutation Ignore time 1 Agg De is greater than or equal to
10. 4 NANUSS public Et Record status 8 4 is terribly old Test Data Repository td Marked EW Special Dietary Food Ep SGE BAG Gluten Free 3 ia NANUSS privat po Tagak remove Dian Beet Name completed Name Figure 6 4 1 3 37 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Note Any incidental or undesired deletion of markers can be abolished with Cancel buttons however the Cancel button is not more aclive after the Save button was used There are Cancel buttons that are specific solely for single and aggregated sections and the Cancel button applicable for the whole tab in the right lower corner of the tab 6 4 2 Unit Conversions The Unit Conversions are useful for converting commonly applied household measures like spoon cup or egg into standard measure units When defining a recipe compiler does not need to convert eggs into e g grams just enters number of eggs and the application coverts it into standard measure unit by using specific conversion factor defined by compiler 6 4 2 1 Defining New Unit Conversion Before a unit conversion is defined user must add a source unit into the Units tab in the User Thesauri register for more details and procedure see chapter 6 4 4 Units Procedure 1 Go to the User Thesauri register and select the Unit Conversions tab Figure 6 4 2 1 1 2 Click the New button to add a new row in the tab Figure 6 4 2 1 2 3 Select source and t
11. Sep3 2007 kpresser o 10 fpPersonlc jP onge Sep3 2007 kpresser Sep 3 2007 kpresser H Productia GE o 15 Reference X 3 ewhen J ep 3 2007 kpresser B Sep 3 2007 kpresser Figure 4 2 1 1 Standard EuroFIR Vocabularies ace Types Value Types Method Indicators Id Additiona Descriptor Scope Note Synonyms Code Creation Creation by Mutation Mutation Article in Used eithe Sep 3 2007 kpresser Sep 3 2007 kpresser more nor Brideimi ai Sepa 2007 kpresser Sep 3 2007 presser 4 Arficlein JAR Sep3 2007 kpresser Sep 3 2007 kpresser H Bok 8 jSep3 2007 kpresser Sep 3 2007 kpresser H JBouraliss Use with e E Sep3 2007kpresser Sep 3 2007 kpresser E else Other refe Other refe E Sep3 2007 kpresser Sep3 2007 kpresser 5 11 JPamphlet jUsefora PA Sep 3 2007 kpresser Sep 3 2007 kpresser 10 Personalc Personalc E Sep 3 2007 kpresser Sep3 2007 kpresser o a JProductla jUsefora L JSep3 2007 kpresser Sep 3 2007 kpresser Si fReferene Usewhen X JSep3 2007 kpresser BB Sep3 2007 kpresser Figure 4 2 1 2 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 File Help Versioning Food Indexer LanguaL Data Quality Analysis Create a new version Version name Creating a new versian will copy all data from the
12. User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 File Help User administration EuroFIR Thesauri User Thesauri Versioning Food Indexer LanguaL Data Quality Analysis Standard User Vocabularies Markers Unit Conversions Recipe Preparation Methods Units Method Indicator Defaults Descriptor Scope Note Additional Info 92 Karltest 93 Tasse Cappuccino Cafetier Verband 102 cl centilitres 9 1 TESTCODE this is a testcode use if no comp in comp thes Do 102 cl nd Scope Note 3 Synonyms Unit is used for Measuring Unit is used for Recipies Figure 6 4 4 1 3 6 4 4 2 Updating Unit Go to the User Thesauri register and select the Units tab Figure 6 4 4 Left click on an item and click the Edit button to activate the item for modification Change the unit Figure 6 4 4 2 1 Click the Save button to store the change Compiler Client must be restarted to update list of units Figure 6 4 4 2 2 ps ANA 47 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Additional Info Is For Value Is For Cooking o vebod WI 102 cl centilitres Eq E sibs tablespoon ff B5 91 TESTCODE thisisatestcode _ use if no comp in comp thes Mo J Id Code Descriptor Scope Note Additional Info Synonyms Unit is used for Measuring Unit is used for Recipies Figure 6 4 4 2 1 Standard User V
13. draft 1 May 2013 6 3 9 Component Groups lt is a list of EuroFIR component groups Column Parent indicates superior group Figure 6 3 9 File Help General Setting User Administration EuroFIR Thesauri User Thesauri Versioning Food Indexer LanguaL Data Quality Analysis Standard EuroFIR Vocabularies Components Acquisition Types Units Matrix Units Reference Types Value Types Method Types Method Indicators Component Groups Id Code Descriptor Scope Note Synonyms Parent Additional Info Creation Creation by Mutation Mutation 310 GRP STERL Sterols This term is for CLASSIFICATI May 25 2 IUnwin May 25 2010 IUnwin 312 GRP SUGAR Sugars This term is for CLASSIFICATI May 25 2 IUnwin May 25 2010 IUnwin 313 GRP SUGFB Sugars in fibre This term is for CLASSIFICATI May 25 2 IUnwin May 25 2010 IUnwin 311 GRP SUGOH Sugar alcohols This term is for CLASSIFICATI Sugar alcohols IM M ay 25 2 IUnwin May 25 2010 IUnwin 321 GRP VIT Vitamins This term is for CLASSIFICATI ay 25 2 IUnwin Ma 25 2010 IUnwin GRP VITA Vitamin A and related components This term is for CLASSIFICATI May 25 2 IUnwin May 25 2010 IUnwin 316 Vitamin B components This term is for CLASSIFICATI 322 May 25 2 IUnwin May 25 2010 IUnwin 317 Vitamin C components This term is for CLASSIFICATI 322 May 25 2
14. 4 2 2 2 41 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 al 299 sy MERE egg s s Alt tea spoon 9 ram 18 BEE EE rest m ite et 35 Ries L2 Aa centlitres Id 10 Source Unit 1 litre Target Unit ml millilitre Conversion Multiplier 1000 Figure 6 4 2 2 3 6 4 3 Recipe Preparation Methods Recipe Preparation Methods tab Figure 6 4 3 includes list of cooking methods that can be applied for recipe calculation in Compiler Client Here in Administration Tool user can modify cooking methods In addition to standardized EuroFIR methods which are based on facet G in LanguaL user can add own cooking methods and its description Cooking methods are connected with retention factors and thus when a method is selected particular retention factors are applied for component values of ingredients during recipe calculation Note Each food must be correctly classified in the Aggregated food detail window before it is selected for recipe calculation because retention factors are dependent on the cooking method and on the EuroFIR food classification 42 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 File Help User administration EuroFIR Thesauri User Thesauri Versioning Food Indexer LanguaL Data Quality Analysis Standard User Vocabularies Markers Unit Conversions Recipe Preparation Metho
15. Custom AutoFilter 10 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 4 2 5 Colour Conventions and Indicators White fields active text fields accessible for modification Grey fields and texts read only fields and buttons not accessible for modification or use 4 2 6 Working with Registers Opening Adding Editing and Deleting Record Modifications of descriptors are partially limited since Administration Tool contains standardized thesauri and coding systems that are generally recognized by European compiler organisations and their proper use is essential for data compatibility Thus arbitrary modification is undesirable and hence the modification of the EuroFIR thesauri are not allowed All these thesauri are located in the EuroFIR Thesauri tab Users with administrator rights are allowed to modify the General Settings User Administration User Thesauri Versioning and Data Quality Analysis registers Opening Record There are two possible ways for opening a record e Single click on a record displays detail at the bottom of the tag Figure 4 2 6 1 This is applicable in all registers except for Quality Assessment register e Double click on a record or click on the Open button opens a detail window of a record This is valid in the Quality Assessment register only User can modify particular record in detail window Figure 4 2 6 2 11 User Manual for FoodCASE Administration Tool 1 4 5 draf
16. D I L JO0t2L20 reser Sep 3 2007 kpresser 5k kilogram 150100 92 W W loct21 20 lkpresser Sep3 2007kprser 690 AJ Ikilojoule LI g50100192 W loct21 20 lkpresser Sep3 2007kpeser 2 e 310 Volume unit outside ISO 1000 Y W JOc21 20 preser Sep3 2007kpreser 8mg milligram 50100 92 W JOt2L20 kpreser Sep3 2007kpressr 9m qmilltre amp Multiple of volume unit litre v v JOct21 20 kpresser Sep3 2007 kpresser 10mmo millimole A 50100 1992 n W JOc2L20 kpreser Sep3 2007kprsser 11MSE monosaccharide equivalent IMSE 1ggucse amp v JOd2120 Kkpreser Sep3 2007kpresr 12NE Iniacinequivalent Wi JQjOd2L20 kreser Sep3 2007kpeser 13ng pengam 50100 92 W Joct21 20 kpresser Sep3 2007kprser MR pqeo 9 Jusdfrpo le D I wv Oct 21 20 kpresser Sep3 2007 kpresser 15gRE retinolequivalent UseforReti 1 RE 1ugalransreino V Oct21 20 kpresser Sep3 2007 kpresser l ug microgram 501000 992Thedescripor Y _ JOc2120 kpreser Sep3 2007kpreser 17u
17. IUnwin May 25 2010 IUnwin 318 Vitamin D components This term is for CLASSIFICATI 276 May 25 2 IUnwin May 25 2010 IUnwin 319 GRP Vitamin E components This term is for CLASSIFICATI 276 May 25 2 IUnwin May 25 2010 IUnwin 276 GRP VITFAT Fat soluble vitamins This term is for CLASSIFICATI 321 May 25 2 IUnwin May 25 2010 IUnwin 322 GRP VITH20 Water soluble vitamins This term is for CLASSIFICATI 321 May 25 2 IUnwin May 25 2010 IUnwin 320 GRP VITK Vitamin K components This term is for CLASSIFICATI 276 May 25 2 IUnwin May 25 2010 IUnwin Id 315 Code GRP VITA Parent 276 Descriptor Vitamin A and related components Scope Note This term is for CLASSIFICATION ONLY DO NOT USE term to identify a specific component Use a more precise narrower term Additional Info Synonyms Figure 6 3 9 6 4 User Thesauri It is a register for additional thesauri The title itself evokes that user can modify them by own Those are Markers Unit Conversions Recipe Preparation Methods Units and Method Indicator Defaults 6 4 1 Markers Markers are indexing terms used for food or component value identification Here in FoodCASE Administration Tool they can be defined by user The tab for markers is split into two sections The left part is for single level database and the right is for the aggregated
18. May 23 2011 3 42 51 PM v Qi And Or 2 Single Comp Is there at least o 1 Aggregated Is there at least o Reie 3 Single Comp Is there at least o Ignore time is less than Jun24 20113 59 24PM Jun 24 2011 3 24 22 PM un 24 2011 3 59 12 PM Jun 24 2011 3 31 08 PM Bun 24 2011 3 31 18 PM _3 Single Comp Is there at least of BL e 3 Single Comp evaluation date NY Single Comp Fthe brand name s Jun 6 2011 5 34 00 P EC Brand name rmock rmo NYE i Single Comp commercial name Dun 201 5 17 EC Commercial a Ee Single Comp If generic name is set Jun 6 2011 5 25 32 P EC Generic name _ rmock mech Sl Comp he ab was ected un 201 6 10 04 PEC Lab acredted mk et 3 1 Single Comp Number of analytical Jun 6 2011 6 21 38 P EC Num analytical sa rmock 3D rmock Sn Comp porton replete Jun 6 201 6 17 24 PEC Porton repieates rmod et 3 1 Single Comp H a standard referenc Jun 6 2011 6 14 07 P EC Reference materi rmock rmock Sing Cop samples were hm Jur 6 2011 6 06 29 P C Samples homoge mack frade Single Comp If samples were stabi Jun 6 2011 6 02 00 P EC Samples stabilize rmock rmock i Aggregated Rating is calculated a Mar 9 2012 7 47 46 ENERC 1 does not fpresser kpresser 162 Time 12 00 Figure 4 2 4 2 Filtered data based on given criteria in
19. References Becker W M ller A Ireland J Roe M Unwin Pakkala H 2008 Proposal for structure and detail of a EuroFIR standard on food composition data Il Technical annex EuroFIR Technical Report D1 8 19 40 p Becker W Unwin I Ireland J M ller A 2007 Proposal for structure and detail of a EuroFIR standard on food composition data Description of standard European Food Information Resource Network 12 p EuroFIR 2013 European Food Information Resource Network http www eurofir eu Schlotke F et al 2000 EUROFOODS Recommendations for Food Composition Database Management and Data Interchange V squez Caicedo A L Bell S Hartmann B 2007 D2 2 9 Report on collection of rules on use of recipe calculation procedures including the use of yield and retention factors for imputing nutrient values for composite foods European Food Information Resource Network 38 p 64
20. aggregated level into the new version 1am sure I want to do this Create New Version Existing versions Creation By Public Raphael Creation Creationby Version Public More Figure 4 2 1 3 4 2 2 Simple Copy and Paste Exporting Individual row can be copied to another application e g Excel Word with Ctrl C and Ctrl V keys Figures 4 2 2 1 and 4 2 2 2 Components Acquisition Types Units Matrix Units Reference Types Value Types Method Types Method Indicators Component Groups Id Code Descriptor Scope Note Additiona Is For Va IsFor Co Synonyms Mutation Mutation Creation Creation by Editable 92 Karltest Y Sep 6 2011 kpresser Sep 6 2011 kpresser Y D C uc ee S ed 2011 esther Sep Z 201 esther _ L Nt eea A561 7 Oct 21 20 kpresser__ Sep 3 2007 kpresser 2BCE pbetacart 1BCE 1 V Meg etene Mari7 2 kpreser Mar17 2 kpreser 22d dee m mE EE v Mari7 2 kpresser Mari7 2 kpreser g am mw EE pensar Bep 3 2007 presser presser fa kel kilocalorie E Oct 21 20 2 Klogam SO 1000 v Oct 21 20 kpresser Sep 3 2007 lkpresser a A AL 0c 21 20 kpresser sep 3 2007 kpresser litre Volume u Oct 21 20 kpresser Sep 3 2007 kpresser TS q microgram ISO 1000 Oct 21 20 kpresser Sep 3 2007 kpresser 17 microlitre ISO
21. elei ei EE 22 6 92 ACQUISIION E Ne 23 AA 23 a AA 25 6 3 0 Relerence TYPES Eden GA NA tant aa haka 26 6 30 Y ale MV DOS RT 27 o te PAA 28 6 35 Oo MOINOGHINGICA ORS EEN 28 039 Component GrONDS er 30 BA User TMG EE 30 641 ILE EE 30 Ada Bepminda WIaIKelS essa han ANA na O 31 o4 1 2 Updaung MAKETS aaah ana A aah 9f 64 1 9 Deleting MARCOS dedere ruth besucht ux NA a ha 37 6 4 2 nlt lee EE 38 64 2 1 Defining New Unit Convera cali 38 04 22 Updating Rull EE ei Ee WEE 40 6 4 3 Recipe Preparation Methods NA aa 42 6 4 3 1 Defining New Cooking Method 43 6 4 3 2 Updating Cooking Method oec acea tics aaa ud abas ui aka aa 43 SE MLB ee 44 6AA Deng New UN sse uerbo ab dest toa o bi o nd te OU 45 eum oa Beeren m op c 47 6 45 Method Indicator DEAU S osa O e lude ge Ulan aNG 49 CAC Own Coding S S Leti a O abeo OL E touc an ovs NG ana cave baa 49 O VEISIORINO mere T cT DE 50 6 5 1 Creating New Database Version errar eererrena nennen nnn nnn nnns inan nnn nnn 50 6 5 2 Numbering the Database Version ios aa Sab Nude aa ka kaaa decode Nan 52 9 555 Marking Version Tor Publishing ahahah Ne deca toli epos co Re Deere GN 52 6 6 Data Quality EEN 52 60 1 General PEC tdi iii TN RP 52 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 SAVE REN UU m TE 52 6 6 3 Quality Entity Finer AA 54 6 6 4 Quality Requirements Aa 55 6 6 5 Quality Assessment tadas 57 6 6 6 Run Qua
22. ffattv arid 1f 11nidentified F16 lIN millinram Mav 25 2 knreccer Mav 25 7 gt Significant digits 3 Figure 6 3 21 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 6 3 1 Components It is a list of EuroFIR component identifiers with codes and recommended measure units The tab includes space for recording complementary Chebi Eurofoods and INFOODS component codes Only values for components ticked for Public will be automatically exported for publishing e g on a website Figure 6 3 1 The thesaurus is in read only mode File Help General Setting User Administration EuroFIR Thesauri User Thesauri Versioning Food Indexer LanguaL Data Quality Analysis Standard EuroFIR Vocabularies Components Id Name Code Public Chebi Compon Eurofoods Import S Standard Remarks Infoods Creation Creation by Mutation Mutation 1998 caproic acid ATTENTIO Jul 19 2010 IUnwin Jul 19 2010 IUnwin MINE smi 1 1 O II E E Bs zb ju ha 19 2010 IUnwin 2000 caprylic acid ATTENTIO ry ol LDL Lo Lo Lo Lo o O Jul 19 2010 ul 19 2010 IUnwin o ps E M RES RES e a ia e e 1 RR Tm 2001 capsanthin CAPSAN Ma 25 de Tunwin un 11 20 IUnwin 55 carbohydr CHO May 25 kpresser Jun 17 20 kpresser C 6llcarbohydr cHor MO May 25 2 lkpresser Jun 18 20 62earbohydr cHOU e 66jarondi COF nees Mik U 20
23. for registered users only 15 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Data Quality Analysis Figure 6 1 1 1 6 1 2 Look 4 Feel The tab enables selection of different colours and defining a title of the Compiler Client application Figures 6 1 2 1 and 6 1 2 2 This helps users distinguish a productive environment from a test environment If users have installed FoodCASE twice once to test some data and functionality test environment and once for their productive data these two settings help faster recognition if one is working in the test or productive environment 16 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 id FoodCASE Admin BE es File Help AJ al ef e ro iit CITE WWII BA LIT IL LT Sa JE EL BR IL LT O MO IE tT a ew Gb ww O E Jm O L Preview D E BE Sample Tex Sample Text pa ka LI Sample Text Sample Text Figure 6 1 2 1 17 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Column so hisa A N Function 503 575 kafeerah em EE 505 624 Kakaopulv Juf p ge Ls ims Kakaopuh Ut BEE 2 Component criteria 1 Component K aaa so jest i il 851 13 X O OK o 7 ses Batch process amp And DO pc Single components 1
24. or folder and enables searching in it and select descriptor record or file User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 And C Or Search liron Create New Version Mark Version for Publication Close Save P Save amp close Run Quality Assessment Register Timer Cancel Timer Reschedule Timer Refresh Radio button only one option is allowed it is applied for searching feature as an operator Searched text field for entering information that is searched Create New Version it creates a new version of the aggregated database i e all data will be copied from the aggregated level into the new version Mark Version for Publication marks particular database version that is ready for publishing Close ends up work in detail window of a record and abandons it If a particular record has been modified a control question asking on saving changes or not precedes closing the window Save saves changes made on a record and leaves the detail window of the record open Save and close saves a change made on a record ends up work in detail window of the record and abandons it Run Quality Assessment launches the quality assessment based on defined parameters Register Timer opens a window for setting a period for automatic data quality assessment run Cancel Timer cancels timer set for a periodic data quality assessment run Resch
25. to group as soon as another tree level Proximates is created within this marker 36 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 6 4 1 2 Updating Markers Markers can be modified e By left click on a marker and simple rewriting of name in the field Name e By left click on a marker and moving it to a different position in the marker tree Moving is possible between single and aggregated level as well Any changes must be confirmed by the Save button Be careful when modifying a marker which is already used for data identification Note Any incidental or undesired modifications on markers and changes can be abolished with Cancel buttons however the Cancel button is not more active after the Save button was used There are Cancel buttons that are specific for single and aggregated sections and the Cancel button applicable for the whole tab in the right lower corner of the tab 6 4 1 3 Deleting Markers Markers can be deleted by left click on a marker and using the Remove button Any changes must be confirmed by the Save button As soon as a marker is used for data identification it cannot be deleted and the application notifies user by a message window about how many times it is used Figure 6 4 1 3 i3 FoodCASE Admin BE File Help Food Indexer LanguaL Data Quality Analysis Code NANUSS privat 5 4 Marked 4 to be checked by PC EH Special Dietary Foods e NANUSS C e Dia food
26. 0 Loo e SSC We Figure 6 2 1 1 Modifying existing user 1 Go to the User administration register Figure 5 1 2 Set cursor on a user 3 Click the Edit button 4 Edit login name name of a user and add a password 5 Click the OK button to save changes Figure 6 2 1 2 Note When a user forgets his her password the administrator cannot give it to him again but the administrator can overwrite the password give this new password to the user 19 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 io ii ean Jf Change this user Username trial Name est Group admin 1 E Mme compler 2 AJ0 0 0 8 pL compiler 2 compiler 2 70 Lo fu fain AB A D admin 1 85 Figure 6 2 1 2 Deleting existing user For removing a user set the cursor on desired user and click the Remove button The user is immediately deleted from the list and losses all access rights for FoodCASE 6 3 EuroFIR Thesauri The register is used for viewing EuroFIR thesauri There are following thesauri included Components Acquisition Types Units Matrix Units Reference Types Value Types Method Types Method Indicators and Component Groups Figure 6 3 EuroFIR thesauri have common concept with following fields code descriptor scope note additional information synonyms and related terms Code and descriptor a
27. 02carotene ATTENTIO Jul 19 2010 IUnwin ut 19 2010 IUnwin 2003 carotene ATTENTIO S Jul 19 2010 IUnwin Jul 19 2010 IUnwin es Tomo CL keh 1 E 0n M Ti 1d 55 Name Code Component group Euro foods Infoods Chebi Public Standard unit gram Remarks significant digits 3 Figure 6 3 1 22 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 6 3 2 Acquisition Types lt is a EuroFIR thesaurus of acquisition types for indication from where information was acquired Figure 6 3 2 The thesaurus is in read only mode File Help General Setting User Administration EuroFIR Thesauri User Thesauri Versioning Food Indexer LanguaL Data Quality Analysis Standard EuroFIR Vocabularies Components Acquisition Types Units Matrix Units Reference Types Value Types Method Types Method Indicators Component Groups Id Code Descriptor Additional Info Scope Note Synonyms Creation Creation by Mutation Mutationby Scientific communication Published articles reports Sep 3 2007 kpresser Sep3 2007 kpresser Independent laboratory Laboratory report protocol Sep 3 2007 Sep 3 2007 Other acquisition type E else other acquisitio Sep 3 2007 k Sep 3 2007 Food composition table database
28. 1000 Oct 21 20 Kpresser Sep 3 2007 kpresser pem 4 2 2 1 Volume unit outside ISO 1000 1992 but recognized by CIPM as having to be retained because of its TI litre practical importance ISO prefixes e g deci centi TRUE TRUE pallida kpresser an kpresser FALSE RES i 15 15 28 543 16 00 00 0 milli micro etc may be attached to the unit to form multiples Figure 4 2 2 2 4 2 3 Ascending Descending Order Left click on the head of the column orders rows in ascending or descending way Ordering is following first are words beginning with special characters e g 1 5 numbers second are words starting in English alphabet and special letters e g close the order User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 4 2 4 Filtering Options in Data Quality Analysis Register Some columns contains drop down arrow which allows filter information in a table Activation of drop down list on column header shows filtering criteria specific to the column Figure 4 2 4 1 Advanced filter can be set to an individual column by selecting Custom functionality and using Custom AutoFilter Figure 4 2 4 2 Data Quality Analysis Toolkit Administration Quality Requirements eme creation Genoa Casa Jo REID type Le Jun 13 2011 7 27 Jun 13 2011 9 57 rmock o cd Jun 13 2011 10 1 tmod bun 24 2011 3 24 Jun 6 2011 3 23
29. 13 Run Quality Assessment 16 04 Contributing values must not be older than 5 years year of generation 42544 Data older than 5 years evaluation date 38238 EC Brand name 328238 El Commercial name 38238 EC Generic name 38238 EC Lab accredited 38238 EC Mum analytical samples 28238 EC Portion replicates 28218 EC Reference material 38238 EXERC bI does not match to the calculated energy Swiss formula 1465 EC Samples homogenised 38238 EC Samples stabilized 28238 Analytical Method 28238 Is component unambiguously 38238 Is food group known 34238 Is matrix unit unequivocal 382238 Is the heat treatment known 28228 Is unit unequivocal 38 38 Humber of analytical samples 38238 Was brand provided 38238 Was commercial name provided 28238 Was consumerz dietary label claim info provided 182238 Hi H EuroFIR Data Quality Analysis Toolkit Administration Run Quality Assessment done 1951 seconds elapsed Every food must have at least 4 component values Fill factor EuroFIR Were samples from more than one location taken Fill factor For every food carbohydrate CHOT or CHO must be provided For every food carbohydrate CHOT or CHO must be provided EuroFIR Were samples from more than one season taken For every food energy must be provided For every food energy must be provided For every food fat must be provided For every food fat must be provided For ev
30. ASE Administration Tool 1 4 5 draft 1 May 2013 4 Getting Started 4 1 Graphic Controls The controls are listed from a major part in a chronological order based on usage of the application Name JC Drop down list displays a list of available descriptors columns categories properties or records and enables choosing one item from the list Single Food Check tick box represents one of two values True or False Tick in the check box field indicates True which in most cases means that the operation is applicable for indicated record GES Colum z Ascending Descending Order click on a header of any META column sorts data in table in either ascending or descending 14 ng l order corresponding to the selected column Note Numbers are ordered first then letters are ordered based on English alphabet and special letters e g are ordered in the end of the list ok Confirm confirms the process or action Cancel Cancel cancels selected option without any change New New New activates or displays empty rows for adding new record i e descriptor code marker condition etc EE Edit Edit makes accessible details of selected record row for modification Remove removes record from the tab Save stores changes on data Reload Reload reload of data Select from thesaurus index search in folder opens standardized thesaurus data table
31. CD management system FoodCASE The manual is divided in several chapters based on the software layout Particular steps of system management can be conducted arbitrary Users can start work with each chapter independently on each other 3 Login and Exit 3 1 Login For starting FoodCASE Administration Tool hereinafter also application user needs a personal user name and a password Figure 3 1 1 The login data are case sensitive As soon as the user is logged in all operations inputs or modifications are recorded under the registered name FoodCASE is a multi user application which means that multiple user can login at the same time FoodCASE is also a client server system which means that a user is working with a client application that is connected to the FoodCASE server which is responsible for the data storage User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Please enter your username and password Username admin Password AAA LAA Figure 3 1 1 lf user name and or password is not correct error message displays Figure 3 1 2 Number of login attempts is not limited Please enter your username and password Username or password incorrect Username Password Figure 3 1 2 3 2 Exit To exit the application use one of the following e Click the Menu File Exit Ctrl Q e Use the Ctrl Q keys e Click the x sign in the upper right corner of the main screen User Manual for FoodC
32. Compiled food composition Sep 3 2007 Sep 3 2007 Industry laboratory Laboratory report protocol Sep3 2007 Sep 3 2007 Food label product information Food label or product infor Sep 3 2007 Sep 3 2007 In house or affiliated laboratory O own in house or affil Sep 3 2007 Sep 3 2007 Published and peer reviewed scientific pa Peer reviewed scientific stu Sep 3 2007 Sep 3 2007 Value created within host system To be used for values creat Sep 3 2007 Sep 3 2007 Acquisition type not known Sep 3 2007 Sep 3 2007 Authoritative Document Use for documents publishe Dec 1 2009 kpresser Dec 1 2009 kpresser T FIO NO OND UE Swine gt TIO kum ole Code F Descriptor Food composition table database Scope Note Compiled food composition table or database Documentation of the underlying data sources varies but further information is generally available e g from the responsible compiler Additional Info Synonyms Figure 6 3 2 6 3 3 Units It is a EuroFIR thesaurus of measure units with additional information and scope notes that enable users apply the descriptors properly for data documentation aggregation and recipe calculation In addition the thesaurus includes overview of additional units added by compilers in the User Thesauri register in the Units tab F
33. Existing versions Creation Creation By May 10 2010 1 54 53 PM Raphael Dec 1 2009 2 34 08 PM kpresser Figure 6 5 1 1 rood CASE Admi File Help Create a new version Version name working version Mar 22 2013 11 47 15 AM porubska May 10 2010 1 54 53 PM REC ihe pee 1 2009 2 34 08 PM kpresser le k Figure 6 5 1 2 51 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 6 5 2 Numbering the Database Versions Database numbers of versions are assigned automatically by software Following principle is applied for numbering different database versions 1 Current version 2 First archived version which is oldest version 3 Second archived version which is the second oldest version n The latest archived version available Anytime a new version of the database is created in the Versioning register it is identified with number following chronologically n 1 6 5 3 Marking Version for Publishing Any version on the list can be marked for publication by setting cursor on a version and click the Mark Version for Publication button or by putting a tick in the check box This version is marked as the public version This mark can for instance be used to show only this data on a website 6 6 Data Quality Analysis This register is used for setting qualitative parameters and frequency of data quality assessment Assessment can be run only in FoodCASE Ad
34. Individual marker turns to group as soon as another tree level is created within this marker Figure 6 4 1 1 6 31 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 EBA NANUSS privat o NANUSS public E special Dietary Foods NANUSS 3 Dia food de to be checked by PC e Paolo d A Record status Et SGE BAG partial bei NANUSS privat checked 4 NANUSS public t completed 4 NANUSS i deleted E to be checked by PC isterribly old bes NANUSS privat Data Repository td NANUSS public EN Special Dietary Food wd NANUSS i 3 t4 to be checked by PC isterribly old added component a amp Data Repository s with no ingredients gt T SGE BAG TE NANUSS privat NANUSS public pog NANUSS 3 i to be checked by PC Figure 6 4 1 1 1 32 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 NANUSS privat kal CS NANUSS public Er Le Special Dietary Foods 44 NANUSS e Dia food i to be checked by PC Edi Record status zd i partial 3 td NANUSS privat checked 4 NANUSS public completed bg NANUSS 3 beg to be checked by PC fortified food regated Value Test sd Marked C A SGE BAG a NANUSS privat NANUSS public A NANUSS to be checked by PC isterribly old added component e Recipe with no ingredients Data Repository E Jp SGE BAG MANUSS privat NANUSS public NANUSS C4 to be
35. User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 FoodCASE v 1 4 5 User Manual for Administration Administration Tool Prepared by Janka Porubska With contribution from Esther Infanger and Karl Presser User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Contents a GN ol TEE A NEN EL Nn EUN 4 IPEA IS OOO AS EE 4 12 Geelen Er eege Le WEE 4 2 ADOUL ne AE UE ASA 4 x 9 Ka AA teins 4 omo 4 A mH HEP 5 SW Eri go Eee AA A A A eee nee 6 A Graphic ONO Sii PAANO NA ANA ee aca ico 6 4 2 General Functionalities of Main Registers eee a 8 d2 COMM EO ace P A 8 4 2 2 Simple Copy and Paste EXPORINO dit 9 429 ASc nding Descending Orde doc 9 4 2 4 Filtering Options in Data Quality Analysis Register nnn0nnnnnnnnnnnnennnnneennrrnnrrrreenrrrnrrrrrenrrennn 10 4 2 5 Colour Conventions and Indcators Aa 11 4 2 6 Working with Registers Opening Adding Editing and Deleting Record 11 5 Main ADPICA MON iii ria Eu EEN 14 o A II nn Sera eee Sores dent sect eae 14 SIMSON Dc em 15 AA E ee eee ee meee 15 5 22 Ment AAA T T O a o au An 15 6 Working with Hegisters erre nennen nennen nnn nnns nana nns ea nnns inar era nan 15 61 219 2 2 Boy a1 90 Sina NA E iia aii 15 sm I BUG Tacna AN naa a NGA As 15 SM BU Eolo M A UP 16 6 2 User Adis UO D osos coo rs iaa uina e Uu dito Vani 18 6 2 1 Adding New Modifying and Deleting Existing User a 18 Ao EUIS E 20 PO
36. arbohyd Use if cont CHO g SUGAR g CARBOHY Dec 1 2009 kpresser Jun15 20 kkabt 45 MI0183 Carbohydrate available ca lt Formula gt Carbohyd Use for av CHO g 100 6 25 N CARBOHY Dec 1 2009 kpresser Jun 15 20 kabt Use only if dietary fibre is A33MICH3 Carbohydrate available ca Formula Carbohyd Useforav CHO g 100 PROT CARBOHY Dec 1 2009 kpresser Juni 2012 kpresser Use only if dietary fibre is 153 MI0001b Carbohydrate EC Nutrition lUseforca CHO g SUGAR g CARBOHY Jun 15 20 kabt_ uni5 20 kabt Corresponds to M10182 14 MI0001 Carbohydrate EC Nutrition lt Formula gt CHOPL Use for ca CHO g SUGAR g CARBOHY Dec 1 2009 kpresser Jun 15 20 lkabt Corresponds to M10182 86 MI0131 Carbohydrate total calcula lt Formula gt Total car CHOT g 100 PRO CARBOHY Dec 1 2009 kpresser Jun15 20 kab 1 A34MICH4 Carbohydrate total calcula lt Formula gt Total car CHOT g 100 PRO CARBOHY Dec 1 2009 kpresser Jun 1 2012 kpreser S8 MI0302 Carotenes total calculated lt Formula gt Total car Thistotal 1 Del 2009 kpreser Dec 1 2009 kpresser 20MI023 Chemical assay Del 2009 kpresser Dec 1 2009 kpress
37. are going to be aggregated may be expressed Figure 6 3 4 This tab is in read only mode File Help EuroFIR Thesauri Food Indexer LanguaL Data Quality Analysis Standard EuroFIR Vocabularies Matrix Units Id Code Descriptor Additional Info Scope Note Synonyms For aggregation Creation Creation by Mutation Mutationby 1D per 100g dry weight Sep 3 2007 kpresser ser 3 2007 kpresser ke perkgdryweight of AL UK Kep 3 2007 kpresser Sep 3 2007 presser 3F per100g total fatty acids not usable foraggregaton Sep 3 2007 kpresser Sep 3 2007 kpresser 4 TF_ per100g total fat not usable for aggregation ll Sep3 2007 kpresser Sep 3 2007 kpresser SN perg nitrogen not usable for aggregation Sep 3 2007 kpresser Sep 3 2007 kpresser 6T pperi00gtotalfod Usedfor data from foods 1 Sep3 2007 kpresser Sep3 2007 kpresser m c E EE ER m per 100ml food volume FZ Sep 3 2007 kpresser SS 3 2007 kpresser SW per 100g edible porton Se 3 2007 ER 10WKG perkgedibleporton O Z 1 j Sep3 2007kpresser Sep3 2007 kpressr HM perlfodvoum QWhenusedfordenst Tl Sep3 2007 kpresser Sep3 2007 kpresser I13FT per g total fat not usable for aggregation sos f Mars 2010 kkpresser Mar 5 2010 kpresser 14VM ppermifoodvoume JWhenusedfordenst ll Mar 5 2010 kp
38. arget units from the drop down lists and define conversion multiplier between these units at the bottom of the window 4 Click the Save button to store the new conversion Compiler Client module must be restarted to update units conversion Figure 6 4 2 1 3 Note Conversions must be defined carefully in order they work properly e g spoon converted into grams is not a precise conversion because foods have different density and spoon different size more detailed specification is e g teaspoon of honey tablespoon of flour 38 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 E FoodCASE Ad File Help L ime cere 109 aee pen quen Qoam B n lrt lo asse Cappuccino Do 7 R ratio kate s O Sites kate 1 2 9 cl centilitres mi millilitre 10 cl centilitres ml millilitre He 58 at tsp tea spoon g gram AN 9cl centilitres mi millilitre a Id Source Unit Target Unit Figure 6 4 2 1 2 39 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 General Setting User Administration EuroFIR Thesauri User Thesauri Food Indexer LanguaL Data Quality Analysis Standard User Vocabularies Unit Conversions Recipe Preparation Methods Units Method Indicator Defaults Source Unit M Unit Factor L dl decilitre o 2 ml millilitre di 3legg s chicken eggts g gram lt tea spoon gram 10
39. ation colour of the field turns to white colour and click the Save or Save and Close button saves the modified information e Modification of information in detail window of a record and click the Save or Save and Close button saves the modified information Deleting Record Deletion is irreversible and can be done by clicking on the Delete button Deletion is possible only for following registers User Administration Quality Assessment Analysis Deletion must be confirmed by clicking on the Yes button or the No button if deletion is not desired Figure 4 2 6 3 7d FoodCASE Admin Belo x File Help User administration EuroFIR Thesauri User Thesauri Versioning Food Indexer LanguaL Data Quality Analysis Data Quality Analysis Toolkit Administration Quality Entities Quality Entity Filter Quality Requirements Quality Assessments Run Quality Assessment Quality Entities niti Display Nome me O e lo Eeer As gregated Component tblaggrfoodcomponent ac idag grfoodcomp ac aq grfoodcomp 1 B A dc d L e 17 Respe ibieepe e Vp recipeidversion L 15 Reference tblreference rf Irfidreference rf referencehidden f 12 Singe component _tplailefoodcomponent_ _estsigglefeodeomp jon theng eerd f on mgc 7 Single Food tblsinglffood f 1000 test entity tbitest tt t idtest t idtest 1
40. celled or rescheduled by using the Cancel Timer and the Reschedule Timer buttons respectively Figure 6 6 7 3 Note The timer can launch the earliest run shortly after midnight of the actual date The shortest frequency for running the analysis is 1 day 61 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Quality Assessment Timer Start Timer not registered Interval Timer not registered Next Execution Timer not registered Figure 6 6 7 1 rocne a Peng File Help Food Indexer LanguaL Data Quality Analysis Data Quality Analysis Toolkit Administration Figure 6 6 7 2 62 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 File Help Data Quality Analysis Toolkit Administration Quality Entities Quality Entity Filter Qualitv EN Quality Assessments Run Quality Assessment Quality Assessment Timer Maintenance Quality Assessment Timer Start 16 00 Interval 1 days Next Execution Tue Feb 19 16 00 00 CET 2013 Reschedule Timer Figure 6 6 7 3 7 FoodCASE Administration Tool vs Compiler Client Application There is no limitation for working on both applications at the same time however changes conducted in Administration Tool are not applied in FoodCASE Compiler Client unless Compiler Client is restarted 63 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013
41. checked by PC Em p Record status partial n amp checked completed a deleted Et Value status i7 reported value documented value isterribly old added component Data Repository Figure 6 4 1 1 2 Highlighted group displays in the field Name 33 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Single Food E SGE BAG NANUSS privat A NANUSS public a NANUSS a to be checked by PC E i Record status p partial checked is terribly old sy Data Repository EH Special Dietary Food 6 New Marker 3 4 Recipe with no ingredients 5 SGE BAG 4 NANUSS privat a NANUSS public NANUSS to be checked by PC E i Record status v partial checked completed 3 4 deleted EK Value status Eu ll reported value 4 documented value DR Test A Marked isterribly old added component amp Data Repository Figure 6 4 1 1 3 New marker integrated into the marker group Special Dietary Food regated Food Test a i 4 Marked bu Special Dietary Foods i ig Dia food Paolo Cu SGE BAG t4 NANUSS privat NANUSS public NANUSS to be checked by PC fortified food regated Value Test 3 Marked CA SGE BAG p NANUSS privat NANUSS public NANUSS i to be checked by PC isterribly old added component amp Data Repository 34 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013
42. d by PC C A Reco 4 amp Marked fortified food is terrihlv old References Versions Single foods Broccoli roh User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Broccoli raw Brombeere roh Brotaufstrich Actilife Bala Blackberry fresh Jun 29 20 Margarine like sprea Brotaufstrich Actilife Bala Jun 29 20 Spread Actilife Balan Brotaufstrich Becel pro a Spread Becel pro act Buchweizenmehl B ndner Gerstensuppe carbohydr alcohol 0 0 7 0 g Food Na comp Wee ees Je MIR003 R MIR003 MIR003 MIROO3 carbohydr chloride cholester 2 2 MIR003 MIRO003 2z0 20 20 20 20 20 energy kJ fat total fatty acids Brunsli fatlyacids 2601 fatty acids MIR003 EY o o Co MIR003 MIR003 MIR003 MIR003 liodide iron total magnesiu WON SIS TI 22 i Lu 10 TI MIRO003 niacin pre Ni MIR003 MIR003 IP D Single Food Ep SGE BAG 3 004 NANUSS privat le NANUSS public NANUSS to be checked by PC EE Record status Pai checked A 4 Proximates e deleted Refresh Batch Process Clear ID Name Batch Process Clear Figure 6 4 1 1 6 Individual marker checked turns
43. database including recipes Altogether there are four entities for which markers can be defined single food single value aggregated food including recipes and aggregated value including values calculated as recipes Figure 6 4 1 1 1 These four entities are blocked for deletion Each entity contains tree structured groups of markers e g main group record status subgroups partial checked completed deleted however it is up to users how they organise their markers 30 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 6 4 1 1 Defining Markers Go to the User Thesauri register and select the Markers tab Figure 6 4 1 1 1 2 By left click select a marker or marker group sub group to which you want add a new marker Selected marker or group displays in the field Name Figure 6 4 1 1 2 3 Click the Add button at the bottom of the particular section to add a new marker The new item integrates into the selected marker group Figure 6 4 1 1 3 4 Rename the New Marker as you desire in the text field Name and fill in description information if relevant Figure 6 4 1 1 4 5 Click the Save button in the lower right corner to save new marker As soon as the marker is saved it can be immediately applied in FoodCASE Compiler Client module Figure 6 4 1 1 5 however if both applications are open at the same time Compiler Client must be restarted to consider changes carried out in Administration Tool Note
44. ds Units Method Indicator Defaults Id Name Description 2 Baked or roasted _ Cooked without moisture covered or uncovered in an oven ROASTING usually applies to meats or nuts Blind baked Use when a pie crust or other pastry is baked without the filling Boiled Cooked in boiling water at 100 degrees C 212 degrees F Boiled and drained Cooked in boiling water at 212 degrees F water that is not absorbed into the food product is discarded after cooking Boiled and undrained Cooked in boiling water at 212 degrees F The water incorporates itself into the product being cooked or is not discardec Boiled in large amount of liquid Cooked in boiling water at 212 degrees F Liquid to solid ratio is greater than 2 1 Boiled in small amount of liquid Braised Browned initially in fat and then tightly covered and cooked over low heat in a small amount of water Broiled or grilled Cooked without moisture under or over intense direct heat Charcoal Broiled Cooked without moisture over direct heat from a charcoal fire Cooked by dry heat Cooked at moderate to high levels of heat in which no liquid is added and only small amounts of fat may be added to pre Cooked by microwave Cooked in a microwave oven Cooked by moist heat If the food absorbs a significant amount of water also used REHYDRATED or WATER ADDED Cooked in varying arr Cooked in small amount of fat or oil Cooked with sufficient fat or oil to coat and moisten the food being
45. ed from related food Useful as separate case where a specific calcula Sep 3 2007 kpresser Sep 3 2007 kpresser imputed estimated imputed estimated from othe Use this Method Type if no further information o kpresser kpresser Sep 3 2007 Sep 3 2007 Sep 3 2007 kpresser Dresser kpresser estimated according to regul kpresser Sep 3 2007 kpresser Other method type kpresser kpresser Method type not known kpresser Sep 3 2007 kpresser no method information available Use for e g Edible proportion for milk of 100 a Dec 1 2009 Sep 3 2007 Estimated according Dresser Dec 1 2009 kpresser R Descriptor calculated as recipe Scope Note Used in case of complete recipe calculation incl NLG factors See food description for further information Figure 6 3 7 6 3 8 Method Indicators Itis a EuroFIR thesaurus of method indicators extended with user method indicators which help assign component value with particular analytical or calculation procedure The column Formula contains a formula in a given syntax so that FoodCASE is able to interpret this formula and calculate the value in the given unit The column Group gives information to which component category group belongs component for which indicator is stated Figure 6 3 8 1 The Usage Notes presents extra condit
46. edule Timer opens a window for resetting timer Refresh clears all search criteria and reloads actual data e g just added or changed from database User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 4 2 General Functionalities of Main Registers 4 2 1 Column Customisation The columns of each tab in the working area are customisable One can move the displayed column to a desired place in the table by clicking on the head of the column and drag it to the desired position Figure 4 2 1 1 and 4 2 1 2 Further in the Versioning and Data Quality Analysis registers columns can be hidden and displayed again by right click on column head and using given options Figure 4 2 1 3 For arranging columns to the default settings close the application Standard EuroFIR Vocabularies Reference Types Component Groups Eee Id Additiona Descriptor pe Note Synonyngs Creation Creation by Mutation Mutation Article n AB ed eithe 1 3 2007 kpresser Sep 3 2007 Dresser ore nor ride in i 2 sep a 2007 kpresser Sep 3 2007 lpresser 3 ticle in AR Beni 2007 kpresser_ Sep3 2007 kpresser 8 ek Eoo GSE PBS F A reg Sepa 2007 reser Sep 3 2007 reser 8 ural iss ate Sep 3 2007 presser Sep 3 207 reser 6JE else Otherrefe E herrefe Sep3 2007 kpresser Sep3 2007 kpresser 11 jPamphlet PA fe fora Sep3 2007 kpresser
47. egated level into the new version Iam sure I want to do this Existing versions Id Creation Creation By Public May 10 2010 1 54 53 PM Raphael Dec 1 2009 2 34 08 PM kpresser Mark Version for Publication Figure 6 5 Here two versions of the database are available the head version is marked for publishing 6 5 1 Creating New Database Version New database version is a snapshot of the head version at a specific time The new version is stored in the archive and is available only for reading Compilers continue working on the head version Procedure 1 Go to the Versioning register 2 Tick the check box am sure want to do this to confirm that and thus confirm that a new version wants to be created Figure 6 5 1 1 3 Enter name of a new version into the text field Version name 4 Click the Create New Version button and new version is created after a while Figure 6 5 1 2 The newly created version can be seen in drop down window of the Version register in FoodCASE Compiler Client Note Name of the version in the field Text can include own numbering naming and dates 50 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Versioning Food Indexer LanguaL Create a new version Version name working version Creating a new version will copy all data from the aggregated level into the new version Y Iam sure I want to do this Create New Version
48. er O 128 MH144 Chromatography lt EurofoodsME code JDeci2009kpreser Deci 2009kpreser 129MH154 Colorimetric method lt Component gt K MG Dec1 2009 kpresser__ Dec 1 2009 kpresser O Z O 18MH013 Colorimety CC Deci 2009 kpresser Deci 2009kprssr 109 MH015 Columnchromatography Eurofoods ME code JDeci 2009Kkpreser Deci 2009kpreser 88 MIO172 Dietary fibre calculated fro Formula Dietaryfi FIBT g FIBINS g F DIETARY Dec 1 2009 kpresser Jun 15 20 kabt 41 MI0171 Dietary fibre calculated fro lt Formula gt Dietary fi Use for di FIBT g CHOT g CH DIETARY Dec 1 2009 kpresser Jun 15 20 kabt Use only if CHO is NOT cal L ZU MRO pieene GN a BEAM 2008 eg Dec 1 2009 presse 156 MIF903 Disaccharides calculated a Disaccharides sum DISAC g LACS g DISACCHA Jun 15 20 kabt Jun15 20 kat YY E 41 MI0171 Dietary fibre calculated from total carbohydrates and available carbohydrate FIBT g CHOT g CHO g DIETARY FIBRE mm a Additional info a New Figure 6 3 8 1 ID Code Descriptor Additional Info Scope Note Synonyms Formula 154 MIF900 Am
49. ery food protein must be provided For every food protein must be provided For every ingredient amount must be gt 0 For every ingredient at least one preparation method should be specified For homemade food recipe description must be provided For homemade food recipe description must be provided If FAT 0 or logical sero then all other fatty acids can exists but not gt 0 If FAT 0 or logical zero then all other fatty acids can exists but not gt 0 Given year cf generation causes generation by to be mandatory How well does food match Is food national representative 85 Init Cache Matrix unit cannot be used for aggregation 84 Init Cache Method indicator known 83 Init Cache Method indicator known Method parameter mandatory for protein calculated from nitrogen Method parameter mandatory for total fatty acids calculated from total fat Minimum length of single food name 572 Method type known 78 Init Cache Minimum length of single food name gt 2 Mustfield English food name Mustfield English food name 75 Init Cache Mustfield EuroFIR classification 74 Init Cache Mustfield EuroFIR classification 23888 FEEEEEEEEEEE Egg EE EEE 4111111111111 e i 81 Init Cache 80 Init Cache o e i Figure 6 6 6 3 60 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 i3 FoodCASE Admin File Help User administration EuroFIR Thesauri User Thesauri Versioning Food Indexer Langua
50. est emp tes des Figure 6 6 2 1 Based on defined condition quality assessment is conducted on the latest actual database at aggregated food aggregated component recipe level and at the test entity Quality assessment is not conducted on the references and on the single database level EE FoodcasE Admin File Help Data Quality Analysis Data Quality Analysis Toolkit Administration Quality Entities eng Geier Ems ge O y E Aggregated Food eT Lr Ree biete tp AS des Dee i mees n referencehidden L 7 sige Food ibong olefood CN idsin glefood f si nglefoodhidden ap i0 festentiy bie lt dot eye Hr Display Name Aggregated Food O O Entity Name tblaggrfood maaga Key Column af idaggrfood Condition af aaarfoodidversion 1 Figure 6 6 2 2 Entities can be modified by use of the Open New and Delete buttons 53 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 6 6 3 Quality Entity Filter It is a table for defining terms for filtering data according to various descriptors when setting criteria for quality assessment analysis For example aggregated components can be filtered based on the Method Indicator thesaurus Figure 6 6 3 1 These filter parameters can be subsequently seen in Data Quality Analysis Toolkit which is accessible via Compiler Client Figure 6 6 3 2 Standard buttons Open New Delete and Refresh are used for setti
51. gregatedFoo Foreveryfoodfat must be provi Jun13 201 rmock Jan17 20 kpresser 139 Aggregated Foo For every food protein must be p n 1 Jun13 201 rmock un 24 20 rmock 140 JggregatedFoo Forhomemadefoodrecipedesc Dun13 201 rmock Jun 24 20 rmock 171 Aggregated Foo If FAT 0 or logical zero thenal Jun13 201 rmock Jun 24 20 rmock IE ACTI pactherl Each food name TY mode CEA oc 143 Aggregated Foo Mustfield EuroFIR classification Jun13 201 rmock Jun 24 20 rmock 144 Aggregated Foo Mustfield restaurant or homema amp Juni13 201 rmock Jun 24 20 jmock 145 Aggregated Foo Mustfield retention factor classifi Jun13 201 rmock Jun24 20 rmock Se oro erre trees 1000 de d eru Foo Rc of all component amounts mm of all n that Mar 8 201 Mad Jan 17 20 ez WEE EE A ier Dvsopicd Foo um of CHO amd FT shaebl aot E ibn caen of CHO anl FEST AA 28 Rcc Aggrec sted Foo Sum of sugar SUGAR and starc ere gar and starc TA AAA TEST TIT AA CA TA Aggregated Foo SY Combination of synonymter un 13 201 mock Jun24 20 mock KT E Figure 6 6 4 1 bed Save A Save amp close e Close Requirement Id 1990 Aggregated Food Sum of all component amounts must be 100g
52. igure 6 3 3 The columns Is For Value and Is For Cooking indicates level at which unit can be applied Application for value means that unit can be used for expression of component content Application for cooking means that unit can be used for defining amounts of ingredients in recipe calculation The last column entitled Editable indicates which units are default defined by EuroFIR and which are added by compilers themselves User can not remove or add tick to an EuroFIR unit Units added by compilers can be set either accessible for modification or blocked Tick in the field means that the unit is modifiable Editable units can be modified in User Thesauri register Changes can be seen after closing and reopening the application However this tab is in read only mode 23 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 EuroFIR Thesauri Food Indexer Langual Standard EuroFIR Vocabularies Scope Note Additional Info Is For Value Is For Cooking Synonyms Mutation Mutation Creation Creation by He LATE alpha tocopherol equivalent 1 ATE 1 mg RRR alpha toco Oct 21 20 kpresser Sep 3 2007 kpresser since etarcarotene equivalent 6CE 11 ug alFtrans betwen JOE 2 28 lpresser Sep 32007 presser IE 3g nm 9 j50100 992 Lil YY DZ 20 kpresser Sep 3 2007 kpresser akal Ikilocalorie M A 4
53. ino acids total essential calculated as sum of individual amino acids Amino acids sum of individual es AAE8 mg 4 51 MI0210 Fatty acids monounsaturated calculated as sum of individual fatty acids cis isomers only lt Formula gt FAMSCIS sum of indi Use for m FAMSCIS g 81 MIO101 Energy calculated according to Southgate kcal lt Formula gt Energy kcal 4xg ENERCcal k 25MI0109 Energy calculated according to EC Nutrition Labelling Directive kJ polydextrose exception lt Formula gt Energy kJ 17 kJ g x Use only if ENERCJ kJ 24 MI0108 Energy calculated according to EC Nutrition Labelling Directive kcal lt Formula gt Energy kcal 4 kcal Use for en ENERCcal kt q MORATA MT Taas nala nen sel ien en ba DO Miikribiaw skhalliss Nien ation LT eres las Panes LIN LAT LUN so Ilan Far an ruro p ENERCI KJ 17 PROT g 17 CHO g 37 FAT g 29 ALC g 13 OA g 10 POLYL g 5 POLYDEXS g ENERGY 7 lt Formula gt Energy kJ 17 kJ g x g PROT 17 ki g h POLY 37 kJ g x g FAT 29 kJ g x g ALC 13 kJ g x g OA 10 kJ g x g POLY 5 kJ g x g POLYDEXS Additional info lt Component gt ENERC yan Use only if CHO is calculated with MI0181 SUGAR g STARCH g or M10182 SUGAR g STARCH g OLSAC g DEXTN g E Usage es New J Edit Figure 6 3 8 2 29 User Manual for FoodCASE Administration Tool 1 4 5
54. ion information for contributing components used in a formula e g Figure 6 3 8 2 28 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 File Help EuroFIR Thesauri Food Indexer Langual Data Quality Analysis Standard EuroFIR Vocabularies Method Indicators Component Groups Additional Info Scope Note Syno Formula Group Creation Creation by Mutation Mutation Usage Notes 127 MI1142 Atomic emission spectrosco lt Eurofoods ME code 59 MI0303 Beta carotene calculated fr lt Formula gt Carotene Use for be 77 CARTBEQ BCE 6 V BETA CA Dec 1 2009 kpresser Jun 15 20 kabt 57 MI0301 Beta carotene equivalent c lt Formula gt beta caro Use for ca 8 CARTBEQ BCE CART BETA CA Deci 2009 kpresser Jun15 20 kab 144 MI1214 Bindingassay lt EurofoodsME code Deci 2009 kpresser Dec 1 2009 kpresser 17MH010 Biasay dA ps Deel 2009 kpresser Dec 1 2009 kpresser 130MI160 Bomb calorimetry lt Component gt ENERA Del 2009 kpreser Dec 1 2009 kpresser U 70 MIRO02 Calculationmethods Thistem Sse 1 2009 kpresser Dec1 2009 kpresser 43 MI0i81 Carbohydrate available cal lt Formula gt Carbohyd Use if only CHO g SUGAR g CARBOHY Dec 1 2009 kpresser Jun 15 20 kabt 44 MI0182 Carbohydrate available cal lt Formula gt C
55. ize of database and number of quality requirements set for data The progress of the analysis is indicated by the green line and by per cent of achieved checks At the same time particular requirements with number of hits on how many records met the requirement are displaying continually Figure 6 6 6 2 There is no special button to stop running of the quality assessment however by closing the application the analysis stops Figure 6 6 6 4 Before quality assessment is launched user should define conditions under which analysis will run e g entities database versions quality conditions etc see chap 6 6 1 6 6 5 Procedure 1 Go to the Run Quality Assessment tab and click the Run Quality Assessment button 2 Enter a name of the run and click the OK button Figure 6 6 6 1 3 The application starts analysis which might take several minutes or even half an hour Figure 6 6 6 2 58 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 4 As soon as the assessment is done Figure 6 6 6 3 user can see the results in the Data Quality Analysis Toolkit in the Compiler Client of FoodCASE Menu File View Data Quality Analysis new Select a quality assessment and analyse them Note For a large database it might be best to start a quality assessment at the end of the day and let it run over night Figure 6 6 6 1 59 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 20
56. known X value type not known Uee when the Value Ty Sep 3 2007 se when the Selected Dec 1 2009 For Value Type AV the average Used when the Selecte IDec1 2009 mn 3 UJ S o y Ga E un Un lt un alue Type N is only u unknown l P us r1 CIC fo 3 co y am Kee gt Use this value type together with a blank Selected Value and with Method Type X if compilation work has shown the value to be unknown i e there is no literature available and no estimation or calculation possible If a Selected Value is present but nothing is known about it origin or derivation etc use value type not known X Value Type N is only useful in the table of aggregated values of a FCDB in cases where there is no Selected Value no statistics etc In cases where the compiler is completely clueless as to what value to assign It signals missing data for future analyses and enables tables to be printed correctly Figure 6 3 6 27 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 6 3 7 Method Types It is a EuroFIR thesaurus of method types which indicates procedure used for obtaining component value Figure 6 3 7 This tab is in read only mode File Help General Setting User Administration EuroFIR Thesauri User Thesauri Versioning Food Indexer LanguaL Data Quality Analysis Standard EuroFIR Vocabularies
57. l Data Quality Analysis Data Quality Analysis Toolkit Administration Quality Entities Quality Entity Filter Quality Requirements Quality Assessments Run Quality Assessment Quality Assessment Timer Maintenance Progress 2 46 56 seconds elapsed Output 161 Run Acquisition type known 225 160 Run Acquisition type known 38238 159 Run At least one ingredient should exist 334 158 Run Acquisition type known 42844 157 Run At least one constributing value should exist 42844 15 Run At least one reference should exist 334 A Are you sure you want to close the admin tool while the quality assessment is still running Figure 6 6 6 4 6 6 7 Quality Assessment Timer In FoodCASE Administration Tool periodicity of the assessment can be set by timer to be carried out regularly When timer is set analysis can run automatically without need to start up any of the applications That means that while only administrator is authorized to set parameters and timer to run the analysis the results of the assessment can be whenever analysed by compilers in Data Quality Analysis Toolkit Procedure for setting cancelling resetting timer 1 Go to the Quality Assessment Timer tab Figure 6 6 7 1 2 Click the Register Timer button 3 Define start time and interval for regular run of analysis Figure 6 6 7 2 and click the Save or Save and Close button 4 Timer can be can
58. lity Assessment a 58 6 6 7 Quality Assessment Tmer a 61 7 FoodCASE Administration Tool vs Compiler Client Application cc eccccceeeeeeeeeeee ees 63 erleedegen RU a a aces 64 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 1 Introduction 1 1 What is FoodCASE FoodCASE Food Composition And System Environment is a computerized food information management system that merges standardized rules and provide an environment for harmonized food composition data FCD compilation It consists of two software applications Compiler Client Module and Administration Tool The former is utilised by compilers for FCD documentation and the latter allows setting properties and parameters applied for documentation and is only available for users with administrator rights 1 2 FoodCASE Administration Tool It is an extra software application of FoodCASE for setting properties and parameters applied for FCD documentation The application is accessible only for compilers with administrator rights Even the administrator himself does not have full rights to modify all settings standard thesauri and other parameters The database system available in the application is based on the European recommendations on food composition databases Schlotke et al 2000 Becker et al 2007 Becker et al 2008 EuroFIR 2013 2 About the Manual This manual gives instructions for managing systems thesauri and quality parameters of F
59. lter by Acquisition Type Filter by Creation User Filter by bd Filter by Method Indicator Filter by Method Type Filter by Mutation User Filter by Unit Data Quality Tree Gather data and do calculation Figure 6 6 3 2 Quality Entity Filter Details When setting quality entity filter Figure 6 6 3 1 all information that can be defined in an SQL statement can be defined 6 6 4 Quality Requirements Here user defines measures for quality assessment For instance measure that check data consistency for sum of all components in food to give 100 Figure 6 6 4 1 and 6 6 4 2 For adding deleting and editing requirements use standard buttons Open New Delete and Refresh However the requirement is described by SQL language and that is why an IT specialist must specify it User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 49 FoodCASE Data Quality Analysis Data Quality Analysis Toolkit Administration ius aggregated Foo ENERC K does not match to th Rating is calculated as follow Mar 9 201 kpresser Mar 9 201 presser Po a EP NA O A TT 172 Aggregated Foo Fillfactor un 15 201 jrmock Jun24 20 jmock 136 JAggregatedFoo Foreveryfood carbohydrate CH amp 1 1 Jun13 201 rmock Jun 24 20 rmock 137 Aggregated Foo For every food energy mustbep 1 1 1 Quni13 201 rmock Jun 24 20 rmock 138 JAg
60. ministration Tool over the current version There are six tabs within this register 6 6 1 General Principles For quality assessment purposes there are applied various principles in FoodCASE that are on the cutting research edge in the area of data quality As data quality is quite complex topic FoodCASE offers maximum flexibility for the definition of quality measurement In order it is necessary that to use SQL like syntax to define some of the measurement parameters These functionalities are described in the following 6 6 2 Quality Entities This is a list of standard entities in FoodCASE Figure 6 6 2 1 Quality entities are used to define on what business object is quality assessed The list of quality entities is complete so that no entities must be added Anyway to modify a quality entity it is helpful to understand the database structure of FoodCASE 52 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 User administration Food Indexer LanguaL Data Quality Analysis Data Quality Analysis Toolkit Administration Quality Entities Quality Entity Filter Quality Requirements Quality Assessments Run Quality Assessment Quality Assessment Timer Maintenance Quality Entities A rhea fin q9 E ia 13 potes Food SE a idaggrfood af o NG 1 gt a 16 Aggregated Component_____ tblaggrfoodcomponent jac ac idaggrfoodcomp _jac aggrfoodcompidversion 1 1 aag 1001 t
61. more amp ISO 1000 1992 The descriptor d Oct21 20 kpresser Sep3 2007kpreser IBPT e Der Cent lever use fo Although most dimensionless p Vi et 21 20 kpresser INov6 2007 lkpresser Pl 22d Jdelite S Mo Jj v Mar 17 2 kpresser Mar 17 2 kpresser__ 23tp fteaspoo Y MaiZ2 kreser Mar 17 2 kpresser 24egs chickenegg s J 0 A Wi Y Ier 2 kpresser Mar 17 2 kpresser 91TESTCOD fhisisatestode useifmoco W TESTTEST Jul15 2010 asdf Quli5 2010asdf W 92lKarltest lo M Sep6 2011 kpresser Sep 6 2011 kpresser W E E e 102 cl centilitres v Fi Mar 21 2 janka por Mar 20 janka por Code dl Es ma A M Do hihihihi O Can be used for measured values Can be used for recipies Synonyms Figure 6 3 3 Users added own descriptors highlighted in red rectangle 24 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 6 3 4 Matrix Units It is a EuroFIR thesaurus of matrix units which is used to express mass quantity for which composition is given Tick in the field of the column For aggregation indicates in which matrix foods which
62. ng filter parameters to an entity Food Indexer LanguaL Data Quality Analysis Data Quality Analysis Toolkit Administration Quality Entity Filter Quality Requirements Quality Entity Filter a iciti 28 Aggregated Component 4 Aggregated Component p O 43 Aggregated Component Method Indicator 4 aggrfoodcompid tblmethodind m M E v ded E MM 142 Aggregated Component Method Type 4 aggrfoodcompid tbimethodtyp m E 22 ated Component 71 Oualit 39 IA gre Component 40 Aggregated Component 41 Aggre gated Component UH Save qf Save amp close yg Close Aggregated Component 16 Aggre gated Component Filter Id 143 27 i 3A nare Food Ti Entity Aggregated Component 21 Aggregated Food qy Filter Name Method Indicator 38 Aggregated Food Mex NEE er Column 9 Aggregated Food 4 aggrfoodcompidmethodindicator Join Table tblmethodindicator m Join Column m idmethodindicator Name Column m methodindicatordescriptor Apply Condtion Figure 6 6 3 1 54 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 s FoodCASE Data C File View Tools Developer Welcome to the FoodCASE Data Quality Analysis Toolkit 1 Please select a data quality analysis tree definition Aggregated Component Data Quality rmock 2011 05 21 22 23 51 921 Specify filter or grouping criteria if desired Fi
63. ocabularies Additional Info Is For ei Is For pak 02 fare oe loved wt 7 102 Lem deciliters a U sfb ESTI L U Additional Info Synonyms Unit is used for Measuring Unit is used for Recipies Figure 6 4 4 2 2 48 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 6 4 5 Method Indicator Defaults For some calculated components there exist two or more calculating methods in EuroFIR Method Indicator Thesaurus In this tab user can set default calculating method for calculated components Figure 6 4 5 and then preferred method is applied for calculation in Compiler Client and user does not have to select it individually Even though user set a default method still there will be possibility to change to another method indicator in the Compiler Client if needed 3d FoodCASE Admi File Help User administration EuroFIR Thesauri User Thesauri Versioning Food Indexer LanguaL Data Quality Analysis Standard User Vocabularies Markers Unit Conversions Recipe Preparation Methods Units Method Indicator Defaults AMINO ACIDS ESSENTIAL Parameters PROTEIN Parameters MONOSACCHARIDES Parameters DISACCHARIDES Parameters SUGAR Parameters STARCH Parameters DIETARY FIBRE Parameters FATTY ACIDS TOTAL Parameters FATTY ACIDS POLYUNSATU Parameters NOTHING SELECTED gt NOTHING SELECTED gt NOTHING SELECTED g
64. on describe in details conditions of measure Type define if the requirement is a hard constraint soft constraint or an indicator Assessment SQL measurement of data quality requirement written in SQL like manner 6 6 5 Quality Assessment Executed runs of quality assessment are listed here The tab indicates who and when carried out the quality assessment Figure 6 6 5 1 The name of the run can be modified using the Open button Figure 6 6 5 2 or run can be deleted completely from the database by using the Delete button Click on the New button redirects user to the Run Quality Assessment tab Data Quality Analysis Toolkit Administration Quality Entities Quality Entity Filter Quality Assessments Run Quality Assessment Quality Assessment Timer Maintenance Quality Assessments bere Stiet ss ea JE 28 test 15 2 13 Feb 15 2013 3 40 33 F Feb 15 2013 4 11 57 P janka Feb 13 2013 5 26 58 P kpresser 6 testa Jan 18 2013 2 15 38 PM Jan 18 2013 2 40 44 P 25 feti ooo o o anna 2013 9 31 06 PM Jan 17 2013 9 58 33 P Figure 6 6 5 1 57 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 m FEOOdCASE Admin SE Lb LI AULES Quality Assessments Quality Assessments test 18 2 13 Figure 6 6 5 2 6 6 6 Run Quality Assessment Here user can launch the quality assessment based on defined parameters The run takes quite long time and length depends on s
65. prepared but not cooked in enough fat or oil to imme Cooked in steam Cooked in water or water based liquid Cooked with added fat or oil Cooked by adding fat or oil to those foods that do not contain fat or oil that would render during the cooking process Cooked with fat or oil Cooked with inherent fat or oil Cooked in fat or oil rendered from the food being prepared 1 Deep fried Cooked in hot fat or oil deep enough to immerse the food entirely Double Steamed Double steaming also called double boiling is a Chinese cooking technique to prepare delicate food such as bird nests Griddled Cooked on a flat surface at medium heat with only a sufficient amount of fat used to prevent sticking Popped Cooked by agitating the food over a dry high heat source resulting in exploding Pressure fried Use when e g meat and cooking oil are brought to high temperatures while pressure is held high enough that the water Rotisserie Rotisserie is a style of roasting where meat is skewered on a spit and revolves over a flame or other heat source The rc Sauteed Cooked in a very small amount of very hot fat turning and browning the food on all sides E Seared Searina for nan seating is a technique used in arillina roastina hraisina saut ina etc that cocks the surface nf the for 137 Name Descriptor
66. rVerband W M 102d centiltres 0 1 0 M fa 91 TESTCODE thisisatestcode luseifnocompincompthes MWM M ld Code Descriptor Scope Note Additional Info Synonyms Unit is used for Measuring Unit is used for Recipies Figure 6 4 4 6 4 4 1 Defining New Unit d 2 3 Go to the User Thesauri register and select the Unit tab Figure 6 4 4 Click the New button to add a new row in the tab Figure 6 4 4 1 1 Define new unit and specify for what purpose it will be applied for value and or for cooking Figure 6 4 4 1 2 Click the Save button to save the new unit Compiler Client must be restarted to update list of units Figure 6 4 4 1 3 45 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 FC ASE Adm File Help Additional Info Is For Va Is For Co Saee Cop 31 rv OA o 10d centilitres WM JW j U SI TESTCODE ue is a testcode use if no comp in comp thes ox o X Additional Info Synonyms Unit is used for Measuring Unit is used for Recipies Figure 6 4 4 1 1 Additional Info Is For et Is For Tm tri Varna mt d cemtilitres IL YA AO bm BETESTOODE fisica testeode _ use Eno comp in comp thes ko Ty tbs tablespoon Additional Info Synonyms Unit is used for Measuring Unit is used for Recipies Ww Figure 6 4 4 1 2 46
67. re mandatory while other fields are optional and are useful for complementary and unambiguous description of a concept Each thesaurus contains column Id which contains database identifiers for listed descriptors and columns indicating who and when created and modified a record oince EuroFIR thesauri are standardized vocabularies that are recognized by compiler organisations they are not modifiable in FoodCASE 20 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Standard EuroFIR Vocabularies Components Acquistion Types Units Matrix Units Reference Types Value Types Method Types Method Indicator Component Groups Id Name Code Chebi Component Group Eurofoods Import Source Standard Remarks Infoods Creation Creation by a l25 ratty acid 16 1 remainder F16 1K milligram May 25 2 kpresser Ma 127 fatty acid 16 1 trans mems pE 3 3 lignan 25 ker bes zi 128fatty acid 16 2 F16 2 J dd LC milligam May 25 2 kpresser May25 2 2053fatyacid 16 2 n 4 ciscis F16 2CN4 o gy 25 2 Unwin 129 fatty acid 16 3 F16 3 Ia milligram May 25 2 kpresser gt 2054fatty acid 16 3 n 3 allcis F16 3CN3 OT A 130fatty acid 16 4 me T Lo ligam ay 25 2 kpresser May 25 2 2055 fatty acid 16 4 n 3 all cis Fue a A 1 O O e 0 121
68. resser Mar 5 2010 kpresser Id Code Descriptor per 100ml food volume Synonyms EE for Aggregation v Figure 6 3 4 25 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 6 3 5 Reference Types It is a EuroFIR thesaurus providing kinds of sources for food composition information Figure 6 3 5 This tab is in read only mode Descriptor Additional Info Scope Note Synonyms Creation Creation by LAB Article in book Used either for a Sep 3 2007 presser Sep 3 2007 28 tArtideinJourmal More normally c 4AR Article in Report Jo 1 Sep 3 2007 kpresser Se B Book _ A sepa E Otherreference type J E else Except Other reference Sep3 2007 kpresser Use for electroni JI poumalisue Use with extrem Use for a refere 0000 10 P Personal communicat ersonal commu Sep 3 2007 ES Pamphlet folder se for a refere Sep3 2007 R Report o Sep3 2007 Sw Software _ Sep3 2007 ww xX FE Sep 3 2007 Reference type not k se when the re Sep 3 2007 Personal communication Personal communication with no further bibliographic information but the reporter s name and address ma S Synonyms Figure 6 3 5 26 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 6 3 6 Value Types It is a EuroFIR thesaurus of value t
69. t Sugar calculated as the sum of total mono and di saccharides Dietary fibre calculated from total carbohydrates and available carbohydrate NOTHING SELECTED gt Figure 6 4 5 Comment The available buttons are not active 6 4 6 Own Coding System In the Compiler Client application there is actually incorporated the Swiss food group categorisation However this categorisation claimed as a user categorisation is without any possible way for modification Here in Admin Tool could be added another tab for Own food group coding system e g for national standard that could be created through Administration Tool and applied in Compiler Client as a local specific standard 49 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 6 5 Versioning The register Versioning gives an overview of archived database versions of aggregated FoodCASE database The head database version is the one on which compilers always work All others are snapshots of the head version created at a specific time Figure 6 5 If the head version is marked for public e g for a website then all changes will be published immediately whenever something in the database has changed File Help User administration EuroFIR Thesauri User Thesauri Versioning Food Indexer LanguaL Data Quality Analysis Create a new version Version name Creating a new version will copy all data from the aggr
70. t 1 May 2013 File Help administration hesauri User Thesauri Versioning Food Indexer LanguaL Data Quality Analysis Standard User Vocabularies Unit Conversions Recipe p1 Id Source Unit Target Unit Factor 9 cl centilitres ml millilitre ifa dedire fi Aj gt 3 egg s chicken egg s g gram SS CC Sogam arts L EI Kartest o BR 2 ml millilitre dl decilitre 100 Eeer Karltest 3 ml millilitre mi millilitre dl decilitre Figure 4 2 6 1 Z3 FoodCASE Admi File Help Data Quality Analysis Toolkit Administration Quality Entities Quality Entity Filter Quality Requirements Quality Entities ac aggrfoodcompidversion 1 17 Recipe tblrecipe rp idrecipe rp Mc mababa 1 L0 Refrenco eec f eres rtreferencehidden P ak Aa tbisinglefoodcomponent c cidsinglefoodcomp join tblsinglefood f on c singlefoo si Food ended of femi lendeodden T ooo __ 100 jestentity bites T T85 3 ag 9etet2 1 o ro recipeidversion 1 Figure 4 2 6 2 12 User Manual for FoodCASE Administration Tool 1 4 5 draft 1 May 2013 Adding New Record Adding a new record can be conducted in all registers except for EuroFIR Thesauri register by using the Add or New button Editing Record There exist two possible ways for record modification e Click on the Edit button makes record details accessible for modific
71. ypes which represent character of component value Figure 6 3 6 This tab is in read only mode FC oodCA SE J File Help EuroFIR Thesauri Food Indexer LanguaL Standard EuroFIR Vocabularies 5 Idvaluetype Valuetypecode Valuetypeadditionalinfo Valuetypedescriptor Valuetypescopenote Valuetypesy Creation Creationby Mutation Mutationby he Selected Value corr Used when the Selecte S mean ep 3 2007 kpresser median UsedwhentheSelecte Sep3 2007 kpressr 3MI TheSelected Value corr minimum _ Use when the Selected 7 Sep 3 2007 kpresser Sep 3 2007 kpresser ANM TheSeleced Value corr maximum UsedwhenheSelected Sep3 2007 kpresser Sep 3 2007 kpresser weighted Heed when the Selecte Sep3 2007 esstan JseonlyiftheSelected Sep3 2007 kpresser Cd LTE cic 3 se only if the Selected Sep 3 2007 kpresser Sep 3 2007 best estimate sed when the Selecte Sep3 2007 3 2007 kpresser EE pu c c S uu 8 W S e Si 3 Sep 3 presse logical zero X jUsedwhentheSelecte Sep 3 2007 kpresser__ Sep 3 2007 kpresser rr o jundecidable Use this Value Type wt SEP 3 2007 kpresser Sep 3 2007 kpresser se this value type toge ep 3 2007 kpresser Sep 3 2007 kpresser else Except for its u other value type 8 Usefor other Value Typ Sep 3 2007 alue type un

Download Pdf Manuals

Related Search

Related Contents

frog-pm4_frog-pm6  Etiquetage des aliments.  SoftBank 204SH 取扱説明書  4 - Hyundai Power Products  （EMM-32）取扱説明書PDFダウンロード（902KB）  ABI PRISM® SNaPshot™ Multiplex Kit Quick Reference Card  取扱説明書 - Bose  BRAZO EXTENSIBLE PARA SELFIES  2 SP2 Partial Rollback  Philips HD2136/05 pressure cooker  

Copyright © All rights reserved. Failed to retrieve file