<!DOCTYPE html><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
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 class="moz-txt-link-freetext" href="https://www.checklistbank.org/">https://www.checklistbank.org/</a><br>
3. Go to "Datasets" and find the most recent "Annual Release"<br>
(this one: <a class="moz-txt-link-freetext" href="https://www.checklistbank.org/dataset/310463/about">https://www.checklistbank.org/dataset/310463/about</a>)<br>
<img src="cid:part1.FflmfbbI.3Eb1zuci@illinois.edu" alt="" width="459" height="539"><br>
4. Click on Downloads to generate a download: (see options to pick
below);<br>
<img src="cid:part2.0uki4T90.lsz0lboi@illinois.edu" alt="" width="400" height="272"><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>
<br>
<div class="moz-cite-prefix">On 12/12/2025 12:10 PM, Pellegrini,
Rodrigo [DOS] wrote:<br>
</div>
<blockquote type="cite" cite="mid:SA9PR09MB5840848258FE713F445EDCB2A0AEA@SA9PR09MB5840.namprd09.prod.outlook.com">
<pre wrap="" class="moz-quote-pre">Greetings everyone,
We are currently making an effort to catalog our entomology collection at the NJSM, ...</pre>
</blockquote>
<blockquote type="cite" cite="mid:SA9PR09MB5840848258FE713F445EDCB2A0AEA@SA9PR09MB5840.namprd09.prod.outlook.com">
<pre wrap="" class="moz-quote-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.
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.
... 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.
It would save us a ton of time, and we would very much appreciate it. Please let me know directly at <a class="moz-txt-link-abbreviated" href="mailto:Rodrigo.Pellegrini@sos.nj.gov">Rodrigo.Pellegrini@sos.nj.gov</a> if you can help us out.
Thank you very much for your time,
Rod
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
- Deborah Paul, Biodiversity Informatics Community Liaison
- Species File Group (INHS), University of Illinois
-- Natural History Collections and Museomics NHCM Editor-in-Chief <a class="moz-txt-link-freetext" href="https://nhcm.pensoft.net">https://nhcm.pensoft.net</a>
-- Biodiversity Information Standards (TDWG) Past Chair 2021-2022
-- Florida State University Courtesy Appointment
-- Species File Group and Events <a class="moz-txt-link-freetext" href="https://speciesfilegroup.org">https://speciesfilegroup.org</a></pre>
<br>
</body>
</html>