<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=utf-8">
<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:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Hello Deborah,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thank you very much for this. We’re giving it a try. It took a while to cull the list, but I think we got what we needed.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thank you also to everyone else that replied and offered their files (Nathalie, Christine, and others—I apologize if I’ve left your name out).
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I may be in touch depending on how our trials with the GBIF dataset go. I imported it to EMU, but the file was so large excel truncated it, and I may have missed
something. Time will tell as we move forward cataloging our bugs!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">All the best,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Rod<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><a name="Rodrigo_Pellegrini"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><img width="250" height="150" style="width:2.6041in;height:1.5625in" id="_x0000_i1027" src="cid:image001.jpg@01DC6E9F.D3F70930"></span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Telework on Thursdays<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Deborah Paul <dlpaul@illinois.edu>
<br>
<b>Sent:</b> Friday, December 12, 2025 1:44 PM<br>
<b>To:</b> nhcoll-l@mailman.yale.edu<br>
<b>Cc:</b> Pellegrini, Rodrigo [DOS] <Rodrigo.Pellegrini@sos.nj.gov><br>
<b>Subject:</b> [EXTERNAL] Re: [Nhcoll-l] Entomology taxonomy for database<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="1" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td width="100%" style="width:100.0%;background:black;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-family:"Calibri",sans-serif;color:red">*** CAUTION ***</span></b><o:p></o:p></p>
</td>
</tr>
<tr>
<td width="100%" style="width:100.0%;background:yellow;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p align="center" style="text-align:center"><span style="font-family:"Calibri",sans-serif;color:black">This message came from an
<b>EXTERNAL</b> address </span><strong><span style="font-family:"Calibri",sans-serif;color:red">(<a href="mailto:dlpaul@illinois.edu"><span style="font-weight:normal">dlpaul@illinois.edu</span></a>)</span></strong><span style="font-family:"Calibri",sans-serif;color:black">.
<b><u>DO NOT</u></b> click on links or attachments unless you know the sender and the content is safe.
<b><br>
New Jersey State Government Employees Should Forward Messages That May Be Cyber Security Risks To
</b><a href="mailto:PhishReport@cyber.nj.gov">PhishReport@cyber.nj.gov</a>.</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi Rod,<br>
<br>
Glad to hear you have a paleoentomologist with you. You can get names and taxonomy you need from Catalogue of Life via their exporter. <br>
<br>
1. You will need a GBIF account (do you have one? they are instant to get) to Login.<br>
2. Log in to Checklist Bank (where COL datasets live, to search and download). <a href="https://urldefense.com/v3/__https:/www.checklistbank.org/__;!!J30X0ZrnC1oQtbA!NA-nX3xSyytKOKTAtJjNtRBTtJc-JKD-Ed4NO_Sz58PFvRheH3ARKLnSQpgZhzcZbn921tlKUXvQ_bN1iakxMM3f_qu8$">
https://www.checklistbank.org/</a><br>
3. Go to "Datasets" and find the most recent "Annual Release"<br>
(this one: <a href="https://urldefense.com/v3/__https:/www.checklistbank.org/dataset/310463/about__;!!J30X0ZrnC1oQtbA!NA-nX3xSyytKOKTAtJjNtRBTtJc-JKD-Ed4NO_Sz58PFvRheH3ARKLnSQpgZhzcZbn921tlKUXvQ_bN1iakxMLVrMbvM$">
https://www.checklistbank.org/dataset/310463/about</a>)<br>
<img border="0" width="459" height="539" style="width:4.7812in;height:5.6145in" id="_x0000_i1025" src="cid:image002.png@01DC6E9F.D3F70930"><br>
4. Click on Downloads to generate a download: (see options to pick below);<br>
<img border="0" width="400" height="272" style="width:4.1666in;height:2.8333in" id="_x0000_i1026" src="cid:image003.png@01DC6E9F.D3F70930"><br>
<br>
5. You will get more that you want / need (i. e. classification above Family level). You can of course delete the columns you are not interested in.<br>
<br>
Please holler if you have questions. The COL team will help. I pinged my colleague Geoff Ower, one of the COL Developers to be sure I've pointed you in a useful direction.<br>
<br>
Best,<br>
Debbie<br>
<br>
<o:p></o:p></p>
<div>
<p class="MsoNormal">On 12/12/2025 12:10 PM, Pellegrini, Rodrigo [DOS] wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<pre>Greetings everyone,<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>We are currently making an effort to catalog our entomology collection at the NJSM, ...<o:p></o:p></pre>
</blockquote>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<pre>A paleoentomologist recently joined our ranks, and has been identifying, re-identifying and assigning catalog numbers to our old (recent) insects, and the time to import them into our database, EMU, is nigh.<o:p></o:p></pre>
<pre>Needless to say, our taxonomy tables in the database lack insect taxonomy. ... I'm wondering if anybody here would be kind enough to share their entomology taxonomy tables as a CSV file, for me to import them into our database. We are hoping to get a file that includes up to the Family level, and we could create the genus species for the species represented in our collections.<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>... if your database (whatever it may be) can produce a comma-separated-file with understandable headers for the hierarchy (or a key of what the backend name headers correspond to in the hierarchy), I can make it work.<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>It would save us a ton of time, and we would very much appreciate it. Please let me know directly at <a href="mailto:Rodrigo.Pellegrini@sos.nj.gov">Rodrigo.Pellegrini@sos.nj.gov</a> if you can help us out.<o:p></o:p></pre>
<pre>Thank you very much for your time,<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Rod<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
</blockquote>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<pre>-- <o:p></o:p></pre>
<pre>- Deborah Paul, Biodiversity Informatics Community Liaison<o:p></o:p></pre>
<pre>- Species File Group (INHS), University of Illinois<o:p></o:p></pre>
<pre>-- Natural History Collections and Museomics NHCM Editor-in-Chief <a href="https://urldefense.com/v3/__https:/nhcm.pensoft.net__;!!J30X0ZrnC1oQtbA!NA-nX3xSyytKOKTAtJjNtRBTtJc-JKD-Ed4NO_Sz58PFvRheH3ARKLnSQpgZhzcZbn921tlKUXvQ_bN1iakxMG-LKUh9$">https://nhcm.pensoft.net</a><o:p></o:p></pre>
<pre>-- Biodiversity Information Standards (TDWG) Past Chair 2021-2022<o:p></o:p></pre>
<pre>-- Florida State University Courtesy Appointment<o:p></o:p></pre>
<pre>-- Species File Group and Events <a href="https://urldefense.com/v3/__https:/speciesfilegroup.org__;!!J30X0ZrnC1oQtbA!NA-nX3xSyytKOKTAtJjNtRBTtJc-JKD-Ed4NO_Sz58PFvRheH3ARKLnSQpgZhzcZbn921tlKUXvQ_bN1iakxMHjBxTx9$">https://speciesfilegroup.org</a><o:p></o:p></pre>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>