a.Archived = 1
a.Neutered = row["desexdate"].strip() != "" and 1 or 0
a.NeuteredDate = getdate(row["desexdate"])
a.BreedName = asm.breed_name_for_id(a.BreedID)
a.CrossBreed = row["crossbreed"] == "TRUE" and 1 or 0
if a.CrossBreed == 1:
a.Breed2ID = 442
if row["dob"].strip() != "":
a.DateOfBirth = getdate(row["dob"])
if a.DateOfBirth is None:
a.DateOfBirth = a.DateBroughtIn
a.IdentichipNumber = row["MicroChip"]
if a.IdentichipNumber != "": a.Identichipped = 1
a.Sex = getsex12(row["Sex"])
a.Weight = asm.cfloat(row["weight"])
if "size" in row: a.Size = asm.size_id_for_name(row["size"])
a.BaseColourID = asm.colour_id_for_name(row["Colour"], firstWordOnly=True)
a.ShelterLocation = 1
a.generateCode(asm.type_name_for_id(a.AnimalTypeID))
if "dep_sReason" in row: a.ReasonForEntry = row["dep_sReason"]
if row["sOther"] != "":
a.ReasonForEntry = row["sOther"]
a.EntryReasonID = 11
if row["circumstance"].find("Stray"):
a.EntryReasonID = 7
comments = "Original Type: " + typecol
comments += "\nOriginal Breed: " + breedcol + "/" + breed2col
comments += "\nOriginal Colour: " + row["Colour"] + "/" + row[
"SecondaryColour"]
comments += "\nLocation: " + getsblocation(row["refugelocation"])
comments += "\nCircumstance: " + row["circumstance"]
a.LastChangedDate = a.DateBroughtIn
#asm.additional_field("Legacy_Tag_No", 0, a.ID, d["Tag_no"])
#asm.additional_field("Legacy_Tag_No_Q", 0, a.ID, d["Tag_no_qualifier"])
a.ShortCode = d["Tag_no"]
a.ShelterCode = a.ShortCode
a.BreedID = asm.breed_from_db(d["Breed"], 1)
a.BreedName = d["Breed"]
if d["Cross_Breed"] != "":
a.Breed2ID = asm.breed_from_db(d["Cross_Breed"], 1)
a.CrossBreed = 1
a.BreedName = "%s / %s" % (d["Breed"], d["Cross_Breed"])
#a.BaseColourID = asm.colour_id_for_names(d["Base_Colour"], d["Secondary_Colour"])
a.BaseColourID = asm.colour_from_db(d["Base_Colour"])
a.AnimalComments = d["Notes"]
a.Sex = asm.getsex_mf(d["Sex"])
a.Size = asm.size_id_for_name(d["Size"])
a.NeuteredDate = getdate(d["Date_Desexed"])
if a.NeuteredDate is not None: a.Neutered = 1
a.IsNotForRegistration = 0
a.IsNotAvailableForAdoption = 1
a.IdentichipNumber = d["Microchip_no"]
a.Identichip2Number = d["Alternate_Chip_No"]
#asm.additional_field("MChipType", 5, a.ID, d["Microchip_Type"]) # MChipType additional field
if a.IdentichipNumber != "": a.Identichipped = 1
if a.IdentichipNumber == "0":
a.Identichipped = 0
a.IdentichipNumber = ""
a.IdentichipDate = asm.getdate_ddmmyyyy(d["Date_Microchipped"])
a.IsGoodWithCats = 2
a.IsGoodWithDogs = 2
a.IsGoodWithChildren = 2