Import Anmials from excel structure

Import of animals

In Pantheon we have also possibility to import Animals from external file. On animal card or animal record on button import / export  we select Import animals. Form to import animals wil appear

Before import you first have to select appropriate template. Each category already contains system template in database and you can always use this template. Through template designer in Administration Panel you select appropriate fields for import. Field name that is colored red is obligatory. Animal import currenty support selected fields:

Once you select appropriate template you can add file(s) to form in different ways: (1) by clicking on button Import from file and selecting desired file(s) or (2) with drag and drop, where you drag desired file directly to import form. If you are importing multiple files, you can select or drag and drop multiple files at once. You can also drag and drop whole folder to import form and all appropriate files will be imported.

If you have already selected one file and select another file, an IRIS message will appear that enables you to add file to existing data or overwrite exisiting data with new file.

If you want to review data that codes are applicable and animals exisit in the database, you can use function Check data. This function will review whole dataset and it is only applicable for large datasets. If there are less than 1.000 records in import form, Pantheon will automatically check data at the beggining and after each change. For datasets between 1.000 and 5.000 Pantheon will only check data at the beggining and not for each change. If dataset is larger than 5.000 data check has to be done automatically.

If you would like to export created template to fill file with data, you can use button Export template   Software will export Excel file with the same structure as template. It will also save it with the same name as the name of template. Template file will be saved in desired location ant Excel will form two tabs:

• Data, which is blank, contains only column names and it is used to fill it with data.
• Help, which contains list and description of fields that can be imported in selected category (for reprodution same list as it is above in the table). This could be used as help which data can be imported or as description for which data has to be inserted in specific fields (e.g. codes for insemination type, result, etc.).

Once you click save an import seleted information, software will enable you to either close import window or finish import, leave import window open and import additional file.

Once you imported file, ID of file is stored in the database which prevents you to import the same file again.

Missing data

If some data is missing in imported Excel, user can find explanation in column Note, what value exactly is missing.

User can select missing value from dropdown or insert value manually. If data is missing for more rows (like breed in screenshot above), he can select rows, that have missing values and add data with right click on mouse button. A menu below will appear and he can select, what he would like to insert.