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) |
Location of animal. Group has to be inserted in agricultural holding. |
| Animal ID (acAnimal) |
ID of animal. If this field is left blank, software will automatically calculate AUTOID for this animal at import. |
| 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
|
| Breeding focus (acOrientation) |
Brreeding focus of animal. Values are coded as follows:
CL - Combined-milk
CO - Combined
CT - Combined-meat
HR - Breeding
ML - Milk
MT - Meat
SC - Suclker cows
|
| acMotherID |
ID of animal's mother.
|
| acMotherName |
Name of animal's mother. |
| acFatherID |
ID of animal's father. |
| acFatherName |
Name of animal's father.
|
| adDateArrival |
Date of arrival to farm. In case of birth date of arrival is the same as date of birth.
|
| Arrival Type (acTypeArrival) |
Type of arrival. Values are coded as follows:
AC - Arrival by contract
CL - Birth
IN - Inventory (on 31.dec.)
PR - Purchase
|
| Arrival weight (anWeightArrival) |
Weight at arrival. |
| Price (anPriceArrival) |
Price at arrival.
|
| Contract No. (acContractNo) |
In case of contract rearing, number of contract. Contract has to be inserted in agricultural holding |
When we fill the excel we can imported to Pantheon. With click on button Import from Excel, we import this data to our database.
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. |