# Depending on the version of shelterbuddy, sometimes there's ## type, breed and secondBreed cols that dereference the tables typecol = "" breedcol = "" breed2col = "" if row.has_key("type"): typecol = row["type"] breedcol = row["breed"] breed2col = row["secondBreed"] else: # We're going to have to look them up from the speciesID and # secondarySpeciesID fields typecol = getsbtypenamefromspeciesid(row["speciesID"]) breedcol = getsbbreednamefromspeciesid(row["speciesID"]) breed2col = getsbbreednamefromspeciesid(row["secondarySpeciesID"]) a.AnimalTypeID = asm.type_id_for_name(typecol) a.SpeciesID = asm.species_id_for_name(typecol) a.BreedID = asm.breed_id_for_name(breedcol) a.Breed2ID = asm.breed_id_for_name(breed2col) if row["DateIN"].strip() != "": a.DateBroughtIn = getdate(row["DateIN"]) if a.DateBroughtIn is None: a.DateBroughtIn = getdate(row["AddDateTime"]) if a.DateBroughtIn is None: print "BOLLOCKS: " + str(row) if row["DateOUT"].strip() != "": a.ActiveMovementDate = getdate(row["DateOUT"]) if a.ActiveMovementDate is not None: a.ActiveMovementType = 1 a.Archived = 1 elif a.DateBroughtIn.year < 2015:
if a.AnimalName.strip() == "": a.AnimalName = "(unknown)" if d["SPECIES"] == "Dog": # Canine a.SpeciesID = 1 a.AnimalTypeID = 10 a.EntryReasonID = 11 elif d["SPECIES"] == "Cat": # Feline a.SpeciesID = 2 a.EntryReasonID = 11 a.AnimalTypeID = 12 else: # Other species a.SpeciesID = asm.species_id_for_name(d["SPECIES"]) a.AnimalTypeID = asm.type_id_for_name(d["SPECIES"]) a.generateCode() a.ShortCode = d["ANIMALNO"] a.Sex = asm.getsex_mf(d["SEX"]) a.BreedID = asm.breed_id_for_name(d["BREED1"]) if d["BREED2"] == "Unspecified": a.Breed2ID = a.BreedID a.CrossBreed = 0 else: a.CrossBreed = 1 a.Breed2ID = asm.breed_id_for_name(d["BREED2"]) a.BreedName = asm.breed_name(a.BreedID, a.Breed2ID) if d["BREED2"].find("Mix") != -1: a.CrossBreed = 1 a.Breed2ID = 442 a.BreedName = asm.breed_name_for_id(a.BreedID) + " / " + asm.breed_name_for_id(a.Breed2ID)
types = "" if types.find("Volunteer") != -1: o.IsVolunteer = 1 if types.find("Employee") != -1: o.IsStaff = 1 if types.find("Member") != -1: o.IsMember = 1 if types.find("Foster") != -1: o.IsFosterer = 1 # animals.csv for row in asm.csv_to_list(PATH + "animals.csv"): a = asm.Animal() animals.append(a) ppa[row["id"]] = a a.AnimalName = row["name"] if a.AnimalName.strip() == "": a.AnimalName = "(unknown)" a.ShortCode = row["code"] a.AnimalTypeID = asm.type_id_for_name(row["species"]) a.SpeciesID = asm.species_id_for_name(row["species"]) a.BreedID = asm.breed_id_for_name(row["primary breed"]) a.Breed2ID = asm.breed_id_for_name(row["secondary breed"]) a.CrossBreed = asm.iif(row["secondary breed"] != "", 1, 0) a.BreedName = asm.breed_name_for_id(a.BreedID) a.BaseColourID = asm.colour_id_for_name(row["primary color"]) a.Sex = asm.getsex_mf(row["sex"]) a.DateBroughtIn = asm.getdate_iso(row["time entered"]) a.DateOfBirth = asm.getdate_iso(row["birth date"]) if a.DateOfBirth is None: a.DateOfBirth = asm.getdate_iso(row["time entered"]) a.NeuteredDate = asm.getdate_iso(row["neutered/spayed date"]) if a.NeuteredDate is not None: a.Neutered = 1 a.Archived = 0 a.IdentichipNumber = row["microchip #"] if a.IdentichipNumber != "": a.Identichipped = 1
# Depending on the version of shelterbuddy, sometimes there's ## type, breed and secondBreed cols that dereference the tables typecol = "" breedcol = "" breed2col = "" if row.has_key("type"): typecol = row["type"] breedcol = row["breed"] breed2col = row["secondBreed"] else: # We're going to have to look them up from the speciesID and # secondarySpeciesID fields typecol = getsbtypenamefromspeciesid(row["speciesID"]) breedcol = getsbbreednamefromspeciesid(row["speciesID"]) breed2col = getsbbreednamefromspeciesid(row["secondarySpeciesID"]) a.AnimalTypeID = asm.type_id_for_name(typecol) a.SpeciesID = asm.species_id_for_name(typecol) a.BreedID = asm.breed_id_for_name(breedcol) a.Breed2ID = asm.breed_id_for_name(breed2col) if row["DateIN"].strip() != "": a.DateBroughtIn = getdate(row["DateIN"]) if a.DateBroughtIn is None: a.DateBroughtIn = getdate(row["AddDateTime"]) if a.DateBroughtIn is None: a.DateBroughtIn = asm.now() if row["DateOUT"].strip() != "": a.ActiveMovementDate = getdate(row["DateOUT"]) if a.ActiveMovementDate is not None: a.ActiveMovementType = 1 a.Archived = 1 elif a.DateBroughtIn.year < asm.now().year - 1:
# animals.csv for row in asm.csv_to_list(PATH + "animals.csv", remove_non_ascii=True): if row["name"] is None: continue if row["code"] is None or row["code"] == "": continue if row["primary breed"] is None or row["primary breed"] == "": continue if row["species"] is None or row["species"] == "": continue if row["primary color"] is None or row["primary color"] == "": continue a = asm.Animal() animals.append(a) ppa[row["id"]] = a a.AnimalName = row["name"] if a.AnimalName.strip() == "": a.AnimalName = "(unknown)" a.ShortCode = row["code"] a.AnimalTypeID = asm.type_id_for_name(row["species"]) a.SpeciesID = asm.species_id_for_name(row["species"]) a.BreedID = asm.breed_id_for_name(row["primary breed"]) a.Breed2ID = asm.breed_id_for_name(row["secondary breed"]) a.CrossBreed = asm.iif(row["secondary breed"] != "", 1, 0) a.BreedName = asm.breed_name_for_id(a.BreedID) a.BaseColourID = asm.colour_id_for_name(row["primary color"]) a.Sex = asm.getsex_mf(row["sex"]) a.DateBroughtIn = asm.getdate_iso(row["time entered"]) if a.DateBroughtIn is None: a.DateBroughtIn = asm.now() a.DateOfBirth = asm.getdate_iso(row["birth date"]) if a.DateOfBirth is None: a.DateOfBirth = asm.getdate_iso(row["time entered"]) if a.DateOfBirth is None: a.DateOfBirth = a.DateBroughtIn a.NeuteredDate = asm.getdate_iso(row["neutered/spayed date"]) if a.NeuteredDate is not None: a.Neutered = 1