Sheep Data Storage and Retrieval User Manual
Contents
1. 7 To leave this report and return to the program press the le button PDF file are opened in Mozilla Firefox They can also be saved on your computer CSV files are automatically download in a zip file This report provides the basic 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 This report includes a group summary for each breed and or cross 1 Choose Lamb Report in the middle box Bet SIS S e Press Lamb Report e m cowl B RDF e 3 Click on arrow D at the end of the Group 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 birth date dam and tattoo within each breed cross 5 Click on button if the report isn t shown on the screen 6 To leave this report and return to the program press the button 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 This report includes a group summary for each breed and or cross Reports amp Exports 1 Choose Compact Lamb Report in the middle box Compact Lamb Re e gt ie pe 3 Click on arrow D at the end of the Group box to see a list of manage2. 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 When the only information you know on an animal is its tattoo or its national ID the box C SIUL can help you to find the animal Start User n Manage veo MMP ot s C ep Or Orga ee INV CEPO9 9804D 97980 314197980 2013 04 26 CEPOS1556x C CEPO802632C DPL INV CEPO978624D 97862 314197862 E 2013 04 21 CEPO81556x C CEPO802522C DEL To start enter the entire or a partial part of the animal tattoo or national ID and press i The program will search through all animals in your GenOvis account CEPO567 N e ii e 2006 5 CEPOSEF ISC yag Animals that match the query will appear in the list on the right of the search tool To access this list simply click the arrow to the right of the text box empty The total number of subjects found is indicated to the right of the list 11 If you are using a national ID you must tick the box Ni sf to the right of the search field For more accurate results it is recommended to enter the entire tattoo or national ID of the animal eg CEPOOOO08U not only CEPOO008 or 0008U This search tool does not include uppercase and lowercase letters eg CEPO cepo Cepo CEPO etc will all work You can also use the symbol if you do not know the exact number of animals Eg CEPO 24XC indicates you all animals beginning wi
3. 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 number one each year if desired For example ABC1WC is different than ABC1ZC In this case both animals are probably tagged with number 1 but the first one is born in 2009 and the second one in 2010 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 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 id
4. show up 7 C c Sire if you type a sire id here only the lambs with that sire will show up on the report C d Dam if you type a dam id here only the lambs with that dam will show up on the report a e You are not required to choose one of these options 5 Sort click on the arrow to view the sort choices for the report 44 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 10 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 eae 11 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 v Use Nat 12 Once the choices are made click the button to see the report 13 Press to return to program 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 Reports amp Exports be culled H BS 1 Choose Ewe Inventory Report in the middle box Ewe Inventory Rep e gt ape 2 Press 5 3 Click on the arrow El at the end of the sort box to choose a sort option 4 Click on the arrow 2 at the end
5. Your account is already set to be in English If you select then the program will start in English the To change your password Password must be more than 5 characters New Password 0 Re enter Password UU 1 Type the new password inthe ew Password eee box 2 Retype the password into the Re enter Password Sd ox 3 The 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 i i Change Password without losing the information You just need to ensure you press Change Password before F Change Password logging out 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 If you forgot your password please contact the technical support by phone 418 856 1200 extension 221 or by e mail at genovis cepoq com A new password will be given I 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 infor
6. 314197761 314197762 314197760 314197753 314197751 314197752 314197756 314197749 314197750 314197738 314197728 314197722 314197717 314197714 314197713 314197705 314197702 314197703 314197698 moni z foes Tl En Tl E ec oe Tl Ge Tl cee Tl Gn a fe a foe Tl Ge To Gn a e ee TT 2013 04 28 2013 04 21 2013 03 31 2013 03 31 2013 03 29 2013 03 29 2013 03 29 2013 03 26 2013 03 26 2013 03 25 2013 03 23 2013 03 23 2013 03 22 2013 03 21 2013 03 21 2013 03 21 2013 03 21 2013 03 20 2013 03 20 2013 03 18 2013 03 17 2013 03 14 2013 03 13 2013 03 12 2013 03 12 2012 12 04 2012 12 03 2012 12 03 2 N127 127 N Nc TINE CEPO81556xXC CEPO81556xXC CEPO80212WC CEPOS80212WC CEPOS80212WC CEPO80212WC CEPO80212WC CEPO80323WC CEPO80212WC CEPOS80212WC CEPOSs0361WC CEPO80361WC CEPO80212WC CEPO80197YC CEPOS0361WC CEPOS80197YC CEPOS0212WC CEPO80212WC CEPOsoos0YC CEPO800S0YC CEPO80197YC CEPO80323WC CEPOSs0361WC CEPO80361WC CEPO800SO0YC CEPO80163YC CEPO54725C CEPO80163YC CEPARNIASYC CEPO802632C CEPO802522C CEPOSs0091YC CEPOSs0091YC CEPO80079YC CEPO80111YC CEPO80079YC CEPO80174YC CEPOSs0067YC CEPOS80217YC CEPOSs0104YC CEPO80104YC CEPOs0061YC CEPO80101YC CEPOS80223YC CEPOS80101YC CEPO80078YC CEPOs0065YC CEPO80181YC CEPO80114YC CEPO80075YC CEPO80209YC CEPO80070YC CEPO80103YC CEPO80151YC CEPO6837UC CEPOSs0266WC CEPOS80379XKC CFEPNS953TC DP1 BET DPL DRI DP1 DP1 DP1 DRL DP1 DP1 DP
7. a selected management group or your entire active flock To do this Reports amp Exports 1 Select EPD Export from the last dropdown box o S UE le EPD Export e 2 Press eS gt Group INY do 8 EXPORT 3 Select the management group the current inventory INV 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 M Export is ready 4 Click Ssk 5 A box will pop up telling you when your export is nieces B 43224_5335447828789592189 csv zi ip ready Click Ok P5224 _S55544 HIE IT Wat eva sat Tock Pestoes Ortens Hep JAFHA A S a aii Dirt Test vew Cehte mod Woss mio Wiusican Comment FX d azm 131 353 bytes E omues ay 2 rdan pated a 12 6 A save box will appear shown below Check Open with then OK 7 A downloads box will then show your file being downloaded When it is finished double click on the OBa Tota 131 363 totes int Me zipped file to open it 8 Press to return to program Refer to Appendix 8 EPD Export File Header to get the meaning of the headers Refer to Appendix 9 Conversion form CSV File to Excel File 48 If you want to substitute the headers to their full names instead of their abbreviations a file on the Blog website is available on Documentation Tab Data Upload Excel Heading Templates Data Export File Headers EPDs Export Header This
8. 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 Review animal identification basics section below section 2 3 5 2 to ensure that 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 It is 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 in the future 3 All parents must be entered manually into the system as Founder animals before their lambs can be entered See 2 3 7 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 maximum period length is 41 days see Appendix 1 Management Group Notion 5 Find the function in the right hand menu of the Animals tab Enter the founder tattoo breed breed code following by
9. for the animal in the fields listed for this file 2 3 8 1 6 Founder CSV The file allows uploading of information on parents new to the genetic evaluation database 43224 CEPO10WC 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 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 Appendix7 Heading Templates for Upload Data Files 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 36 2 3 8 1 7 Complete Lamb CSV The file
10. 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 to be used for this animal when generating the tattoo ManagementYear yyyy ManagementGroup 1 9998 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 Code1 CommentCode2 CommentCode3 See an example in Appendix7 Heading Templates for Upload Data Files 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 f
11. 1 BET DRI REF DPL DPL DP1 DP1 BEF DPI DP1 DPL DP1 BEF DP1i DPI DP1 DP1 MP4 Delete selected ani C Enter new animal Edit group C Enter ultrasound d Edit a qroup ultrasg Enter founders C Upload data C Disposal Transfe C Mating module Reports amp Exports Can L E j Special edits amp reports Edit selected anim 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 T G INY sx C GD aD The sequential allows sorting animals using only the numerical part of their tattoo This function is useful when you have more than one producer set and you want to sort numerically animals 10 1 Select the year and management group from the dropdown box at the top left of the screen Y G INV You can select a management group the current inventory INV 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 a National ID C and Sex se 7 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 313 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
12. 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 Ifthe 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 i i 7 Once the breeding ewes and rams are in the system the button can be used to enter lambs into a management group 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 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 If you are using the official national Id for your animals please see the national Id section below An Example of a Purebred Tattoo for 2013 ABC 123 AD Flock letters ABC Animal number 123 Year letter 2013 A Generation code D
13. 13 07 12 fk B 26 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 Animals 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 tattoo Tattoo Dam Breed Tattoo Sire Breed EB gt 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 Mor 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 database optional Breeds can only be entered on founder animals The breed of all progeny will be calculated by the program 27 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 Purebred Dorset DP1 Hybrid DP RV DP1 RV1 Suffolk Romanov SU3 RV1 s
14. 3 8 1 2 Ultrasound Data CSV lt 33 2 3 8 1 3 Birth Data Export CSV 34 2 3 8 1 4 50 Day Weight Data Export CSV oo 35 2 3 8 1 5 100 Day Weight Data Export CSV aaa 35 2 3 8 1 6 Founder Data Export CSV 36 2 3 8 1 7 Complete Lamb Data CSV 37 2 3 8 1 8 Disposal CSV 2 38 2 3 9 Disposal and Transfers ool eceeceeeeececeeeeevseeecceceeeseseeseeeeseeseeees 39 2 4Reports CC 42 2 4 1 Lamb Report rawdata and genetic index in a management group 43 2 4 2 Compact Lamb Report LL 43 2 4 3 EPD Report Full EPD Report for Lambs in A Management Group 44 2 4 4 Ewe Inventory Report Inventory of Ewes 45 2 4 5 Ram Inventory Report Inventory of Rams 46 2 4 6 EPD Parent Report FullEPD Report for Parents 46 2 4 7 Flock Evaluation Report Flock Summary Information sss 47 Export Files 2 4 8 EPD Export 2 2 2 222 48 2 4 9 Inventory Export 49 2 4 10 Progeny Statistics Export Progeny Stats Export 50 2 4 11 Rawdata Report Export Producer 22222222 51 2 5 Mating Module ce ccccescecsnececececesseceseecseeseeeeseseceseseseeeseeseeesseeeneees 52 2 5 1 Mating Group Export File oie lececceceeceeeeeeeeeeeeeeeeeeseeseeeeeeeeees 56 2 5 2 Mating File for the Electronique Notebook eee 58 3 Other Useful Information 3 1 Animal Record Validation 60 Appendices Appendix 1 Management Group Notion Appendix 2 Breed Codes Appendix 3 Disposal Codes and Comment Codes Append
15. CS Founders CS 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 30 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 see section2 3 7 Entering Founders or incorrect tattoos 6 A popup box will show up on the screen Opening result 7805580388429279931 cs zip x You have chosen to open result7805580388429279931 csv zip which is 4 WinRAR ZIP archive 366 bytes from http quartet aps uoquelph ca 8080 M What should Firefox do with this file Open with WinRAR ZIP default v C Save File I Do this automatically for files like this from now on Cancel What should Firefox do with this file You are given the option to
16. Getting Started with the New Online Program User s Manual Canadian Sheep Genetic Evaluation System SWA 2 0 March 17 2014 Table of Contents 1 Getting Started 1 1 RACES NT cence essn evens ystna ens seuseenseeh ccascececececesecedeceseceteceseeeseeeseceseences 5 1 2 Logging Onto and Logout the System ooo lee ceeceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 5 1 3 Important Things to Remember le eeeceeeeceeceeeeeeeeeeeeeeeeseseeeeeeeeeeeeeee 6 1 4 Basic Navigation of the Program occ eeeceeeeceeceeeeeeeeeeeeeeeeeeseeeeeeseseeeeees 7 2 Application Tabs DM hc hs en Bo Le he Ee Fees Eo Ee etd add tb tact st dnt ated tes atisdachi 8 2 2User eee 8 2 21 Producer Info eee 8 2 22 Changing Your Password cee ceeeeececeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 9 2 3Animals ee 10 2 3 1 Search Tool filters eee 10 2 3 2 Global Search Tool 2 2222 11 2 3 3 Information on an Individual Animal certificates 13 2 3 4 Editing Selected Animal ce ceceececeecceseceseeceneeeneeeneeeseseeeees 15 2 3 5 Entering New Animals cn cnesctescrrecedecadsenitetdcetdteniuohidendbendendbendsceds 16 2 3 5 1 New Flocks to CSGES ss 2 2 222 16 2 3 5 2 Animal ID Basics eee 17 2 3 5 3 NationallD e 18 2 3 5 4 Entering New Animals 18 2 3 6 Editing a Group 2 2 2 2222 25 2 3 7 Entering Founders ss 2 27 2 3 8 Uploading Data eee 29 2 3 8 1 Uploading Formats 33 2 3 8 1 1 Ewebyte Export 2 22 33 2
17. O11AD CEP080212W CEPO7421UC 2013 08 02 0 DP1 DP1 DP1 5 0 CEP0O12AD CEP0O80212W CEPO 7421UC 2013 08 02 1 DP1 DP1 DP1 45 nn 1 CEPO14AD CEPOBUZT ZVV POs 1566X C 2013 08 09 0 DP1 DP1 DP1 3 1 CEPO15AD CEP080212W CEP081586x C 2013 08 09 1 DP1 DP1 DP1 4 5 Weighing 50 Day 100 Day 2013 09 22 2013 11 01 Sex Sex 50 Act DDate Gindex Uit Date Born Born Adj Adg DCode Mat Gindex WA Raised Raised 100 Act CCF Tindex Ln fAct Adi Adg CO2 Mat Tindex FtfAct A CC3 F 3 J F e e e e z One lamb is missing for this dam should have 3 lambs F 27 2 38 71 2 41 57 44 M 25 2 33 57 2 37 46 57 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 l button 24 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 without having to re enter all other information To use this function CEPO978454D CEPO978624D CEPO978634D CEPO979544D CEPO979554D CEPO979794D CEPO979804D Choose the Animals tab at the top of the screen Select the management group you wish to add weights in the main grid of the Animals tab On the right hand side of the screen click the button and the following screen will appear Year 2 013 Group 4 Tattoo CEPO978454D Dam Tattoo CEPO80256ZC Sire Tattoo CEPO80163YC Breed DP1 Bir
18. Open with or Save File Choose to Open with then press OK You will then see a popup box called Downloads with the result file listed Double click on this file to open it DB Tota 5 bten l fie 7 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 8 Go through each record row and either fix the row for a subsequent upload or delete the row if it is invalid t 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 31 9 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 10 If you open the results file and there are no records it means that there are no further errors and the records are all in the database 11 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 man
19. ary 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 ce 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 3 Disposal and Comment Codes 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 any 22 of the ewe lambing or lamb codes applies at this time they should be chosen from the drop down list or entered see Appendix 3 Disposal and Comment Codes dd 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 ee Save To save the completed record Type Alt S to save the record or click on the save button ff 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 compl
20. ck by selecting All If you want to print a lamb report you need to know what management group Always choose the SEULGI button to return to the main screen don t use the back button on your browser A otherwise you will find you are logged out 1 To move from tab to tab just click on the tab To find your name and address choose user tab at top of screen This tab also allows you to change your password whenever you choose To find your animals choose Animals tab at top of screen Reports amp Exports To get reports EPD Ewe and Ram Inventory Lamb Reports etc Certificate e gt go under Animals tab In the right hand menu select the type of o Lamb Report reports you need Reports are classified in three categories Individual Reports Group Reports and Exports EPD Export e 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 If you choose a button on the right when in the animals tab you must click to go back to the main animal screen When entering data any field with a triangle dh 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 Click on located in the top right corner of the scr
21. ct the disposal code from the drop down menu T A A L 5 Then press the e CJ box and select the date on the calendar or enter it manually yyyy mm dd 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 Zanimals will be processed Are you sure you how many animals you have selected Click on OK to dispose these animals A green message will appear at the EEEn OK Cancel bottom of the window to confirm the disposition 8 Press to return to the fab Note Comment is optional You can indicate here where your animals were disposed You can also use the different filters to get less animals in the main grid before clicking on the Disposal Transfer button The animals that will appear in the disposal transfer tab are the same as those shown on the main grid of the program This means if you find the animal using the global search tool there will have only one animal in the disposal transfer tab On the other hand using the different filters can help to reduce the number of animals shown on this tab 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 In the sisi tab select the management group of the animal you wish to transfer or your current inventory group INV if
22. de 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 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 animal as recorded on the pedigree of and animal registered with the CLRC Registration Number This is an optional 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 21 dd bb CC 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 button on the animais ereen 50 Day Date Enter the date that the 50 day weight was taken using the date fo
23. e parents of the lambs in the management group chosen Select a sort order for the ewes rams with the dropdown box E You can select only the ewes or only the rams by entering F or M in the Sex box s C 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 v Use Nat Once the choices are made click on the button to see the report Cancel Press to return to program 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 1 A Choose Flock Productivity Report in the middle box Reports amp Exports r ock Evaluation Re o ores UP Flock Evaluation Re S T wm o 2011 Cocon z1 0 M F af 3 a sie 7 fel fa 10 14 fn as 14 fis 3 This report is for a 1 year 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 2012 key 2012 12 31 or select it in the calendar 47 4 Click onthe button to see the report 5 Press to return to program 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 Excel You have the option of exporting the EPDs from either
24. e headers to their full names instead of their abbreviations a file on the Blog website is available on Documentation Tab Data Upload Excel Heading Templates Data Export File Headers Progeny Stat Export Header This export file reported all the rawdata of ewes and rams having progeny in the flock Reports amp Exports 1 Select Export Producer from the last dropdown box 9 H we Export producer e Press 5 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 with then 5 OK n 5 A downloads box will then show your file being downloaded CE ee When it is finished double click on the zipped file to open the SAROVAR a2 file en Refer to Appendix 9 Conversion form CSV File to Excel File 4 i Refer to Appendix 11 Export Producer File Header 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 on Documentation Tab Data Upload Excel Heading Templates Data Export File Headers Export Producer Header 51
25. earrange columns into the correct format just make sure to save the file as a CSV file c Upload the data 1 Press in the Animals tab to bring up a new window 29 Step 7 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 Select upload type v 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 Producer 43224 Uploading Data 2 Click on uplood O 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 SS 3 Select the upload file type using the dropdown menu The different upload file types are 1 Ewebyte Lamb Export File 2 BerGere Lamb Export File similar as the complete data file 3 Ultrasound CSV 4 Birth CSV 5 50CSV 6 100 CSV 7 Disposal CSV 8 Founders CSV P 4 Click on button Step 2 Select the type of upload this file is File Type Select upload type T Step 3 Select upload type Press the Proces EweBytes Lamb Export File aiita Gersere Lamb Export File UtraSound CS Birth CS Check the messa Invalid records wi a0 Ca 100 CSW Disposal
26. ect Open with then click OK which is a Adobe Acrobat 7 0 Document 8 6 KB From http quartet aps uoquelph ca 8080 gt What should Firefox do with this file 8 Once the certificate is downloaded you can save it on open wih Adobe Reader defauk Z C Save File your computer select Save as or print it select Print I Do this automatically for files like this from now on Cancel Click here 3 Adobe Acrobat Professional Certificate 1a pdf i File Edit View Document Comments Tools Advanced Window Help gt Open Ctrl O Create PDE F ai 5 Organizer arkup ay Send for Review A Secure A Sign Z S Forms F Email Close Ctrl Saye Ghr 5 os Save As Shift Ctrl 5 CEPO80413X Gam DP Bih Daa 2010 05 01 313480413 yen F rwimdro 0 0255 Save as Certified Document Revert sss anart Performance Data gt CHUAN Manageren Giaup i Reduce File Size oo S Ca aA BairiRaamd Wa CHuIHs Balh Wi E a uw wos WHr SONIA ADG S ei Send for Review 30 CEHWZNN IDONIASJADG 242 ZT UNS aA wo arua U i Lanval ait Form Data gt aie CHW ENS D KYM aJ OW KYA A To pri nt Document Properties Ctrl D bam CEPOIEL at uy Y Print Setup Shift Ctrl P 8 Print Ctrl P e Genetic Indecies T G Print with Comments Summary Ctrl T tuum 3 GoM rom PrintMe Internet Printing Shift Ctrl 9 maa 9 Press to r
27. ee Appendix 2 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 example 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 t is useful to record the sire and or dam if they are known If the program stats that the animal already exists this means that animal is already in the genetic evaluation In that case call t
28. een to access the GenOvis blog site 2 Application Tabs The Start tab allows changing 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 English Fran ais The tab allows changing your producer information as well as your password CSGES 1 9910 43224 C E P 0 Q 4CEP 4XCO CEPO stare Animais producer iafocmation Password must be more than 5 characters New Password 0 Farm Name Re enter Password Mn First Name Address City Province Quebec Country Canada Home Phone Work Phone OU Mobile Phone Td rax CO Email 1 Email 2 0 GPS Coordinates T When new producer information is entered the seve 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 If 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 seve 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 Language Enalish next time you will log on
29. entification 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 database 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 Animals tab at the top of the screen 2 Onthe right hand side click the Enter new animals button and the following screen will appear Producer 45224 Adding New Animals Generate Tattoo Birth Weight kg Td 50 Day we kg CO 50 Day Date 100 Day we kg TO Group Count 0 pith Date commentcode2 S SOSO O i Hew Tattoo Other Comments 18 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 Enter the required information for each animal What is required for each field of
30. 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 a 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 and the birth date b Date Format The system stores 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 c 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 d Enter the management year use the birth year of lambs and the management group must be only number no letter from 1 to 9998 in the boxes e 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 f 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 impor
31. er tab are the same as those shown on the main grid of the program This means if you find the animal using the global search tool there will have only one animal in the disposal transfer tab On the other hand using the different filters can help to reduce the number of animals shown on this tab 41 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 Exports Certificate e gt Lamb Report e gt EPD Export e Individual Reports Group Reports Export Files 1 The reports and exports are divided in three categories a Individual Reports Certificate Progeny Report Progeny Summary View Ancestor b Group Reports c Export Files Lamb Report rawdata and genetic indexes Compact Lamb Report EPD Report full EPD lamb report Ewe Inventory Report Ram Inventory Report EPD Parent Report full EPD parent report Flock Evaluation Report Group Report to validate data entry EPD Export Inventory Export Progeny Stats Export Producer Export rawdata 2 Use the arrow a on the report tab to select the type of report you need 3 Click on 6j 4 If needed you must select a management group or current inventory and different options 5 Select the management group using the arrow M 6 Click on PDE 42
32. er 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 CEPO198 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 Appendix7 Heading Templates for Upload Data Files 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 3 8 1 5 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 35 100 day weight kg 100 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 Appendix7 Heading Templates for Upload Data Files The same validation rules apply as if you were entering the data manually This file will overwrite any information stored
33. eted date format flock letters management year 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 3 1 Animal Validation Section 2 3 7 Enter Founders or Appendix 4 Common Error Codes for further details 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 return to the main laa tab at the top of the screen Data validation From the iii screen select Group report in the scroll menu in the section group report middle box croup report ane and press Then select the management group and click on to see the animals you have entered This 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 23 Lamb Report for Management Group 43224 2013 101 C EP 0 Q Sylvain Blanchette 1642 rue de la Ferme LA POCATIERE QC GOR1Z0 Lamb Sire Dam Birth Date Breed Breed Breed Birth vvt Correct Foster Recipient 0 CEP
34. eturn to program 14 Date format when you have no choice is always yyyy MM dd Edit 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 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 CEPO9 7032C Breed DP1 Birth Date Sex z Born As Raised As x Management Year Management Group 1 Select an animal in the main Birth Weight kg 4 50 Day Wt kg 24 8 50 Day Date 2013 02 08 100 Day Wt kg 35 8 100 Day Date 2013 03 22 4 4 Disposal Date Disposal Code Comment Code 1 RB Retained for Breeding Me Comment Code 2 Comment Code 3 Other Comments screen underlined in blue and press Edit selected animal _ This will open the window above 15 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
35. ffice 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 ioan If you still get the error message please contact the technical support 1 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 Animals Each tab content will be explained 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 for further instructions Logout enema To logout click on 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 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 INV or the 2000 younger animals of the flo
36. h 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 DPRAM 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 Appendix7 Heading Templates for Upload Data Files 34 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 3 8 1 4 50 CSV The file allows you to send in data aft
37. he CEPOQ or send an e mail to genovis cepog 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 Animals that are in the INV group current inventory are those with progeny and without disposal code If you want to add animals without progeny in your current inventory eg ewe lambs add them the comment code RB 28 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 Ewebyte lamb export file BerGere lamb export file same as the complete lamb CSV Ultrasound data CSV Birth CSV 50 CSV 100 CSV Complete lamb CSV Information on new animals to the system can be uploaded using Founders CSV Animals can be disposed using Disposal CSV These formats are further explained in the Upload Formats section 2 3 8 1 B Prepare the file The 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 8 1 Uploading Formats below Excel can be used to r
38. is tattoo should be made up of the breed code of the ewe ram and the word ewe ram i e 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 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 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 cons
39. ist 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 20 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 3W 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 Therefore 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 O with a 3U comment co
40. it is present in this group 40 Press the Disposal Transfer button 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 Once you have all the animals you need selected press the ote eee box and select the date on the calendar or enter it manually yyyy mm dd Select the disposal code 1K 6K or 5K from the drop down menu M If needed enter pertinent information in the Comments box Select the ROPID GenOvis number of the new animals owner if it is a GenOvis participant in the transfer box IF not leave this box blank Press Save 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 a Press to return to the ab Note Comment is optional You can indicate here where your animals were transferred See Appendix 3 Disposal and Comment Codes to get the list of the disposal codes You can also use the different filters to get less animals in the main grid before clicking on the Disposal Transfer button The animals that will appear in the disposal transf
41. ix 4 Common Error Codes Appendix 5 How to Set the Upload File Date Format Appendix 6 How to Set Up the Decimal Separator Appendix 7 Heading Template For Upload Data File Appendix 8 EPD Export File Header Appendix 9 Conversion from CSV File to Excel File Appendix 10 Inventory Export File Header Appendix 11 Progeny Stats Export File Header Appendix 12 Export Producer File Header Thanks to Delma Kennedy and its team for their help in the realisation of this User s Manual 1 Getting Started 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 rr 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 Logging 1 Visit http quartet aps uoguelph ca 8080 SWA login html Do not b permet forget to use Mozilla Firefox as browser You can also access this site GenOvis from our website www genovis ca Click on the following picture a kaa T 2 Type in your username and password the username is your ID number e g 1234 and the password is assigned by the o
42. ls 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 2013 CEPO97845 AD CEPO80256 ZC 314197845 2013 04 20 DP1 2013 4 CEPO97862 CEPO80252 514197862 2013 04 21 F DP1 AD ZC 2013 4 CEPO97863 CEPO80247 544197863 2013 04 22 M DP1 AD ZC 2013 4 aie ea moo prir AUE Sn DP1 AD ZC 2013 4 CEPO97955 CEPO80260 314197955 2013 04 24 F DP1 AD ZC 2013 4 CEPO97979 CEPO80240 514197979 2013 04 28 M DP1 2013 AD CEPO97980 AD Zc CEPO80263 ZC 314197980 2013 04 28 Year __ Group__ Tattoo _ Damid__ NatId__ Birthdate 4 F Disposalcode CdR ote O o commet S S S S S Y Selected Transter ropo dO i E o Disposal If an animal passes away it is important to report its disposal This can be done by Animals 1 In the INV of the animal s you wish to dispose of tab select the management group or your current inventory group 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 39 The button allows you to select in one click the first 10 animals in the layout table The number of animals selected appears under the button 4 Once you have all the animals you need selected sele
43. mation 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 order of tattoo sequential national Id sex birthday dam id sire id breed disposal code and date CSGES 2 020 43224 C E P 0 Q 4CEP 4XCO CEPO Start User Manage Y G INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV INV TMA It it the current inventory INV that is shown by default in the main grid CEPO979804D CEPO978624D CEPO977784D CEPO977794D CEPO977734D CEPO977754D CEPO977744D CEPO977644D CEPO977664D CEPO977634D CEPO977614D CEPO977624D CEPO977604D CEPO977534D CEPO977514D CEPO977524D CEPO97756AD CEPO977494D CEPO977504D CEPO977384D CEPO97728A4D CEPO9 77224D CEPO977174D CEPO977144D CEPO977134D CEPO977052C CEPO977022C CEPO977032C CEPNO749R ZC 97980 97862 97778 97779 97773 97775 97774 97764 97766 97763 97761 97762 97760 97753 97751 97752 97756 97749 97750 97738 97728 97722 97717 97714 97713 97705 97702 97703 q7AQA 314197980 314197862 314197778 314197779 314197773 314197775 314197774 314197764 314197766 314197763
44. ment groups Click on the management group required 5 In the second box select to see all the lambs All or only the undisposed ones Undisposed 43 6 In the last box choose 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 7 Click on button 8 Lambs will be sorted by birth date dam and tattoo within each breed cross 9 To leave this report and return to the program press the SL button 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 C 2 S 2 press CD Runt A e 3 Click on the arrow 2 at the end of Group box to select the management group required Select INV current inventory to get the full EPD report of your active flock 4 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 C b Sx Sex if you type F 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
45. ntly 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 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 a 2 3 8 1 2 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 for tattoo Animal weight in kg Measurement date yyyy mm dd Loin depth mm Fat depth 1 mm Fat depth 2 mm Fat depth 3 mm 33 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 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 Disposal and comment codes are listed in Appendix 3 2 3 8 1 3 Birt
46. of Group box You can choose current INV 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 5 Once the choices are made click the button to see the report 6 Press MAGEE to return to program 45 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 rams in the flock Reports Exports 1 Choose Ram Inventory Report in the middle box a e S Ram Inventory Rep e gt 2 Press e s 3 Click on the arrow i at the end of the sort box to choose a sort option 4 Click on the arrow B at the end of Group box You can choose current INV 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 5 Once the choices are made click the button to see the report 6 Press to return to program This report provides the full EPD report all EPDs and genetic indexes for the parents of the lambs in a given management group Reports Exports 1 Choose EPD Parent Report in the middle box e gt EFD Parent Report e gt 2 Press e S 46 Click on the arrow 2 at the end of Group box to select the management group required and choose the group required This report will produce the EPDs for th
47. or this file 37 2 3 8 1 8 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 for transfer See an example in Appendix7 Heading Templates for Upload Data Files 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 38 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 disposal and transfer 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 anima
48. 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 Excel 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 Inventory Export from the last dropdown box T m e Press i meen Boor EXPORT Export is ready 3 Click Sele 4 A box will pop up telling you when your export is ready Click x You have chosen to open O k Z 43224_5335447828789592189 csy zip which is a WinRAR ZIP archive 30 1 KB From http quartet aps uoquelph ca 8080 What should Firefox do with this File 5 A save box will appear shown below Check Open with then Uazens wenn zr cast C Save File O K Tl Do this automatically for files like this From now on con 6 A downloads box will then show your file being downloaded When it is finished double click on the zipped i i file to open it 7 Press to return to program Refer to Appendix 9 Conversion form CSV File to Excel File Refer to Appendix 10 Inventory Export File Header 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 on Documentation Tab Data Upload Excel Heading Templates Data Export File Headers Inventory Expo
49. rmat 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 button on the animals career 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 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 these codes or your summary numbers for mortality will not be calculated correctly on your summ
50. rt Header 49 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 Excel 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 o P e 2 Press Progeny Stats Expt e G Group INY a EXPORT CD 3 Select INV 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 Export is ready 4 Click Saks 5 A box will pop up telling you when your export is ready Click gyre You have chosen to open O k Y 43224_5335447828789592189 csv zip which is a WinRAR ZIP archive 30 1 KB From http quartet aps uoguelph ca 8080 r What should Firefox do with this file 6 A save box will appear shown below Check Open with then Kae san ea zi O K J Do this automatically For files like this From now on coe 7 A downloads box will then show your file being downloaded When it is finished double click on the io zipped file to open it 8 Press to return to program Refer to Appendix 9 Conversion form CSV File to Excel File Refer to Appendix 11 Progeny Stats Export File Header to get the meaning of the headers 50 If you want to substitute th
51. screen 2 Select the group NOTE you may also enter M or F to see a list of the rams or ewes ina 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 Reports amp Exports Certificate Ancestors in the scroll menu of the first box then press j Certificate 4 Select Certificate Progeny Report Progeny Summary or View see above for explanations on these types of reports Progeny report Progeny Summary 5 The report will appear on the screen in PDF If the report doesn t isv ancestors appear within few seconds click on Eikii 13 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 Page iS of 1 Automatic Zoom Performance Certificate CEPO97703Z 314197703 Owner 43224 C E P 0 0 Breed DP1 Breeder 43224 C E P 0 0 Sex F Birth Dae 2012 12 03 Inbreeding 5 13 Click here to dowload the certificate Pedigree SS ai Performa SS CEPO5731S ManagementGro SSD CEPO2144N BornRaist Sire CEPO80163Y Birth Vt DP1 SDS CEPO68M SOV Ad JADG 248 26 8 0 333 SD CEPO3581S 100V Adj JADG 35 8 40 8 0 28 SDD CEPO8124P UV Loin F at 35 8 29 9 4 Opening Certificate1la pdf x You have chosen to open SL Certificate1a pdf 7 When the box is opened sel
52. tant 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 2012 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 be entered by using the button on the main animals screen prior to entering the progeny Please note that this message will appear when you enter a dam and there is no information in the sire box CEPOB997TC I Dam Tattoo CEPOR997TC CEPOS0431 AC Breed sire or dam not found 19 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 entered in the database 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 be entered by using the button on the main animals screen prior to entering the progeny see section 2 3 7 Entering Founders Occasionally there may be a lamb born and the ewe ram can t be identified Use a standard unknown dam sire tattoo Th
53. th CEPO and ending with 24XC 12 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 animal s 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 used to monitor how daughters 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 animals tab at the top of the
54. th Date 2013 04 20 Sex Female somas es Raised As Foster ID n Recipient ID C National ID EE Hame e DELETE 1 7 Producer 43224 Editing Management Group 2013 4 Birth Weight kg Offspring List 50 Day Wt kg Tattoo Sex Birthdate sireid Damid 50 Day Date 2013 06 25 T Ey wow ao C woyo BA 4 The list of animals in that group will appear in the box on the left hand side animal 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 Enter in the 50 and 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 all its records If you need to delete an animal press DELETE to remove the selected animal and 25 Warning This button removes definitively this animal and his data Do not use this button the remove animal from the flock inventory or to dispose lambs See Section 2 3 9 Diposal Transfer 8 Press to return to the program Notes Remember to always click save _ 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 ae Date 20
55. ually after the upload in Edit group The date format to be used in all import data files is yyyy mm dd You need to set the date format on your computer Your computer must store dates in the correct format otherwise you will be unable to import your data into the GenOvis program see Appendix 5 How to Set the Date Format in Files to Import Into the GenOvis Program Also note that the decimal separator is the dot not the comma You must also set this on your computer to be able to use the different data import files see Appendix 6 How to Change the Decimal Separator 32 2 3 8 1 1 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 ADDPN 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 curre
Download Pdf Manuals
Related Search