[Evergreen-reports] [External] Report for Pending Users - is this even possible?

[Patrick, Irene]

Hi Barb,

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.

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.

Unfortunately, that doesn't solve the problem with multiple locations.  You'd still have to go into pending patrons for each one.

It definitely would be nice to be able to run a report for them!

Irene Patrick
Electronic Resources Librarian
State Library of North Carolina
NC Department of Natural and Cultural Resources
919.814.6788 |  irene.patrick at ncdcr.gov<mailto:irene.patrick at ncdcr.gov>

109 East Jones Street  | 4640 Mail Service Center
Raleigh, North Carolina 27699-4600
[A close up of a logo  Description automatically generated]<https://statelibrary.ncdcr.gov/>
Twitter<https://twitter.com/ForEverythingNC> | Facebook<https://www.facebook.com/ncghl/> | Instagram<https://www.instagram.com/foreverythingnc/> | YouTube<https://www.youtube.com/user/statelibrarync/> | LinkedIn<https://www.linkedin.com/company/state-library-of-north-carolina>
Don't wait to vaccinate. Find a COVID-19 vaccine location near you at MySpot.nc.gov<https://covid19.ncdhhs.gov/vaccines>.
Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties.



From: Evergreen-reports <evergreen-reports-bounces at list.evergreen-ils.org> On Behalf Of Barb Mitchell via Evergreen-reports
Sent: Friday, December 10, 2021 9:44 AM
To: evergreen-reports at list.evergreen-ils.org
Subject: [External] [Evergreen-reports] Report for Pending Users - is this even possible?

CAUTION: External email. Do not click links or open attachments unless you verify. Send all suspicious email as an attachment to Report Spam.<mailto:report.spam at nc.gov>

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.

Thanks for any help possible!

Barb Mitchell (she/hers)
County Coordinator
Cambria County Library System
814.536.5131 ext. 219
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20211210/bdbd602c/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 49715 bytes
Desc: image001.jpg
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20211210/bdbd602c/attachment-0001.jpg>