Re: [OPEN-ILS-GENERAL] Records with no items

[Mary Llewellyn]

I use SQL to identify records like that. My query is something like this:

select bre.id
from biblio.record_entry bre
where bre.deleted = 'f'
and bre.id not in
(select bre.id
from biblio.record_entry bre, asset.call_number acn
where acn.record = bre.id
and acn.deleted = 'f'
and bre.deleted = 'f')

My SQL syntax skills are kind of rudimentary. I'm sure someone else can
write something more elegant. This one is looking for biblio.record ids
that are not associated with undeleted call numbers and bibs

Maybe this example will give insight on tables and parameters to use in a
report.

Mary


On Wed, Oct 23, 2019 at 10:44 AM Marguerite Grant <
margueritegr...@rodgerslibrary.org> wrote:

> We have been trying to identify active (not deleted) records that have no
> active (not deleted) items.  I haven't had any success creating a report.
>
> Is there a canned report to do this and if not, perhaps someone can send
> me some insight as to what tables and parameters I should be using.
>
> Thanks very much for any help you can give me.
>
> Marguerite Grant
>
> ---
>
> Rodgers Memorial Library
>
> Hudson, NH
>


-- 
Mary Llewellyn
Database Manager
Bibliomation, Inc.
24 Wooster Ave.
Waterbury, CT 06708
mllew...@biblio.org

[OPEN-ILS-GENERAL] Position Available: Automation Services Librarian, Pioneer Library System

[Bob Wicksall]

Position Available: Automation Services Librarian 
The Pioneer Library System (PLS) is a cooperative library system located in 
Canandaigua, NY and serves 42 small and rural public libraries across Ontario, 
Wyoming, Wayne, and Livingston Counties. We are currently looking for a 
detailed oriented and coding savvy librarian to help further the development 
and support of our Integrated Library System (ILS), Evergreen. Under the 
direction of the Executive Director, this position will be part of the ILS team 
that focuses on the enhancement, development, management, and support of our 
ILS. Typical tasks include running report queries in the ILS, monitoring and 
testing updates, supporting ILS issues at member libraries, offering training 
sessions, and influencing system-wide policy. 

Essential Duties Include : 


1. Work with Computer and Network Services Manager, PLS staff, and member 
libraries to identify and coordinate ILS developments, enhancements, upgrades, 
and reporting; third party services associated with the ILS; and other services 
and projects relating to library technologies provided by PLS. 
2. Effectively lead ILS related projects through development, management, 
implementation, and closing. 
3. Maintain professional communication and working relationships with 
system staff, member libraries, project team members, vendors, and ILS related 
communities. 
4. Coordinate activities with system staff on ILS related projects. 
5. Manage, implement, and advise on ILS related policies and procedures. 
6. Organize and conduct project team meetings, policy advisory committee 
meetings, and user group meetings. 
7. Provide support for procedure and policy-related ILS questions. 
8. Present and train on ILS related topics to system staff and member 
libraries. 
9. Partners with the Cataloging & E-Resources Specialist for backup and 
support. 
10. Other duties as assigned. 

Required Skills, Knowledge, and Abilities 


* Working knowledge of integrated library systems and technology specific 
to the acquisition, cataloging, and circulation of library resources; 
bibliographic databases, public access catalogs, and how they are used. 
* Knowledge of SQL, HTML, CSS, and XML. 
* Knowledge of issues and workflows that have an impact on member 
libraries. 
* General knowledge of cataloging (i.e. MARC, RDA). 
* Skills in consulting and working with library professionals and 
contractors. 
* Skills in drafting and updating written policies, procedures, and 
directives. 
* Ability to manage projects successfully. 
* Valid driver’s license and willingness to travel to member libraries and 
conferences as required. 

Education and Experience 


* MLS or equivalent degree from an ALA accredited school of library and 
information science 
* New York State Public Librarian’s Professional Certificate. 
* Two or more years of relevant professional library experience sufficient 
to perform essential duties of the position; or equivalent combination of 
training, education, and experience. 

Salary & Benefits 


* Salary range $52,000 - $56,000, commensurate with experience. 
* Vacation, sick time, holiday, and health insurance benefits 
* NYS Retirement 

How to Apply 

To apply for this position, send a PDF with your cover letter, resume, and 
contact information for three professional references to care...@pls-net.org 
with the subject line: Automation Services Librarian. Preference will be given 
to applications received by November 18, 2019. The position will remain open 
until filled. 

Visit [ http://pls-net.org/careers | http://pls-net.org/careers ] for the full 
job posting. 

[OPEN-ILS-GENERAL] Records with no items

[Marguerite Grant]

We have been trying to identify active (not deleted) records that have no
active (not deleted) items.  I haven't had any success creating a report.

Is there a canned report to do this and if not, perhaps someone can send me
some insight as to what tables and parameters I should be using.

Thanks very much for any help you can give me.

Marguerite Grant

---

Rodgers Memorial Library

Hudson, NH

[OPEN-ILS-GENERAL] Academic Libraries Using Evergreen

[Murphy, Benjamin]

I'd like to learn about the experiences of academic libraries that are using 
Evergreen in a college or university setting. What are the pros and cons of 
Evergreen in your environment? Are you using something for managing reserves 
collections, and if so what? Do you use Evergreen to share materials amongst 
several branches of the same institution, or with your peer institutions?

Feel free to contact me off list. If its easier to describe your experiences on 
the phone, I'm happy to call you.

Thanks,
Benjamin

Benjamin Murphy
NC Cardinal Program Manager
NC Dept. of Natural and Cultural Resources
919.814.6797 |  benjamin.mur...@ncdcr.gov
https://statelibrary.ncdcr.gov/ld/nc-cardinal

109 East Jones Street  | 4640 Mail Service Center
Raleigh, North Carolina 27699-4600

Email correspondence to and from this address is subject to the North Carolina 
Public Records Law and may be disclosed to third parties.

[OPEN-ILS-GENERAL] EVG Hack-A-Way Day 3 Stream

[Goben, Anna]

The link for today's stream is at:

https://zoom.us/j/768782544?pwd=czZMczlRQXlha0lGM2RTaWFaRXhJdz09

The stream will start around 8:30.

Thanks,
-Anna


Anna Goben

Evergreen Indiana Coordinator

Indiana State Library

140 N. Senate Ave.

Indianapolis, IN 46204

Telephone: 317-234-6624

Fax: 317-262-3713