FacebookTwitterLinkedIn
Login / Register

Login / Register

IUG FORUM

Stay always connected!
  1. Laurie Palumbo
  2. Sierra/ Millennium/ Encore
  3. Friday, August 11 2017, 08:01 AM
  4.  Subscribe via email
At the beginning of each semester, we get a list of required texts from the bookstore. Currently, the circulation staff manually searches each title to see if we own it so it can be put on course reserve. I have been asked to automate a comparison of ISBNs from our bib records to the bookstore's required texts list. Does anyone currently do this or something similar? Would you be willing to share with me how?
Thanks for your time,
Laurie

lpalumbo@sju.edu
Comment
There are no comments made yet.
Add Comment
Laura Wright Accepted Answer
0
Votes
Undo
I wonder if you could create a JSON query in Create Lists? I did something similar recently to create a review file based on titles. I used Notepad++ to convert the title list into the query format.

My query looked something like this:

{
"queries": [
{
"target": {
"record": {
"type": "bib"
},
"field": {
"tag": "t"
}
},
"expr": [
{
"op": "starts_with",
"operands": [
"american factfinder"
]
},
"or",
{
"op": "starts_with",
"operands": [
"american memory"
]
},
"or",
{
"op": "starts_with",
"operands": [
"archivision digital research library"
]
},
"or",
{
"op": "starts_with",
"operands": [
"arxiv"
]
},
"or",
{
"op": "starts_with",
"operands": [
"association of religion data archives"
]
},
"or",
{
"op": "starts_with",
"operands": [
"audubon\u0027s birds of america at the university of pittsburgh"
]
},
"or",
{
"op": "starts_with",
"operands": [
"beazley archive"
]
},
"or",
{
"op": "starts_with",
"operands": [
"bibliografia mesoamericana"
]
},
"or",
{
"op": "starts_with",
"operands": [
"bibliography of linguistic literature"
]
},
"or",
{
"op": "starts_with",
"operands": [
"bibliography of the history of art (getty archive)"
]
},
"or",
{
"op": "starts_with",
"operands": [
"bioline"
]
},
"or",
{
"op": "starts_with",
"operands": [
"brasiliana electronica"
]
},
"or",
{
"op": "starts_with",
"operands": [
"buildinggreen suite"
]
}
]
}
]
}

You could change title to ISBN and starts_with to has

In Notepad++ I pasted the list of titles, then ran a find/replace regular expression that looked like this:

find: ^(.*)$

(i.e., find beginning of line, any characters any number of times, end of line)

replace: {"op": "starts_with", "operands": ["$1" ] }, "or",

(i.e. replace with {"op": "starts_with", "operands": ["title" ] }, "or",

---

This would give you a review file of isbns in your catalog that match the ones requested for course reserves.
You might be able to do this more easily with SQL though?

Laura.Wright@colorado.edu
Comment
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. Sierra/ Millennium/ Encore
  3. # 1
  • 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: 2 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.