<div dir="auto">I got the answers I needed, thanks to all who responded!</div><div dir="auto"><br></div><div dir="auto">Best,</div><div dir="auto">Catherine</div><div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 11, 2023 at 2:58 PM Katelin Pearson <<a href="mailto:katelin.d.pearson24@gmail.com">katelin.d.pearson24@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Hi Catherine,</div><div><br></div><div>Have you considered using a Symbiota portal? You can import data via a CSV file, and they have pretty customizable label-printing functions, depending on what exactly you want: <a href="https://biokic.github.io/symbiota-docs/editor/label/" target="_blank">https://biokic.github.io/symbiota-docs/editor/label/</a></div><div><br></div><div>You might reach out to someone at the Minnesota Biodiversity Atlas (<a href="https://www.bellmuseum.umn.edu/atlas/" target="_blank">https://www.bellmuseum.umn.edu/atlas/</a>) to see if they'd create a collection profile for you. If not, you could always make a collection in the Consortium of Small Vertebrate Collections portal (<a href="https://csvcoll.org/portal" target="_blank">https://csvcoll.org/portal</a>/).</div><div><br></div><div>Best,</div><div>~Katie</div></div><div dir="ltr"><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 11, 2023 at 12:53 PM Alison H. Harrington <<a href="mailto:alisonhh@umich.edu" target="_blank">alisonhh@umich.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Hi Catherine,</div><div><br></div><div>To second Tom, I had the same question and reached out to some other herbarium colleagues. The overwhelming answer I got was also to use the MailMerge function in Microsoft. There are some decent tutorials on it and it is pretty flexible in terms of formatting. We use Specify as the database of record and although it has a label generation function, that function seems to have broken before I started my position and I've never used it. <br></div><div><br></div><div>Mailmerge has a couple of minor quirks but it is a broadly used tool so there are many answered questions online. <br></div><div><br></div><div>best,</div><div>Alison</div><div><br></div><div><span>-- </span><br><div dir="ltr"><div dir="ltr"><div><font size="2"><b>Alison H. Harrington, PhD</b></font></div><div><font size="2"><b>Research Collections Manager | Fungi, Lichens, Bryophytes</b></font></div><div><font size="2">University of Michigan Herbarium (MICH) | Research Museums Center</font></div><div><font size="2"><a href="https://www.google.com/maps/search/3600+Varsity+Drive+%231042+%7C+Ann+Arbor,+MI+48108-2228?entry=gmail&source=g">3600 Varsity Drive #1042 | Ann Arbor, MI 48108-2228</a><br></font></div><div><font size="2">Collection of Zoosporic Eufungi at UM (CZEUM) | </font><a href="http://czeum.herb.lsa.umich.edu" target="_blank">czeum.herb.lsa.umich.edu</a></div><div><font size="2"><a href="mailto:alisonhh@umich.edu" target="_blank">alisonhh@umich.edu</a> | 734.936.8028</font></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 11, 2023 at 3:46 PM Thomas J Trombone <<a href="mailto:trombone@amnh.org" target="_blank">trombone@amnh.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>
<div lang="EN-US">
<div>
<p class="MsoNormal">Hi Catherine,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></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.)<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Best,<u></u><u></u></p>
<p class="MsoNormal">Tom<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Thomas J. Trombone | Data Manager | Department of Ornithology<u></u><u></u></p>
<p class="MsoNormal">American Museum of Natural History | Central Park West @ 79th Street | New York, NY 10024-5192<u></u><u></u></p>
<p class="MsoNormal">(212) 313-7783 | <a href="mailto:trombone@amnh.org" target="_blank">trombone@amnh.org</a> |
<a href="http://www.amnh.org/our-research/vertebrate-zoology/ornithology" target="_blank">http://www.amnh.org/our-research/vertebrate-zoology/ornithology</a><u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div style="border-color:rgb(225,225,225) currentcolor currentcolor;border-style:solid none none;border-width:1pt medium medium;padding:3pt 0in 0in">
<p class="MsoNormal"><b>From:</b> Nhcoll-l <<a href="mailto:nhcoll-l-bounces@mailman.yale.edu" target="_blank">nhcoll-l-bounces@mailman.yale.edu</a>> <b>
On Behalf Of </b>Catherine Early (she/her)<br>
<b>Sent:</b> Thursday, May 11, 2023 3:35 PM<br>
<b>To:</b> <a href="mailto:nhcoll-l@mailman.yale.edu" target="_blank">nhcoll-l@mailman.yale.edu</a><br>
<b>Subject:</b> [Nhcoll-l] software to automate database entries into tags<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div style="border:1pt solid rgb(156,101,0);padding:2pt">
<p class="MsoNormal" style="line-height:12pt;background:none 0% 0% repeat scroll rgb(255,235,156)"><b><span style="font-size:10pt;color:black">EXTERNAL SENDER</span></b><span style="font-size:10pt;color:black"><u></u><u></u></span></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif">Hi all,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif"><u></u> <u></u></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.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif"><u></u> <u></u></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? <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif"><u></u> <u></u></span></p>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif">Best,</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Trebuchet MS",sans-serif">Catherine</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<table cellpadding="0" border="0">
<tbody>
<tr>
<td style="width:125.25pt;padding:0.75pt" width="167">
<table cellpadding="0" border="0">
<tbody>
<tr>
<td style="padding:0.75pt">
<table cellpadding="0" border="0">
<tbody>
<tr>
<td style="padding:0.75pt">
<table cellpadding="0" border="0">
<tbody>
<tr>
<td style="padding:0.75pt">
<p class="MsoNormal"><img style="width:2.0833in;height:0.9062in" id="m_5773661461131767831m_6569883733058535365m_-8213933341455348410_x0000_i1025" src="https://ci3.googleusercontent.com/mail-sig/AIorK4wD9JXWFLGfFGcjNPg9ybTqLuzHoh9SsWwN0epasNsoagFJsUsqboDVGj5yunC50y06p5F7S5Y" width="200" height="87" border="0"><u></u><u></u></p>
</td>
<td style="padding:0.75pt 0.75pt 0.75pt 11.25pt">
<p style="margin:0in;line-height:13.5pt"><b><span style="font-size:13.5pt;font-family:Arial,sans-serif;color:rgb(63,63,63)">Catherine M. Early, PhD<u></u><u></u></span></b></p>
<p style="margin:0in;line-height:13.5pt"><i><span style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(63,63,63)">she/her/hers</span></i><span style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(63,63,63)"><u></u><u></u></span></p>
<p style="margin:0in;line-height:13.5pt"><span style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(63,63,63)">Barbara Brown Chair of Ornithology<u></u><u></u></span></p>
<p style="margin:0in;line-height:13.5pt"><span style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(63,63,63)"><a href="mailto:cearly@smm.org" target="_blank">cearly@smm.org</a><u></u><u></u></span></p>
<p style="margin:0in;line-height:13.5pt"><span style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(63,63,63)"><a href="https://catherineearly.wixsite.com/home" target="_blank">https://catherineearly.wixsite.com/home</a><u></u><u></u></span></p>
</td>
</tr>
</tbody>
</table>
</td>
<td style="padding:0.75pt 0.75pt 0.75pt 11.25pt">
<p class="MsoNormal" style="margin-bottom:12pt"><br>
<br>
<u></u><u></u></p>
</td>
</tr>
</tbody>
</table>
</td>
<td style="padding:0.75pt 0.75pt 0.75pt 11.25pt"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;display:none"><u></u> <u></u></span></p>
<table style="width:375pt" width="500" cellpadding="0" border="0">
<tbody>
<tr>
<td style="padding:0.75pt">
<p style="margin:0in;line-height:12pt"><span style="font-size:9pt;font-family:Arial,sans-serif;color:rgb(63,63,63)">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.<u></u><u></u></span></p>
</td>
</tr>
</tbody>
</table>
</td>
<td style="padding:0.75pt"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Nhcoll-l mailing list<br>
<a href="mailto:Nhcoll-l@mailman.yale.edu" target="_blank">Nhcoll-l@mailman.yale.edu</a><br>
<a href="https://mailman.yale.edu/mailman/listinfo/nhcoll-l" rel="noreferrer" target="_blank">https://mailman.yale.edu/mailman/listinfo/nhcoll-l</a><br>
<br>
_______________________________________________<br>
NHCOLL-L is brought to you by the Society for the Preservation of<br>
Natural History Collections (SPNHC), an international society whose<br>
mission is to improve the preservation, conservation and management of<br>
natural history collections to ensure their continuing value to<br>
society. See <a href="http://www.spnhc.org" rel="noreferrer" target="_blank">http://www.spnhc.org</a> for membership information.<br>
Advertising on NH-COLL-L is inappropriate.<br>
</div></blockquote></div>
_______________________________________________<br>
Nhcoll-l mailing list<br>
<a href="mailto:Nhcoll-l@mailman.yale.edu" target="_blank">Nhcoll-l@mailman.yale.edu</a><br>
<a href="https://mailman.yale.edu/mailman/listinfo/nhcoll-l" rel="noreferrer" target="_blank">https://mailman.yale.edu/mailman/listinfo/nhcoll-l</a><br>
<br>
_______________________________________________<br>
NHCOLL-L is brought to you by the Society for the Preservation of<br>
Natural History Collections (SPNHC), an international society whose<br>
mission is to improve the preservation, conservation and management of<br>
natural history collections to ensure their continuing value to<br>
society. See <a href="http://www.spnhc.org" rel="noreferrer" target="_blank">http://www.spnhc.org</a> for membership information.<br>
Advertising on NH-COLL-L is inappropriate.<br>
</blockquote></div><br clear="all"><div><br></div><span>-- </span><br><div dir="ltr"><div dir="ltr"><font face="arial narrow, sans-serif">Katie D. Pearson</font><div><font face="arial narrow, sans-serif">Project & Data Manager</font></div><div><span style="font-family:"arial narrow",sans-serif">Symbiota Support Hub, iDigBio</span><div><font face="arial narrow, sans-serif">Arizona State University</font></div></div></div></div></div>
</blockquote></div></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><font face="trebuchet ms, sans-serif">Best,</font></div><div><font face="trebuchet ms, sans-serif">Catherine</font></div><div><br></div><div><table border="0px" style="font-family:"Times New Roman""><tbody><tr><td style="width:167px"><table style="font-family:"Times New Roman""><tbody><tr><td><table><tbody><tr><td><table><tbody><tr><td><img src="https://ci3.googleusercontent.com/mail-sig/AIorK4wD9JXWFLGfFGcjNPg9ybTqLuzHoh9SsWwN0epasNsoagFJsUsqboDVGj5yunC50y06p5F7S5Y" width="200" height="87"><br></td><td style="padding-left:15px"><p style="font-family:"Proxima Nova",Arial,sans-serif;color:rgb(63,63,63);font-size:18px;margin:0px;padding:0px;font-weight:bold;line-height:18px">Catherine M. Early, PhD</p><p style="font-family:"Proxima Nova",Arial,sans-serif;color:rgb(63,63,63);font-size:14px;margin:0px;padding:0px;line-height:18px"><i>she/her/hers</i></p><p style="font-family:"Proxima Nova",Arial,sans-serif;color:rgb(63,63,63);font-size:14px;margin:0px;padding:0px;line-height:18px">Barbara Brown Chair of Ornithology</p><p style="font-family:"Proxima Nova",Arial,sans-serif;color:rgb(63,63,63);font-size:14px;margin:0px;padding:0px;line-height:18px"><a href="mailto:cearly@smm.org" target="_blank">cearly@smm.org</a></p><p style="font-family:"Proxima Nova",Arial,sans-serif;color:rgb(63,63,63);font-size:14px;margin:0px;padding:0px;line-height:18px"><a href="https://catherineearly.wixsite.com/home" target="_blank">https://catherineearly.wixsite.com/home</a><br></p></td></tr></tbody></table></td><td style="padding-left:15px"><br><br><br style="color:rgb(34,34,34)"></td></tr></tbody></table></td><td style="padding-left:15px"><p style="font-family:"Proxima Nova",Arial,sans-serif;color:rgb(63,63,63);font-size:14px;margin:0px;padding:0px;line-height:18px"><br></p></td></tr></tbody></table><table width="500" style="font-family:"Times New Roman""><tbody><tr><td><p style="font-family:"Proxima Nova",Arial,sans-serif;color:rgb(63,63,63);font-size:12px;margin:0px;padding:0px;line-height:16px">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.</p></td></tr></tbody></table></td><td></td></tr></tbody></table></div></div></div>