FacebookTwitterLinkedIn
Login / Register

Login / Register

IUG FORUM

Stay always connected!
  1. Jennifer Murray
  2. Sierra/ Millennium/ Encore
  3. Wednesday, April 11 2018, 11:49 AM
  4.  Subscribe via email
We would like to find an easy way to send our faculty/instructors the circulation stats from the items in their reserves courses. We would also like to the stats to be in a useful format, like csv.

We do not want to send them screenshots of their course page in Sierra (the easiest, but least professional and usable format).

Is there some really simple export or email feature within reserves for sending circulation statistics that I am missing?'

Thank you for any help.
Sincerely,
Jen

jennifer.murray@usask.ca
Comment
There are no comments made yet.
Add Comment
Marla Lobley Accepted Answer
0
Votes
Undo
I have not yet found an easy export or email feature. If you've been keeping a manual list of barcodes or item numbers, you could use those to make a Create Lists review file and then export with the RESV NOTE (under Item). (If you don't have a manual list, then do a Create Lists for Location= Reserves and export with the barcode or item number before taking items off reserve.)

Our RESV NOTES read like this: "06-03-08 ON RESERVE FOR ENG 1213-Benton;" "02-02-10 OFF RESERVE FOR ENG 1213- Benton. CIRCED 2 TIMES." I use Excel's Find and Replace tools to look for CIRCED and replace it with some symbol (like @). Then I use Text to Columns to move all of the @ signs to another column. Sometimes this moves data several columns to the right because an item has been off/on reserve several times and had CIRCED several times in the RESV NOTE. If that's the case, then I take the data in the furthest right column and move it to the correct column. This can be done quickly by applying a filter to each column with data in it and sorting the data in each column so that you can copy and paste all of the data from that column to the correct column at one time. Once all of the data is in the right place, the data in that column will look something like 2 TIMES". You could do Find and Replace again to replace TIMES and any punctuation with nothing so that all you would be left with is a number.

If anyone knows of a simpler way, I would love to learn about it!

mlobley@ecok.edu
Comment
Great, I'm starting to learn SQL too and will be at IUG next week hoping to learn more. Yes, please share and if I figure something out, I will also!

mlobley@ecok.edu
  1. Marla Lobley
  2. 3 days ago
Hi Marla,
Thank you very much for your thoughtful reply. We are just about to start investigating the use of SQL to grab the stats out. Hopefully, this will allow us to easily grab the stats and send them to the instructors in a simple excel doc.
I thought about the Create List option, but feel like it is a LOT of work for something that should be quite simple.
I will let you know how the SQL thing works out.
Fingers crossed,
Jen
  1. Guest
  2. 3 days ago
There are no comments made yet.
Add Comment
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,pdf,ppt,pptx,doc,docx,xls,xlsx,,txt,rtf,jrxml
• Remove Upload Files (Maximum File Size: 5 MB)
You may insert polls into your post. The poll would then appear in the post.
Vote Options
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.