Morning/ evening/ whatever time is is for you folk.
I am working on a script that can be executed from any machine to import an animal and make sure the breed/species is also set. does anyone have a working script i can look over to see where i am missing things?
Currently using this script.
from farmOS import farmOS
from datetime import datetime
import csv
hostname = "farming.*****.*******"
username = *****************
password = **********************
# Maintain an external state of the token.
current_token = None
# Callback function to save new tokens.
def token_updater(new_token):
print(f"Got a new token! {new_token}")
# Update state.
current_token = new_token
# Create the client.
farm_client = farmOS(
hostname=hostname,
token_updater=token_updater, # Provide the token updater callback.
)
# Authorize the client (initial or refresh token):
if not current_token:
current_token = farm_client.authorize(username, password, scope="farm_manager")
else:
# Use existing token if available (optional refresh logic)
pass
# Create the animal
animal_data = {
"attributes": {
"name": "My Great Planting",
},
}
response = farm_client.asset.send('animal', animal_data)
but i am getting an error at the last line saying
“”“422 Client Error: Unprocessable Content for url”“”
Sounds like you’ve already identified the issue! The “Animal Type” (animal_type) field is required on animal assets (aka “Species/breed”). It belongs in the relationships of the asset. If you create an animal through the farmOS UI you can look at it in the API to see how animal_type needs to be formatted. It needs to reference the UUID of a taxonomy_term in the animal_type vocabulary.
You can fetch a list of animal_type terms from the API to find the UUID of the term you want. If the term does not exist, you will need to create it first before you can reference it on the animal asset.
Once you have the UUID, I think your code will look something like this:
# Create the animal
animal_data = {
"attributes": {
"name": "My Great Animal",
},
"relationships": {
"animal_type": {
"data": {
"id": "5d9cce61-032f-4dba-b67c-999429505a12",
},
},
},
}
from farmOS import farmOS
from datetime import datetime
import pandas as pd
import csv
hostname = "farming.****************.cloud"
username = "*************"
password = "*************"
# Maintain an external state of the token.
current_token = None
# Callback function to save new tokens.
def token_updater(new_token):
print(f"Got a new token! {new_token}")
# Update state.
current_token = new_token
# Create the client.
farm_client = farmOS(
hostname=hostname,
token_updater=token_updater, # Provide the token updater callback.
)
# Authorize the client (initial or refresh token):
if not current_token:
current_token = farm_client.authorize(username, password, scope="farm_manager")
else:
# Use existing token if available (optional refresh logic)
pass
def create_find_animal_type(data):
animal_type_search = farm_client.term.iterate(
'animal_type',
params=farm_client.filter('name', data),
)
animal_type = next(iter(animal_type_search), None)
# If the animal type does not already exist, create it
if animal_type is None:
term_create_response = farm_client.term.send(
'animal_type',
{"attributes": {"name": data}}
)
animal_type = term_create_response["data"]
return animal_type
with open(r"csv_asset--animal.csv", newline='') as csvfile:
csv_reader = csv.DictReader(csvfile)
for animal in csv_reader:
animal_dob = datetime.strptime(animal['birthdate'], "%Y-%m-%d")
animal_type = create_find_animal_type(animal["animal type"])
# Create the animal
animal_create_response = farm_client.asset.send('animal', {
"attributes": {
"name": animal['name'],
"sex": animal['sex'],
"birthdate": animal_dob.strftime('%Y-%m-%dT%H:%M:%S+00:00'),
"is fixed": animal["is fixed"],
},
"relationships": {
"animal_type": {
# Make each animal a animal_type
"data": {
"type": animal_type['type'],
"id": animal_type['id'],
},
},
},
})
print("Created {!r}: {}/asset/{}".format(
animal['name'],
farm_client.session.hostname,
animal_create_response['data']['attributes']['drupal_internal__id'],
))
this worked great for importing 100 hens into my coop. Then i manually moved them to where they needed to be. Also created the animal_type as required.
Curious… is there a reason you’re allowing is_fixed to be changed? For animal assets that should generally be set to FALSE all the time, unless you’re doing something intentionally?
For more info on is_fixed, see these data model docs: Location | farmOS
It was just included in the default CSV I created when I accidentally thought it was for castrated or not.
Next CSV may remove that. I might adjust the script to auto bring in anything from the CSV that is not empty and auto create the payload a little nicer.
added all the script to github, added more details and validation for the CSV.
For some reason my instance can not use the CSV import properly. so i built this up. This is also a way for me to automate some of the animal sales we conduct.
Thanks for sharing @mattman0123! I’m sure others will find this useful in the future.
I wonder if it’s a CSV upload issue? Are you able to upload other files, like images/files on assets/logs? Happy to help debug this if you want… maybe in a separate topic or chat.
Yea it’s not the most intuitive name.