Import Animals from excel structure
In Pantheon we have also possibility to import Animals from excel structure. On animal card on button import / export
we choose Import animals from excel.
Program opens new windows:

With click on button export structure excel
, we get excel wit all data that are necessary for import data back to Pantheon.

In this excel we enter data about our animals.

The data that are important are:
(903/905/906/915) (acSetOfAnimalType) |
903 - for Cattle
905 - for sheep and goat
906 - for pigs
915 - horses
|
Animal ID |
We enter animals ID's |
Data of birth |
We enter data of birth for all animals |
(1/2) ac sex |
1 - male
2- female
|
 |
In case that program create this excel table in second, third,...sheet, we have to delete all empty sheets

|
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. |