Home

Getting Started with the New Online Program

1. Total of lamb weights weaned by the animal avwtwy Average of lamb weights weaned per year for this animal birthyear Animal birth year disdate Disposal date discode Disposal code 63
2. User s Manual 1 Getting Started 1 1 Requirements 1 Ensure the web browser used is Mozilla Firefox If you don t have Firefox it can be installed from this website http www mozilla com Other browsers may cause errors and crash the CGES application 2 If you are idle for more than 30 minutes your session will expire You can test this by reloading 1S the page If that takes you back to the login form then you must login again 3 If you cannot see the top of the screen and it appears that the windows are too high on your screen press F11 This will make the application use the full height Press F11 again to change back 1 2 Logging onto the system Logging 1 Visit http quartet aps uoguelph ca 8080 Sheep Do not forget to use Mozilla Firefox as browser 2 Type in your username and password the username is your ID number e g 1234 and the password is assigned by the office 3 Click on or press enter to continue into the CSGES application 4 Ifyou get the following message Invalid username or password this means there is an error in your username or password Re enter carefully your username and password and press again Login If you still get the error message please contact the technical support Data Entry Service phone 418 856 1200 extension 221 or e mail genovis cepog com Once logged in the CSGES application three tabs can be seen at the top of the screen Start User and Anim
3. for a maternal effect or d for a direct effect gt woe ll Gm d a is an accuracy p is a percentile and this is followed by the trait number see list above d vill r For example gt gdp2 is the percentile for direct growth trait 2 birth weight gt r5isthe EPD for number born later trait Here is the layout of the columns in the file in order Stype number used to sort the file it may be ignored Type Animal type RAM EWE and LAMB if this file is for a particular management group LAMB if for all animals Ropid The producer number Breedgroup The breed group of this animal Mangroup The management group yyyy nn or 0 0 if for all animals Id The animal s tattoo Nid The animal s national ID Sireid The animal s sire s tattoo Sirenid The animal s sire s national ID Damid The animal s dam s tattoo Damnid The animal s dam s national ID Birthdate The animal s birth date yyyy mm dd Sex The animal s sex Inbreeding The animal s inbreeding coefficient Gx Growth Index Gxp Growth Index percentile GMx Growth Maternal Index GMxp Growth Maternal Index percentile Tx Terminal Index Txp Terminal Index percentile TMx Terminal Maternal Index TMxp Terminal Maternal Index percentile ed1 gda1 gdp1 Growth Trait 1 Lamb Survival Direct EPD Accuracy Percentile up
4. 44 Click on the arrow l lt at the end of Y G box to select the management group required and choose the group required This report will produce the EPDs for the parents of the lambs in the management group chosen Select a sort order for the ewes rams with the dropdown box S You can select only the ewes or only the rams by entering F or M in the Sex box sex E If you check the box Use Nat it is the national ID of the ewes and or rams that will appear on the report instead of their tattoo use nat Once the choices are made click on the button to see the report Cancel Press to return to program 2 4 7 Flock Evaluation Report Flock Summary Information Productivity Report This report summarizes the average performance of the flock for a year by breed The current year is broken down by age of ewe as well as listing a total average for the flock This can be used to monitor flock performances Reports amp Exports Choose Flock Productivity Report in the middle box and 7 ock Evaluation Re Vd en S M PDF End Date o zorz uzon ema O is mM t wi tl fF s so 1 2 3 Ja 5 Tel Ka La Jr 41 ba z e 16 1 7 45 2 This report is for a 1 vear period prior to the date you choose in the calendar provided Click on the end date required For example if you want to see the flock report for 2009 key 2009 12 31 or select it in the calendar 3 Clickonthe button to see t
5. Lambing Interval 1 147 days 1 50 day and 100 day weighing interval 28 days Note that these values can be changed by the administration Ovis Appendix 1 The Notion of a Management Group The first notion to consider when wishing to evaluate animals with the GenOvis program is the management group The genetic evaluation program relies heavily on the adequate use of management groups It is therefore important to understand what that means exactly as it forms the basis of an efficient genetic evaluation The notion of management groups Lambs born within the same breed or the same cross having all been born within an interval of 41 days reared in the same place and having received the same food and the same management are considered a management group Lambs of different breeds can be placed in the same rearing group Once the data for genetic evaluation is processed the program will make the distinction between each breed or cross Specifications for weightings and measurements O Weight of lambs at birth taken within 24 hours of birth O Weight at 50 days taken between age of 28 and 69 days but ideally between 35 and 65 days Q Date of the 50 day weigh in Q Weight at 100 days taken between age of 70 and 120 days but ideally between 85 and 115 days Q Date of 100 day weigh in A minimum delay of 28 days must be respected between the 50 day and the 100 day weigh ins Q Thickness of loin eye and dorsal fa
6. CEPOG0264 314197954 2013 04 24 F DP1 AD ZC 2013 4 CEPO97955 CEPO60260 314197955 2013 04 24 F DP1 AD ZC 2013 4 E oiea 314197979 2013 04 28 M DP1 2013 4 l ee 314197980 2013 04 28 F DP1 Disposal Code L e Select 10 e DO comment CC a Transfer nans de i WER in Disposal If an animal passes away it is important to report its disposal This can be done by 1 Inthe EE tab select the management group of the animal you wish to dispose of 2 Press the button 3 Select the animal that you wish to dispose of It is possible to dispose many animals at a time as long as they have the same disposal code and date Animals selected will be underlined in blue 4 Once you have all the animals you need selected press the nere Be box and select the date on the calendar or enter it manually yyyy mm dd 37 5 Select the disposal code isposal Code CBO From the drop down menu Bl 6 You can add some comments in the comment box if needed 7 Press to dispose of animals A pop up will appear asking if you want to dispose these animals It will also tell you 2 animals will be processed Are you sure how many animals you have selected Click on OK to dispose these animals A green message will appear at the bottom of Ca Cancel the window to confirm the disposition 8 Press to return to the dee Lat Note e Comment is optional You can indicate here where your animals were dispos
7. E 1 Type the new password inthe New Password OOOO box 2 Retype the password into the Re enter Password LT box 3 The change Password button will become available press it to save your new password A message will then pop up confirming the success of the password change In order for your password to be accepted indicated by the availability of the Change Password button it must be at least 5 characters long and both boxes must contain identical passwords The passwords are case sensitive ex sheep2015 is different of SHEEP2015 When a new password is entered you can still switch between tabs and bring up reports without F e Change Password losing the information You just need to ensure you press Change Password before logging out l Change Password S and ending your session As well once is pressed your current session will not be ended though when you logout the new password will take effect 10 2 3 Animals The tab allows you to filter through all the raw data of each of your ewes rams and lambs As well it is where you can modifiy animal information enter new lambs add weights add founders upload data and dispose transfer animals You can also access all the reports both individual and group as well as the export files You can also create your breeding group using the GenOvis mating planner Data can be sorted by clicking on the columns heads to sort in ascending or descending orde
8. Generate Tattoo The program will use your flock letters the five last digits of the national ID the year letter and the generation code according to the birth date of the lamb New Animal Tattoo the flock letters chosen at the top of the screen will default into the new animal tattoo box To accept these letters press the right arrow key then key the animal number and TAB or ENTER to the next field The year letter and generation code will be added automatically Your own flock letters should be used as the flock letters for the lamb The animal number can have as many as six digits but it must consist of only numbers All lambs that a ewe gives birth to should be recorded including the dead and mummified and coded with disposal codes appropriately Obviously the dead lambs will usually not have tags so numbers can be made up Some producers use a zero in front of the numbers of siblings For example triplets with one dead may be 24 25 and 025 Others use large numbers that they wouldn t normally use For example 90001 or 9001 Sex The sex of the lamb must be entered as M for rams F for ewes and W for wethers Hermaphrodites can be filled in as F or M but should be identified with the comment code ZW Born As Enter the number of lambs born by the natural dam including those born dead or mummified Raised As This is the number of lambs weaned or the number raised to the 50 day weighing There
9. Lamb Export File Ultrasound CSW Disposal CS Founders CS p 4 Clickon button 5 After submission a result code appears at the bottom of the screen that looks like result7930037860297860277 csv zip Lines Records Inserts 435 433 423 28 Result Code result7930037860297860277 csv zip Lines Records Inserts 435 433 423 Lines Records Inserts 435 433 423 Lines Records Inserts 435 433 423 Explanation The name of the returned file showing any errors Indicates the number of lines in the data file Indicates the number of lines that contain actual animal data must be in proper format according to Ewebyte or CSV Indicates the number of lines that were actually inserted into the system In this case out of 435 lines of data 433 were actual animals to be recorded However only 423 were actually put into the system This indicates that 10 animals contained errors such as the parents not being in the system Section2 3 5 Animals Enter Founders or incorrect tattoos 6 A popup box will show up on the screen Opening result7805580388429279931 csv zip i x You have chosen to open result7805580388429279931 csv zip which is a WinRAR ZIP archive 366 bytes from http quartet aps uoquelph ca 8080 What should Firefox do with this File Open with WinRAR ZIP default D C Save File T Do this automatically For files like this From now on Cancel E
10. Producer GenOvis number Founder tattoo may be blank if being generated Founder breed coded according to the new system Founder birth date yyyy mm dd Founder sex M F Founder dam may be a national id or a tattoo but it must be found in the CSGES database Founder sire may be a national id or a tattoo but it must be found in the CSGES database National Id 9 digits Letters the flock letters to be used for this animal when generating the tattoo See an example in Appendix 5 FounderDam and Foundersire only if known and already entered in the database The tattoo number is generated using the last 4 digits of the national number with your assigned flock letters and the year letter to create the tattoo format needed by the database Leave the column animal tattoo blank and the system will generate automatically a tattoo The same validation rules apply as if you were entering the data manually This file will overwrite any information stored for the animal in the fields listed for this file 34 2 3717 Complete Lamb CSV The file is similar to the Ewebyte file and allows for the uploading of most lamb information using one file 43224 CEPO 2010 7 313681771 CEPO81771XC CEPO5916TC MCW2423UC 2010 11 01 M 2 B 6 1 29 2 2011 01 06 48 4 2011 02 22 2011 03 28 5H 43224 CEPO 2010 7 313681772 CEPO81772XC CEPO5916TC MCW2423UC 2010 11 01 F 2 4 5 2010 12 01 5D 3H File Format Producer FlockLetters the flock letters
11. being downloaded When it is finished double click on the zipped file and choose Open Containing Folder 6 Double click on the folder and it will open Open the file in the folder This file will contain all of your EPDs 7 Press to return to program 2 4 10 Progeny Statistics Export Progeny Stats Export Downloading and Opening the Progeny Statistics Export This program allows you to export the progeny information to a csv file data are separated with comma which is able to be opened in any spreadsheet You have the option of exporting the EPDs from either a selected management group or your entire active flock To do this Reports amp Exports 1 Select Progeny Stats Export from the last dropdown box and Sg la 1 press Progeny Stats Expe e 2 Select Cl current to get only the ewes and the rams that have progeny or all to get information on all the animals you owned and had progeny s click ER 4 A box will pop up telling you when your export is ready Click Ok Export iz ready e Ml s AU 5 A save box will appear shown below Check Open with then OK Opening 43224 5335447828789592189 csv zip x You have chosen to open 43224 5335447828789592189 csv zip which is a WinRAR ZIP archive 30 1 KB from http quartet aps uoguelph ca 8080 What should Firefox do with this File G Open with WinRAR ZIP default DI C Save File T Do this automatically For file
12. dams of the specified group The CSV file that is sent down can easily be opened with your spreadsheet program and manipulated further In this case there are three types of records RAM EWE and LAMB which are indicated in the type column There is also a column called stype which is there to facilitate sorting The rams will come first followed by the ewes and finally the lambs of the group If you select all then the export file will contain all of the animals currently owned by the producer the disposed ones and the ones sold in other flocks This can amount to many animals The type column in this case will always be LAMB This is the layout of the CSV download file containing EPDs accuracies and percentiles produced by the CSGES system The first record of the file contains a list of the variable names which are documented below The latest EPD evaluations are always included in the download A reminder of the traits involved in the new system Growth Reproduction 1 Lamb Survival 1 to 5 1 Age at first lambing 2 Birth Weight kg 2 Number born first lambing 3 Adjusted 50 day weight kg 3 Number weaned first lambing 4 Adjusted 100 day weight kg 4 Lambing interval 5 Ultrasound loin mm 5 Number born later lambings 6 Ultrasound fat mm 6 Number weaned later lambings The variables containing EPD computations are coded as follows gt g for growth or r for reproduction gt m
13. flock inventory or to dispose lambs 24 8 When all animal weights have been entered press to return to the program Notes Remember to always click or press Alt S after each individual animal For entering the 50 and 100 dates you can press the button labelled S to those right of the boxes to set the same date for all animals in that group Ba Date 2013 07 12 T Le 2 3 6 Entering Founders A founder is an adult animal that has not been entered into the Canadian Genetic Evaluation database as a lamb and is not currently in the database Your animals may already be in the database if you have purchased them from a breeder who has participated in a genetic evaluation program through using GenOvis or SFIP in the past 1 Choose the animais tab at the top of the screen 2 On the right hand side of the screen click the button and the following screen will appear Producer 43224 Founder Animals Generate Tattoo tatoo nd Tattoo Dam Breed Tattoo Sire Breed Eu 25 3 Enter Birth Date yyyy mm dd National ID optional Founder Tattoo including the generation code You can enter the number of the animal and press TAB the year letter and the generation code will appear automatically Breed see usage notes below Sex M or F Dam ID and sire ID if known If you know the dam and or the sire of the founder you can indicate them but these animals must previously be present in the datab
14. must be done please contact the office We will process the changes for you 2 Also you cannot change the tattoo Id of an animal This change can be processed only by the Office 3 You cannot edit all the information of animals that were entered as founders Please contact the office We will process the changes for you Producer 43224 Editing animal record for Tattoo CEPO977032ZC Dam Tattoo Birth Weight ka 4d Sire Tattoo 50 Day Wt kg Birth Date 100 Day Wt kg Sex X 100 Day Date k Disposal Date Born As Born Disposal Code Raised As 2 Raised Management Year Comment Code 1 Management Group Comment Code 2 a Recipient ID wm Other Comments 15 1 Select an animal in the main screen underlined in blue and press Edit selected animal This will open the window above 2 You can change all the information contained in the boxes present on the screen You can also add any comments in the box Other Comments 3 When the changes are completed for the animal press the Save button 4 A green message will appear at the bottom of the window close to the save button to indicate that the save was done properly If you get a red message this is because there is an error in the new information entered If you cannot find the error please contact the office 2 3 4 Entering New Animals 2 3 4 1 New Flocks to the CSGES Review animal identification basics section below to ensure t
15. report will show you if you made mistake during the data entry It will indicate you if few lambs are missing It is important to take a look at this report when your data entry is completed If there are errors in the group the lambs of the group won t be included in the next EPD calculation Lamb Repor for Management Group 43224 2011 1 Weighing C E P o g Sylvain Blanchette al E 1642 rue de la Ferme LA POCATIERE QC GORAZO 21 Apr 11 30 Jun 11 Lam h Sire Dam Bibi Date Sex 50 Act Die Gindex LM Dae eed Breed Seed Sith UU T Bom Agi dog D ogre Ida Girdle Wd Foster Aased 100 Act CC index Ln Act Ad Doner Ad Ady CCZ Mat Timdex Eir ot At Corrects GG CEP OS 1S0OB Y C Mona T UC CEPOZOOIWC Jan 271 2017 hM z5 2 El SUVDF A GU DP 4 CEPOS1367C SIMZ2ORIUC CEPOST66TC Jan21 2011 F sutDPI am tr 55 2 One lamb is missing for this POSTS YC JOB CEFOSSSLC Jan z 2011 y SUP A bie 1 1 16 025 1 13 1 53 ZE 36 0 4 1 52 0 43 Ae 1 0 09 003 C EFOS1870YC MOWOE440UC CEPOZIaNL Jan z6 2011 hi 0 54 SUTVDRA GU DFA 0 64 _ 0 55 Jul 2011 430 Ph To add weights to animals that have been previously added to the database use the button To make changes to only one animal in the group use the Edit selected animal button 23 2 3 5 Editing a Group The button allows you to enter the information on 50 and 100 weighing and dates and comment codes after the animal has been entered into the database w
16. 100 2 Day Weight CSV Header ae Ea Dispo Dispo Ge EE Founder CSV Header k j Lamb Tattoo Breed Birth Date Sex Dam Sire National ID Floc GenOvis Letters 43224 DP1 2001 07 05 312357986 CEPO 43224 CEPO33LC 2011 09 07 Optional 312357998 sid en CSV Header Ultrasound Date of Measurement Loin L T Fat1 Fat2 Fat3 D 00 Weight yyyy mm dd gee 43224 CEPOIRC 2009 05 25 compete Lamb Data CSV Header BerGere Export Flock Group sp 43224 EE a mr ee M nra Cass2a cero 2010 a ors2rsos6 cerossrre ceroazrc 20100840 F 2f 1 43324 CEPO 2010 4 CEPOS986XC CEPO357TC CEPO42RC 2010 08 10 M 2 1 Birth D Di Di Geer NAME rta 22 229 50 Day Date 100 Day Date Gd ere pient Weight Weight Ban Date Code 56 32 2010 09 29 45 2010 11 03 2010 11 07 SH EE Mr EE EME SS Ge Code Code 2 3 CEPO56LC fas s mens mum Disposal CSV Header D Lamb ID Disposal Transfer Disposal Comment Comment Comment E New GenOvis Date Ee 1 ER 2 E 3 aa transfer 43224 CEPO5849LC 2011 01 19 oe to Geschl 43224 CEPO5987PC 2010 10 15 1K RB Bailey 43224 CEPO9965XC 2011 02 15 Se ii Lob Appendix 6 EPD Export File To get a CSV export file of the latest EPDs go to the Reports tab and choose EPD Export which Will bring up a popup If you select a year group you will get all of the animals involved in the group along with the sires and
17. 3 313 313 1 to 9 digits S M F or W All the animals corresponding to the information you filled out in the filters will be shown active and disposed animals The number that appears at the left bottom of the screen is the number of animals that are found according to the filters in the management group selected 2 3 2 Information on an Individual Animal First select an animal in the list of animals on the screen underlined in blue Now select the type of individual report you want then press You can access four type of individual reports The Animal Certificate provides information on the animals pedigree and performance data The pedigree lists parentage for four generations The performance data recorded on the animal as a lamb and the current EPD and genetic indexe values are also listed This report can be used to monitor inbreeding and can be forwarded to future buyers The Progeny Report lists each individual progeny of the animal with its basic lamb performance data along with disposal and comment codes This report can be used to look at the individual performance of each progeny of a parent and to determine how many progeny are parents in the flock The Progeny Summary report shows the average performance of all progeny of an animal along with the average EPDs and genetic indexes for those progeny for all traits The summary also calculates the average productivity of the daughters of the animal This report can be use
18. 3 4 2 Animal Identification Basics In order to do genetic evaluations it is necessary to have a system of unique identification of animals so that all animals can be evaluated in one large database For the purposes of the program at this time all animals must be recorded with tattoo format identification If you are using the official national Id for your animals please see the national Id section below This format is made up of flock letters an animal number a year letter and a generation code The generation code is needed in the genetic evaluation database because the year letters repeat after 22 years and there is more than 22 years of data in the database Flock letters are assigned for a fee from Canadian Livestock Records Corporation CLRC for purebred and commercial flocks Commercial flock letters may also be available from your enrolment organization An Example of a Purebred Tattoo for 2013 ABC 123 AD Flock letters ABC Animal number 123 Year letter 2013 A Generation code D An Example of a Commercial Tattoo 5ABC 123 AD Ontario Commercial Flock Number 5 Flock letters ABC Animal number 123 Year letter 2013 A Generation code D Commercial flock letters always have a number in front of the letters Five is the number that signifies Ontario The animal number is assigned by the producer and the year letter is determined by CLRC for all species The year letter allows producers to start numbering their animals at
19. 3H Domp Sire CEPO5472S Birth DP1 SDS CEPO8H SUR Adj JAD Opening Certificate1a pdf xi You have chosen to open x s i Certificate1a pdf 7 When the box is opened select Open with then click OK eens SE from http quartet aps uoguelph ca 8080 What should Firefox do with this file 8 Once the certificate is downloaded you can save it on fOpenwith Adobe Reader defaut sl C Save File your computer select Save as or print it T Do this automatically for files like this from now on Cancel 13 Click here To save Adobe Acrobat Professional Certificatela pdf 9 Press to return to program Performance Certificate CEPO80413X Sum D I 313480413 ur TI CIGL SS CHUAN FD are DR Zug CHUI ui SOS Wa wo AUG Clim CHUN A DS WYANT OF MYW as DJO KYAT Dam CEPOWEL vi Genetic Indecias Path Das 2010 05 01 rpm qw 0 0255 Performance Data Monageren Gioup wars Eon Pa amd Bibi SONMLIAS IADO SMT IOONI IAJ ADG 242 27 2 UM Lori Anal 14 CSGES Different Functions Date format when you have no choice is always yyyy MM dd 2 3 3 Editing Selected Animal allows editing or adding information to an animal that already exists in the database sire dam birth date sex weights and weighing dates national ID comment codes disposal code and date WARNING 1 You cannot edit the information of an animal with progeny If changes
20. 8 7WC 0 2009 10 03 5C File Format Producer GenOvis number Animal tattoo including year letter and generation code Raised as 50 day weight kg 50 day weigh date yyyy mm dd Disposal date yyyy mm dd Disposal code Comment code 1 Comment code 2 Comment code 3 See an example in Appendix 5 The same validation rules apply as if you were entering the data manually This file will overwrite any information stored for the animal in the fields listed for this file 2 3715 100 CSV The file allows you to send in data after the 100 day weighing 43224 CEPO1982WC 27 6 2010 01 19 43224 CEPO1983WC 37 1 2010 01 19 43224 CEPO1984WC 22 2010 01 19 43224 CEPO1985WC 34 5 2010 01 19 File Format Producer GenOvis number Animal tattoo including year letter and generation code 100 day weight kg 100 day weigh date yyyy mm dd 33 Disposal date yyyy mm dd Disposal code Comment code 1 Comment code 2 Comment code 3 See an example in Appendix 5 The same validation rules apply as if you were entering the data manually This file will overwrite any information stored for the animal in the fields listed for this file 2 3716 Founder CSV The file allows uploading of information on parents new to the genetic evaluation database 43224 CEPO1OWC DP1 2009 01 02 F CEPO45PC 43224 CEPO11WC DP1 2009 06 02 M CEPO23UC 43224 CEPO12WC DP1 2009 05 02 F 43224 DP1 2009 06 02 M 310661332 CEPO File Format
21. CPOS JLAISTETT P 2012 08 23 CEPUGILISWE CEROSPLITE CPL CI CEPROS PEITO 114197607 F 2012 08 25 CEFORIONATE CEP ISGGSO Dra e C POST TNIC 314197679 F 2012 08 23 CEPOSOMIWC CEPOSYSITC DPI E CEPOS7676ZC 314197676 F 2012 08 23 CEPOMIZ90WE CEPOSTEIRC DPI e CEPOSTEMIC 314197674 M 2012 08 22 CEPOMNSSWE CEPOSGSITC DPI Led CEPOSIGGRZC 314197665 F 2012 08 21 CEPORDMISME CEROIGT SC BRL El CEPOSTSTSZC 3141976875 M 2012 08 21 CEPOEOITIWC CEPOSOMIWC DM CI CEPS TBC 14197668 M 2012 08 21 CEROBOL 33 EPONA A TC DPL El CEPOS76R 1 ZC 1141478661 M 2012 08 21 CE POBISSIXC CERDaSTASO DPI CEROGT AT 3141907669 F 2012 08 21 C POBOL 23 CEPOENASTO DPI It it the current inventory CI that is shown by default in the main grid 2 3 1 Search Tool filters All animals ever recorded are kept in the database and can be found using the filter boxes at the top of the application To start ver BE Y 09 11 1 Select the year and management group from the dropdown box at the top left of the screen EAF Ets You can select a management group the current inventory Cl or the 2000 younger animals in your flock All 2 Once you click the management group all the animals in that group should be brought up 3 Further filtering can be done by Tattoo Number C7 National ID C and Sex Ex T CEPO 163S completed tattoo or partial you can indicate 163S 163 16 63 Indicate the more information you have to speed up the search N 31
22. Getting Started with the New Online Program User s Manual Canadian Sheep Genetic Evaluation System SWA 2 0 Preliminary version July 19th 2013 Table of Contents 2 APPUCIHON Es td NR o e 2 1 Start N Oo aa Un WM LD Oo WO wo Ww 27 31 31 31 32 33 33 34 2 3 7 1 7 Complete Lamb Data CSV 35 2 3718 Disposal CSV 37 2 3 8 Disposal and Transfers 37 DiC OWS EE 40 2 4 1 Lamb Report rawdata and genetic index in a management group 40 2 4 2 Compact Lamb Report ss L 41 2 4 3 EPD Report Full EPD Report for Lambs in A Management Group o 42 2 4 4 Ewe Inventory Report Inventory of Ewes ss 43 2 4 5 Ram Inventory Report Inventory of Rams 44 2 4 6 EPD Parent Report Full EPD Report for Parents __ 44 2 4 7 Flock Evaluation Report Flock Summary Information _s 45 Fes om od D A EEE nu tnt mn ca us 46 2 4 9 Inventory Export ss 47 2 4 10 Progeny Statistics Export Progeny Stats Export _ _ L 48 2 4 11 Rawdata Report Export Producer 49 2 5 Mating Module coming soon not available yet 3 Other Useful Information 51 3 1 Animal Record Validation 51 Appendices Appendix 1 Management Group Notion Appendix 2 Disposal Codes and Comment Codes Appendix 3 Common Error Codes Appendix 4 Breed codes Appendix 5 Heading Template For Upload Data File Appendix 6 EPD Export file Appendix 7 Progeny Stats Export file Thanks to Delma Kennedy and its team for their help in the realisation of this
23. RAM CEPO2412TC 2 2 2009 3 3 9 43224 CEPO1984WC F 2009 10 03 DPRAM CEPO2412TC 2 2 2009 3 2 8 43224 CEPO1985WC F 2009 10 03 DPRAM CEPO2877TC 1 1 2009 3 3 3 43224 CEPO1986WC M 2009 10 03 DPRAM CEPO2856TC 3 2 2009 3 3 43224 CEPO1987WC M 2009 10 03 DPRAM CEPO2856TC 3 0 2009 3 2 7 2009 03 10 5C 43224 CEPO1988WC M 2009 10 03 DPRAM CEPO2856TC 3 2 2009 3 3 5 File Format Producer GenOvis number Animal tattoo including year letter and generation code Sex M F W wether Birth date yyyy mm dd Sire Tattoo including year letter and generation code Dam Tattoo including year letter and generation code Donor ewe Tattoo including year letter and generation code Foster ewe Tattoo including year letter and generation code Born as Raised as Management group yyyy gg Birth weight Kg Disposal date yyyy mm dd Disposal code Comment code 1 Comment code 2 Comment code 3 See an example in Appendix 5 The same validation rules apply as if you were entering the data manually This file will overwrite any information stored for the animal in the fields listed for this file 32 2 3714 50 CSV The file allows you to send in data after the 50 day weighing The file looks like this 43224 CEPO1982WC 1 13 2009 12 09 43224 CEPO1983WC 2 22 6 2009 12 09 43224 CEPO1984WC 2 13 5 2009 12 09 43224 CEPO1985WC 1 21 5 2009 12 09 43224 CEPO1986WC 2 26 2009 12 09 43224 CEPO19
24. Suffered from White Muscle Disease stiff lamb Sired by Al Suffered from Poisoning Embryo Transplant Appendix 3 Common Error Codes 100 day date 50 day date unreasonable 100 day date birth date unreasonable 100 day weight given withough a date 100 day weight not valid 100 day weight unreasonable 50 day date birth date unreasonable 50 day weight given without a date 50 day weight not valid 50 day weight unreasonable Animal record save for ID failed Bad ROPID Birth date is not a valid date Birth date missing Birth weight unreasonable Breed code missing Breed code not valid Breed code specified for the id not consistent with dam breed Breed code specified for the id not consistent with sire breed Dam exception Dam ID missing Dam ID not found in pedigree Dam national ID not found Dam sex not female Incomplete record Invalid letters Invalid numbers Invalid producer number Invalid record Invalid ROPID Lamb Dam birth date difference error Lambing interval unreasonable Lamb Sire birth date difference error Letters belong to other producer letters in use by letters length must be 2 3 or 4 Loin depth mandatory Management group not valid Management year not valid Management year group not valid Disposal code given without disposal date Disposal code if for ewe and sex not female Disposal code is for ram and sex not male Disposal code not valid Disposal date birth date unreasonabl
25. als Each tab content will be explain in this guide User Animals e All tabs become available once you have made a complete connection to the server Depending on your distance from the database and the speed of your internet connection this may take a few seconds to a few minutes e Be sure to change your password after the first time you login This can be done under the producer tab See below Section 2 2 2 Producer Changing Your Password page 9 for further instructions Logout To logout click on Maia located at the top right corner of the screen This will bring you at the login page All the information that wasn t saved before will be lost 1 3 Important Things to Remember All animals show up on the animals screen in management groups groups of lambs that lambed within 30 days of each other It is also possible to show up the current inventory by selecting CI or the 2000 younger animals of the flock by selecting All If you want to print a lamb report you need to know what management group Cancel Always choose the button to return to the main screen don t use the back button on your browser otherwise you will find you are logged out 1 4 Basic Navigation of the Program 1 To move from tab to tab just click on the tab 2 To find your name and address choose gas tab at top of screen This tab also allows you to change your password whenever you choose 3 To f
26. any of the ewe lambing or lamb codes applies at this time they should be chosen from the drop down list or entered see section 1 3 Disposal and Comment Codes Other Comments This is a memo field which means that text can be typed into it to record any other information that you wish to keep on this animal Save To save the completed record Type Alt S to save the record or click on the save button If successful a Most of the field of the form will be cleared and the cursor put in position to enter the next animal b The following field will remain completed date format flock letters management group dam ID sire ID birth date 50d and 100d weight dates An invalid save will show the specific error in red text at the bottom of the window Most common errors are due to an incorrect sire dam and values that were not entered correctly or were out of range See Section 2 11 Animal Validation below Be sure you use the right date format according of the date format you chose at the beginning Once your data entry session is completed close the popup by clicking on or press ESC to Animal return to the main LS tab at the top of the screen Data validation 22 Animal From the Mma screen select Group report in the scroll menu in the section group report middle box Group report and press Then select the management group and click on to see the animals you have entered This
27. as the reasons This file can be edited and the upload reattempted You can also choose to make changes or enter the animals directly using the Edit selected animal or button 2 3712 Ultrasound CSV The file contains ultrasound measurements for animals that are already in the system and the file looks like this 43224 CEPO1RC 38 1 2005 05 29 22 3 5 8 5 1 4 4 43224 CEPO2RC 43 6 2005 05 29 23 3 5 1 4 7 4 4 43224 CEPO3RC 39 9 2005 05 29 24 0 4 4 4 4 4 7 43224 CEPO4RC 40 8 2005 05 29 23 3 3 7 4 0 5 5 File Format Producer GenOvis number Animal tattoo or national Id including year letter and generation code Animal weight in kg Measurement date yyyy mm dd Loin depth mm Fat depth 1 mm Fat depth 2 mm Fat depth 3 mm The same validation rules apply as if you were entering the data manually This file will overwrite any information stored for the animal in the fields listed for this file 31 Birth CSV 50 CSV 100 CSV The next three upload types were created so the user could upload measurements in three stages after birth after the 50 day weighing and after the 100 day weighing All dates must be formatted yyyy mm dd You cannot use national ID for the moment in these files 2 3713 Birth CSV The file allows you to send in data for a group shortly after birth The file looks like this 43224 CEPO1982WC F 2009 10 03 DPRAM CEPO1552RC 1 1 2009 3 3 43224 CEPO1983WC M 2009 10 03 DP
28. as your password CSGESCVL 9910 43224 CEP ACER ASCO CEPO Open BLOG 5 eee Paswoord must be more than amp characters Producer Information Mew Pan ser prd TH Farm too EH D TEE ee First Nene STTS l eg Last Name Blanchette io iii w ieen city TEPOCANERE 7 Postal Cade BRITO Language French Province quebre country Emsa TI Home Phone 418 eas00 l Work en BEE inbile Phone E rax Emaili Sylvan blanchetie eepagecm ma EE GPS Conrdinates Status Active 2 2 1 Producer Information When new producer information is entered the save button will become available Warning All information having a red asterisk mark must be filled out before pressing the save button If not you cannot save the modifications you made on your profil f you enter new information you can still switch between tabs and bring up reports without losing the information You just need to ensure you press Save before logging out and ending your session Note that GPS coordinates work by entering a pair of numbers separated with a comma that can easily be retrieved from Google Maps example 43 744695 80 436228 If you select Language English then the program will start in English the next time you will log on Your account is already set to be in English 2 2 2 Changing Your Password To change your password Password must be more than 5 characters New Password S O Re enter Password
29. ase optional Breeds can only be entered on founder animals The breed of all progeny will be calculated by the program e When you indicate the breed or crossbreed of a founder you must enter each breed using the good breed code and the breed proportion Each beed must be separated by ex Purbred Dorset DP1 Hybrid DP RV DP1 RV1 Suffolk Romanov SU3 RV1 see Appendix 4 Breed Codes 4 Once the required fields are complete the Save _ button becomes available and when invoked the record is further validated by the server in the context of the entire database Use the mouse to click save _ or use the keyboard shortcut Alt S 5 When all animals have been entered press to return to the program Usage notes If you enter a National ID you must also provide a tattoo because tattoo is the primary identifier for animals in the database If you click the Generate Tattoo box then a Tattoo will be automatically created for the ID based on the letters chosen the last 5 digits of the national Id and the birth date The letters will be those selected but you may change them if the animals come from another producer Regardless though the tattoo must be properly formatted You must enter a proper breed code for the founder For a purebred you must enter the 1 after the breed code ex SU1 purebred If you enter the founder s sire and or dam then the breed code must be consistent with their breed codes For exa
30. at the end of Group box 3 You can choose current Cl ewes that have progeny and have not been disposed and ewes that have an RB comment code or the dams of the listed management groups 4 Once the choices are made click the button to see the report 5 Press to return to program 43 2 4 5 Ram Inventory Report Inventory of Rams This produces a list of either the current rams in your flock or a list of the rams in a specific management group with their average performance information This information can be useful to identify the best Cem 1 Choose Ram Inventory Report in the middle box and Ram Inventory rer O S 0 press ED E sortorder ES Dismiss 2 Click on the arrow ES at the end of the sort box to choose a sort option rams in the flock Reports amp Exports 3 Click on the arrow l lt at the end of Group box You can choose current CI rams that have progeny and have not been disposed and rams that have an RB comment code or the sires of the listed management groups 4 Once the choices are made click the button to see the report 5 Press to return to program 2 4 6 EPD Parent Report Full EPD Parent Report This report provides the full EPD report all EPDs and genetic indexes for the parents of the lambs in a given management group Reports amp Exports 1 Choose EPD Parent Report in the middle box and press e EPO Parent Report O Le re H nl E H Bang
31. be entered by using the button on the main animals screen prior to entering the progeny The dropdown box to the left may be used to select a dam or a sire without taping the all the tattoo When you start to enter a parent ID the list will show you the animals corresponding at your entries You can also enter the national ID of the parents if this information is already CEPO8997TC Dam Tattoo CEPO8997TC CEPOS0461 AC Breed sire or dam not found entered in the database Occasionally there may be a lamb born and the ewe ram can t be identified Use a standard unknown dam sire tattoo This tattoo should be made up of the breed code of the ewe ram and the word ewe ram Le use DPewe DPram for an unknown Polled Dorset ewe ram or SUewe SUram for an unknown Suffolk ewe ram For a ewe ram where the breed is 19 unknown use XX i e XXewe XXram These unknown ewe ram identifications are already in the database and do not have to be entered as founders see Apendix 2 for breed codes Breed This field is calculated by the system Breed can only be recorded on founder animals Birth date This field must be entered in the date format that was chosen at the top of the screen National ID This field is an optional field designed to accept the national identification number for the lamb being entered If you want the program to generate a tattoo ID using the National ID of the animal check the box
32. c information for all lambs in the selected management group using the 50 and 100 day weighing This report can be useful when selecting replacement ewe lambs and flock sires It contains rawdata and genetic indexes of lambs evaluated in the same management group Reports amp Exports 1 Choose Lamb Report in the middle box and press e S a Lamb Report e gt PDF e gt 2013 4 CPP ns 2 20133 3 Click on arrow E at the end of the Year Group Y G box to see a list of management groups Click on the management group required The report will show up on the screen Lambs will be sorted by tattoo within each breed crossbred 5 Clickon button if the report isn t shown on the screen 6 To leave this report and return to the program press the Cancel button 2 4 2 Compact Lamb Report This report provides the basic information the EPDs and the genetic indexes for all lambs in the selected management group using the 50 and 100 day weighing Reports amp Exports 1 Choose Compact Lamb Report in the middle box and press o O gt Compact Lamb Ber e e L 2 Click on arrow ES at the end of the Year Group Y G box to see a list of management groups 3 Click on the management group required The report will show up on the screen Lambs will be sorted by tattoo within each breed crossbred You can select to see all the lambs All or only the undisposed ones Undisposed 5 You can also choo
33. d to monitor how daughters 12 and all progeny kept from a particular ram or ewe are performing This summary is useful when comparing two flock sires The View Ancestor button will allow you to see the genetic evaluation of an animal s ancestors To access these individual reports 1 Choose ii tab at the top of the screen 2 Select the group NOTE you may also enter M or E to see a list of the rams or ewes in a selected group or a specific national id or specific tattoo to see only one individual animal in the list 3 Select any animal by clicking on its row will be underlined in blue BEE Certificate Certificate 4 Select Certificate Progeny Report Progeny Summary or View Ancestors in the scroll menu of the first box then press see IIa Progeny summary above for explanations on these types of reports View ancestors 5 The report will appear on the screen in PDF If the report doesn t appear within few seconds click on PDF 6 You can consult online print or save the file on your computer To be able to save the report on your computer or to print it you must download it first CEPO976962C PDF Page of 1 Automatic Zoom Performance Certificate CEPO976962Z Owner 43224 C E P 0 0 Breed D I Birth Date 2012 12 01 314197696 Breeder 43224 C E P 0 0 a a Click here to dowload the certificate Pedigree SSS CEPO1877H Perfor SS CEP08163P ManagementG SSD CEPO205
34. e Disposal date is not a valid date Disposal date unreasonable for disposal code Flock letters not valid Founder exists and not owned by you ID already in pedigree ID Exception Id exists in database save failed Id has offspring founder save failed ID has offspring pedigree save failed ID is a dam and has progeny ID is a sire and has progeny ID is disposed You may not transfer ID missing ID not found ID not found in animals ID not found in pedigree ID not owned ID not valid Save Pedigree failed Save ultrasound IF failed Sex Missing Sire Exception Sire ID missing Sire ID not found in pedigree Sire national id not found Sire sex not male Tattoo not compatible with birth date Ultrasound date birthdate difference Ultrasound fat 1 depth unreasonable Ultrasound fat 2 depth unreasonable Ultrasound fat 3 depth unreasonable Ultrasound loin depth unreasonable Ultrasound weight mandatory Ultrasound weight unreasonable Must have at least one fat measurement National ID belongs to __ National ID exists in database National ID invalid National ID must be 9 numeric digits New tattoo exists No moves for ID no user given Born as not valid Not found in animals Not found in pedigrees Offspring count complete for dam on date Old tattoo not found Pedigree save failed Producer not found Raised as not valid Rap ROPID Records exists for ID Save animal moves ID amp MOVE DATE failed Save animal mo
35. e file in the folder This file will contain all of your EPDs 8 Press to return to program Refer to Appendix 6 EPD Export File to get the meaning of the headers If you want to substitute the headers to their full names instead of their abbreviations a file on the Blog website is available titled Data Export Headers under the Data Upload Excel Heading Templates on the Documentation Tab 2 4 9 Inventory Export Downloading and Opening the Inventory Export This program allows you to export the information of the EPDs to a csv file data are separated by comma which is able to be opened in any spreadsheet You have the option of exporting the EPDs from either a selected management group or your entire active flock To do this Reports amp Exports OC WB 1 Select Inventory Export from the last dropdown box E and e Inventory Export o press uns E 2 Click EXPORT Export is ready 3 A box will pop up telling you when your export is ready Click Ok 4 A save box will appear shown below Check Open ere x You have chosen to open with t h e n OK 43224 5335447828789592189 csv zip which is a WinRAR ZIP archive 30 1 KB from http quartet aps uoguelph ca 8080 What should Firefox do with this File Open with winRAR ZIP default DI C Save File T Do this automatically For files like this From now on Cancel 4 7 5 A downloads box will then show your file
36. ed Transfer If an animal is sold to another producer on the GenOvis program you can transfer the animal and all of its information to the new owner This can be done by 1 Inthe eis tab select the management group of the animal you wish to transfer 2 Press the button 3 Select the animal that you wish to transfer It is possible to transfer many animals at the same time animals selected will be underlined in blue as long as they have the same disposal code and date 4 Once you have all the animals you need selected press the pe Re box and select the date on the calendar or enter it manually yyyy mm dd 5 Select the disposal code 1K 6K or 5K from the drop down menu H 6 If needed enter pertinent information in the Comments box 7 Select the ROPID GenOvis number of the new animals owner if it is a GenOvis participant in the transfer box ro ig not leave this box blank 38 8 Press to transfer animals A pop up will appear asking if you want to transfer these animals It will also tell you how many animals you have selected Click on OK to transfer these animals A green message will appear at the bottom of the window to confirm the transfer 2 animals will be transferred to C E P 0 Sylvain Blanchette 43224 Are you sure 9 Press to return to the Animais tab Note e Comment is optional You can indicate here where your animals were transferred See Appendix 2 Disposal and c
37. esults file and there are no records it means that there are no further errors and the records are all in the database It is important to enter a B for lambs raised by bottle in the number raised column If you are using BerGere or Ewebyte you should also remove LOUVE BOTTLE in the foster column otherwise the foster name will be LOUVE BOTTLE for these lambs You can also correct this manually after the upload in edit group 1 30 2 3 7 1 Uploading Formats 2 3711 EweByte Lamb Export File The file usually ends with ASC and contains records like this example CEPO10WC F SU 8 250 02 01 2009 CEPO23UC CEPO48PC 2 2 09 01 DP 22 7 03 29 2009 26 0 117 0 0 0 00 0 0 5 3 02 01 2009 CEPO11WC M SU 8 250 02 06 2009 CEPO23UC CEPO8SC 2 2 09 01 DP 0 0 0 0 0 0 00 0 0 FADDPN 02 25 2009 4 8 02 06 2009 CEPO12WC F SU 8 250 02 05 2009 CEPO31UC CEPOSORC 2 2 09 01 DP 20 0 03 29 2009 24 1 110 0 0 0 00 0 0 4 5 02 05 2009 CEPO13WC M SU 8 250 02 06 2009 CEPO23UC CEPO8SC 2 2 09 01 DP 0 0 0 0 0 0 00 0 0 FADD 03 11 2009 3 5 02 06 2009 This file is generated automatically by the Ewebyte program Each record is parsed and considered for insertion into the database The same validation rules apply as if you were entering them manually All data in this file will overwrite anything currently in the database in those fields for that animal As mentioned above a zipped CSV file is sent back to you with any rejections as well
38. file that contains the data must have the lamb information in a specific order and format The format for each file is in Section 2 3 7 1 Uploading Formats below Excel can be used to rearrange columns into the correct format just make sure to save the file as a CSV file 27 C Upload the data Producer 43224 Uploading Data Step T Upload a file by pressing the Upload button The filename will appear in the box below when the upload is complete Step 2 Select the type of upload this file is File Type Eelect upload type Step 3 Press the Process button to add your data to the main database Check the message here for the result of the processing Invalid records will be returned as a CSV file with error messages included Sortir Press in the is tab to bring up a new window Click on button and select the file on your computer you want to upload in the GenOvis program When selected the name of the file will appear in the box under Select the upload file type using the dropdown menu The different upload file types are Step 2 Select the type of upload this file is 1 Ewebyte Lamb Export File Fle Type 2 BerGere Lamb Export File similar as Ste Select upload type Press the Proces the complete data file EweBytes Lamb Export File 3 Ultrasound CSV 4 Birth CSV Check the messaj 50 CSV Invalid records wi Birth CSW 100 CSY 7 Disposal CSV 8 Founders CSV rents Gersere
39. fore if the lamb has been raised on a ewe along with one other lamb you would place a 2 in this column This is regardless of how many lambs were born by the ewe she could have only had a single but raised twins If the lamb has been bottle fed a B is placed in this column A dead lamb is always raised as a 0 if its 5A 5B or 5C If a lamb dies between 10 days and the 50 day weighing 5D consider the lamb raised if it reaches 21 days of age or more Before 21 days of age the Raised As should be zero A bottle lamb that dies should be raised as 0 with a 3U comment code Foster ID This field is used when the lamb has been fostered onto another ewe Complete the sire and dam sections with the identification of the natural parents Put the identification of the 20 foster ewe in the Foster ID field The foster ewe will be entered again as a dam for her own lambs The foster ewe must exist in the database in order to save the information on the lamb being entered Recipient ID In the case of an embryo transfer the recipient ewe or birth mother should be listed as the recipient and the genetic dam eggs donor should be listed as the dam The donor must exist in the database in order to save the information on the lamb being entered Name This is an optional field designed to accommodate the name of an animals as recorded on the pedigree of and animal registered with the CLRC Registration Number This is an opti
40. hat all of your animals can be identified using a tattoo format or an official national ID number The animals don t have to be physically tattooed it is just the format used to identify animals in the database 1 Make an inventory of your breeding animals ewes and rams 2 Itis beneficial in the genetic evaluation system to enter pedigree animals if they are known At this time it is not possible to import the pedigree information from CLRC but it will be possible soon 3 All parents must be entered manually into the system as Founder animals before their lambs can be entered See 2 35 Entering Founders below 4 The system deals with all new lambs as management groups Usually this is a period of about 30 days of lambing Lambs in the same group must be raised in the same environment and feeded the same way 5 Find the function in the right hand menu of the Animals tab Enter the founder tattoo breed breed code following by 1 for purebred ex SU1 birth date aaaa mm dd and sex Breeds can only be entered on founder animals The breed of all progeny will be calculated by the program 6 If the program stats that the animal already exists this means that animal is already in the genetic evaluation system Contact the office to transfer this animal in your GenOvis account 16 7 Once the breeding ewes and rams are in the system the Enter new animals button can be used to enter lambs into a management group 2
41. he report Cancel 4 Press to return to program 2 4 8 EPD Export Downloading and Opening The EPD File This program allows you to export the information of the EPDs to a csv file data are separated by comma which is able to be opened in any spreadsheet You have the option of exporting the EPDs from either a selected management group or your entire active flock To do this Reports amp Exports Ke E mD B 1 Select EPD Export from the last dropdown box and press EBD Expor eo 2 Select the management group the current inventory CI or alls animals of your flock including the ones disposed or transferred to another barn all that you want to export the EPDs for in the dropdown box 3 Click EXPORT Export is ready 4 A box will pop up telling you when your export is ready Click Ok 5 A save box will appear shown below Check Open with x You have chosen to open then OK 43224 5335447828789592189 csv zip which is a WinRAR ZIP archive 30 1 KB From http quartet aps uoguelph ca 8080 What should Firefox do with this file Open with WinRAR ZIP default DI C Save File T Do this automatically For files like this From now on Cancel 46 6 A downloads box will then show your file being downloaded When it is finished double click on the zipped file and choose Open Containing Folder 7 Double click on the folder and it will open Open th
42. ind your animals choose Animals tab at top of screen Reports amp Exports 4 To get reports EPD Ewe and Ram Inventory Lamb Reports etc Certificate e o under Animals tab In the right hand menu select the type of 5 e W Lamb Report e reports you need Reports are classified in three categories Individual Reports Group Reports and Exports EPD Export e 5 To help you to create your breeding groups choose the button located in the right hand menu of the Animals tab By using the expected genetic values and the inbreeding level of the offsprings it is easier to create the breeding groups 6 If you choose a button on the right when in the animals tab you must click to go back to the main animal screen 7 When entering data any field with a triangle Ei at the end of the box means there is an error with the information entered You can click on the triangle and get a list of choices that will fix the problem 8 Click on ECC located in the top right corner of the screen to access the GenOvis blog site 2 Application Tabs 2 1 Start The tab allows you to change the language seen in the application To change the language of the application 1 Click on the arrow to the right of the dropdown box 2 Click on the language you want and all the text will automatically be translated Language English Englizh French 2 2 User The tab allows you to change your producer information as well
43. ithout having to re enter all other information To use this function Choose the Animals tab at the top of the screen 2 Select the management group you wish to add weights in the main grid of the Animals tab 3 On the right hand side of the screen click the button and the following screen will appear Producer 43224 Editing Management Group 2013 4 Keschten Birth Weight kg IS 1 Offspring List CEPO97862AD Tattoo CEPO978454D CEPO97863AD gloas Cos CEPO97954AD EE EE 100 Day Wt kg Cr CEPO979554D Sire Tattoo CEPOS0163YC 100 Day Date CBA CEPO979794D Breed DP1 ERA Birth Date 2013 04 20 ca L Raised As Other Comments Foster ID Aa Recipient ID een National ID 147 ER 4 The list of animals in that group will appear in the box on the left hand side 5 Select the animal tattoo you want to add new weights to from the list of animals in the selected group Clicking on the animal will bring up all the pre existing data for that animal 6 Enter in the 50 or 100 day weight and date in the boxes on the right Click Save and go onto the next animal You can also press ALT S to save the information If all values entered are valid the next animal in the list will come up and its information can be entered 7 If you need to delete an animal press DELETE to remove the selected animal and all its records Warning This button removes definitively this animal and his data Do not use this button the remove animal from the
44. mple if the dam s breed was SU1 RI1 and you enter SU1 for the founder s breed the save will be rejected because it is not possible for the founder s breed not to have RI in it Itis useful to record the sire and or dam if they are known Ifthe program stats that the animal already exists this means that animal is already in the genetic evaluation In that case call the CEPOQ or send an e mail to 26 genovis cepoq com and we will make the transfer for you You aren t able to transfer animals from other flocks by yourself The founders don t have management group When you search them in the main grid select the management group 0 0 2 3 1 Uploading Data Upload data Data that has been recorded in other programs can be uploaded into the program using this button If you can export your data in an excel CSV or comma delimited format you can upload your data electronically There are a number of options depending on the format of your data A Determine the upload type that you will be using Lamb information can be uploaded using e Ewebyte lamb export file e BerGere lamb export file same as the complete lamb CSV e Ultrasound data CSV e Birth CSV 50 CSV 100 CSV e Complete lamb CSV Information on new animals to the system can be uploaded using e Founders CSV Animals can be disposed using e Disposal CSV These formats are further explained in the Upload Formats section 2 3 7 1 B Prepare the file The
45. n show your file being downloaded When it is finished double click on the zipped file and choose Open Containing Folder 49 5 Double click on the folder and it will open Open the file in the folder This file will contain all of your EPDs 50 3 Useful Information 3 1 Animal Record Validation When an animal record save is attempted the following validations are performed a You must be properly logged into the system b The dam specified must be found in the Pedigree and her sex must be F c The sire specified must be found in the Pedigree and his sex must be M d The lamb birth date must be a valid date and must be consistent with the birth dates of the parents see table below This validation is not performed if a phantom sire or dam i e XXram or XXewe where XX is the breed code is used e The breed code of the lamb is computed from the parents f The 50 100 and ultrasound dates are validated as specified in the table g The weights and other measurements are validated h The 100 day date must be at least 28 days greater than the 50 day date i The previous lambing date for the damn must be at least 147 days prior to the current lambing j A Foster ID needs to have lambs within the past 30 days Ranges for Validation of Data Input ariable Minimum Maximum rh ES B Bornas o HE Raisedas oO os BODayWeight Al 28 UltraDayWeight do HL 99 UltraDayFatThickness 0 LJ
46. number one each year if desired For example ABC1JC is different than ABC1KC In this case both animals are probably tagged with number 1 but the first one is born in 1999 and the second one in 2000 All year letters and generation codes are automatically generated for lambs as you enter data according to the birth date that is recorded Once the flock letters and animal number are entered for a lamb press ENTER or TAB to the next field and the year letter and generation code will be added Generation codes do not show up on reports but are visible on the tattoos that you see on the animals screen 17 2 3 4 3 National Identification National identification became mandatory on January 1 2004 Animals are required to be tagged with an official national identification tag when leaving the farm This number can also be used to identify sheep in the genetic evaluation database The program requires the unique identification to be unique forever and to indicate the flock in which the animal was born Currently the national identification is a number between 310 000 000 to 319 999 999 As a result if you use a national Id number in the national Id field and leave the tattoo blank a tattoo number will be generated This is necessary at this time for the pedigree table to work The tattoo number is generated using the last 5 digits of the national number with your assigned flock letters and the year letter to create the tattoo format needed by the da
47. omment codes to get the list of the disposal codes 39 2 4 Reports All information that you have sent to the genetic evaluation program since 1986 in Ontario and 2000 in Quebec is available in the online database Information can be viewed or saved to your computer for the following Reports amp Expo re De ram GREE Ne D sep See O 1 The reports and exports are divided in three categories a Individual Reports Certificate Progeny Report Progeny Summary a mp View Ancestor b Group Reports Lamb Report rawdata and genetic indexes Compact Lamb Report EPD Report full EPD report Ewe Inventory Report O ND wu Ram Inventory Report 10 EPD Parent Report full EPD report 11 Flock Evaluation Report 12 Group Report to validate data entry c Export Files 13 EPD Export 14 Inventory Export 15 Progeny Stats Export 16 Producer Export rawdata 2 Use the arrow ES on the report tab to select the type of report you need 3 Clickon i 4 Select the management group using the arrow 5 If needed you must select a management group or current inventory and different options 6 Click on ais 7 To leave this report and return to the program press the MISS button 40 PDF file are opened in Mozilla Firefox They can also be saved on your computer CSV files are automatically download in a zip file 2 4 1 Lamb Report rawdata and genetic indexes This report provides the basi
48. onal field designed to accommodate the registration number of an animal registered with CLRC Birth Weight kg The completion of this section is optional but if used the weights should be recorded in kilograms to one decimal place Birth weights should be taken in the first 24 hours of life 50 Day Wt kg Enter the actual weight in kilograms to one decimal point If the 50 day weight for the animal has not been taken the weight should be entered later under the DO Ergo button on the Lammas screen 50 Day Date Enter the date that the 50 day weight was taken using the date format chosen The 50 day weights should be taken when the group of lambs is between 35 65 days of age The range of dates accepted is actually 28 to 69 days which provides some flexibility in weigh dates You don t need to weigh each lamb when it is 50 days old Use the Weighing Date Calculator to see on which dates you can weigh the group Different 50 day weight dates can be entered if needed 100 Day Wt kg Enter the actual weight in kilograms to one decimal point If the 100 day weight for the animal has not yet been taken the weight should be entered later under the DEUST button on the D Animais een 100 Day Date Enter the date that the 100 day weight was taken using the date format chosen The 100 day weights should be taken when the group of lambs is between 85 and 115 days of age The range of dates accepted is actually 70 to 120 days which provides
49. or transfer See an example in Appendix 5 NOTE REGARDING NATIONAL ID USE You may use national id for dam sire foster and donor But national Id is used to generate tattoos in the CSGES database for use in the system hence the need for flock letters to be supplied The tattoo is generated from the flock letters the last 5 digits of the national Id number and a year letter and generation code that is determined from the lamb s birth date Producers can still search for animals and generate reports using national Id 36 2 3 8 Disposals and Transfers If an animal has passed away or has been sold it can be disposed or transferred This can be especially useful in smaller flocks when adding animals If instead of typing the dam or sire when adding new lambs you wish to select them from the dropdown box disposals and transfers ensure that your flock is current It is also important to keep up to date because when you print your reports it includes all active animals If animals are not disposed of they remain active in your flock and their information is used in producing reports which may reduce the accuracy Producer 43224 Transfer Disposal Year Group Tattoo Damid_ Natid_ Birthdate Sex Breed Disdate_ Discode CEPO97845 CEPO80256 2013 4 314197845 2013 04 20 F DP1 2013 4 CEPO97062 CEPO00252 314197862 2013 04 21 F DP1 AD ZC 2013 4 CEPO97863 CEPO80247 314197863 2013 04 22 M DP1 AD ZC 2013 4 CEPO97954
50. r of tattoo national Id sex birthday dam id sire id breed disposal code and date CSCES v1 9910 43774 CEPO O 4CERAXCO CEPO T i 5 CC Dis Date CI CERN 7 TUS ZC 314197705 M 2012 12 04 CEPDBDISITE CEPOSBSTUC DPI CH CEbOamenmzt 314107599 M 2012 12 03 CEROBOLAITO CEPOS0TRTC Di Cl CERT TD ZC 314197700 M 2012 12 03 CEPOGDILATYE C FOGOTSTE DPI ke CEPOSIPONIC 314197702 F 2012 12 03 C POSOLEMTE CEPOE0379XE DPL ct CEPOSTFOLZC 314157701 M 2012 12 03 CEPOSATISC CEPOSI2GEWEC DPL El CEEOS7 TAZE 314197704 M 2012 12 03 COFPOBOLEMTE CEPOBDIMRE DPL Cl Le Zeckt re J14197702 M 2012 12 03 CEPOSM FIST CEFOSUIIGEME DPI ei CEPOSTESAZE 14197698 F 2012 12 02 C POBDIEMC CEPOMISITE DPI CI CLPS esac J14197 469 M 2012 12 01 CEPOM PSC CL FORS TIRE DPI e CEPOS7697ZC 314197697 M 2012 11 01 CEPOSM72SC CEPOSISIWC DPI el CEPOS769SZC 314197595 F 2012 09 09 CEPOBO4OSXC CEPOSSISSC DPI Reports amp Exports e CEPOSTEMIC 314187694 M 2011 09 00 CEPORDMOSXC CEPOSSISSC CPL Certificate JO EI CEPOS TBC 3714197693 M 2012 04 08 CEPOBITIOWC CER LOTS Di cl CEPOSTEN2ZC 314197692 M 2012 09 03 CEPOBUISSWC CEPOTASYWGC DPI ki CI CEFROGT BAT 314197656 M 2012 08 26 CEPOBISSENO EPO Ban Lat Es C CERES 314107686 F 2013 08 26 CERDAISSEXC CER SAGM SCO DPI cl EPO 768 5 ZC 314197683 M 2012 06 24 CEPOBLSS IMC CEROSGSETO DPL ke CEEOS767BZC 314197678 F 2012 09 29 CEPOGIMIWO CEROSBEITO DPL CI Cerca 760 2 S14 197601 M 2012 08 25 CEPUMI CEROS TIOS DFL E
51. resul TAOS SAO FOF P9951 cay ip WinRAR evaluation copy Fie Comment Too Farmies pikira He What should Firefox do with this file You are given the option to Open with or Save the file Choose to Open with then press OK You will then see a popup box called Downloads with the result file listed Click on this file and you will see where the computer has stored this file SEI TC ECHT Extract Ta T t CE EM romance cv re ZIP archive unpacked sine SEL bytes E Pakad eee eee Daer Girer TEE er ER 168 Peer CSW Meret 2013 07 04 Ls DEI Ia Bytes p Pie 29 10 11 12 If any errors exist the zipped results CSV file returned will contain the rejected records with a message at the end of the row indicating why it was not inserted Go through each record row and either fix the row for a subsequent upload or delete the row if it is invalid It is preferable to delete the error messages before uploading again the file otherwise you will get two errors in the new file the last one is the new one Save the file as a CSV and upload this file as the same upload type used for your original file If the first upload was a Ewebyte make sure the re upload is still Ewebyte even though it is a CSV file Check the result code at the bottom to see if the fixed lines were recorded as inserts If not open the newly returned CSV file and fix the remaining errors If you open the r
52. s dates as yyyy mm dd However you can choose your preferred date format for entry For example if your selected d m y the following entries will be interpreted as November 1 2010 1 11 10 or 1 11 2010 It is important to respect the order chosen and to add manually the or between the day the month and the year Flock Letters Selecting your flock letters from the pull down menu to pre populate the new animal tattoo field If you are entering lambs into a group with a different set of flock letters you can choose from the pull down or change them manually when the breed changes Enter the management year use the birth year of lambs and the group number must be only number no letter in the boxes Group Count This is a calculated field The Group Count on this popup shows how many animals have been entered into this group so far Dam and Sire Tattoo After the first animal is entered in a session the identification of the dam and the sire will default for entry of the next lamb It is important to enter the complete tattoo flock letters animal number year of birth and generation code or national ID 9 digits of the parent Please note that the generation code changed in 2013 for the letter D Animals born from 1991 to 2013 must have the generation code C The parent must be found in the database If the parent is not in the database you will get a message as sire or dam not found close to the Breed In that case it must
53. s like this From now on core 48 6 A downloads box will then show your file being downloaded When it is finished double click on the zipped file and choose Open Containing Folder 7 Double click on the folder and it will open Open Tota 1 5 betes en dr the file in the folder This file will contain all of your EPDs 8 Press to return to program Refer to Appendix 8 Progeny Stats Export File to get the meaning of the headers If you want to substitute the headers to their full names instead of their abbreviations a file on the Blog website is available titled Progeny Stats Export Headers under the Data Upload Excel Heading Templates on the Documentation Tab 2 4 11 Export Producer Downloading and Opening the Export Producer This export file reported all the rawdata of ewes and rams having progeny in the flock 1 Select Export Producer from the last dropdown box D and press 5 Reports amp Exports la e Export is ready Export producer e 2 A box will pop up telling you when your export is ready Click Ok Dyer 43224 IAA 79279 NET zip x 3 A save box will appear shown below Check Open with then OK SE whidh ka Windia TDF chen 3 1 kE from hltpe iquarbet ape AR lei Ca Sen W s deel prel os do vl thts fie TY open satt June IIP def sur T dava Pie T Da ther putanas For files ike this from pe o CE Cored 4 A downloads box will the
54. se to see all the EPDs All or only the EPD measured Only measured it means for example the 100day EPD isn t shown if the 100 day weighing isn t entered 41 6 Clickon button if the report isn t shown on the screen 7 To leave this report and return to the program press the Cancel button 2 4 3 EPD Report Full EPD Report for Lambs ina Management Group This report provides the full EPD report and genetic selection index for all lambs in a selected management group This report contains rawdata all the EPDs and genetic indexes of lambs in a particular management group It shows also the inbreeding value of the lambs Reports amp Exports 1 Choose EPD Report in the middle box and press gt Ei EPD Report e Be EB sr L By Sex Pe 2 Click on the arrow E at the end of Y G box to select the management group required Select CI current inventory to get the full EPD report of your active flock 3 The report can be filtered by a T tattoo if you type in a lamb s tattoo in the group the report will only show that lamb You can also key specific flock letters to make appear only the lambs having these letters on the report L b Sx Sex if you type E only female lambs will show up on the report and M only male lambs will show up on the report and W only the wethers lamb will show up c Sire if you type a sire id here only the lambs with that sire will show up on the report d Dam if yo
55. some flexibility in weigh dates It must have an interval of at least 28 days between 50 day and 100 day weighings You don t need to weigh each lamb when it is 100 days old Use the Weighing Date Calculator to see on which dates you can weigh the group Different 100 day weight dates can be entered if needed Disposal Dates The date or approximate date of death or disposal can be entered here For a 5A mummified or 5B still born the birth date of the lamb should be used It is important to use 21 dd bb CC dd ee these codes or your summary numbers for mortality will not be calculated correctly on your summary for the lambing group or your flock evaluation report Mummified and stillborn information is important for monitoring in the flock and can be early indicators of nutrition problems You can also add this information later on Disposal Transfer button Disposal Code If the lamb is not longer in the flock or was born dead mummified or as part of an abortion the appropriate code should be entered here Click on the arrow ES at the end of the field to choose the codes from a list or enter the code directly Stillborn 5B is used when the lamb didn t breathe and 5C died 0 10 days is used when the lamb did breathe but subsequently died see Appendix 2 Comment Codes 1 2 and 3 These codes are designed to keep track of particulate situations or conditions of your animals Up to three comment codes can be used If
56. t taken by ultrasound measurements carried out at the same time as the 100 day weigh in and ideally when the average weight of the lamb group is 35kg It is important to respect management groups in order for GenOvis to evaluate lambs In order to be efficient an evaluation must ignore the effects of the environment and concentrate solely on genetics therefore the use of management groups is primordial For the same reasons it is essential that lambs having received particular treatments be placed in separate groups EE Management Group Appendix 2 Animal Record Disposal and Comment Codes Ewe Disposal Codes Sold for Breeding Predator Loss Sold for Slaughter Disposed Unknown Reason Culled Due to Age 4z Died S Ewe Comment Codes Overfat at Lambing 1H Physical Defects Easy Assisted lambing Induced Ovulation Difficult Assisted lambing Born Backwards lambing Ram Disposal and Comment Codes 6L Sold for Slaughter R Died 6W Culled due to Age o l Lamb Disposal Codes Dies after 50 Day Weighing Gave Lamb Away Sold For Slaughter Stockyard Disposed Unknown Reason Lamb Comment Codes RB Retained for Breeding 28 Deformed or Crippled Seuerelnun Severe Injury 3F Scurs Seus 3V Conformation defect conne defect Suffered from Predator Attack Not Present at Weighing lost Suffered from Pulpy Kidney overeating disease 4B Sent to performance station 3M
57. tabase 2 3 4 4 Entering New Animals These instructions assume that you have been enrolled in the program in the past which means that your breeding animals will already be in the database If you have breeding animals that are not in the database their information will have to enter under the button prior to entering data from their progeny 1 Choose dai tab at the top of the screen 2 On the right hand side click the Enter new animals button and the following screen will appear 3 A window will open and show all information that can be entered The boxes with a red asterisk are required prior to save the lamb information When all the information is filled out for a lamb press save or press on ALT S Producer 45224 Adding New Animals Generate Tattoo Birth Weight kg Td sopaywetkg Td 50 Day Date 100 Day We tka TO 100 Day Date Group Count 0 Disposal Date E Disposal Code med s Comment Codes TTT Other Comments se 18 Enter the required information for each animal What is required for each field of entry is explained below use the ENTER or TAB key to move from one field to the next You can enter only the birthing information or the birthing information and additional weight information d Generate Tattoo Check this box if you want the program to create automatically tattoos using the five last digits of the National ID numbers for your animals Date Format The system store
58. to Growth Trait 6 gm1 gma1 gmp1 Growth Trait 1 Lamb Survival Maternal EPD Accuracy Percentile up to Growth Trait 6 r1 rai1 rp1 Reproductive Trait 1 EPD Accuracy Percentile Up to Reproductive Trait 6 62 Appendix 7 Progeny Stats Export File Here is the layout of the columns in the file in order ropid GenOvis number sex Animal sex ewes first then rams id Animal tattoo nid Animal national ID sireid Sire tattoo sirenid Sire national ID damid Dam tattoo damnid Dam national ID breed Animal breed breedgroup Breed group sirebreedgroup Sire breed group dambreedgroup Dam breed group birthdate Animal birth date minlbdate First lambing date maxlbdate Last lambing date nlambings Number of lambings nlambs Number of lambs born nwlambs Number of lambs raised by the dam nflambs Number of lambs fostered avnborn Average of lambs born per lambing avnwean Average of lambs weaned per lambing avbirthwt Average of birth weights avadj50wt Average of 50 day adjusted weights avadj100wt Average of 100 day adjusted weights avadg100 Average of ADG 100 day cc comment code agefirstlamb Age at first lambing avlint Average of lambing interval avnby Average of lambs born per year avnwy Average of lambs weaned per year totwtweaned
59. to be used for this animal when generating the tattoo ManagementYear yyyy ManagementGroup 1 9999 National ID 9 digits 310000000 to 320000000 NewLambTattoo leave blank for automatic generation Dam ID may be a national id or a tattoo but it must be found in the CSGES database Sire ID may be a national id or a tattoo but it must be found in the CSGES database BirthDate yyyy mm dd Sex M F W BornAs RaisedAs Foster ID may be a national ID or a tattoo but it must be found in the CSGES database Recipient ID may be a national ID or a tattoo but it must be found in the CSGES database Name Registration Birth weight kg 50 day weight kg 50 day Date yyyy mm dd 100 day weight kg 100 day Date yyyy mm dd Disposal Date yyyy mm dd Disposal Code Comment Code CommentCode2 CommentCode3 See an example in Appendix 5 The same validation rules apply as if you were entering the data manually This file will overwrite any information stored for the animal in the fields listed for this file 35 2 3718 Disposal CSV The file allows disposing animal in the genetic evaluation database 43224 CEPO2759LC 2011 02 15 1L 43224 CEPO4598XC 2010 10 08 5G File format Producer Animal ID tattoo or national ID must be found in the database Disposal date yyyy mm dd Disposal code Comment code 1 Comment code 2 Comment code 3 Comment you can indicate here everything you want Ex sold to Johny Bailey GenOvis f
60. u type a dam id here only the lambs with that dam will show up on the report om CU e You are not required to choose one of these options 4 Sort click on the arrow to view the sort choices for the report If no sort order is chosen the report will be sorted by tattoo within breed a If you select an EPD or a genetic index the lambs will sort from the highest to the lowest b If you select tattoo the lambs will be sorted from the smaller number to the taller number 42 8 If you check the box By sex the lambs will be first sorted by sex males first then females then by the sort order you chose previously GA 9 If you check the box Use Nat it is the national ID of the lambs that will appear on the report instead of their tattoo ee 10 Once the choices are made click the button to see the report Cancel 11 Press to return to program 2 4 4 Ewe Inventory Report Inventory of Ewes This produces a list of either the current ewes in your flock or a list of the ewes in a specific management group with their average performance information This information can be useful in identifying the best ewes in the flock as well as any ewes that should be culled Reports amp Exports 9 1 Choose Ewe Inventory Report in the middle box and press sa i Ewe Inventory Rep e el CES sort Order Ve Dismiss 2 Click on the arrow at the end of the sort box to choose a sort option Click on the arrow E
61. ves failed Save animal Save disposal failed Save failed ID missing Save failed ID not in pedigree Save failed ROPID missing User already in system You must be logged in to save a founder record You must be logged in to save a pedigree record You must be logged in to save an animal record Appendix 4 Breed Code List Breed Code LACAUNE ECTS ARCOTT OUTAOUAIS O m LINCOLN LIN MERINO HORNED MM Mo K Mp s M NEWFOUNDLAND Cu Tu ER na Ee BLACK WELSH MOUNTAIN NORTH COUNTRY cae e De Lu Cu Tu MERINO POLLED MONTADALE OXFORD O ato POLYPAY po M ni Musae EM M CHAROLLAIS co M CLUN FOREST cm COLUMBIA L ROUGEDE L OUEST RO L COOPWORTH cp M LOTH AEA SL M CORRIEDALE CR m SHETLAND 13 COTSWOLD CW 1 emeng s M CROSSBRED MEDIUM XM m soay sv S CROSSBRED SMALL xs s CROSSBRED LARGE XL t os TM DORPER OTM DORSET HORNED DH M DORSET POLLED DP M HAMPSHIRE HA OL HEXAM LEICESTER HCM HYBRID M ICELANDIC Mo sacos A M KARAKUL KK TM KATAHDIN KA S Appendix 5 Heading Templates for Upload Data Files s CSV Header Lamb Reci Nb Nb Management Birth Dispo Dispo gea Geo wa Birth Date Sire Foster Ee Tattoo pient Born Raised Group Date Ir CEPO 43224 26578YC e 2011 06 14 CEPO3536UC CEPO859SC al leew NES 2011 3 50 2y Weight CSV ee Oey 50Day Dispo Dispo T i Pa ee NE

Getting Started with the New Online Program

Contents

Download Pdf Manuals

Related Search

Related Contents