Re: [Mickaboo Techlist] ASM Bird Size info

24 Jul 2008

      Wendi:  The ASM database fields aren't -exactly- as they seem.  We 
customized things a good deal in the codebase and database.  In the 
instance of animal.Size we actually reused (but did not rename) that 
field for "Health Status" as it is displayed on our website.  Our 
"small" "medium" and "large" bird categories were simply assigned by us 
in the website code.  Below is the relevant snippet. Note that I realize 
this isn't intuitive or optimal -- that's just what we had to work with 
at the time.

The developer ASM database has photos in it; it's basically a snapshot 
of the current ASM database that's static (no one uses it).

=================
## Determine whether the bird is small, medium or large
if ( $speciesID <= 5 ) {
 $size = "small"; }
elsif ( $speciesID <= 11 ) {
 $size = "medium"; }
elsif ( $speciesID <= 15 ) {
 $size = "large"; }
elsif ( $speciesID == 16 ) {
 $size = "small"; }
elsif ( $speciesID == 17 ) {
  $size = "small"; }
elsif ( $speciesID == 18 ) {
  $size = "medium"; }
elsif ( $speciesID == 19 ) {
  $size = "medium"; }
elsif ( $speciesID == 20 ) {
  $size = "medium"; }
==================

Wendi Whitcomb wrote:
...
Hi
Nancy: you can skip to the note :)
When I queried the ASM Developer database, I received the following sizes:
0, 1, 2, 3, 4, 5.  I assigned 0 & 1 to Small, 2 & 3 to Medium, 4 & 5 to
large.  However this does not seem to match the birds in the database
correctly.  I am getting Amazons mixed in with cockatiels, Macaws mixed in
with conures and cockatiels.  Is this just because it's a developer database
or is that not the correct field (animal.Size).  Matt are there pictures of
the birds in the developer database (i.e, that is to say some ID and
accessible path that I could pull the photo...if not I'll just stub it out
until later and put fake photos in)
Note: I have Menu (queries) for small, medium, large birds.  A menu item
that takes you to page where the number of birds per species is listed, one
can then click on the species and be taken to a listing of birds of that
species.
In process...would like input
1. On the newly added  birds, what is the time period for being in the
category "New Additions" 1 month, 2 weeks, etc?
2.  On the Advanced search: 
* check boxes for good with children, special needs, drop down for species
and size (which are mutually exclusive).  Other parameters?
Thanks,
Wendi

Re: [Mickaboo Techlist] ASM Bird Size info

AMuse