Generate multi-column intake CSV from submitted surrender forms

mchapman87501 / fnf_intake_forms

0 stars 0 forks source link

Generate multi-column intake CSV from submitted surrender forms #9

Closed mchapman87501 closed 1 year ago

mchapman87501 commented 1 year ago

The generated CSV should have these column headers.

Location
Adult cat/mama cat name
KITTEN NAME
INTAKE DATE
SOURCE/intake info
RESCUE ID
GENDER
BREED/COLOR
DOB
Weight/date
CHIP#
FVRCP#1 date (due at >=2lbs)
FVRCP#2 (due 3--4 weeks after FVRCP#1)
FVCRP#3
DEWORMED date
RABIES vax date
TESTED date (neg unless stated)
S/N date
Check this box when added to Portal
Check this box when added to Pawlytics
Notes

mchapman87501 commented 1 year ago

Per Lisa, "Location" should contain either a location name (SFC, Petco, Teca Tu) or Foster/Adopter Name. In other words it should give the location where the cat resides following its intake.

mchapman87501 commented 1 year ago

The app may not be able to compute values for all of the columns above. For example, at present the surrender forms do not have fields corresponding to the "Location" field. When generating the multi-column intake CSV, such fields will be left empty.