<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:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* 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.EmailStyle20
{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="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi Barb,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I was never able to find a source for that. When I put in a ticket, our consortium staff had to run a SQL report on the server for us to pull the information, and even then it didn’t include the addresses.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The best we’ve been able to do is go to the Pending Patrons screen, click on the right hand dropdown arrow, and select the Download Full CSV option. That at least will export the information into an Excel file that you can keep. But you
have to be sure to display all the columns you want to include in the downloaded file.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Unfortunately, that doesn’t solve the problem with multiple locations. You’d still have to go into pending patrons for each one.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">It definitely would be nice to be able to run a report for them!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black">Irene Patrick<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Electronic Resources Librarian<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">State Library of North Carolina<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">NC Department of Natural and Cultural Resources
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">919.814.6788 | </span><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><a href="mailto:irene.patrick@ncdcr.gov"><span style="color:#0563C1">irene.patrick@ncdcr.gov</span></a><span style="color:black">
<o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">109 East Jones Street | 4640 Mail Service Center
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Raleigh, North Carolina 27699-4600<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-top:6.0pt"><a href="https://statelibrary.ncdcr.gov/"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:windowtext;text-decoration:none"><img border="0" width="327" height="102" style="width:3.4062in;height:1.0625in" id="Picture_x0020_1" src="cid:image001.jpg@01D7EDBC.C07E5BA0" alt="A close up of a logo
Description automatically generated"></span></a><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0in;margin-bottom:6.0pt;margin-left:0in">
<a href="https://twitter.com/ForEverythingNC"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#0563C1">Twitter</span></a>
<span style="font-size:10.0pt;font-family:"Arial",sans-serif">|</span> <a href="https://www.facebook.com/ncghl/">
<span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#0563C1">Facebook</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif"> | </span><a href="https://www.instagram.com/foreverythingnc/"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#0563C1">Instagram</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif"> |
</span><a href="https://www.youtube.com/user/statelibrarync/"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#0563C1">YouTube</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif"> |
<span style="color:#2E74B5"><a href="https://www.linkedin.com/company/state-library-of-north-carolina"><span style="color:#2E74B5">LinkedIn</span></a></span><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:12.0pt;margin-right:0in;margin-bottom:6.0pt;margin-left:0in">
<b><span style="font-family:"Arial",sans-serif;color:#201F1E;background:white">Don’t wait to vaccinate. Find a COVID-19 vaccine location near you at </span></b><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><a href="https://covid19.ncdhhs.gov/vaccines" target="_blank"><b><span style="font-size:11.0pt;background:white">MySpot.nc.gov</span></b></a></span><b><span style="font-family:"Arial",sans-serif;color:#201F1E;background:white">.</span></b><o:p></o:p></p>
<p class="MsoNormal" style="margin-top:12.0pt"><i><span style="font-size:10.0pt;color:#7F7F7F">Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties.</span></i><i><span style="font-size:10.0pt;color:#7F7F7F"><o:p></o:p></span></i></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>From:</b> Evergreen-reports <evergreen-reports-bounces@list.evergreen-ils.org>
<b>On Behalf Of </b>Barb Mitchell via Evergreen-reports<br>
<b>Sent:</b> Friday, December 10, 2021 9:44 AM<br>
<b>To:</b> evergreen-reports@list.evergreen-ils.org<br>
<b>Subject:</b> [External] [Evergreen-reports] Report for Pending Users - is this even possible?<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:red">CAUTION:</span></b><span style="font-size:10.0pt;color:black"> External email. Do not click links or open attachments unless you verify. Send all
suspicious email as an attachment to <a href="mailto:report.spam@nc.gov"><span style="color:red">Report Spam.</span></a><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI",sans-serif;color:black;background:white">Hi all! I work with 14 libraries in my system. Sometimes users submit requests online for library cards, and the library staff don't always catch
them in a timely manner. I was wondering if there was a way to create a report to pull the details of pending users at each library - currently I have to log in to each individual library to view these in the Circulations tab, being able to run a single report
for all 14 libraries would be a big time-saver. I've done some digging but I haven't been very fruitful so far, it seems that since they aren't registered users yet that they probably won't show up under the User source.</span><span style="font-size:12.0pt;font-family:"Segoe UI",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Segoe UI",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:12.0pt;font-family:"Segoe UI",sans-serif;color:black;background:white">Thanks for any help possible!</span><span style="font-size:12.0pt;font-family:"Segoe UI",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<div id="Signature">
<div>
<div id="divtagdefaultwrapper">
<p><span style="font-size:12.0pt;font-family:"Segoe UI",sans-serif;color:black">Barb Mitchell (she/hers)</span><span style="font-size:12.0pt;color:black"><br>
</span><span style="font-size:12.0pt;font-family:"Segoe UI",sans-serif;color:black">County Coordinator
</span><span style="font-size:12.0pt;color:black"><br>
</span><span style="font-size:12.0pt;font-family:"Segoe UI",sans-serif;color:black">Cambria County Library System</span><span style="font-size:12.0pt;color:black"><br>
</span><span style="font-size:12.0pt;font-family:"Segoe UI",sans-serif;color:black">814.536.5131 ext. 219</span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>