Import of pigs from Excel
Import of pig fattening groups
In Pantheon we have also possibility to import pigs in fattening module from external file. On pig fattening module 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:
| Herd |
ID of herd to which animals will be added. Herd has to be inserted in Animal groups with appropriate settings (classification = Pigs, Feedlots = True). |
| Arrival type |
Type of arrival. Values are coded as follows:
AC - Arrival by contract
CL - Birth
IN - Inventory (on 31.dec.)
PR - Purchase
|
| Serial no. |
Serial number (ID) of pig group. |
| Weight |
Weight at arrival. |
| No. of animals |
Number of animals with selected ID. |
| Arrival date |
Date of arrial to farm (if born on farm, the date is the same as date of birth). |
| Breed |
Animal breed. Breed has to be inserted in Items. |
| Previous location |
Previous location of animal. If arrival type is birth (CL) then this information is not needed as it is the same as ID of our farm. |
| Price |
Price at arrival. |
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. Once you fill missing data,button save will become active and you can save your data.
After save additional message will appear that enables you to close import form of import additional file.