[r32]: fixChildrensCards / USAGE Maximize Restore History

Download this file

USAGE    32 lines (25 with data), 1.1 kB

When the Crawford County Library Switched from Winnebago to Koha, there was
no way to connect the child card to the guarantor (parent) during the data
transfer, because the guarantor field uses the borrowerid as a link from the
parent to the child (that is, the parent's borrowerid is contained in the
child cards guarantor field). This program will assume the person in the
contactname field is the guarantor and look that person up, and insert their
borrowerid into the child's guarantor field. Furthermore, it is assumed that
the name in contactname is of the syntax "LASTNAME, FIRSTNAME" or "FIRSTNAME
LASTNAME".

Special cases will be added for:
"$FIRSTNAME $LASTNAME,Mother"
"$FIRSTNAME $LASTNAME,MOTHER"
"$FIRSTNAME $LASTNAME,Mom"
"$FIRSTNAME $LASTNAME,MOM"
"$LASTNAME,$FIRSTNAME (MOM"

"$FIRSTNAME $LASTNAME,Father"
"$LASTNAME, $FIRSTNAME,FATHER
"$LASTNAME,$FIRSTNAME (DAD)"

"$FIRSTNAME $LASTNAME,Therapist"

"$LASTNAME (GRANDPA),$FIRSTNAME" 

"$LASTNAME (grandma),$FIRSTNAME"
"$FIRSTNAME $LASTNAME,grandmothe"
"$FIRSTNAME $LASTNAME,Grandmothe"
"$LASTNAME,$FIRSTNAME (G.MA"

"$FIRSTNAME $LASTNAME,Great Aunt"