<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word"><head><META content="text/html; charset=us-ascii" http-equiv="Content-Type">
<META content="text/html; charset=us-ascii" http-equiv="Content-Type">
<STYLE><!-- /* Style Definitions */ p.5a8b6ce1-5dc5-44e8-8afe-3d1770bb6aec, li.5a8b6ce1-5dc5-44e8-8afe-3d1770bb6aec, div.5a8b6ce1-5dc5-44e8-8afe-3d1770bb6aec, table.5a8b6ce1-5dc5-44e8-8afe-3d1770bb6aecTable {margin:0cm; margin-bottom:.0001pt;}div.Section1 {page:Section1;}--></STYLE>
<META content="text/html; charset=us-ascii" HTTP-EQUIV="Content-Type"><meta content="Microsoft Word 12 (filtered medium)" name=Generator><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><BODY>
<DIV>
<P CLASS="5a8b6ce1-5dc5-44e8-8afe-3d1770bb6aec"><div class=WordSection1><p class=MsoNormal>Hello colleagues,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve recently been having some issues with the way mammal specimen collection data is recorded in our database and I was wondering how others organise their collection data.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>My issues revolve around being able to record different preparation types in a simple manner that enables easy retrieval of data relating to 1) how many individuals of that species we have 2) how many of a certain preparation type we have, and 3) what the location of the different prep types is. At the moment I can achieve all these, but not always in an easy way.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We use KE EMu and use a multiple record method of recording different prep types as only one location can be linked to each record (our institution uses a barcode based location system). Therefore, a skin, skull and fluid prep from one individual will need to be recorded three times – so that separate location data can be added – and linked to the main record, usually the skin is designated. Associated tissue samples are also linked to the main record, but they have completely different catalogue numbering so there isn’t a straight forward way to search that brings up all records for one individual (same goes for older specimens where different parts of a single individual specimen were originally registered with different catalogue numbers). Many of these things I probably can’t change but I’m hoping I can improve things a little and it’s nice to know how others manage similar problems. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>So my specific questions for the list are:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>1. In the case of specimens with more than one preparation type, how do you record these – in one record or multiple?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>2. How do you record locations for different parts of a single individual specimen (if you do at all)?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>3. Do you have a generic preparation type classification that is supplemented by additional information? Eg. ‘skull’ as a prep type description but then another field that indicates whether it is a complete skull with mandibles or just a partial cranium.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>4. For those that use KE Emu or similar systems, do you use the conceptual parent method of grouping multiple associated records? I wasn’t keen on it, but I am starting to think it may be more practical.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thank you all for your input and thoughts (happy to hear from non-mammal people too!).<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Karen<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:9.0pt'>Karen Roberts, PhD</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt'>Collection Manager, Vertebrates</span><span style='font-size:9.0pt'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt'>Museum Victoria, GPO Box 666</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>, </span><span style='font-size:9.0pt'>Melbourne VIC 3001,</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> </span><span style='font-size:9.0pt'>Australia</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt'> </span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt'>e: <a href="mailto:karoberts@museum.vic.gov.au"><span style='color:windowtext;text-decoration:none'>karoberts@museum.vic.gov.au</span></a></span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt'>web: <a href="http://museumvictoria.com.au/" target="_blank"><span style='color:windowtext;text-decoration:none'>http://museumvictoria.com.au/</span></a></span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></P>
<P CLASS="5a8b6ce1-5dc5-44e8-8afe-3d1770bb6aec"><SPAN STYLE="FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold"><B><SPAN STYLE="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 8pt"></SPAN></B></SPAN> </P>
<P CLASS="MsoNormal" STYLE="MARGIN: 0cm 0cm 0pt"><FONT FACE="Verdana" SIZE="1">Museums Board of Victoria ABN 63 640 679 155 is endorsed as a Deductible Gift Recipient. <BR></FONT><FONT FACE="Verdana" SIZE="1">All gifts of $2 or more are tax deductible.</FONT></P></DIV>
<DIV><BR><IMG ALIGN="baseline" ALT BORDER="0" HSPACE="0" SRC="http://museumvictoria.com.au/images/email-ta.jpg"></DIV>
<DIV><BR><BR><FONT FACE="Verdana" SIZE="1"><STRONG>Melbourne Museum,</STRONG> winner of the Victorian Tourism Awards for Best Major Tourist Attraction in 2010,2011,2012 and Australian winner in 2011.<BR><BR></FONT><FONT FACE="Verdana" SIZE="1"><A HREF="http://museumvictoria.com.au/">museumvictoria.com.au</A></FONT></DIV>
<P><FONT COLOR="#808080" FACE="Arial" SIZE="1">This e-mail is solely for the named addressee and may be confidential. You should only read, disclose, transmit, copy, distribute, act in reliance on or commercialise the contents if you are authorised to do so. If you are not the intended recipient of this e-mail, please notify </FONT><A HREF="mailto:npostmaster@museum.vic.gov.au"><FONT COLOR="#808080" FACE="Arial" SIZE="1">postmaster@museum.vic.gov.au</FONT></A><FONT COLOR="#808080" FACE="Arial" SIZE="1"> by email immediately, or notify the sender and then destroy any copy of this message. Views expressed in this email are those of the individual sender, except where specifically stated to be those of an officer of Museum Victoria. Museum Victoria does not represent, warrant or guarantee that the integrity of this communication has been maintained nor that it is free from errors, virus or interference.</FONT></P>
<P CLASS="MsoNormal" STYLE="MARGIN: 0cm 0cm 0pt"><SPAN STYLE="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 10pt"><FONT SIZE="1">Please consider the environment before printing this email.</FONT></SPAN></P>
<P CLASS="MsoNormal" STYLE="MARGIN: 0cm 0cm 0pt"><SPAN STYLE="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 10pt"></SPAN> </P>
<P><FONT COLOR="#808080" FACE="Arial" SIZE="1"></FONT> </P></BODY></HTML>