ERFP Workshop 30 April – 2 May 2009 Reykjavik, Iceland

Exporting data for EFABIS ERFP Workshop30 April – 2 May 2009Reykjavik, Iceland Action EFABISnet AGRI GEN RES 020 receives financial support from the European Commission, Genetic Resources in Agriculture, under European Commission Council Regulation (EC) No 870/2004 AGRI GEN RES 2006 EFABISnet

Outline • EFABIS system • CryoWEB • Exchange protocol • Export data from CryoWeb • Import data in EFABIS

EFABIS system • European Farm Animal Biodiversity Information System • A network of national and regional database exchanging breeds, contacts and library data • For more information see the help and FAQ on http://efabis.tzv.fal.de

EFABIS system II

Population and conservation statistics Population statistics per year are recorded for each breed The total amount of genetic material stored in genebanks are recorded for each breed

CryoWeb Content

Breed totals reported CryoWeb vs FABISnet • Individual animal records • Actual from register

Exchange protocol • CryoWeb contains individual animal data • EFABIS contains cumulated yearly statistics per breed • These cumulated statistics can be generated from the data in CryoWeb • The generated statistics from other systems can be joioned and uploaded in EFABIS

Exchange protocol II The file format is defined in the protocol description The statistics from other systems can be joined at this step

Export data from CryoWeb First click on the ”Main menu” To be able to export data from CryoWeb, you should be logged as a manager

Export data from CryoWeb II First click on the ”Admins” tab Then click on the ”EFABIS export” tab This will bring you to the ”Export data for EFABIS” form

Export data from CryoWeb III Select one or more years from the list To create the export file click the link ”Export data” To select more than one year press and hold Ctrl key and select with the mouse

Export data from CryoWeb IV Click on the link to download the file

Export data from CryoWeb V Choose ”Save file” Click the ”OK” button to save the file to your computer

Export data from CryoWeb VI Semen Oocytes Year Species Somatic cells male Embryos Breed Country Somatic cells female 2006|Galloway|Cattle|Germany|434|434|0|4343|444 2006|Salers|Cattle|Germany|6|321||32131| 2006|Braunvieh alter Zuchtrichtung|Cattle|Germany||3|||23 2006|Blonde d'Aquitaine|Cattle|Germany|||32|| 2006|Deutsche Langschan|Chicken|Germany||||| 2006|Charolais|Cattle|Germany||33||| 2006|Pinzgauer Fleischnutzung|Cattle|Germany||||| Export file format

Import data in EFABIS Log-in as National Coordinator

Import data in EFABIS II Then click on ”Upload conservation data” link Click on ”Enter data” menu item

Import data in EFABIS III Click on the ”Browse” button Then choose from your computer the file exported from CryoWeb

Import data in EFABIS IV Click on the ”Upload file” button to load the data in EFABIS

Import data in EFABIS V Save the report file with the status of loading on your computer

Import data in EFABIS VI Status 2006|Galloway|Cattle|Germany|434|434|0|4343|444->OK-> 2006|Salers|Cattle|Germany|6|321||32131|->OK-> 2006|Braunvieh alter Zuchtrichtung|Cattle|Germany||3|||23->OK-> 2006|Blonde d'Aquitaine|Cattle|Germany|||32||->OK-> 2006|Deutsche Langschan|Chicken|Germany|||||->OK-> 2006|Charolais|Cattle|Germany||33|||->ERR->No population record for this year 2006|Pinzgauer Fleischnutzung|Cattle|Germany||||| Error message

ERFP meeting Reykjavík, 2009 Thank you for your attention!

ERFP Workshop 30 April – 2 May 2009 Reykjavik, Iceland