Import Animals from excel structure
In Pantheon we have also possibility to import Animals from Excel file. On animal card or animal record on button import / export 
we choose Import animals from excel.
With click on button export Excel structure, we get Excel file with columns for import data back to Pantheon. Structure goes as follows:
| (903/905/906/915) (acSetOfAnimalType) |
903 - for Cattle
905 - for sheep and goat
906 - for pigs
915 - horses
|
| Agricultural Holding (acGmid) |
Lication of animal. Group has to be inserted in agricultural holding. |
| Animal ID (acAnimal) |
ID of animal. |
| Common Name (acName) |
Name of animal.
|
| Date of Birth (adDateBirth) |
Date of birth of animal.
|
| Breed (acBreed) |
Breed of animal. Breed has to be inserted in items. |
| (1/2) ac sex |
Gender of animal. Values are codded as follows:
1 - male
2- female
|
| (1/2) ac sex |
|
| (903/905/906/915) (acSetOfAnimalType) |
|
| Animal ID |
|
| Data of birth |
|
| (1/2) ac sex |
|
| (903/905/906/915) (acSetOfAnimalType) |
|
| Animal ID |
|
| Data of birth |
|
| (1/2) ac sex |
|
When we fill the excel we can imported to Pantheon. With click on button Import from excel 
, we import this data to our database
On click on button Import from excel, we find excel, where we have save our data in computer
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.
| Type |
Type of animals. |
| Purpose |
Purpose of animals. |
| Acquisition type |
Acquisition type of animals. Acquisition type has to be inserted in animal movement codebook as acquisition. |
| Seller |
Seller (previous owner) of animals. Seller has to be inserted in subjects. |
| Contract |
If animals are bred under contract, contract can be selected. Contract has to be inserted in contracts. |
| Weight | Total weight... |
Total weight of all selected animals. This value is then recalculated as average to selected animals. |
| Weight | Average weight... |
Average weight of animals. This value is added to each selected animal. |
| Price | Total price... |
Total price of all selected animals. This value is then recalculated as average to selected animals. |
| Price | Average price... |
Average price of animals. This value is added to each selected animal. |