Size: 40
Comment:
|
Size: 48755
Comment:
|
Deletions are marked like this. | Additions are marked like this. |
Line 1: | Line 1: |
Describe public/Idea_user_manual here. | ## page was renamed from Database User Manual {{attachment:ibc_logo.jpg}} = USER MANUAL FOR THE IDEA INTERFACE = == Preface == The following is a manual to guide the user through the features of the new '''IDEA. IDEA''' stands for ''Interbull Data Exchange Area.'' IDEA is a restricted area accessible only to member countries through the Interbull website. . Last updated May 11 , 2012 <<TableOfContents()>> == LOG IN == To enter the main page of IDEA go to https://idea.interbull.org You will be required to provide a username and password to log in. Your username is equal to the intial of your name followed by your surname. For example, the user name for Thomas White will be twhite. If your surname contains special character, such as ö, ä, å etch, write it with the corresponding ASCII letters, i.e. o,a, etc. Your username is associated to the organization you belong to. IDEA has a table linking together usernames and organizations for the persons that have had so far regular contacts with the Centre. If you wish for one of your co-worker to have access to IDEA, simply notify the Centre with his/her name and email address. Access to IDEA is, therefore, set to an individual access. If you used to share your password in the past, it is your responsability to change it to a new password. === First time log in === You will receive a temporary password from Interbull Centre. Use your username, as described above, and your temporary password to log in. == AFTER YOU LOG IN == Welcome to IDEA!!! The first thing you need to do is to change the temporary password to one of your choice. The main '''User Menu''' appears in the top navigation pane with several menu items that will allow you to interact with the database. In this section we give you an explanation of their functions. === Home Menu === The IDEA Home menu gives you access to the main functions available in the database. Currently these functions are solely related to the pedigree handling, but new functions for handling of conventional MACE, genotypes etc, will also be accessible from here whenever their modules will be implemented. The available pedigree functions are: Query, Uploads, Conflicts, Statistics. === Query === If you want to get pedigree information on a particular animal, click on ''Query'' menu link.The page that will open contains an ''Animal lookup'',by inserting an International ID in the ''Animal lookup'' and then clicking on ''Lookup!'' will show the information related to your query. The central part of the page will show the international ID of the animal you were interested, followed by its name, birth date and birth date status, animal status, date of last update and who performed the last update. Above it, by clicking on ''"Parents:show/hide"'' you get access to the animal's parents and grand-parents. Below it, by clicking on ''"Offspring: show/hide"'' you get access to a table listing all the animal's offspring together with tehir name and birth date. The table, by default, shows the first 200 offsprings associated to the aniaml ID. You can however modify the number of entries by clicking on the harrow beside "entries". Likewise, if you are only interested on a specific offspring, you can search for it by inserting its IID in the "''search''" space. Each ID reported in the parents and offspring section, is an active link, therefore clicking on any displayed ID will update the page with that animal’s pedigree information. If you enter an alias ID in the Animal lookup space you will see the official IID associated to that alias id. Your profile Username is by default equal to your organization code and, as it is used throughout the system to identify your organization as the authoritative organization for the animals you have right to administer, it cannot be changed. In case you notice that the email address is incorrect or if you want to change any information, click on Your profile menu link. On the page that will open on the right pane you will be able to change/update user information, such as: __Your name:__ By default your name is set equal to your organization name and would appear as a header in all the others windows. If you like to change it with your own name, simply type it in the corresponding box. National characters might not be readable so please avoid them. __E-mail:__ This is the email address the database services will use to contact you, so double check that it is always up to date. __Password:__ In here you can reset your password. To complete the change you need to confirm your new password in the Verify Password box. '''__N.B. __For the changes to be effective click SAVE at the bottom of the page!! ''' == Animal IID Query == == Upload == The ''upload'' menu link is set up for uploading of pedigree, proofs, parameters and forms such as GE and validation forms. At the moment only the feature to upload the pedigree is active; other upload options will be implemented soon. === Upload Pedigree and Cross-reference links === Whether you want to upload a whole pedigree file, pedigree information for just few bulls or create cross-reference links, simply click on the ''Upload Pedigree'' button. You will be directed to a new window in which you can browse the file(s) you want to upload through the ''browse'' button. In this window you have the possibility to upload two different files: * Using the '''''New pedigree box''' you can upload the zip file produced by the CheckPedigree'''''.'''pl'' program, being this file the output including all your pedigree information, a part of them (i.e. just new bulls or ancestors) or pedigree information for animals you need to verify (for the verification procedure see below). '' * Using the '''''Correct ID''' box you can upload a''''' '''file202''''' '''which creates cross-reference links or set a given ID to invalid. The format to use is reported in Appendix III. '' A file 202 can be used to correct animals’ IDs appearing in your “Request of Pedigree” or to create cross reference links among domestic animals you have previously uploaded. '''N.B.'''· * The file202 cannot be zipped and does not require a special name, i.e. you can name it as you like giving it whatever extension but not a .zip· * You cannot link a male animal into a female animal and vice versa.· * In order for this function to work properly it is necessary that the “wrong/alias IID” is already present in the database, if this is not the case you will get a screen message of the type: '''Wrong/Alias ID → Correct ID ''Not Linked''''' To make the link work first upload a pedigree record for the animal you want to change ID and then upload a file202.· * When the link is successful the message on the screen will be of the type: '''Wrong/Alias ID → Correct ID ''Linked'''''· * You are allowed to link together only animals for which you are authoritative for. If you attempt to perform a link between two animals and one or both of them are outside your competence, then the message on the screen will be of the type: '''Wrong/Alias ID → Correct ID Not authority over this animal''' * You can upload both files, pedigree and file202, together or just one of them. After you have browsed the files and have clicked on the ''Upload ''button you will be asked to confirm that the files you have chosen are the correct ones. * By clicking ''Process'' you will confirm that the files are ok and their content will be loaded into the database. * If you click the ''Delete ''button the file(s) will be dropped from the Interbull server. The uploading of the file202 and the creation of the cross-reference links in the database will happen in real time while for the pedigree file, depending on its size, the loading will be executed on line or in a batch queue through the buffer disk. In any case a message on the screen will inform you that the data has been successfully sent to Interbull server and will be loaded later. You will be notified by email when the loading has been completed. '''__N.B. __'''__Keep in mind that by clicking on the ''Delete ''button means that '''no file(s)''' have been sent or loaded to the database and therefore you will have to start the loading procedure once again__ === Creation of cross reference in the database === The creation of cross reference in the database is made by uploading of a file202 (see above). Two IDs will be always considered as two different animals until a proper file202 is uploaded. For creation of cross references involving animals belonging to two different organizations please send an email to Valentina ( valentina.palucci@slu.se ). Interbull staff can in fact act as “super user” and create a cross reference for these special cases. === Name of the animal === The official name of an animal is equal to the name provided by each official organization. To avoid sudden changes in names or name missing it is extremely important that each authoritative organization always provide a name record, whenever available, for every uploading and be consistent with the name, i.e. do not provide the full name for the first uploading and a short version of it for the next, otherwise the name of the animal will get overwritten. === How do I change/add a name for a given animal? === Only authoritative organization can modify the name of an animal. To do so simply upload a pedigree file with the new name information and the changes will be recorded in the database.''' ''' == Download menu link == Clicking on the ''Download'' button you will be able to get information about pedigree, proofs, parameters, forms, retrieve a list of animals waiting for your validation (as you appear to be their authoritative organization) or check the list of invalid international ID. Many of the features contained in this tab are still under development but you can already get access to the list of animals waiting for your validation as well as check the invalid international id. === Retrieve your "Request of Pedigree" === By clicking on'' __here__'' you will be directed into an ascii file following the format shown in Appendix IV. You can save the file by clicking on “File/Save As” in the tool bar.The ascii file contains a list of all animals as loaded by reporting countries and for which you appear as the authoritative organization. This means that only you have the right to say if the pedigree record is correct or not.''' ''' === Verification Process: How does it work? === For each animal listed in your “Request of Pedigree” file yhave to upload its pedigree information as it appears in your own database, using file format 200 and checkpedigree.pl.By doing so you are ''verifying ''the reported information as the system considers verified only the information provided by the authority organization. When you are verifying an animal record you might find yourself in front of four possible scenarios, below you find instructions on what to do for each of them.''' ''' '''Scenario 1''' If you find that the animal ID reported is correct then you will have to: * Upload a pedigree file (file200 previously inspected by CheckPedigree.pl) as it appears in your own database, weather the reported pedigree information is correct or not. '''Scenario 2''' If you notice that an animal has been reported with an incorrect international id then you will have to: * Upload a pedigree record for that animal using its correct id * AND upload a file202. The file202 will provide the cross-reference link between the reported animal id and the animal id you verified. Example: A country submitted a pedigree for the animal BSWUSAF000000569466 using the ID BSWUSAF000000''65''9466. As it is an USA animal, the animal will appear in the USA list of Request of Pedigree. When looking at the record USA notices that two numbers have been misplaced. So USA will upload a pedigree file using the correct id for the animal (BSWUSAF000000569466) together with a file202 which will look like: 202 BSWUSAF000000659466 BSWUSAF000000569466 '''Scenario 3''' If you realize that a given animal has been erroneously associated to your organization then: * If you know the right authoritative organization, upload a pedigree file containing the new international ID of that animal. Doing so the animal will be sent for validation to the organization associated to the country you specified in its international ID. Example: Animal BSWUSAM000803611398 is sent to USA for validation but USA realizes the animal belong to DEU instead. USA uploads a file200 (checked by CheckPedigree.pl) for the animal BSWDEUM000803611398 '''Scenario 4''' If you do not know anything about that animal and it does not appear in your database then you have to: * Upload a file202 containing “UUUUUUUUUUUUUUUUUUU” in the “correct IID” field. Doing so the animal’s international ID will be considered as invalid and listed in the ''limbo'' (for the limbo see below) Example: Animal BSWUSAM000000000008 cannot be found in the USA database.The file 202 will be: 202 BSWUSAM000000000008 UUUUUUUUUUUUUUUUUUU You will have to upload your files using the uploading pedigree tool you find in the ''upload'' tab.''' ''' === Corrected Foreign Animals === In this file you find information on the validation activity over an IID, and its pedigree, done by each authoritative organization on your foreign animals. Therefore by checking it you can get the corrected IDs, or pedigrees, of some of the animals you have been reported that have been corrected by their authoritative organizations.You can open the file by clicking on the link or save it directly on your computer. The file format is specified in Appendix V. The content of the file will be completely updated after extraction of the pedigree for each Interbull evaluation. You therefore have the time between extractions to check the file and eventually do the necessary correction in your own database. === Look at the Limbo === By clicking on the ''limbo ''tab you will get access to the list of international IDs that were not recognized by their authoritative organizations and therefore set to unknown. The list is available for you to double check your database and eventually update it accordingly. === Download Pedigree === After every Interbull evaluations the international pedigree for the six breeds evaluated at the Centre will be available for download. By clicking on ''Download Pedigree ''you will have access to the international pedigree used in the latest Interbull evaluation. You will be entitled to have access only to the international pedigree of the official breed(s) with which you participate to the Interbull evaluation.You will be able to either look at the pedigree or saved it on your own computer. === Statistics Menu Link === The ''Statistics'' menu link contains general information about your pedigree. '''''Overview of verified/unverified animals submitted by your organization''''' The table shows the general situation of your pedigree data as it is in the database at the time of your log in. The table contains the country of the authoritative organization, the number of animals that have already been validated by it and the number of animals that are still waiting for validation, for all the breeds you have submitted. By clicking on the drop down menu you can select a particular breed among your own and have the same statistics recalculated just for that breed. '''N.B. '''among all the animals in the “''animal''” field that you have uploaded, the ones having your country code in their international ID are considered validated by default because you are their authoritative organization, therefore there should not be any animals still pending validation by your country in this table. If this is not the case it means that there are some parents without an entry in the animal field and could not be validated because the validation procedure takes place in the animal field. To prevent this to happen, you will have to upload pedigree records for the animals and their parents as well. '''''Summary of animals waiting for verification by your organization''''' This table contains the list of all animals submitted to the Interbull database by other organizations for which you appear to be the authoritative organization and therefore you need to provide the correct information (see verification procedure above) . The table contains the total number of records, the reporting organization’s name and its country code. This table is useful for you to monitor your verifying ID tasks. === Pedigree Conflicts === Although your national pedigree file has been already checked by the CheckPedigree.pl for pedigree conflicts, there is the possibility that the international pedigree still shows some birthdays conflicts.To check for that click on ''Pedigree Conflicts'' bottom, you will be directed into a new page showing all conflicts where your organization is involved. Below is an explenation of the Pedigree Conflicts page content: The IID listed is the one of an animal in which pedigree there is one of more conflicts. The type of conflicts are shown in the Conflict path column, where S, D, SD means that the sire, the dam or the sire of the dam birthdate is conflicting with the animal’s birthdate. The cross (x) in the “Strange” column indicates that all animals involved in the conflict have already been verified by their own authoritative organization. Clicking on “''Details''” will open a new page showing more details on the animals in conflict. === How to handle animal's conflicts? === Sometimes a conflict could be due to unverified animals, if this is the case please proceed on verifying the animals double checking that the new birthdate you are going to provide will no more be in conflict. If you do not know how to fix the conflict you should contact Interbull Centre deciding what action you, as the authoritative organization for that animal, want to take. So, in general, to fix a conflict you should: * Upload new pedigree file of the conflicting animal with a new no-conflicting birthdate * In case you do not know how to fix it you should contact Interbull Centre''' ''' === Pedigree Duplicates === By clicking on “Pedigree Duplicates” you will see a list of potential duplicates associated to your organization. The list shows five pairs at the time. For each animal listed you will see its international IID and birthday, by clicking on its IID you will access to its pedigree information. Beside each IID you have an empty box to mark. === How to handle pedigree duplicates? === In case you realize that the animals shown in the list are indeed duplicates, mark the box associated to the official IID. If the animals are NOT duplicates mark both boxes. Then press “''Submit Changes''” and the changes will be saved and stored in the database. The pairs you have processed will be dropped from your list ''__only__'' if you are authority for both animals in the pair. Otherwise the conflict will remain in your list until the other authoritative organization provides your same answer. === What is the meaning of the star? === Whenever you are authoritative only for one animal IID showed in the pair, your submission will be kept on a hold and showed with a star (*) until the other authoritative organation has also the opportunity to look into the matter and expressed its own opinion. There can be two different scenarios: * You and the other authoritative organization have submitted the same information: The change will then become official in the database and the pair will drop from your list. * You and the other authoritative information have provided different information:The “disagreement” will be mark by stars (*) in both IID. No changes will happen in the database. You should contact the other authoritative organization via Interbull Centre. The conflict remains in your list. == APPENDIX I: Organization Codes as provided by Interbull Centre == ||<tablewidth="744px" tablestyle="text-align:left"width="91px" style="vertical-align:bottom">'''Org. code''' ||<width="488px" style="vertical-align:bottom">'''Organization name''' ||<width="165px" style="vertical-align:bottom">'''Country ''' || ||<style="vertical-align:top">ADHIS ||<style="vertical-align:top">Australian Dairy Herd Improvement Scheme ||<style="vertical-align:top">Australia || ||<style="vertical-align:top">GEMBLOUX ||<style="vertical-align:top">Gembloux Agricultural University, Animal Breeding and Genetics group ||<style="vertical-align:top">Belgium || ||<style="vertical-align:top">CDN ||<style="vertical-align:top">Canadian Dairy Network ||<style="vertical-align:top">Canada || ||<style="vertical-align:top">PLEMDAT ||<style="vertical-align:top">Czech Moravian Breeders' Corporation ||<style="vertical-align:top">Czech Rep. || ||<style="vertical-align:top">NAV ||<style="vertical-align:top">Nordic Cattle Genetic Evaluation ||<style="vertical-align:top">Denmark || ||<style="vertical-align:top">ARC ||<style="vertical-align:top">Estonian Animal Recording Centre ||<style="vertical-align:top">Estonia || ||<style="vertical-align:top">INRA ||<width="488px" style="vertical-align:top">Institut de l'Elevage ||<style="vertical-align:top">France || ||<style="vertical-align:top">GRUB ||<style="vertical-align:top">Bavarian State Research Center for Agriculture, Institute of Animal Breeding ||<style="vertical-align:top">Germany || ||<style="vertical-align:top">VIT ||<style="vertical-align:top">United Data Systems ||<style="vertical-align:top">Germany || ||<style="vertical-align:top">OMMI ||<width="488px" style="vertical-align:top">National Institute for Agricultural Quality Control ||<style="vertical-align:top">Hungary || ||<style="vertical-align:top">ICBA ||<style="vertical-align:top">Israeli Cattle Breeders' Association ||<style="vertical-align:top">Israel || ||<style="vertical-align:top">ICBF ||<style="vertical-align:top">Irish Cattle Breeding Federation ||<style="vertical-align:top">Ireland || ||<style="vertical-align:top">ANARB ||<style="vertical-align:top">Italian Brown Cattle Breeder's Association ||<style="vertical-align:top">Italy || ||<style="vertical-align:top">ANAFI ||<style="vertical-align:top">National Association of Holstein Breeders ||<style="vertical-align:top">Italy || ||<style="vertical-align:top">ANAPRI ||<style="vertical-align:top">Italian Simmental Fleckvieh Breeder's Association ||<style="vertical-align:top">Italy || ||<style="vertical-align:top">NLBC ||<style="vertical-align:top">National Livestock Breeding Centre ||<style="vertical-align:top">Japan || ||<style="vertical-align:top">LIETUVA ||<style="vertical-align:top">Ministry of Agricolture ||<style="vertical-align:top">Lithuania || ||<style="vertical-align:top">LDC ||<style="vertical-align:top">Agricultural Data Centre ||<style="vertical-align:top">Latvia || ||<style="vertical-align:top">GENO ||<style="vertical-align:top">GENO ||<style="vertical-align:top">Norway || ||<style="vertical-align:top">LIC ||<style="vertical-align:top">Livestock Improvement Corporation ||<style="vertical-align:top">New Zealand || ||<style="vertical-align:top">NABC ||<style="vertical-align:top">National Animal Breeding Centre ||<style="vertical-align:top">Poland || ||<style="vertical-align:top">ANABLE ||<style="vertical-align:top">Portuguese Research centre ||<style="vertical-align:top">Portugal || ||<style="vertical-align:top">PSSR ||<style="vertical-align:top">The Breeding Services of the Slovak Republic ||<style="vertical-align:top">Slovak Rep || ||<style="vertical-align:top">BFRO ||<style="vertical-align:top">University of Ljubljana, Zootechnical department ||<style="vertical-align:top">Slovenia || ||<style="vertical-align:top">NIAS ||<style="vertical-align:top">Korean National Institute of Animal Science ||<style="vertical-align:top">South Korea || ||<style="vertical-align:top">CONAFE ||<style="vertical-align:top">Confederation of Spanish Holstein Associations ||<style="vertical-align:top">Spain || ||<style="vertical-align:top">HACHE ||<style="vertical-align:top">Holstein Association, Switzerland ||<style="vertical-align:top">Switzerland || ||<style="vertical-align:top">BRAUNVIEH ||<style="vertical-align:top">Swiss Brown Cattle Breeders' Federation ||<style="vertical-align:top">Switzerland || ||<style="vertical-align:top">FLECKVIEH ||<style="vertical-align:top">Swiss Simmental and R&W Cattle Breeder's Association ||<style="vertical-align:top">Switzerland || ||<style="vertical-align:top">CRDELTA ||<style="vertical-align:top">CR-Delta ||<style="vertical-align:top">The Netherlands || ||<style="vertical-align:top">SAC ||<style="vertical-align:top">Scottish Agricultural College ||<style="vertical-align:top">Great Britain || ||<style="vertical-align:top">USDA ||<style="vertical-align:top">AIPL, USDA ||<style="vertical-align:top">USA || ||<style="vertical-align:top">ARCAII ||<style="vertical-align:top">ARC, Animal Improvement Institute ||<style="vertical-align:top">South Africa || ||<style="vertical-align:top">SASB ||<style="vertical-align:top">SA Studbook ||<style="vertical-align:top">South Africa || ||<style="vertical-align:top">ARCB ||<style="vertical-align:top">Agricultural Research Council_INTERBEEF ||<style="vertical-align:top">South Africa || ||<style="vertical-align:top">CMBCB ||<style="vertical-align:top">Czech Moravian Breeders Corporation_INTERBEEF ||<style="vertical-align:top">Czech Republic || ||<style="vertical-align:top">FABAB ||<style="vertical-align:top">Faba Coop_INTERBEEF ||<style="vertical-align:top">Finland || ||<style="vertical-align:top">FECLB ||<style="vertical-align:top">Federación Española de Criadores de Limusin_INTERBEEF ||<style="vertical-align:top">Spain || ||<style="vertical-align:top">ICBFB ||<style="vertical-align:top">Irish Cattle Breeding Federation_INTERBEEF ||<style="vertical-align:top">Ireland || ||<style="vertical-align:top">INRAB ||<style="vertical-align:top">Institut de l'Elevage_INTERBEEF ||<style="vertical-align:top">France || ||<style="vertical-align:top">NAVB ||<style="vertical-align:top">Nordic Cattle Genetic Evaluation_INTERBEEF ||<style="vertical-align:top">Denmark || ||<style="vertical-align:top">SACB ||<style="vertical-align:top">Scottish Agricultural College_INTERBEEF ||<style="vertical-align:top">Great Britain || ||<style="vertical-align:top">SDAB ||<style="vertical-align:top">Swedish Dairy Association_INTERBEEF ||<style="vertical-align:top">Sweden || == APPENDIX II: File Format 200 for Dairy Pedigree == ||||||||<tablestyle="text-align:left"width="616px" style="text-align:center;vertical-align:top"> || ||<width="96px" style="vertical-align:top">'''Starting position''' ||<width="277px" style="vertical-align:top">'''Field''' ||<width="115px" style="vertical-align:top">'''Format''' ||<width="127px" style="vertical-align:top">'''Example''' || ||<width="96px" style="vertical-align:top">1 ||<width="277px" style="vertical-align:top">Record type^1^ ||<width="115px" style="vertical-align:top">Character 3 ||<width="127px" style="vertical-align:top">200 || ||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top">'''International ID of ANIMAL''' ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">5 ||<width="277px" style="vertical-align:top">Breed of animal ^2^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">HOL || ||<width="96px" style="vertical-align:top">8 ||<width="277px" style="vertical-align:top">Country of first registration of animal^3^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">11 ||<width="277px" style="vertical-align:top">Sex ||<width="115px" style="vertical-align:top">character 1 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">12 ||<width="277px" style="vertical-align:top">ID number of animal^4^ ||<width="115px" style="vertical-align:top">character 12 ||<width="127px" style="vertical-align:top">000000A12345 || ||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top"> ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top">'''International ID of Sire of ANIMAL''' ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">25 ||<width="277px" style="vertical-align:top">Breed of sire of animal ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">28 ||<width="277px" style="vertical-align:top">Country of first registration of sire of animal^3^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">31 ||<width="277px" style="vertical-align:top">Sex ||<width="115px" style="vertical-align:top">character 1 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">32 ||<width="277px" style="vertical-align:top">ID number of sire of animal^4^ ||<width="115px" style="vertical-align:top">character 12 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top"> ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top">'''International ID of Dam of ANIMAL''' ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">45 ||<width="277px" style="vertical-align:top">Breedof dam of animal ^2^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">48 ||<width="277px" style="vertical-align:top">Country of first registration of dam of animal^3^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">51 ||<width="277px" style="vertical-align:top">Sex ||<width="115px" style="vertical-align:top">character 1 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">52 ||<width="277px" style="vertical-align:top">ID number of dam of animal^4^ ||<width="115px" style="vertical-align:top">character 12 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top"> ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">65 ||<width="277px" style="vertical-align:top">Birth date of animal (YYYYMMDD) ||<width="115px" style="vertical-align:top">integer 8 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">74 ||<width="277px" style="vertical-align:top">Status of animal^5^ ||<width="115px" style="vertical-align:top">Integer 2 ||<width="127px" style="vertical-align:top">10 || ||<width="96px" style="vertical-align:top">77 ||<width="277px" style="vertical-align:top">Birth date of first AI daughters (YYYYMMDD) ||<width="115px" style="vertical-align:top">Integer 8 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">86 ||<width="277px" style="vertical-align:top">Name of animal^6^ ||<width="115px" style="vertical-align:top">character 30 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top"> ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top">'''National ID of ANIMAL''' ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">117 ||<width="277px" style="vertical-align:top">Breed of animal^2^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">120 ||<width="277px" style="vertical-align:top">Country ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">123 ||<width="277px" style="vertical-align:top">Sex ||<width="115px" style="vertical-align:top">character 1 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">124 ||<width="277px" style="vertical-align:top">ID number of animal^4^ ||<width="115px" style="vertical-align:top">character 12 ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top"> ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> || ||<width="96px" style="vertical-align:top">137 ||<width="277px" style="vertical-align:top">Country sending information ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top"> || == APPENDIX IIa:File Format for Beef Pedigree == ||||||||<tablestyle="text-align:left"width="508px" style="text-align:center;vertical-align:top">'''File Format for Pedigree Delivery to the Interbull Centre for Interbeef Evaluation''' || ||<width="79px" style="vertical-align:top">'''Starting position''' ||<width="229px" style="vertical-align:top">'''Field''' ||<width="95px" style="vertical-align:top">'''Format''' ||<width="105px" style="vertical-align:top">'''Example''' || ||<width="79px" style="vertical-align:top">1 ||<width="229px" style="vertical-align:top">Record type^1^ ||<width="95px" style="vertical-align:top">Character 3 ||<width="105px" style="vertical-align:top">601 || ||<width="79px" style="vertical-align:top"> ||<width="229px" style="vertical-align:top">'''International ID of ANIMAL''' ||<width="95px" style="vertical-align:top"> ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">5 ||<width="229px" style="vertical-align:top">Breed of animal ^2^ ||<width="95px" style="vertical-align:top">character 3 ||<width="105px" style="vertical-align:top">CHA || ||<width="79px" style="vertical-align:top">8 ||<width="229px" style="vertical-align:top">Country of first registration of animal^3^ ||<width="95px" style="vertical-align:top">character 3 ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">11 ||<width="229px" style="vertical-align:top">Sex ||<width="95px" style="vertical-align:top">character 1 ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">12 ||<width="229px" style="vertical-align:top">ID number of animal^4^ ||<width="95px" style="vertical-align:top">character 12 ||<width="105px" style="vertical-align:top">008795005065 || ||<width="79px" style="vertical-align:top"> ||<width="229px" style="vertical-align:top"> ||<width="95px" style="vertical-align:top"> ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top"> ||<width="229px" style="vertical-align:top">'''International ID of Sire of ANIMAL''' ||<width="95px" style="vertical-align:top"> ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">25 ||<width="229px" style="vertical-align:top">Breed of sire of animal ^2^ ||<width="95px" style="vertical-align:top">character 3 ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">28 ||<width="229px" style="vertical-align:top">Country of first registration of sire of animal^3^ ||<width="95px" style="vertical-align:top">character 3 ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">31 ||<width="229px" style="vertical-align:top">Sex ||<width="95px" style="vertical-align:top">character 1 ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">32 ||<width="229px" style="vertical-align:top">ID number of sire of animal^4^ ||<width="95px" style="vertical-align:top">character 12 ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top"> ||<width="229px" style="vertical-align:top"> ||<width="95px" style="vertical-align:top"> ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top"> ||<width="229px" style="vertical-align:top">'''International ID of Dam of ANIMAL''' ||<width="95px" style="vertical-align:top"> ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">45 ||<width="229px" style="vertical-align:top">Breedof dam of animal ^2^ ||<width="95px" style="vertical-align:top">character 3 ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">48 ||<width="229px" style="vertical-align:top">Country of first registration of dam of animal^3^ ||<width="95px" style="vertical-align:top">character 3 ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">51 ||<width="229px" style="vertical-align:top">Sex ||<width="95px" style="vertical-align:top">character 1 ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">52 ||<width="229px" style="vertical-align:top">ID number of dam of animal^4^ ||<width="95px" style="vertical-align:top">character 12 ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">65 ||<width="229px" style="vertical-align:top">Birth date of animal (YYYYMMDD) ||<width="95px" style="vertical-align:top">integer 8 ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">74 ||<width="229px" style="vertical-align:top">Name of animal^6^ ||<width="95px" style="vertical-align:top">character 30 ||<width="105px" style="vertical-align:top"> || ||<width="79px" style="vertical-align:top">105 ||<width="229px" style="vertical-align:top">Country sending information ||<width="95px" style="vertical-align:top">character 3 ||<width="105px" style="vertical-align:top"> || == APPENDIX III: Format File202 Correcting Internationa ID by the Authoritative Organization == (Creates Cross-reference links, valid for dairy and beef users) ||<tablestyle="text-align:left"style="vertical-align:top">'''Field description''' ||<style="vertical-align:top">'''Label''' ||<style="vertical-align:top">'''Format''' ||<style="vertical-align:top">'''Start''' ||<style="vertical-align:top">'''length''' ||<style="vertical-align:top">'''Comments''' || ||<style="vertical-align:top">Record Type ||<style="vertical-align:top">Rec ||<style="vertical-align:top">ASCII ||<style="vertical-align:top">1 ||<style="vertical-align:top">3 ||<style="vertical-align:top">202 || ||<style="vertical-align:top">Wrong/Alias IID ||<style="vertical-align:top">W_AIID ||<style="vertical-align:top">ASCII ||<style="vertical-align:top">5 ||<style="vertical-align:top">19 ||<style="vertical-align:top">usual structure of IID || ||<style="vertical-align:top">Correct IID ||<style="vertical-align:top">R_AIID ||<style="vertical-align:top">ASCII ||<style="vertical-align:top">25 ||<style="vertical-align:top">19 ||<style="vertical-align:top">usual structure of IID || == APPENDIX IV: Request of Pedigree for Authoritative Organization == ||<tablewidth="621px" tablestyle="text-align:left"style="vertical-align:top">'''Field description''' ||<style="vertical-align:top">'''Label''' ||<style="vertical-align:top">'''Format''' ||<style="vertical-align:top">'''Start''' ||<style="vertical-align:top">'''length''' ||<width="165px" style="vertical-align:top">'''Comments''' || ||<style="vertical-align:top">Record Type ||<style="vertical-align:top">Rec ||<style="vertical-align:top">ASCII ||<style="vertical-align:top">1 ||<style="vertical-align:top">3 ||<width="165px" style="vertical-align:top">201 || ||<style="vertical-align:top">'''Animal IID''' ||<style="vertical-align:top">A_IID ||<style="vertical-align:top">'''ASCII''' ||<style="vertical-align:top">'''5''' ||<style="vertical-align:top">'''19''' ||<width="165px" style="vertical-align:top">'''usual structure of IID''' || ||<style="vertical-align:top">'''Sire IID''' ||<style="vertical-align:top">'''S_IID''' ||<style="vertical-align:top">'''ASCII''' ||<style="vertical-align:top">'''25''' ||<style="vertical-align:top">'''19''' ||<width="165px" style="vertical-align:top">'''usual structure of IID''' || ||<style="vertical-align:top">'''Dam IID''' ||<style="vertical-align:top">'''D_IID''' ||<style="vertical-align:top">'''ASCII''' ||<style="vertical-align:top">'''45''' ||<style="vertical-align:top">'''19''' ||<width="165px" style="vertical-align:top">'''usual structure of IID''' || ||<style="vertical-align:top">Animal Birthdate ||<style="vertical-align:top">A_BDATE ||<style="vertical-align:top">yyyymmdd ||<style="vertical-align:top">65 ||<style="vertical-align:top">8 ||<width="165px" style="vertical-align:top">Date format || ||<style="vertical-align:top">Animal Name ||<style="vertical-align:top">A_NAME ||<style="vertical-align:top">ASCII ||<style="vertical-align:top">74 ||<style="vertical-align:top">30 ||<width="165px" style="vertical-align:top"> || ||<style="vertical-align:top">Organization Name ||<style="vertical-align:top">Org_Name ||<style="vertical-align:top">ASCII ||<style="vertical-align:top">105 ||<style="vertical-align:top">10 ||<width="165px" style="vertical-align:top"> || ||<style="vertical-align:top">Reporting Country ||<style="vertical-align:top">A_RC ||<style="vertical-align:top">ASCII ||<style="vertical-align:top">116 ||<style="vertical-align:top">3 ||<width="165px" style="vertical-align:top">Country providing the data || ||<style="vertical-align:top">Breed composition ||<style="vertical-align:top">A_breedcomp ||<style="vertical-align:top">ASCII ||<style="vertical-align:top">120 ||<style="vertical-align:top">8 ||<width="165px" style="vertical-align:top">To be left blank for the time being. || . == APPENDIX V: Corrected Foreign Animals == Each record line is separated from the next by a ‘\n’ ||<tablewidth="621px" tablestyle="text-align:left"style="vertical-align:top">'''Field description''' ||<style="vertical-align:top">'''Label''' ||<style="vertical-align:top">'''Format''' ||<style="vertical-align:top">'''Start''' ||<style="vertical-align:top">'''length''' ||<width="165px" style="vertical-align:top">'''Comments''' || ||<style="vertical-align:top">Reported IID ||<style="vertical-align:top">R_IID ||<style="vertical-align:top">ASCII ||<style="vertical-align:top">1 ||<style="vertical-align:top">19 ||<width="165px" style="vertical-align:top">usual structure of IID || ||<style="vertical-align:top">Official Animal IID ||<style="vertical-align:top">A_IID ||<style="vertical-align:top">ASCII ||<style="vertical-align:top">20 ||<style="vertical-align:top">38 ||<width="165px" style="vertical-align:top">usual structure of IID || ||<style="vertical-align:top">Sire IID ||<style="vertical-align:top">S_IID ||<style="vertical-align:top">ASCII ||<style="vertical-align:top">39 ||<style="vertical-align:top">57 ||<width="165px" style="vertical-align:top">usual structure of IID || ||<style="vertical-align:top">Dam IID ||<style="vertical-align:top">D_IID ||<style="vertical-align:top">ASCII ||<style="vertical-align:top">58 ||<style="vertical-align:top">76 ||<width="165px" style="vertical-align:top">usual structure of IID || ||<style="vertical-align:top">Animal Birthdate ||<style="vertical-align:top">A_BDATE ||<style="vertical-align:top">yyyymmdd ||<style="vertical-align:top">77 ||<style="vertical-align:top">8 ||<width="165px" style="vertical-align:top">Date format || ||<style="vertical-align:top">Animal Name ||<style="vertical-align:top">A_NAME ||<style="vertical-align:top">ASCII ||<style="vertical-align:top">85 ||<style="vertical-align:top">30 ||<width="165px" style="vertical-align:top"> || == APPENDIX VI: FREQUENTLY ASKED QUESTIONS == '''Q.''' How do I know that the pedigree file I have submitted has been successfully uploaded into the database? '''A.''' You will receive a confirmation email with some information on the data you have uploaded, i.e. total number of records and number of records validated by default, i.e. number of new domestic animals you have uploaded.The time of receiving the email depends on the size of the pedigree you have uploaded. If the size of the file is ≤100 kb it gets uploaded in real time and you will shortly after receive the confirmation email. If the size of the file is ≥100 kb it gets uploaded during Swedish night hours as the process requires more time. In that case you will receive a confirmation email the next morning, containing the above mentioned information.You are kindly asked to notify the Interbull staff if you have not received any emails 24 hours after uploading of the file. '''Q.''' What is the difference between “'''''Overview of verified/unverified animals.." '''and "'''''Summary of animals waiting for verification..."'''''? '' '''A.''' In the first statistic you can see how the verification process is proceeding on your foreign animals. In the second statistic you get an overview of how many animals reported by other organizations are still waiting for your verification. '''Q.''' How do I know if I have any animal to verify? '''A.''' By clicking on “Statistic/'''''Overview of verified/unverified animals'''''” the table will show you the number of animals you need to verify and their reporting country. '''Q.''' What do I do if I have animals pending verification? '''A.''' Download from the main menu the request of pedigree file. For each of the animal listed in the file you need to provide pedigree information as they appear in your own database and upload them using a file200 format previously checked by CheckPedigree.pl. If you notice that the IID of the animals is wrong or is an alias ID then you also have to submit a file202. '''Q.''' What I have to do if some IIDs listed in the request of pedigree cannot be found in my own database? '''A.''' In this case you only have to submit a file202 with 19 “U”s (i.e. UUUUUUUUUUUUUUUUUUU) in the correct IID field. '''Q.''' What do I do if I notice that an animal has been reported using a cross-reference ID instead than the official IID? '''A.''' Provide the pedigree information for that animal as it appears in your own database using a file200 previously checked by CheckPedigree.pl and also provide a file202 putting the correct official IID in the correct IID field. '''Q.''' Can the actual system distinguish between ID formally correct but written in a different format and the real wrong ID? '''A.''' Anytime the authoritative organization provides a file202 the “wrong/alias ID” gets stored in a particular table called “alternative scheme table”. The system does not distinguish between “formally correct” or “real wrong” IDs. The system is built on the principle that every ID is considered as potentially wrong until it gets validated by the authoritative organization. If an authoritative organization provides a “correct ID” (cross-reference link, file202) it means that the ID provided by the reporting organization was not entirely correct so it gets replaced with the one provided by the authoritative organization. The information provided by the reporting country is not lost but stored in the alternative scheme table. In case the ID reported in the correct field is represented by the unknown ID (i.e. 19 “U”s) then that ID is treated as “real wrong” and placed in the limbo space. '''Q.''' Can I download pedigree information from the interface? '''A.''' After every evaluation you will be able to download the international pedigree for the breeds evaluated at the Centre and for which you participate to the Interbull evaluation. |
USER MANUAL FOR THE IDEA INTERFACE
Preface
The following is a manual to guide the user through the features of the new IDEA. IDEA stands for Interbull Data Exchange Area. IDEA is a restricted area accessible only to member countries through the Interbull website.
- Last updated May 11 , 2012
Contents
-
USER MANUAL FOR THE IDEA INTERFACE
- Preface
- LOG IN
- AFTER YOU LOG IN
- Animal IID Query
- Upload
- Download menu link
- APPENDIX I: Organization Codes as provided by Interbull Centre
- APPENDIX II: File Format 200 for Dairy Pedigree
- APPENDIX IIa:File Format for Beef Pedigree
- APPENDIX III: Format File202 Correcting Internationa ID by the Authoritative Organization
- APPENDIX IV: Request of Pedigree for Authoritative Organization
- APPENDIX V: Corrected Foreign Animals
- APPENDIX VI: FREQUENTLY ASKED QUESTIONS
LOG IN
To enter the main page of IDEA go to https://idea.interbull.org You will be required to provide a username and password to log in.
Your username is equal to the intial of your name followed by your surname. For example, the user name for Thomas White will be twhite. If your surname contains special character, such as ö, ä, å etch, write it with the corresponding ASCII letters, i.e. o,a, etc.
Your username is associated to the organization you belong to. IDEA has a table linking together usernames and organizations for the persons that have had so far regular contacts with the Centre. If you wish for one of your co-worker to have access to IDEA, simply notify the Centre with his/her name and email address.
Access to IDEA is, therefore, set to an individual access. If you used to share your password in the past, it is your responsability to change it to a new password.
First time log in
You will receive a temporary password from Interbull Centre. Use your username, as described above, and your temporary password to log in.
AFTER YOU LOG IN
Welcome to IDEA!!!
The first thing you need to do is to change the temporary password to one of your choice.
The main User Menu appears in the top navigation pane with several menu items that will allow you to interact with the database. In this section we give you an explanation of their functions.
Home Menu
The IDEA Home menu gives you access to the main functions available in the database. Currently these functions are solely related to the pedigree handling, but new functions for handling of conventional MACE, genotypes etc, will also be accessible from here whenever their modules will be implemented.
The available pedigree functions are: Query, Uploads, Conflicts, Statistics.
Query
If you want to get pedigree information on a particular animal, click on Query menu link.The page that will open contains an Animal lookup,by inserting an International ID in the Animal lookup and then clicking on Lookup! will show the information related to your query.
The central part of the page will show the international ID of the animal you were interested, followed by its name, birth date and birth date status, animal status, date of last update and who performed the last update.
Above it, by clicking on "Parents:show/hide" you get access to the animal's parents and grand-parents.
Below it, by clicking on "Offspring: show/hide" you get access to a table listing all the animal's offspring together with tehir name and birth date. The table, by default, shows the first 200 offsprings associated to the aniaml ID. You can however modify the number of entries by clicking on the harrow beside "entries". Likewise, if you are only interested on a specific offspring, you can search for it by inserting its IID in the "search" space.
Each ID reported in the parents and offspring section, is an active link, therefore clicking on any displayed ID will update the page with that animal’s pedigree information.
If you enter an alias ID in the Animal lookup space you will see the official IID associated to that alias id.
Your profile
Username is by default equal to your organization code and, as it is used throughout the system to identify your organization as the authoritative organization for the animals you have right to administer, it cannot be changed. In case you notice that the email address is incorrect or if you want to change any information, click on Your profile menu link. On the page that will open on the right pane you will be able to change/update user information, such as:
Your name: By default your name is set equal to your organization name and would appear as a header in all the others windows. If you like to change it with your own name, simply type it in the corresponding box. National characters might not be readable so please avoid them.
E-mail: This is the email address the database services will use to contact you, so double check that it is always up to date.
Password: In here you can reset your password. To complete the change you need to confirm your new password in the Verify Password box.
N.B. For the changes to be effective click SAVE at the bottom of the page!!
Animal IID Query
Upload
The upload menu link is set up for uploading of pedigree, proofs, parameters and forms such as GE and validation forms. At the moment only the feature to upload the pedigree is active; other upload options will be implemented soon.
Upload Pedigree and Cross-reference links
Whether you want to upload a whole pedigree file, pedigree information for just few bulls or create cross-reference links, simply click on the Upload Pedigree button.
You will be directed to a new window in which you can browse the file(s) you want to upload through the browse button. In this window you have the possibility to upload two different files:
Using the New pedigree box you can upload the zip file produced by the CheckPedigree.pl program, being this file the output including all your pedigree information, a part of them (i.e. just new bulls or ancestors) or pedigree information for animals you need to verify (for the verification procedure see below).
Using the Correct ID box you can upload a file202 which creates cross-reference links or set a given ID to invalid. The format to use is reported in Appendix III.
A file 202 can be used to correct animals’ IDs appearing in your “Request of Pedigree” or to create cross reference links among domestic animals you have previously uploaded.
N.B.·
- The file202 cannot be zipped and does not require a special name, i.e. you can name it as you like giving it whatever extension but not a .zip·
- You cannot link a male animal into a female animal and vice versa.·
- In order for this function to work properly it is necessary that the “wrong/alias IID” is already present in the database, if this is not the case you will get a screen message of the type:
Wrong/Alias ID → Correct ID Not Linked To make the link work first upload a pedigree record for the animal you want to change ID and then upload a file202.·
- When the link is successful the message on the screen will be of the type:
Wrong/Alias ID → Correct ID Linked·
- You are allowed to link together only animals for which you are authoritative for. If you attempt to perform a link between two animals and one or both of them are outside your competence, then the message on the screen will be of the type:
Wrong/Alias ID → Correct ID Not authority over this animal
You can upload both files, pedigree and file202, together or just one of them. After you have browsed the files and have clicked on the Upload button you will be asked to confirm that the files you have chosen are the correct ones.
By clicking Process you will confirm that the files are ok and their content will be loaded into the database.
If you click the Delete button the file(s) will be dropped from the Interbull server.
The uploading of the file202 and the creation of the cross-reference links in the database will happen in real time while for the pedigree file, depending on its size, the loading will be executed on line or in a batch queue through the buffer disk. In any case a message on the screen will inform you that the data has been successfully sent to Interbull server and will be loaded later. You will be notified by email when the loading has been completed.
N.B. Keep in mind that by clicking on the Delete button means that no file(s) have been sent or loaded to the database and therefore you will have to start the loading procedure once again
Creation of cross reference in the database
The creation of cross reference in the database is made by uploading of a file202 (see above). Two IDs will be always considered as two different animals until a proper file202 is uploaded. For creation of cross references involving animals belonging to two different organizations please send an email to Valentina ( valentina.palucci@slu.se ). Interbull staff can in fact act as “super user” and create a cross reference for these special cases.
Name of the animal
The official name of an animal is equal to the name provided by each official organization. To avoid sudden changes in names or name missing it is extremely important that each authoritative organization always provide a name record, whenever available, for every uploading and be consistent with the name, i.e. do not provide the full name for the first uploading and a short version of it for the next, otherwise the name of the animal will get overwritten.
How do I change/add a name for a given animal?
Only authoritative organization can modify the name of an animal. To do so simply upload a pedigree file with the new name information and the changes will be recorded in the database.
Download menu link
Clicking on the Download button you will be able to get information about pedigree, proofs, parameters, forms, retrieve a list of animals waiting for your validation (as you appear to be their authoritative organization) or check the list of invalid international ID. Many of the features contained in this tab are still under development but you can already get access to the list of animals waiting for your validation as well as check the invalid international id.
Retrieve your "Request of Pedigree"
By clicking on here you will be directed into an ascii file following the format shown in Appendix IV. You can save the file by clicking on “File/Save As” in the tool bar.The ascii file contains a list of all animals as loaded by reporting countries and for which you appear as the authoritative organization. This means that only you have the right to say if the pedigree record is correct or not.
Verification Process: How does it work?
For each animal listed in your “Request of Pedigree” file yhave to upload its pedigree information as it appears in your own database, using file format 200 and checkpedigree.pl.By doing so you are verifying the reported information as the system considers verified only the information provided by the authority organization. When you are verifying an animal record you might find yourself in front of four possible scenarios, below you find instructions on what to do for each of them.
Scenario 1
If you find that the animal ID reported is correct then you will have to:
Upload a pedigree file (file200 previously inspected by CheckPedigree.pl) as it appears in your own database, weather the reported pedigree information is correct or not.
Scenario 2
If you notice that an animal has been reported with an incorrect international id then you will have to:
- Upload a pedigree record for that animal using its correct id
- AND upload a file202. The file202 will provide the cross-reference link between the reported animal id and the animal id you verified.
Example:
A country submitted a pedigree for the animal BSWUSAF000000569466 using the ID BSWUSAF000000659466.
As it is an USA animal, the animal will appear in the USA list of Request of Pedigree. When looking at the record USA notices that two numbers have been misplaced. So USA will upload a pedigree file using the correct id for the animal (BSWUSAF000000569466) together with a file202 which will look like:
202 BSWUSAF000000659466 BSWUSAF000000569466
Scenario 3
If you realize that a given animal has been erroneously associated to your organization then:
- If you know the right authoritative organization, upload a pedigree file containing the new international ID of that animal. Doing so the animal will be sent for validation to the organization associated to the country you specified in its international ID.
Example:
Animal BSWUSAM000803611398 is sent to USA for validation but USA realizes the animal belong to DEU instead.
USA uploads a file200 (checked by CheckPedigree.pl) for the animal BSWDEUM000803611398
Scenario 4
If you do not know anything about that animal and it does not appear in your database then you have to:
- Upload a file202 containing “UUUUUUUUUUUUUUUUUUU” in the “correct IID” field.
Doing so the animal’s international ID will be considered as invalid and listed in the limbo (for the limbo see below)
Example:
Animal BSWUSAM000000000008 cannot be found in the USA database.The file 202 will be:
202 BSWUSAM000000000008 UUUUUUUUUUUUUUUUUUU
You will have to upload your files using the uploading pedigree tool you find in the upload tab.
Corrected Foreign Animals
In this file you find information on the validation activity over an IID, and its pedigree, done by each authoritative organization on your foreign animals. Therefore by checking it you can get the corrected IDs, or pedigrees, of some of the animals you have been reported that have been corrected by their authoritative organizations.You can open the file by clicking on the link or save it directly on your computer. The file format is specified in Appendix V.
The content of the file will be completely updated after extraction of the pedigree for each Interbull evaluation. You therefore have the time between extractions to check the file and eventually do the necessary correction in your own database.
Look at the Limbo
By clicking on the limbo tab you will get access to the list of international IDs that were not recognized by their authoritative organizations and therefore set to unknown. The list is available for you to double check your database and eventually update it accordingly.
Download Pedigree
After every Interbull evaluations the international pedigree for the six breeds evaluated at the Centre will be available for download. By clicking on Download Pedigree you will have access to the international pedigree used in the latest Interbull evaluation. You will be entitled to have access only to the international pedigree of the official breed(s) with which you participate to the Interbull evaluation.You will be able to either look at the pedigree or saved it on your own computer.
Statistics Menu Link
The Statistics menu link contains general information about your pedigree.
Overview of verified/unverified animals submitted by your organization
The table shows the general situation of your pedigree data as it is in the database at the time of your log in. The table contains the country of the authoritative organization, the number of animals that have already been validated by it and the number of animals that are still waiting for validation, for all the breeds you have submitted. By clicking on the drop down menu you can select a particular breed among your own and have the same statistics recalculated just for that breed.
N.B. among all the animals in the “animal” field that you have uploaded, the ones having your country code in their international ID are considered validated by default because you are their authoritative organization, therefore there should not be any animals still pending validation by your country in this table. If this is not the case it means that there are some parents without an entry in the animal field and could not be validated because the validation procedure takes place in the animal field. To prevent this to happen, you will have to upload pedigree records for the animals and their parents as well.
Summary of animals waiting for verification by your organization
This table contains the list of all animals submitted to the Interbull database by other organizations for which you appear to be the authoritative organization and therefore you need to provide the correct information (see verification procedure above) . The table contains the total number of records, the reporting organization’s name and its country code. This table is useful for you to monitor your verifying ID tasks.
Pedigree Conflicts
Although your national pedigree file has been already checked by the CheckPedigree.pl for pedigree conflicts, there is the possibility that the international pedigree still shows some birthdays conflicts.To check for that click on Pedigree Conflicts bottom, you will be directed into a new page showing all conflicts where your organization is involved. Below is an explenation of the Pedigree Conflicts page content:
The IID listed is the one of an animal in which pedigree there is one of more conflicts. The type of conflicts are shown in the Conflict path column, where S, D, SD means that the sire, the dam or the sire of the dam birthdate is conflicting with the animal’s birthdate.
The cross (x) in the “Strange” column indicates that all animals involved in the conflict have already been verified by their own authoritative organization.
Clicking on “Details” will open a new page showing more details on the animals in conflict.
How to handle animal's conflicts?
Sometimes a conflict could be due to unverified animals, if this is the case please proceed on verifying the animals double checking that the new birthdate you are going to provide will no more be in conflict.
If you do not know how to fix the conflict you should contact Interbull Centre deciding what action you, as the authoritative organization for that animal, want to take.
So, in general, to fix a conflict you should:
- Upload new pedigree file of the conflicting animal with a new no-conflicting birthdate
In case you do not know how to fix it you should contact Interbull Centre
Pedigree Duplicates
By clicking on “Pedigree Duplicates” you will see a list of potential duplicates associated to your organization. The list shows five pairs at the time.
For each animal listed you will see its international IID and birthday, by clicking on its IID you will access to its pedigree information. Beside each IID you have an empty box to mark.
How to handle pedigree duplicates?
In case you realize that the animals shown in the list are indeed duplicates, mark the box associated to the official IID. If the animals are NOT duplicates mark both boxes. Then press “Submit Changes” and the changes will be saved and stored in the database.
The pairs you have processed will be dropped from your list only if you are authority for both animals in the pair. Otherwise the conflict will remain in your list until the other authoritative organization provides your same answer.
What is the meaning of the star?
Whenever you are authoritative only for one animal IID showed in the pair, your submission will be kept on a hold and showed with a star (*) until the other authoritative organation has also the opportunity to look into the matter and expressed its own opinion. There can be two different scenarios:
- You and the other authoritative organization have submitted the same information: The change will then become official in the database and the pair will drop from your list.
- You and the other authoritative information have provided different information:The “disagreement” will be mark by stars (*) in both IID. No changes will happen in the database. You should contact the other authoritative organization via Interbull Centre. The conflict remains in your list.
APPENDIX I: Organization Codes as provided by Interbull Centre
Org. code |
Organization name |
Country |
ADHIS |
Australian Dairy Herd Improvement Scheme |
Australia |
GEMBLOUX |
Gembloux Agricultural University, Animal Breeding and Genetics group |
Belgium |
CDN |
Canadian Dairy Network |
Canada |
PLEMDAT |
Czech Moravian Breeders' Corporation |
Czech Rep. |
NAV |
Nordic Cattle Genetic Evaluation |
Denmark |
ARC |
Estonian Animal Recording Centre |
Estonia |
INRA |
Institut de l'Elevage |
France |
GRUB |
Bavarian State Research Center for Agriculture, Institute of Animal Breeding |
Germany |
VIT |
United Data Systems |
Germany |
OMMI |
National Institute for Agricultural Quality Control |
Hungary |
ICBA |
Israeli Cattle Breeders' Association |
Israel |
ICBF |
Irish Cattle Breeding Federation |
Ireland |
ANARB |
Italian Brown Cattle Breeder's Association |
Italy |
ANAFI |
National Association of Holstein Breeders |
Italy |
ANAPRI |
Italian Simmental Fleckvieh Breeder's Association |
Italy |
NLBC |
National Livestock Breeding Centre |
Japan |
LIETUVA |
Ministry of Agricolture |
Lithuania |
LDC |
Agricultural Data Centre |
Latvia |
GENO |
GENO |
Norway |
LIC |
Livestock Improvement Corporation |
New Zealand |
NABC |
National Animal Breeding Centre |
Poland |
ANABLE |
Portuguese Research centre |
Portugal |
PSSR |
The Breeding Services of the Slovak Republic |
Slovak Rep |
BFRO |
University of Ljubljana, Zootechnical department |
Slovenia |
NIAS |
Korean National Institute of Animal Science |
South Korea |
CONAFE |
Confederation of Spanish Holstein Associations |
Spain |
HACHE |
Holstein Association, Switzerland |
Switzerland |
BRAUNVIEH |
Swiss Brown Cattle Breeders' Federation |
Switzerland |
FLECKVIEH |
Swiss Simmental and R&W Cattle Breeder's Association |
Switzerland |
CRDELTA |
CR-Delta |
The Netherlands |
SAC |
Scottish Agricultural College |
Great Britain |
USDA |
AIPL, USDA |
USA |
ARCAII |
ARC, Animal Improvement Institute |
South Africa |
SASB |
SA Studbook |
South Africa |
ARCB |
Agricultural Research Council_INTERBEEF |
South Africa |
CMBCB |
Czech Moravian Breeders Corporation_INTERBEEF |
Czech Republic |
FABAB |
Faba Coop_INTERBEEF |
Finland |
FECLB |
Federación Española de Criadores de Limusin_INTERBEEF |
Spain |
ICBFB |
Irish Cattle Breeding Federation_INTERBEEF |
Ireland |
INRAB |
Institut de l'Elevage_INTERBEEF |
France |
NAVB |
Nordic Cattle Genetic Evaluation_INTERBEEF |
Denmark |
SACB |
Scottish Agricultural College_INTERBEEF |
Great Britain |
SDAB |
Swedish Dairy Association_INTERBEEF |
Sweden |
APPENDIX II: File Format 200 for Dairy Pedigree
|
|||
Starting position |
Field |
Format |
Example |
1 |
Record type1 |
Character 3 |
200 |
|
International ID of ANIMAL |
|
|
5 |
Breed of animal 2 |
character 3 |
HOL |
8 |
Country of first registration of animal3 |
character 3 |
|
11 |
Sex |
character 1 |
|
12 |
ID number of animal4 |
character 12 |
000000A12345 |
|
|
|
|
|
International ID of Sire of ANIMAL |
|
|
25 |
Breed of sire of animal |
character 3 |
|
28 |
Country of first registration of sire of animal3 |
character 3 |
|
31 |
Sex |
character 1 |
|
32 |
ID number of sire of animal4 |
character 12 |
|
|
|
|
|
|
International ID of Dam of ANIMAL |
|
|
45 |
Breedof dam of animal 2 |
character 3 |
|
48 |
Country of first registration of dam of animal3 |
character 3 |
|
51 |
Sex |
character 1 |
|
52 |
ID number of dam of animal4 |
character 12 |
|
|
|
|
|
65 |
Birth date of animal (YYYYMMDD) |
integer 8 |
|
74 |
Status of animal5 |
Integer 2 |
10 |
77 |
Birth date of first AI daughters (YYYYMMDD) |
Integer 8 |
|
86 |
Name of animal6 |
character 30 |
|
|
|
|
|
|
National ID of ANIMAL |
|
|
117 |
Breed of animal2 |
character 3 |
|
120 |
Country |
character 3 |
|
123 |
Sex |
character 1 |
|
124 |
ID number of animal4 |
character 12 |
|
|
|
|
|
137 |
Country sending information |
character 3 |
|
APPENDIX IIa:File Format for Beef Pedigree
File Format for Pedigree Delivery to the Interbull Centre for Interbeef Evaluation |
|||
Starting position |
Field |
Format |
Example |
1 |
Record type1 |
Character 3 |
601 |
|
International ID of ANIMAL |
|
|
5 |
Breed of animal 2 |
character 3 |
CHA |
8 |
Country of first registration of animal3 |
character 3 |
|
11 |
Sex |
character 1 |
|
12 |
ID number of animal4 |
character 12 |
008795005065 |
|
|
|
|
|
International ID of Sire of ANIMAL |
|
|
25 |
Breed of sire of animal 2 |
character 3 |
|
28 |
Country of first registration of sire of animal3 |
character 3 |
|
31 |
Sex |
character 1 |
|
32 |
ID number of sire of animal4 |
character 12 |
|
|
|
|
|
|
International ID of Dam of ANIMAL |
|
|
45 |
Breedof dam of animal 2 |
character 3 |
|
48 |
Country of first registration of dam of animal3 |
character 3 |
|
51 |
Sex |
character 1 |
|
52 |
ID number of dam of animal4 |
character 12 |
|
65 |
Birth date of animal (YYYYMMDD) |
integer 8 |
|
74 |
Name of animal6 |
character 30 |
|
105 |
Country sending information |
character 3 |
|
APPENDIX III: Format File202 Correcting Internationa ID by the Authoritative Organization
(Creates Cross-reference links, valid for dairy and beef users)
Field description |
Label |
Format |
Start |
length |
Comments |
Record Type |
Rec |
ASCII |
1 |
3 |
202 |
Wrong/Alias IID |
W_AIID |
ASCII |
5 |
19 |
usual structure of IID |
Correct IID |
R_AIID |
ASCII |
25 |
19 |
usual structure of IID |
APPENDIX IV: Request of Pedigree for Authoritative Organization
Field description |
Label |
Format |
Start |
length |
Comments |
Record Type |
Rec |
ASCII |
1 |
3 |
201 |
Animal IID |
A_IID |
ASCII |
5 |
19 |
usual structure of IID |
Sire IID |
S_IID |
ASCII |
25 |
19 |
usual structure of IID |
Dam IID |
D_IID |
ASCII |
45 |
19 |
usual structure of IID |
Animal Birthdate |
A_BDATE |
yyyymmdd |
65 |
8 |
Date format |
Animal Name |
A_NAME |
ASCII |
74 |
30 |
|
Organization Name |
Org_Name |
ASCII |
105 |
10 |
|
Reporting Country |
A_RC |
ASCII |
116 |
3 |
Country providing the data |
Breed composition |
A_breedcomp |
ASCII |
120 |
8 |
To be left blank for the time being. |
APPENDIX V: Corrected Foreign Animals
Each record line is separated from the next by a ‘\n’
Field description |
Label |
Format |
Start |
length |
Comments |
Reported IID |
R_IID |
ASCII |
1 |
19 |
usual structure of IID |
Official Animal IID |
A_IID |
ASCII |
20 |
38 |
usual structure of IID |
Sire IID |
S_IID |
ASCII |
39 |
57 |
usual structure of IID |
Dam IID |
D_IID |
ASCII |
58 |
76 |
usual structure of IID |
Animal Birthdate |
A_BDATE |
yyyymmdd |
77 |
8 |
Date format |
Animal Name |
A_NAME |
ASCII |
85 |
30 |
|
APPENDIX VI: FREQUENTLY ASKED QUESTIONS
Q. How do I know that the pedigree file I have submitted has been successfully uploaded into the database?
A. You will receive a confirmation email with some information on the data you have uploaded, i.e. total number of records and number of records validated by default, i.e. number of new domestic animals you have uploaded.The time of receiving the email depends on the size of the pedigree you have uploaded. If the size of the file is ≤100 kb it gets uploaded in real time and you will shortly after receive the confirmation email. If the size of the file is ≥100 kb it gets uploaded during Swedish night hours as the process requires more time. In that case you will receive a confirmation email the next morning, containing the above mentioned information.You are kindly asked to notify the Interbull staff if you have not received any emails 24 hours after uploading of the file.
Q. What is the difference between “Overview of verified/unverified animals.." and "Summary of animals waiting for verification..."?
A. In the first statistic you can see how the verification process is proceeding on your foreign animals. In the second statistic you get an overview of how many animals reported by other organizations are still waiting for your verification.
Q. How do I know if I have any animal to verify?
A. By clicking on “Statistic/Overview of verified/unverified animals” the table will show you the number of animals you need to verify and their reporting country.
Q. What do I do if I have animals pending verification?
A. Download from the main menu the request of pedigree file. For each of the animal listed in the file you need to provide pedigree information as they appear in your own database and upload them using a file200 format previously checked by CheckPedigree.pl. If you notice that the IID of the animals is wrong or is an alias ID then you also have to submit a file202.
Q. What I have to do if some IIDs listed in the request of pedigree cannot be found in my own database?
A. In this case you only have to submit a file202 with 19 “U”s (i.e. UUUUUUUUUUUUUUUUUUU) in the correct IID field.
Q. What do I do if I notice that an animal has been reported using a cross-reference ID instead than the official IID?
A. Provide the pedigree information for that animal as it appears in your own database using a file200 previously checked by CheckPedigree.pl and also provide a file202 putting the correct official IID in the correct IID field.
Q. Can the actual system distinguish between ID formally correct but written in a different format and the real wrong ID?
A. Anytime the authoritative organization provides a file202 the “wrong/alias ID” gets stored in a particular table called “alternative scheme table”. The system does not distinguish between “formally correct” or “real wrong” IDs. The system is built on the principle that every ID is considered as potentially wrong until it gets validated by the authoritative organization. If an authoritative organization provides a “correct ID” (cross-reference link, file202) it means that the ID provided by the reporting organization was not entirely correct so it gets replaced with the one provided by the authoritative organization. The information provided by the reporting country is not lost but stored in the alternative scheme table. In case the ID reported in the correct field is represented by the unknown ID (i.e. 19 “U”s) then that ID is treated as “real wrong” and placed in the limbo space.
Q. Can I download pedigree information from the interface?
A. After every evaluation you will be able to download the international pedigree for the breeds evaluated at the Centre and for which you participate to the Interbull evaluation.