<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:Aptos;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Aptos;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#467886;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#96607D;
text-decoration:underline;}
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:11.0pt;
font-family:"Calibri",sans-serif;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Aptos;}
span.EmailStyle19
{mso-style-type:personal;
font-family:Aptos;
color:windowtext;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.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="#467886" vlink="#96607D">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">That’s pretty cool! You may also want to try
<a href="https://anystyle.io/">https://anystyle.io/</a>? It will give you a list in a few different formats (including BibTex) that can be imported into Zotero. I haven’t used it with large bibliographies, but its worked for the handful of citations I’ve tried
in the past.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Lorena</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">******</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Lorena O’English</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Social Sciences and Government Documents Librarian</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Holland and Terrell Libraries</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Washington State University</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Pullman, WA 99164-5610</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#0563C1"><a href="mailto:oenglish@wsu.edu" target="_blank"><span style="color:blue">oenglish@wsu.edu</span></a></span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">@wsulorena<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><a href="https://outlook.office.com/bookwithme/user/ee187d6165534bb18be53689fdebebcd@wsu.edu?anonymous&ep=plink"><span style="color:blue">Bookings page link</span></a><u><span style="color:blue"><o:p></o:p></span></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><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"> Eril-l <eril-l-bounces@lists.eril-l.org>
<b>On Behalf Of </b>Electronic Resources in Libraries discussion list via Eril-l<br>
<b>Sent:</b> Tuesday, June 10, 2025 3:47 PM<br>
<b>To:</b> Electronic Resources in Libraries discussion list <eril-l@lists.eril-l.org><br>
<b>Subject:</b> Re: [Eril-l] Bulk search/Full Text find<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="mso-element:para-border-div;border:solid #FFCACA 1.0pt;padding:1.0pt 1.0pt 1.0pt 1.0pt;background:#FFEB9C">
<p style="background:#FFEB9C;border:none;padding:0in"><b><span style="font-size:10.0pt;color:black">[EXTERNAL EMAIL]</span></b><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">So, having said "I wonder if you could...", I just tried it. I pasted a formatted bibliography into Copilot chat and asked it to give me an RIS file. The first attempt was abysmal (entire citation in the title field, and nothing else),
but after a bunch of trial and error I ended up with a very workable solution, as long as I had reasonably standard citations.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Here's the prompt I finally ended up with:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">"I'm going to paste in a list of bibliographic citations in Vancouver format. Could you create an RIS file that I could use to import these references into EndNote?
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Please be sure to separate the authors, title, publication source, date, volume, issue, page numbers, DOI, URL, and other information into separate fields. If there is any extra information you can't parse, place it in a note field. Make
sure that the RIS file is valid by including the TY field at the beginning of each record and an ER field at the end of each. None of the other fields are required: just leave them out if they're missing.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Be sure to notice that the authors are listed by last name and initials, separated by commas. "McDougall T, Armstrong MB, et al." is three authors who should be included separately in the RIS as "McGougall, T", "Armstrong, MB", and "et
al.".<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">While page numbers are typically numeric, they may have alphabetic prefixes (such as "E123-E234") or be in Roman numerals (ix-xvii). They may also be missing. These are not errors.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If there are any citations you can't process, please display them here along with an indication of what went wrong for each. Do not include any unparsed citations in the RIS file."<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Basically, I started with the initial "Could you create ... into EndNote?" and everything else was added in response to something that went wrong. I've now saved this in my prompt gallery to use again.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">For my test data, I started with the bibliography from <a href="https://urldefense.com/v3/__https:/pmc.ncbi.nlm.nih.gov/articles/PMC11412117/__;!!JmPEgBY0HMszNaDT!tBkZhY_fSEmCsC1O8-bY7pmiWcYsg25hGdjKCjcFFzNKPK5g0zUzJ6ELftlY53SGooznXqMD6glObA86HXU$">
https://pmc.ncbi.nlm.nih.gov/articles/PMC11412117/</a> ("Finding full texts in bulk: a comparison of EndNote 20 versus Zotero 6 using the University of York's subscriptions" -- seemed appropriate!), but most of those references are to web pages without authors,
unpublished manuscripts, and other atypical things. So I decided it wasn't a fair test. But the authors had included (on the publisher site, not in the PMC version) a spreadsheet of articles they had used for their evaluation, so I took a random sample of
articles from that, formatted them in Vancouver style (it being the one I'm most familiar with), and had much better luck.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">In the end, I could just paste in a batch of citations and it'd give me a downloadable RIS file that imported to Zotero 7 just fine (when the time came, I discovered that I don't have EndNote installed on this machine!). The records aren't
perfect (it's a bit iffy with corporate authors, and what would you as a human do with "et al." in this situation?) but they're definitely as good as I'd do with any manual import or reconstruction, and it's much faster. I was just pasting citations in from
a text file, and was doing batches of 10-20. If you've got lots, I'd start with small batches and see how it goes.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">At one point, it offered to look up DOIs for items that didn't have one. That worked, but it only did a few at a time and kept stopping to ask if I wanted it to do more. That wasn't really part of what I was trying to test so I didn't
pursue it very far. It'd definitely be worth looking into to make the full-text lookup more reliable.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Fun!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks to Brock Edmunds at Boston University, whose BLC Forum presentation last week included the example of pasting URLs into a chatbot and getting a bibliography back, and inspired me to try the reverse.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Lynda.<o:p></o:p></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">-----------------------------------------<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">Lynda Howell (she/her/hers)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">University of Vermont Libraries<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual"><a href="mailto:lynda.howell@uvm.edu">lynda.howell@uvm.edu</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual"><a href="https://urldefense.com/v3/__https:/libraries.uvm.edu/dana__;!!JmPEgBY0HMszNaDT!tBkZhY_fSEmCsC1O8-bY7pmiWcYsg25hGdjKCjcFFzNKPK5g0zUzJ6ELftlY53SGooznXqMD6glOWejS25A$">https://libraries.uvm.edu/dana</a><o:p></o:p></span></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>
<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"> Eril-l <<a href="mailto:eril-l-bounces@lists.eril-l.org">eril-l-bounces@lists.eril-l.org</a>>
<b>On Behalf Of </b>Electronic Resources in Libraries discussion list via Eril-l<br>
<b>Sent:</b> Tuesday, June 10, 2025 10:14 AM<br>
<b>To:</b> Electronic Resources in Libraries discussion list via Eril-l <<a href="mailto:eril-l@lists.eril-l.org">eril-l@lists.eril-l.org</a>><br>
<b>Subject:</b> Re: [Eril-l] Bulk search/Full Text find<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">My approach would be to get them into EndNote/Zotero, and then use its Find Full Text function.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">The trick, of course, is getting them into a citation manager. Depending on how structured the spreadsheet is, you may be able to import it. I think EndNote's Find Full Text feature works off the DOI/URL if you have it, so you don't
have to get all of the other fields parsed out perfectly.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">If the citations aren't importable you could paste batches into Google Scholar, PubMed, or Crossref's search box, get the list of results, and export from there.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I saw a presentation this week that gave an AI chatbot a list of URLs and said make me a bibliography. I haven't tried it yet, but I wonder if you could do the opposite.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Sounds like a fun project!<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Lynda<o:p></o:p></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"> Eril-l <<a href="mailto:eril-l-bounces@lists.eril-l.org">eril-l-bounces@lists.eril-l.org</a>>
on behalf of Electronic Resources in Libraries discussion list via Eril-l <<a href="mailto:eril-l@lists.eril-l.org">eril-l@lists.eril-l.org</a>><br>
<b>Sent:</b> Monday, June 9, 2025 7:23 PM<br>
<b>To:</b> <a href="mailto:eril-l@lists.eril-l.org">eril-l@lists.eril-l.org</a> <<a href="mailto:eril-l@lists.eril-l.org">eril-l@lists.eril-l.org</a>><br>
<b>Subject:</b> [Eril-l] Bulk search/Full Text find</span> <o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal"><span style="font-size:11.0pt">Hi all.,</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">My colleague has completely stumped me. I have a colleague who is helping a faculty member with a systematic review. She has an excel file of citations (mostly from Ebsco databases) and is trying to figure
out how to get the full text of them without having to search each individually. We have Alma/Primo if anyone knows any tricks for doing it in there or in Ebsco.
</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">Any ideas?</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">Thanks</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">Theresa</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">Theresa Carlson</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">Head, Content and Delivery Services</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">Cline Library, Northern Arizona University</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">928-523-6849</span><o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>