<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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 lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi Catherine,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Do you have access to Microsoft Office, and if so, have you considered using the mail merge functionality in Word to link a template document to an Excel spreadsheet containing your specimen data? That’s how we often print labels for our
specimens. (We use EMu for our collections database, but we like to modify our printed labels in ways that are far too idiosyncratic to be easily generated by EMu and Crystal Reports.)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Best,<o:p></o:p></p>
<p class="MsoNormal">Tom<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Thomas J. Trombone | Data Manager | Department of Ornithology<o:p></o:p></p>
<p class="MsoNormal">American Museum of Natural History | Central Park West @ 79th Street | New York, NY 10024-5192<o:p></o:p></p>
<p class="MsoNormal">(212) 313-7783 | <a href="mailto:trombone@amnh.org">trombone@amnh.org</a> |
<a href="http://www.amnh.org/our-research/vertebrate-zoology/ornithology">http://www.amnh.org/our-research/vertebrate-zoology/ornithology</a><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Nhcoll-l <nhcoll-l-bounces@mailman.yale.edu> <b>
On Behalf Of </b>Catherine Early (she/her)<br>
<b>Sent:</b> Thursday, May 11, 2023 3:35 PM<br>
<b>To:</b> nhcoll-l@mailman.yale.edu<br>
<b>Subject:</b> [Nhcoll-l] software to automate database entries into tags<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:solid #9C6500 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt">
<p class="MsoNormal" style="line-height:12.0pt;background:#FFEB9C"><b><span style="font-size:10.0pt;color:black">EXTERNAL SENDER</span></b><span style="font-size:10.0pt;color:black"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif">Hi all,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif">We are preparing for a digitization project where we will associate field data with specimens that do not currently have data tags, just field numbers. Because the field notes are idiosyncratic
and not in a standardized format, we (staff) will be entering the specimen's data directly into our database rather than photographing standard format data tags that can be easily transcribed by volunteers into a database. After the data have been entered
in the database, we would like to print data tags to attach to each specimen.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif">I'm looking for a software program that can take a CSV from a specimen database (we use Re:discovery and do not have the resources to switch any time soon) and automatically populate the
fields of a data tag template with the appropriate information from the CSV. Obviously the user would have to map the fields of the CSV to the field of the data tag, but once that is done, it would be a simple importing step then checking to make sure it worked.
Does this kind of program exist already? <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif">Best,</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif">Catherine</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td width="167" style="width:125.25pt;padding:.75pt .75pt .75pt .75pt">
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><img border="0" width="200" height="87" style="width:2.0833in;height:.9062in" id="_x0000_i1025" src="https://ci3.googleusercontent.com/mail-sig/AIorK4wD9JXWFLGfFGcjNPg9ybTqLuzHoh9SsWwN0epasNsoagFJsUsqboDVGj5yunC50y06p5F7S5Y"><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt 11.25pt">
<p style="margin:0in;line-height:13.5pt"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3F3F3F">Catherine M. Early, PhD<o:p></o:p></span></b></p>
<p style="margin:0in;line-height:13.5pt"><i><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#3F3F3F">she/her/hers</span></i><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#3F3F3F"><o:p></o:p></span></p>
<p style="margin:0in;line-height:13.5pt"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#3F3F3F">Barbara Brown Chair of Ornithology<o:p></o:p></span></p>
<p style="margin:0in;line-height:13.5pt"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#3F3F3F"><a href="mailto:cearly@smm.org" target="_blank">cearly@smm.org</a><o:p></o:p></span></p>
<p style="margin:0in;line-height:13.5pt"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#3F3F3F"><a href="https://catherineearly.wixsite.com/home" target="_blank">https://catherineearly.wixsite.com/home</a><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
<td style="padding:.75pt .75pt .75pt 11.25pt">
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br>
<o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<td style="padding:.75pt .75pt .75pt 11.25pt"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellpadding="0" width="500" style="width:375.0pt">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p style="margin:0in;line-height:12.0pt"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3F3F3F">We envision a world where everyone has the power to use science to make lives better,<br>
and we are committed to using STEM as a tool to advocate for justice and equity.<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
<td style="padding:.75pt .75pt .75pt .75pt"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>