Appendix: CSV file import fields

ASM will recognise columns with the following names when importing CSV files. Where you wish to supply multiple rows for the same animal (such as for vaccinations or regimens), make sure you have a populated ANIMALCODE column, similarly for multiple rows to people (such as movements, licenses, etc) make sure you have populated person data.

When processing animal records that already exist, there are certain key fields that will be overwritten on the existing animal from the CSV data. These fields are ANIMALNEUTERED[DATE], ANIMALMICROCHIP[DATE] and ANIMALHEALTHPROBLEMS. This allows you to use a spreadsheet of data on chipping/neutering days and import that data to your existing animals afterwards.

ANIMALCODE

A code for the animal. If supplied, it will set the sheltercode and short sheltercode fields. If not supplied, the system will generate a code for the animal to the appropriate scheme. If you have manual codes turned on and no animal code is supplied, an error message will be displayed and the import abandoned.

ANIMALNAME

The animal’s name

ANIMALIMAGE

A photo for the animal, it can either be a fully qualified HTTP URL to a JPG image OR a base64 encoded JPG expressed as a data URI

ANIMALNONSHELTER

Y/N to indicate whether this animal is a owned by a member of the public and not a shelter animal

ANIMALNOTFORADOPTION

Y/N to indicate whether this animal is not available for adoption (Y is not available).

ANIMALFLAGS

A comma separated list of animal flags, including builtins courtesy, crueltycase, notforadoption, notforregistration, nonshelter, quarantine

ANIMALSEX

The animal’s gender. ASM looks for the initial letter “M” in the string to indicate male, “F” for Female or “U” for Unknown.

ANIMALTYPE

The animal’s type. This should correspond to one of ASM’s animal types from your database.

ANIMALCOLOR

The animal’s color. This should correspond to a color in your database.

ANIMALBREED1

The animal’s primary breed. It should match a breed in your database.

ANIMALBREED2

The animal’s secondary breed. If different from ANIMALBREED1, ASM will mark the animal as a crossbreed.

ANIMALDOB

The animal’s date of birth. This field, or ANIMALAGE must be supplied or the record will not be imported.

ANIMALSIZE

The animal’s size. This should correspond to a size in your database.

ANIMALWEIGHT

The animal’s weight as a floating point number of pounds or kilos (eg: 2.5 = 2 lb and 8 oz)

ANIMALAGE

The animal’s current age in years. ASM will calculate a date of birth from this during import if ANIMALDOB is not supplied or blank.

ANIMALLOCATION

The animal’s location within your shelter. This should correspond to a location in your database.

ANIMALUNIT

The unit within the animal’s location within the shelter, eg: pen/cage number.

ANIMALJURISDICTION

The jurisidiction to allocate the animal to based on entry circumstances (usually pickup)

ANIMALSPECIES

The animal’s species. This should match a species in your database.

ANIMALHOUSETRAINED

Y/N/U to indicate yes/no/unknown

ANIMALGOODWITHCATS

Y/N/U to indicate yes/no/unknown

ANIMALGOODWITHDOGS

Y/N/U to indicate yes/no/unknown

ANIMALGOODWITHKIDS

Y/N/U to indicate yes/no/unknown

ANIMALCOMMENTS

Some comments to put in the animal’s comment field.

ANIMALHIDDENDETAILS

Some comments for the animal’s hidden details field.

ANIMALMARKINGS

Some comments for the animal’s markings field.

ANIMALHEALTHPROBLEMS

Some comments for the animal’s health problems field.

ANIMALNEUTERED

Y/N to indicate yes/no

ANIMALNEUTEREDDATE

The date the animal was neuteured. If supplied and not blank, ANIMALNEUTERED = Y is also assumed.

ANIMALMICROCHIP

If not blank, ASM will mark the animal microchipped with this as the microchip number.

ANIMALMICROCHIPDATE

The date the microchip was implanted

ANIMALENTRYDATE

The date the animal entered the shelter (date brought in). Today’s date will be used if this column is not present or the value is blank.

ANIMALENTRYCATEGORY

The animal’s entry category, which should correspond to an entry category in your database.

ANIMALREASONFORENTRY

Free text, notes on the reason the animal entered the shelter.

ANIMALDECEASEDDATE

If the animal is deceased, the date it died.

ANIMALADDITIONAL<fieldname>

If you have animal additional fields defined, you can put the uppercased version of their name as a suffix to this. Eg, for an additional field called Weight, ANIMALADDITIONALWEIGHT

CURRENTVETTITLE

If we have current vet info for the animal, the vet’s title.

CURRENTVETINITIALS

Vet’s initials.

CURRENTVETFIRSTNAME

The vet’s first name(s).

CURRENTVETLASTNAME

The vet’s last name. This column being present and having data in it determines whether or not the importer will consider the animal as having current vet info.

CURRENTVETADDRESS

Vet’s address.

CURRENTVETCITY

The vet’s city/town.

CURRENTVETSTATE

The vet’s state/county.

CURRENTVETZIPCODE

The vet’s zip or postcode.

CURRENTVETJURISDICTION

The vet’s jurisdiction

CURRENTVETHOMEPHONE

The vet’s home phone.

CURRENTVETWORKPHONE

The vet’s work phone.

CURRENTVETCELLPHONE

The vet’s mobile phone.

CURRENTVETEMAIL

The vet’s email.

CURRENTVETADDITIONAL<fieldname>

If you have person additional fields defined, you can put the uppercased version of their name as a suffix to this. Eg, for an additional field called DateOfBirth CURRENTVETADDITIONALDATEOFBIRTH

DONATIONDATE

The date the donation amount on this line was received. If movement columns are present, it will be attached to the movement as well as the person. If no person columns are present, having this column in the CSV file will cause an error.

DONATIONAMOUNT

The amount of the donation on this line (as a floating point number)

DONATIONFEE

The amount of any transaction fee in handling the donation

DONATIONCHECKNUMBER

The cheque/check number for the donation

DONATIONCOMMENTS

Any comments to go with the donation

DONATIONPAYMENT

The payment method to use (should correspond to a payment method in your database, eg: Cash)

DONATIONTYPE

The payment type to use (should correspond to a payment type in your database).

DONATIONGIFTAID

Y / N if the payment should have the giftaid flag set

LICENSETYPE

The license type to use (licenses need at least person info)

LICENSENUMBER

The license number (mandatory)

LICENSEFEE

The fee paid for the license

LICENSEISSUEDATE

The date the license was issued

LICENSEEXPIRESDATE

The date the license expires

LICENSECOMMENTS

Any comments on the license

LOGDATE

The date of any log entry (only animal logs can be imported)

LOGTYPE

The type of log entry

LOGCOMMENTS

The log entry itself

MEDICALNAME

The name of the medical regimen for this line

MEDICALDOSAGE

The dosage of the medical regimen

MEDICALGIVENDATE

The date the medical regimen started (only one-off treatment regimens can be created via import)

MEDICALCOMMENTS

Any comments on the medical regimen

MOVEMENTTYPE

The type of movement for this line (0 = Reservation, 1 = Adoption, 2 = Foster, 3 = Transfer, 4 = Escaped, 5 = Reclaimed, 6 = Stolen, 7 = Released to Wild, 8 = Moved to Retailer. If MOVEMENTTYPE is not specified, but a MOVEMENTDATE has been given, ASM will default the type to adoption. If MOVEMENTTYPE is 0, then MOVEMENTDATE and MOVEMENTRETURNDATE will be used to set the reservation date and reservation cancelled date fields.

MOVEMENTDATE

The date of the movement

MOVEMENTRETURNDATE

The return date of the movement

MOVEMENTCOMMENTS

Any comments for the movement

ORIGINALOWNERTITLE

If we have original owner info for the animal, the person’s title.

ORIGINALOWNERINITIALS

Original owner’s initials.

ORIGINALOWNERFIRSTNAME

The original owner’s first name(s).

ORIGINALOWNERLASTNAME

The original owner’s last name. This column being present and having data in it determines whether or not the importer will consider the animal as having original owner info.

ORIGINALOWNERADDRESS

Original owner’s address.

ORIGINALOWNERCITY

The original owner’s city/town.

ORIGINALOWNERSTATE

The original owner’s state/county.

ORIGINALOWNERZIPCODE

The original owner’s zip or postcode.

ORIGINALOWNERJURISDICTION

The original owner’s jurisdiction

ORIGINALOWNERHOMEPHONE

The original owner’s home phone.

ORIGINALOWNERWORKPHONE

The original owner’s work phone.

ORIGINALOWNERCELLPHONE

The original owner’s mobile phone.

ORIGINALOWNEREMAIL

The original owner’s email.

ORIGINALOWNERADDITIONAL<fieldname>

If you have person additional fields defined, you can put the uppercased version of their name as a suffix to this. Eg, for an additional field called DateOfBirth ORIGINALOWNERADDITIONALDATEOFBIRTH

PERSONCLASS

1 = Individual/Couple, 2 = Organisation

PERSONTITLE

The person’s title

PERSONINITIALS

The person’s initials

PERSONFIRSTNAME

The person’s first name (forenames)

PERSONLASTNAME

The person’s last name (surname)

PERSONNAME

If this field is supplied, ASM will assume it contains first names and a last name, overriding any fields that set those. Everything up to the last space is considered first names and everything up to the last space the last name.

PERSONADDRESS

The person’s address

PERSONCITY

The person’s town/city

PERSONSTATE

The person’s state/county

PERSONZIPCODE

The person’s zip or postcode

PERSONJURISDICTION

The person’s jurisdiction

PERSONHOMEPHONE

The person’s home phone number

PERSONWORKPHONE

The person’s work phone number

PERSONCELLPHONE

The person’s cell/mobile number

PERSONEMAIL

The person’s email address

PERSONGDPRCONTACTOPTIN

The GDPR contact optin values, separated by a comma. These values are: didnotask, declined, email, post, sms, phone

PERSONMEMBER

Y or 1 in this column to indicate the person should have the membership flag set.

PERSONMEMBERSHIPNUMBER

The person’s membership number

PERSONMEMBERSHIPEXPIRY

A date for when this person’s membership expires

PERSONFOSTERER

Y or 1 in this column to indicate the person should have the fosterer flag set.

PERSONDONOR

Y or 1 in this column to indicate the person is a regular donor.

PERSONFLAGS

This column can be used to set any other person flags on the imported person. Flags should be comma separated with no extra spaces. Built in flags are their lower case English names, eg: banned,aco,homechecked,homechecker,excludefrombulkemail Additional flags that you have added to the system should exactly match their flag names as they appear on the person screens, eg: banned,Fundraising Flag 1,Custom Flag

PERSONCOMMENTS

Any comments to go with the person record.

PERSONMATCHACTIVE

Y or 1 in this column indicates the person is looking for an animal. If this field is not set to Y or 1, the other PERSONMATCH columns are ignored for this row.

PERSONMATCHADDED

The date the system should start looking for matches

PERSONMATCHEXPIRES

The date the system should stop looking for matches

PERSONMATCHSEX

The gender. ASM looks for the initial letter “M” in the string to indicate male, “F” for Female, “U” for Unknown or “A” for any

PERSONMATCHSIZE

The size of the animal the person is looking for

PERSONMATCHCOLOR

The color of the animal the person is looking for

PERSONMATCHAGEFROM, PERSONMATCHAGETO

The age range of the animal the person is looking for in years

PERSONMATCHTYPE

The animal type of the animal the person is looking for

PERSONMATCHSPECIES

The species of animal the person is looking for

PERSONMATCHBREED1, PERSONMATCHBREED2

The breed of the animal the person is looking for

PERSONMATCHGOODWITHCATS, PERSONMATCHGOODWITHDOGS, PERSONMATCHGOODWITHCHILDREN, PERSONMATCHHOUSETRAINED

The good with/housetrained flags of the animal the person is looking for

PERSONMATCHCOMMENTSCONTAIN

The animal this person is looking for will have this value in its comments

PERSONADDITIONAL<fieldname>

If you have person additional fields defined, you can put the uppercased version of their name as a suffix to this. Eg, for an additional field called DateOfBirth PERSONADDITIONALDATEOFBIRTH

TESTTYPE

The type of test on this line

TESTRESULT

The test result

TESTDUEDATE

The due date for the test

TESTPERFORMEDDATE

The date the test was performed

TESTCOMMENTS

Any comments for the test

VACCINATIONTYPE

The type of vaccination on this line

VACCINATIONDUEDATE

The due date for the vaccination

VACCINATIONGIVENDATE

The date the vaccination was given

VACCINATIONEXPIRESDATE

The date the vaccine wears off and needs to be re-administered

VACCINATIONMANUFACTURER

The manufacturer of the vaccine

VACCINATIONBATCHNUMBER

The serial/batch number of the vaccine

VACCINATIONRABIESTAG

The rabies tag accompanying the vaccine

VACCINATIONCOMMENTS

Comments on the vaccine