Workshop 6: FoodCase: Advance users

FoodCASE: Advance users in collaboration with EuroFIR AISBL and Premotec GmbH 

1. Aim of training

Morning sessions

  • Compilers will get familiar with FoodCASE
  • Compilers will practise how to search and find information in FoodCASE
  • Compilers get to know work flow and most important functionalities of FoodCASE
  • Compilers will practise how to input new references, foods and values (incl. duplicate and borrow function)

Afternoon sessions

– How to …

  • Aggregate foods (incl. fatty acid conversion and borrow function)
  • Calculate recipes
  • Change or delete entries
  • Re-computed/recalculate
  • Perform mass operations

– Functionalities of the Admin Client of FoodCASE, and how to …

  • Manage user profiles
  • Manage user thesauri
  • Manage database versions
  • Run a data quality analysis
  • Export and import data
  • Perform basic data quality checks (within the compiler client and with the data quality analysis tool)
  • File bugs in the Redmine system (optional)

2. Programme

08.30-8.45 Arrival of participants

08.45-9.00 Welcome and set-up

09.00-9.30 Theoretical part: Overview

– FoodCASE overview:

  • What is FoodCASE?
  • How/when/by whom was FoodCASE created?
  • Link to EuroFIR
  • Other FoodCASE users
  • Structure (server, application, website etc.)
  • Parts (Food composition, contaminants (risk), intake data)
  • DQA
  • Playground, manual

9.30-10.45 (incl. coffee break)

Practical part 1: Find information in FoodCASE

  • Demo
  • Start programme
  • Login
  • Structure (tabs, left-middle-right panels, top-middle-bottom tables) and functionalities (sort, filter, individualise size of panels/tables and appearance)
  • Search functionalities
  • Versions
  • Do it yourself

10.45-11.30 Practical part 2: Data entry

Create references, single foods and single components (incl. duplication and borrow)

11.30-12.00 Practical part 3: Generate data

(A) Aggregation process (incl. calculation of derived components, conversions and borrow) and selection for publication 

12.00-13.00 Lunch break 

13.00-14.00 Practical part 3: Generate data

(B) Create recipes

(C) Mass operations with clipboard  ditto

14.00-15.00 (incl. coffee break) Practical part 3: Work with admin client

(A) General settings

(B) User management

(C) User thesauri (markers, categories, units, defaults)

(D) Versions management

15.00-15.45 Practical part 4: Additional functionalities

(A) Export (via copy-paste and tools, incl. to EuroFIR FoodExplorer, EFSA) and import data (via import tool and LanguaL Indexer)

15.45-16.00  Wrap up / Evaluation of training


Please bring your laptop. You will need Java for FoodCase-Risk. To test if Java is installed on your laptop, you can use Oracle’s website:, click on the ‘Verify Java version’ button and allow the tool to do all tests.


Siân Astley, EuroFIR AISBL, Tel. +44 (0)754 869 8343, email [email protected]


Science 14 Atrium (, 14b, Rue de la Science, Bruxelles)