def getpartdate(ye, mo):
""" creates a date at 01/m/y """
months = {
"january": 1,
"february": 2,
"march": 3,
"april": 4,
"may": 5,
"june": 6,
"july": 7,
"august": 8,
"september": 9,
"october": 10,
"november": 11,
"december": 12
}
d = 1
m = 1
if mo.strip() != "" and mo in months:
m = months[mo]
y = asm.cint(ye)
if y == 0: return None
return datetime.datetime(y, m, d)
if a.DateOfBirth is None:
a.DateOfBirth = asm.subtract_days(a.DateBroughtIn, 365)
a.CreatedDate = a.DateBroughtIn
a.LastChangedDate = a.DateBroughtIn
a.ShortCode = d["File"]
a.ShelterCode = str(a.ID) + " " + d["File"]
a.BreedID = asm.breed_id_for_name(d["Breed"].replace(" mix", ""))
a.BreedName = asm.breed_name_for_id(a.BreedID)
if d["Breed"].find("mix") != -1:
a.CrossBreed = 1
a.Breed2ID = 442
a.BreedName = asm.breed_name(a.BreedID, a.Breed2ID)
a.BaseColourID = asm.colour_id_for_name(d["Color"])
a.Sex = asm.getsex_mf(d["Male Female"])
a.Weight = asm.cint(d["Weight"].replace("lbs", "").strip())
if a.Weight > 0:
l = asm.Log()
logs.append(l)
l.LogTypeID = 4 # Weight
l.LinkID = a.ID
l.LinkType = 0
l.Date = a.DateBroughtIn
l.Comments = d["Weight"]
a.NeuteredDate = getdate(d["Spay Neuter Date"])
if a.NeuteredDate is not None: a.Neutered = 1
a.HealthProblems = d["Medical Notes"]
create_vacc("Rabies", d["Rabies Date"], d["Rabies Renewal"])
a.AnimalName = d["Name"]
if a.AnimalName.strip() == "":
a.AnimalName = "(unknown)"
a.DateBroughtIn = asm.getdate_mmddyy(d["IntakeDate"])
if a.DateBroughtIn is None:
a.DateBroughtIn = lastbroughtin
else:
lastbroughtin = a.DateBroughtIn
a.BreedID = asm.breed_id_for_name(d["CatBreed"], 261)
a.BaseColourID = asm.colour_id_for_name(d["CatColor"])
a.AnimalTypeID = asm.iif(d["OwnerSurrender"] == "1", 11, 12)
a.SpeciesID = 2
a.Sex = asm.getsex_mf(d["Sex"])
a.DateOfBirth = asm.getdate_mmddyy(d["DOB"])
if a.DateOfBirth is None:
dy = 365 * asm.cint(d["AgeYrs"])
dy += 30 * asm.cint(d["AgeMos"])
dy += 7 * asm.cint(d["AgeWks"])
dy += asm.cint(d["AgeDays"])
a.DateOfBirth = asm.subtract_days(a.DateBroughtIn, dy)
a.Neutered = asm.iif(d["SpayOrNeuteredPreviously"] == "1", 1, 0)
if a.Neutered == 0:
a.Neutered = asm.iif(d["Spay/NeuterDate"] != "", 1, 0)
a.NeuteredDate = asm.getdate_mmddyy(d["Spay/NeuterDate"])
a.AnimalComments = d["Comments"]
a.IdentichipDate = asm.getdate_mmddyy(d["MicrochipDate"])
if a.IdentichipDate is not None:
a.Identichipped = 1
a.IdentichipNumber = d["Microchip#"]
a.CombiTestDate = asm.getdate_mmddyy(d["FIV/FELVDate"])
if a.CombiTestDate is not None:
a.AnimalTypeID = animaltype
# There is a species column, but the last file I saw it seemed to be pretty optional and not filled in
a.SpeciesID = asm.species_id_for_name(d["as_animal_type"])
a.generateCode()
a.ShortCode = d["id"]
a.ShelterCode = d["id"]
a.AnimalName = d["name"]
a.AcceptanceNumber = d["litter_id"]
a.DateBroughtIn = getdate(d["intake_date"])
if a.DateBroughtIn is None: a.DateBroughtIn = getdate(d["created_at"])
a.DateOfBirth = getdate(d["birthday"])
if a.DateOfBirth is None: a.DateOfBirth = a.DateBroughtIn
a.Sex = 1
if d["gender"] == "1": # They use 1 for female, 0 for male
a.Sex = 0
a.Size = asm.cint(d["size_when_grown"])
primary = d["breed"]
secondary = d["breed_secondary"]
asm.breed_ids(a, primary, secondary, DEFAULT_BREED)
color = d["color_primary"]
a.BaseColourID = asm.colour_id_for_name(color)
a.IdentichipNumber = d["tattoo"]
if a.IdentichipNumber != "": a.Identichipped = 1
a.Weight = asm.atof(d["weight"])
a.Neutered = d["altered"] == "true" and 1 or 0
intaketype = d["intake_reason"]
if intaketype.find("Transfer In") != -1:
a.IsTransfer = 1
a.EntryReasonID = 15
elif intaketype.find("Stray") != -1:
a.EntryReasonID = 7
o.OwnerTown = add["city"]
o.OwnerCounty = add["state"]
o.OwnerPostcode = add["zip"]
else:
# Otherwise, address fields are in the person table
o.OwnerAddress = row["ADDR1"].encode(
"ascii", "xmlcharrefreplace") + "\n" + row["ADDR2"].encode(
"ascii", "xmlcharrefreplace")
o.OwnerTown = row["CITY"]
o.OwnerCounty = row["STATE"]
o.OwnerPostcode = row["POSTAL_ID"]
if asm.strip(row["EMAIL"]) != "(": o.EmailAddress = asm.strip(row["EMAIL"])
if row["HOME_PH"] != 0: o.HomeTelephone = asm.strip(row["HOME_PH"])
if row["WORK_PH"] != 0: o.WorkTelephone = asm.strip(row["WORK_PH"])
if row["THIRD_PH"] != 0: o.MobileTelephone = asm.strip(row["THIRD_PH"])
o.IsACO = asm.cint(row["ACO_IND"])
o.IsStaff = asm.cint(row["STAFF_IND"])
o.IsVolunteer = asm.cint(row["VOL_IND"])
o.IsDonor = asm.cint(row["DONOR_IND"])
o.IsMember = asm.cint(row["MEMBER_IND"])
o.IsBanned = asm.cint(row["NOADOPT"] == "T" and "1" or "0")
if "FOSTERS" in row: o.IsFosterer = asm.cint(row["FOSTERS"])
# o.ExcludeFromBulkEmail = asm.cint(row["MAILINGSAM"]) # Not sure this is correct
# Animals
for row in canimal:
if not IMPORT_ANIMALS_WITH_NO_NAME and row["PETNAME"].strip() == "":
continue
a = asm.Animal()
animals.append(a)
ppa[row["ANIMALKEY"]] = a
a = ppa[d["Animal ID"]]
intaketype = d[
"Intake Type"] # Seems to change names a lot, has been AnimalIntakeType, Entry Category
subtype = d[
"Intake Sub-Type"] # Also seems to change, has been AnimalIntakeSub-Type, Animal Type
# Intake Date
if "Intake Date" in d: a.DateBroughtIn = getdate(d["Intake Date"])
# Intake person
linkperson = 0
if "Intake From Name" in d and d["Intake From Name"] != "" and d[
"Intake From Name"] in ppo:
linkperson = ppo[d["Intake From Name"]].ID
# Age
if "Age (Months)" in d:
a.DateOfBirth = asm.subtract_days(
a.DateBroughtIn, 30 * asm.atoi(asm.cint(d["Age (Months)"])))
# Location
if "Location" in d and d["Location"] != "":
locs = d[
"Location"] # Locations are a comma separated list, with latest on the right
if locs.find(",") != -1: locs = locs[locs.rfind(",") + 1:]
a.ShelterLocation = asm.location_id_for_name(locs, True)
# a.ShelterLocation = asm.location_from_db(locs)
if intaketype == "Transfer In":
a.IsTransfer = 1
a.EntryReasonID = 15
a.BroughtInByOwnerID = linkperson
elif intaketype == "Stray":
a.EntryReasonID = 7
a.BroughtInByOwnerID = linkperson
elif intaketype == "Surrender":
if d["Animal ID"] == "Animal ID": continue
if d["Animal ID"] not in ppa: continue
a = ppa[d["Animal ID"]]
intaketype = d["Intake Type"] # Seems to change names a lot, has been AnimalIntakeType, Entry Category
subtype = d["Intake Sub-Type"] # Also seems to change, has been AnimalIntakeSub-Type, Animal Type
# Animal name
if "Name" in d: a.AnimalName = d["Name"]
# Intake Date
if "Intake Date" in d: a.DateBroughtIn = getdate(d["Intake Date"])
# Intake person
linkperson = 0
if "Intake From Name" in d and d["Intake From Name"] != "" and d["Intake From Name"] in ppo:
linkperson = ppo[d["Intake From Name"]].ID
# Age
if "Age (Months)" in d:
a.DateOfBirth = asm.subtract_days(a.DateBroughtIn, 30 * asm.atoi(asm.cint(d["Age (Months)"])))
# Location
if "Location" in d and d["Location"] != "":
locs = d["Location"] # Locations are a comma separated list, with latest on the right
if locs.find(",") != -1: locs = locs[locs.rfind(",")+1:]
a.ShelterLocation = asm.location_id_for_name(locs, True)
# a.ShelterLocation = asm.location_from_db(locs)
if intaketype == "Transfer In":
a.IsTransfer = 1
a.EntryReasonID = 15
a.BroughtInByOwnerID = linkperson
elif intaketype == "Stray":
a.EntryReasonID = 7
a.BroughtInByOwnerID = linkperson
elif intaketype == "Surrender":
a.EntryReasonID = 17
if a.AnimalName.strip() == "": a.AnimalName = "(unknown)"
a.DateBroughtIn = d.dogIntakeDate or d.dateAdded
a.DateOfBirth = d.dogDateBorn or a.DateBroughtIn
a.CreatedDate = d.dateAdded or a.DateBroughtIn
a.CreatedBy = d.addedBy or "conversion"
a.LastChangedBy = d.modifiedBy or "conversion"
a.LastChangedDate = d.dateModified or a.CreatedDate
a.generateCode()
if d.dogSerialNum and asm.nulltostr(d.dogSerialNum) != "":
a.ShortCode = d.dogSerialNum
a.Sex = asm.iif(d.dogSex.lower().startswith("m"), 1, 0)
a.Neutered = asm.iif(
d.dogSex.lower().find("s") != -1 or d.dogSex.lower().find("n") != -1,
1, 0)
a.Size = 2
a.Weight = asm.cint(d.dogWeight)
a.NeuteredDate = d.dogDateNeutered
a.IsGoodWithCats = asm.iif(d.dogWithCats == 1, 0, 1)
a.IsGoodWithDogs = asm.iif(d.dogWithDogs == 1, 0, 1)
a.IsGoodWithChildren = asm.iif(d.dogWithKids == 1, 0, 1)
a.IsHouseTrained = asm.iif(d.dogHousebroken == 1, 0, 1)
if d.dogLeftEarNum != "" or d.dogRightEarNum != "":
a.Tattoo = 1
a.TattooNumber = "L:%s R:%s" % (d.dogLeftEarNum, d.dogRightEarNum)
a.RabiesTag = d.dogRabiesTag
a.HeartwormTestDate = d.dogHWTDate
if a.HeartwormTestDate is not None: a.HeartwormTested = 1
a.Archived = 0
a.AnimalComments = note_fix(d.dogDescription)
comments = "Color: %s" % d.dogColor
o.OwnerSurname = row["LNAME"]
o.OwnerName = o.OwnerTitle + " " + o.OwnerForeNames + " " + o.OwnerSurname
# Find the address
if addrlink.has_key(row["PERSONKEY"]):
addrkey = addrlink[row["PERSONKEY"]]
if addresses.has_key(addrkey):
add = addresses[addrkey]
o.OwnerAddress = add["address"]
o.OwnerTown = add["city"]
o.OwnerCounty = add["state"]
o.OwnerPostcode = add["zip"]
o.EmailAddress = row["EMAIL"]
o.HomeTelephone = row["HOME_PH"]
o.WorkTelephone = row["WORK_PH"]
o.MobileTelephone = row["THIRD_PH"]
o.IsACO = asm.cint(row["ACO_IND"])
o.IsStaff = asm.cint(row["STAFF_IND"])
o.IsVolunteer = asm.cint(row["VOL_IND"])
o.IsDonor = asm.cint(row["DONOR_IND"])
o.IsMember = asm.cint(row["MEMBER_IND"])
o.IsBanned = asm.cint(row["NOADOPT"] == "T" and "1" or "0")
o.IsFosterer = asm.cint(row["FOSTERS"])
o.ExcludeFromBulkEmail = asm.cint(row["MAILINGSAM"])
# Animals
for row in canimal:
a = asm.Animal()
animals.append(a)
ppa[row["ANIMALKEY"]] = a
a.DateBroughtIn = asm.getdate_yyyymmdd(row["ADDEDDATET"])
if a.DateBroughtIn is None:
a.SpeciesID = 2
else:
a.SpeciesID = asm.species_id_for_name(row["SPECIES"])
a.generateCode(gettypeletter(a.AnimalTypeID))
a.ShortCode = row["FORMNUM"]
ob = row["BREEDID"]
a.CrossBreed = 0
if ob.find("Mix") != -1:
a.CrossBreed = 1
a.Breed2ID = 442
ob = ob.replace("Mix", "")
a.BreedID = asm.breed_id_for_name(ob)
a.BreedName = asm.breed_name(a.BreedID, a.Breed2ID)
a.Sex = asm.getsex_mf(row["SEX"])
a.Size = getsize(row["RSize"])
a.Neutered = asm.cint(row["SPAYED"])
a.NeuteredDate = asm.getdate_mmddyy(row["SPAYDATE"])
a.DateOfBirth = asm.getdate_mmddyy(row["DOB"])
if a.DateOfBirth is None:
a.DateOfBirth = a.DateBroughtIn
a.BaseColourID = asm.colour_id_for_name(row["RColor"])
a.RabiesTag = row["TAG"]
a.IdentichipNumber = row["MICROCHIP"]
if a.IdentichipNumber.strip() != "":
a.Identichipped = 1
a.IdentichipDate = a.DateBroughtIn
a.AnimalName = row["PETNAME"]
if a.AnimalName == "":
a.AnimalName = "(unknown)"
a.Markings = row["RDescr"]
comments = ""
if a.EntryReasonID == 7:
a.AnimalTypeID = 12 # Stray Cat
elif d["Species"] == "Dog":
a.AnimalTypeID = 2 # Unwanted Dog
if a.EntryReasonID == 7:
a.AnimalTypeID = 10 # Stray Dog
else:
a.AnimalTypeID = 40 # Misc
a.SpeciesID = asm.species_id_for_name(d["Species"])
a.AnimalName = d["AnimalName"]
if a.AnimalName.strip() == "":
a.AnimalName = "(unknown)"
a.DateBroughtIn = getdate(d["IntakeDate"])
if a.DateBroughtIn is None:
a.DateBroughtIn = asm.today()
ageinmonths = asm.cint(d["AgeMonths"])
age = asm.cint(d["Age"])
if age > 0: ageinmonths += (age * 12)
if ageinmonths == 0: ageinmonths = 12
a.DateOfBirth = asm.subtract_days(a.DateBroughtIn,
int(ageinmonths * 30.5))
a.CreatedDate = getdate(d["CreateDate"])
a.LastChangedDate = getdate(d["UpdateDate"])
a.generateCode()
if asm.cint(d["AnimalNumber"]) > 0:
a.ShortCode = d["AnimalNumber"]
else:
# Animals with a 0 or non-integer number are non-shelter
a.NonShelterAnimal = 1
a.Archived = 1
a.OriginalOwnerID = get_asm_ownerid(d["ID"])
dt.Description = row["Desc"]
dt.DefaultCost = asm.get_currency(row["Amount"])
# invoices.csv
for row in asm.csv_to_list(PATH + "invoices.csv"):
if not ppt.has_key(row["Item"]): continue
if not ppo.has_key(row["custid"]): continue
od = asm.OwnerDonation()
ownerdonations.append(od)
dt = ppt[row["Item"]]
o = ppo[row["custid"]]
od.OwnerID = o.ID
od.DonationTypeID = dt.ID
od.Date = asm.getdate_ddmmyyyy(row["Date"])
od.Donation = asm.get_currency(row["Amount"])
od.Quantity = asm.cint(row["Qty"])
try:
od.UnitPrice = od.Donation / od.Quantity
except:
od.UnitPrice = od.Donation
od.Comments = row["Desc"]
# Now that everything else is done, output stored records
for o in owners:
print o
for od in ownerdonations:
print od
for dt in donationtypes:
print dt
print "DELETE FROM configuration WHERE ItemName Like 'VariableAnimalDataUpdated';"
dt.Description = row["Desc"]
dt.DefaultCost = asm.get_currency(row["Amount"])
# invoices.csv
for row in asm.csv_to_list(PATH + "invoices.csv"):
if not ppt.has_key(row["Item"]): continue
if not ppo.has_key(row["custid"]): continue
od = asm.OwnerDonation()
ownerdonations.append(od)
dt = ppt[row["Item"]]
o = ppo[row["custid"]]
od.OwnerID = o.ID
od.DonationTypeID = dt.ID
od.Date = asm.getdate_ddmmyyyy(row["Date"])
od.Donation = asm.get_currency(row["Amount"])
od.Quantity = asm.cint(row["Qty"])
try:
od.UnitPrice = od.Donation / od.Quantity
except:
od.UnitPrice = od.Donation
od.Comments = row["Desc"]
# Now that everything else is done, output stored records
for o in owners:
print o
for od in ownerdonations:
print od
for dt in donationtypes:
print dt
print "DELETE FROM configuration WHERE ItemName Like 'VariableAnimalDataUpdated';"
a.AnimalName = d["Name"]
if a.AnimalName.strip() == "":
a.AnimalName = "(unknown)"
a.DateBroughtIn = asm.getdate_mmddyy(d["IntakeDate"])
if a.DateBroughtIn is None:
a.DateBroughtIn = lastbroughtin
else:
lastbroughtin = a.DateBroughtIn
a.BreedID = asm.breed_id_for_name(d["CatBreed"], 261)
a.BaseColourID = asm.colour_id_for_name(d["CatColor"])
a.AnimalTypeID = asm.iif(d["OwnerSurrender"] == "1", 11, 12)
a.SpeciesID = 2
a.Sex = asm.getsex_mf(d["Sex"])
a.DateOfBirth = asm.getdate_mmddyy(d["DOB"])
if a.DateOfBirth is None:
dy = 365 * asm.cint(d["AgeYrs"])
dy += 30 * asm.cint(d["AgeMos"])
dy += 7 * asm.cint(d["AgeWks"])
dy += asm.cint(d["AgeDays"])
a.DateOfBirth = asm.subtract_days(a.DateBroughtIn, dy)
a.Neutered = asm.iif(d["SpayOrNeuteredPreviously"] == "1", 1, 0)
if a.Neutered == 0:
a.Neutered = asm.iif(d["Spay/NeuterDate"] != "", 1, 0)
a.NeuteredDate = asm.getdate_mmddyy(d["Spay/NeuterDate"])
a.AnimalComments = d["Comments"]
a.IdentichipDate = asm.getdate_mmddyy(d["MicrochipDate"])
if a.IdentichipDate is not None:
a.Identichipped = 1
a.IdentichipNumber = d["Microchip#"]
a.CombiTestDate = asm.getdate_mmddyy(d["FIV/FELVDate"])
if a.CombiTestDate is not None:
a.NonShelterAnimal = 1
a.generateCode("A")
a.BreedID = asm.breed_from_db(row["Breed"])
a.Breed2ID = asm.breed_from_db(row["Crossbreed type"], 0)
a.BreedName = row["Breed"]
if row["Crossbreed type"] != "":
a.BreedName += " / " + row["Crossbreed type"]
a.BaseColourID = asm.colour_from_db(row["Colour"])
a.IdentichipNumber = row["Microchipped Number"]
if a.IdentichipNumber != "": a.Identichipped = 1
a.TattooNumber = row["Tattoo Number"]
if a.TattooNumber != "": a.Tattoo = 1
a.Neutered = asm.iif(row["Neutered/Spayed"] != "No", 1, 0)
a.ShelterLocation = 1
a.Markings = row["Marking"]
a.Weight = asm.cint(row["Weight"])
a.Sex = asm.getsex_mf(row["Sex"])
a.Size = asm.size_from_db(row["Size"])
a.CoatType = asm.coattype_from_db(row["Coat Type"])
a.Archived = 1
# the licence
ol = asm.OwnerLicence()
ownerlicences.append(ol)
lt = row["Licence Type"]
ol.OwnerID = o.ID
ol.AnimalID = a.ID
ol.LicenceTypeID = asm.licencetype_from_db(lt)
licnum = "%s%s-%s" % (lt[0:3].upper(), lt[len(lt) - 2:],
row["Licence Number"])
if numused.has_key(licnum):
for d in ccatinfo:
a = asm.Animal()
animals.append(a)
ppa[d["CatName"]] = a
a.AnimalTypeID = 12 # stray cat
if d["AcquiredType"].startswith("County"):
a.AnimalTypeID = 44 # county shelter cat
a.TransferIn = 1
a.SpeciesID = 2
a.AnimalName = d["CatName"]
if a.AnimalName.strip() == "":
a.AnimalName = "(unknown)"
a.DateBroughtIn = asm.getdate_mmddyy(d["DateAcquired"])
if a.DateBroughtIn is None:
a.DateBroughtIn = asm.today()
ea = asm.cint(d["EstimatedAge"])
eu = d["EstimatedAgeUnits"]
if eu.startswith("Week"):
ea = ea * 7
elif eu.startswith("Month"):
ea = ea * 30.5
elif eu.startswith("Year"):
ea = ea * 365
a.DateOfBirth = asm.subtract_days(a.DateBroughtIn, ea)
if a.DateOfBirth is None:
a.DateOfBirth = asm.today()
a.CreatedDate = a.DateBroughtIn
a.LastChangedDate = a.DateBroughtIn
a.generateCode()
a.ShortCode = d["IDNumber"]
a.Markings = d["Description"]